| Author |
 Topic  |
|
|
EigenGoofy
64 Posts |
 Posted - 08/15/2011 : 10:44:09 PM
|
Origin Ver. and Service Release (Select Help-->About Origin): 8.5
Operating System: WinXP
Hello!
On the 1st page of Import Wizard:
Use Import Wizard to import two files: r2A.xvg and r2B.xvg
where r2A.xvg is a ASCII data file with two columns A(X) and B(X), and so is r2B.xvg. If importing the two files, then we have 4 columns, namely A(X), B(X), C(Y), and D(Y).
Data Type: ASCII
Import Filters: None
Import Mode: Start New Columns
On the 2nd page of Import Wizard:
Check the boxes:
worksheet with filename
workbook with file name
file name to workbook comments
file name to column comments
On the 3rd page of Import Wizard:
did not change anything, which means 6 "None", "0", "system" ,and "50".
On the 4th page of Import Wizard:
Check the box:
Save file info. in workbook
On the 5th page of Import Wizard:
On the Column Separator: choose "Delimiter", and check "Space".
The rest are default.
On the 6th page of Import Wizard:
"Read as text" and No check to Partial Import
On the 7th page of Import Wizard:
Check "save filter"
Click "in the user files folder"
Filter file name: "my filter1"
Check "Specify advanced filter options"
On the last page of Import Wizard:
The following labtalk code will be executed after successful import:
type "del col(C);"
click "Finish".
Result and Question:
The result seems normal - it really delete col(C) as I wish. However, the Script Window pops out and says:"col(C) is not a valid column in worksheet r2A". I don't know why it says so, and how to eliminate this annoying reminder.
There is only one worksheet called r2B, and no worksheet called r2A. And, the long name of the workbook is r2B.xvg, and the short name is r2B. I just don't understand why the program is looking for the name r2A. Please note that if I change the oder of import, say importing r2B before importing r2A, then the Script Window says "col(C) is not a valid column in worksheet r2B", and vice versa.
I would just ignore this warning, because everything works fine. However, how to let the big tongue of the Script Window shut up is wanted up.
Thanks very much! |
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 08/16/2011 : 10:52:24 AM
|
Hi EigenGoofy,
The setting of "Start New Columns" may cause the import process as with following columns:
[1st file]
{ a b c d }
{ a b d }
[2nd file]
{ a b d / c e f g}
{ a b d / e f g}
Therefore, the first column in the second file may have been deleted.
Please check if the import result is what you expected. (Try to change the Import Mode to "Start New Sheets" from "Start New Columns".)
Sheet name has been updated every time the each file is imported. That is why the sheet name reflects the file order of importing.
At this moment, I couldn't reproduce the error message you got in the Script window. Can you send your two files to tech@originlab.com with Subject ATTN:Hideo referring to this forum post??
Thanks!
--Hideo Fujii
OriginLab
|
 |
|
|
EigenGoofy
64 Posts |
Posted - 08/19/2011 : 01:10:54 AM
|
On the last page "the Advanced Option page"of Import Wizard, where could I find an option to choose so that it "Run script after all files imported"?
Thank you very much! |
Edited by - EigenGoofy on 08/19/2011 01:11:57 AM |
|
|
|
EigenGoofy
64 Posts |
Posted - 08/19/2011 : 7:29:18 PM
|
My own way to solve this problem.
To avoid the error message "col(C) is not a valid column in worksheet r2ekrrun7", modifying the original code inside the filter or check some boxes may not solve the problem, instead, it may result even worse situation - because it may result even more and different error messages. The correct way to do is to return to the default setting by reseting all the options, and after that to replace the current filter with a back-up filter. If there is no back-up filter, then manually write a complete new filter under the environment of the default setting.
The detailed steps:
1, click "Tools", on the submenu click "Options..", then click "Reset".
2, A message pops out to ask me whether the OriginLab should use the new setting as the starting setting, Click "yes".
3. Restart OrginLab.
After the third step, I expect the problem would have been solved. The answer is "NO". The result may be different from any previous result, but still it is not normal. So there is a critical step 4.
4, In the User Folder, use my back-up filter to replace the current filter. Then restart OriginLab, the problem is solved. No anymore error message is observed so far!
Analysis:
Actually, the code description on the back-up filter is the exact same as the code description on the current filter, and all the options are also the same. The only difference between the back-up filter and the current filter is that the back-up filter was modified less times than the current filter was, in other words, it means the modification history on the back-up filter is shorter than the modification history on the current filter.
If we compare the file size between the back-up filter and the current filter, then the file size on the current filter is a little larger than the file size of the back-up filter, which means that the OriginLab in fact somehow saves the modification history into the filter. If the filter is modified, then it is changed permanently; it can not go back by simply deleting the part that we modified.
|
Edited by - EigenGoofy on 08/19/2011 7:31:26 PM |
|
|
| |
Topic |
|
|
|
"col(C) is not a valid column in worksheet r2A"