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
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 Can't set number of columns ascimport ascimp		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

eyP

Germany
Posts
Posted - 11/30/2006 :  08:40:16 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (Select Help-->About Origin): 7G SR4
Operating System: Windows XP

I want to set the number of columns with LabTalk. I use the ascimport function but the radio button remains too unknown.
I get an error message "The file contains no ascii data".
When I use the Ascimport.Partial function I get the same message.
This was suggested in Forum task "Ask ascimport.numcolumns".
It's possible to solve this with Origin C?


If I use a wks template where the option is set correctly (2 columns), it is set back to unknown if I use:
ascimport.GetSettings();
ascimport.WriteSettings(); //To set the import file name in between
Is there a Origin C statement to set the radio button back to two columns?



Best regards


Edited by - eyP on 11/30/2006 09:04:08 AM

zachary_origin

China
Posts
Posted - 12/01/2006 :  08:07:10 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Can the data be imported by manually operation from the menu? By default, if the number of columns is set as unknown all the columns will be imported. Maybe you need paste your LabTalk script and pieces of the data here so that we can get more information.

Zachary
OriginLab Technical Services.

Edited by - zachary_origin on 12/01/2006 08:11:23 AM
Go to Top of Page

eyP

Germany
Posts
Posted - 12/05/2006 :  04:54:19 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
The data can be imported manually. The separator is ":" with two columns.
The idea is to import the file header with this setting to collect specific values (wert1...wert3, 2 columns) and to look for the beginning of the measurement data.
In a second import step the measurement data is imported (4 columns).
There are two problems: The ASCII error message and the automatic 2 column import.


This is the data file:->
quote:

[DATEIKENNUNG]
Kennlinie
CX4G HP Messplatz

[Option1]
Feld1:wert1
Feld2:wert2

[Option2]
Feld1:wert1
Feld2:wert2
Feld3:wert3

[Messdaten]

[Eckdaten]


Ith I@10000 mW Slope U@16677mA Rs
[mA] [mA] [W\A] [Ohm]

If [mA] Po [mW] Uf Imo [mA]
0.00 15.00 0.07 0.00
387.00 8.00 1.25 0.00
1068.00 14.00 1.30 0.00

This is the import routine:->

ascimport.GetSettings();
ascimport.Partial.C1=1;
ascimport.Partial.C2=2;
ascimport.Partial.R1=1;
ascimport.Partial.R2=40;
ascimport.Delimited=1;
ascimport.Delimiter=4;
ascimport.Character$=":";
ascimport.Width$="";
ascimport.HeaderLines=0;
ascimport.SubHeaderLines=0;
ascimport.AutoSubHeaderLines=0;
ascimport.Mode=0;
ascimport.NumColumns=2;
ascimport.partial=0;
ascimport.RenameWks=0;
ascimport.ApplyRange=0;
ascimport.RenameCols=0;
ascimport.Labels=0;
ascimport.MaxLabels=0;
ascimport.LeadingZeroes=0;
ascimport.NonNumeric=1;
ascimport.FileName$=%A;		//Import Dateiname
ascimport.AutoColTypes=0;
ascimport.TestLines=3;

ascimport.WriteSettings();
ascimport.import();


Edited by - eyP on 12/05/2006 05:09:33 AM
Go to Top of Page

Mike Buess

USA
3037 Posts
Posted - 12/05/2006 :  2:56:12 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Under many circumstances ASCII Import assigns the file header to the string variable %Z. The following script imports all four data columns to the active worksheet and creates a text label for the header.

ascimport.GetSettings();
ascimport.Delimited=1;
ascimport.Delimiter=3; // delimiter=space
ascimport.Partial=0;
ascimport.HeaderLines=0;
ascimport.SubHeaderLines=0;
ascimport.AutoSubHeaderLines=1;
ascimport.RenameWks=0;
ascimport.ApplyRange=0;
ascimport.RenameCols=0;
ascimport.Labels=0;
ascimport.MaxLabels=0;
ascimport.LeadingZeroes=0;
ascimport.NonNumeric=1;
ascimport.AutoColTypes=1;
ascimport.TestLines=3;
ascimport.WriteSettings();
ascimport.FileName$=%A;
%Z="";
ascimport.import();
if( %Z!="" ) {
ty -a %Z; // type header to script window
label -s -n Header %Z; // type to text label
Header.top=0;
Header.left=400; // adjust to suit
};

Mike Buess
Origin WebRing Member
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000