| T O P I C R E V I E W |
| FloTor |
Posted - 09/02/2011 : 09:37:46 AM
Origin 8.1 SR1
Operating System: WinXP
I have lots of data files I want to import into my Origin project, all imports show the same procedure: Import with certain filter (which I already created), add 4 colums to the workbook and fill those columns with data calculated from the original data.
How can this calculation be implemented into my import process?
Thank you,
Florian |
| 3 L A T E S T R E P L I E S (Newest First) |
| easwar |
Posted - 09/05/2011 : 9:30:26 PM
Hi Florian,
The statement
wks.col11.type = 4;
should work fine provided you have a 11th column in your workbook. Perhaps something went wrong when you edited the file in notepad? Try open a file in Import Wizard and pick your filter and walk thru the pages to the last page to check if the script shows properly. Contact tech support if you still have problems.
Easwar
OriginLab
P.S. To edit the filter to quickly change the script (instead of having to walk thru the wizard again), you can use the menu item: Tools->Import Filter Manager. In that dialog, pick your filter, then click Edit button.
|
| FloTor |
Posted - 09/05/2011 : 12:30:28 PM
Thanks alot!
That actually helped! Great feature.
I implemented something which works nearly perfect. But there seemed to be some small error in the labtalk code. So my question is: Where can edit this specific filter again to get rid of this error?
Edit: I edited it directly in the filter file by using Windows notebook. But the following code still doesnt work:
//creating some new colums and fill them with stuff depending on the old ones (works properly)
...
//changing the type of one of the colums to 4 (=X axis)... doesnt work for some reason:
wks.col11.type = 4;
Can anyone tell my how to do this properly? |
| easwar |
Posted - 09/04/2011 : 10:49:24 PM
Hi Florian,
At the end of your import wizard filter, you can add LabTalk script to perform post processing. You can watch this movie:
http://originlab.com/index.aspx?go=Products/Origin/ImportingData&pid=1163
and/or this tutorial:
http://originlab.com/www/helponline/Origin/en/mergedProjects/Tutorial/Tutorial/Post_Processing_with_Import_Filter.html
If you need further help, post again.
Easwar
OriginLab
|
