The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 import from other project file

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
mrandersb Posted - 01/26/2011 : 01:57:24 AM
Right now I have a project file where I am "importing" data from other sheets in the project (in the set column value). Because my project is getting rather large, I would like to make a lot of different project files, and then import all important processed data into one project file.

How can I do this simple? And this a very slow process?

Anders
9   L A T E S T    R E P L I E S    (Newest First)
Sam Fang Posted - 01/30/2011 : 02:08:10 AM
If you didn't change columns or use columns to evaluate other columns or cells in Set Column Values dialog, then Recalculate will also be forced to None. Obviuosly your above script was in that case.

Sam
OriginLab Technical Services
mrandersb Posted - 01/28/2011 : 03:39:36 AM
by the way. The recalculate is set back to none even if i only have

type -mb 1;
doc -a C:\Users\f040427\PhD\Origin Test\Append project test\append.opj;
type -me;

in the before formula script
mrandersb Posted - 01/28/2011 : 03:34:26 AM
thanks, think thats all i needed
Sam Fang Posted - 01/28/2011 : 02:03:14 AM
For the introduction of doc -a, see Help: Programming: LabTalk
Language Reference> Command Reference> Alphabetical Listing of Commands> Document

You can use folpromt:=0 pgpromt:=0 in pe_rmdir command to cancel the prompt. For more, see Help: X-Functions
Utilities> System > pe_rmdir

Recalculate mode is changed from Manual to None, maybe because range of data in the folder created by doc -a is used in "before formula scripts", but you also call pe_rmdir to delete the folder. Then the range won't exist, which will force Recalculate to None. You can copy the data if you want to set Manual.

Sam
OriginLab Technical Services
mrandersb Posted - 01/27/2011 : 06:04:10 AM
Seems like I figured it out, but would still like to see the documentation for the two commands.

Also when for example using the command to delete, it promts with a box asking if i'm sure. I would like that it didn't do that, because I want to do it a lot of times and automatically.

When i puc the doc -a command in the "before formula scripts" and set recalculate to manual, it seems like it is set back to none, can I do something so it is kept at manual?
mrandersb Posted - 01/27/2011 : 05:46:59 AM
Ok I will look into that. I can't seem to find the documentation on the doc -a command, could you give me a link?
Sam Fang Posted - 01/26/2011 : 10:22:34 PM
You can use
doc -a
to append the project that you want to import to your current project, it will create a new project folder for this. After you copy your important processed data from it using script, you can use
pe_rmdir
to delete the new project folder. But it may leave some redundant info in the project.

Sam
OriginLab Technical Services
mrandersb Posted - 01/26/2011 : 09:58:27 AM
Are there any other techniques i can use ?
Sam Fang Posted - 01/26/2011 : 04:45:11 AM
It seems that Origin can't import specified data from other project files using LabTalk script currently.

Sam
OriginLab Technical Services

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000