Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: Importing multiple ASCII files into one channel
72 views
Skip to first unread message
Brad Turpin
Feb 14, 2008, 10:40:11 AM2/14/08
to
Hi SethRow187,
I agree with Ingo, first go through the ASCII DataPlugin Wizard in DIAdem 10.0 or later to generate a DataPlugin which will automatically load one of your ASCII files. Then I would recommend using a VBScript that either concatenates data already loaded from multiple files into separate Groups in the Data Portal, or using a VBScript that additionally pops up a multi-select file dialog to automate both the selection and concatenation.
Below you will find an example of the latter,Brad TurpinDIAdem Product Support EngineerNational Instruments
P.S. You will need to edit lines 17 and 18 in the script "Importing Data From Multiple DataPlugin Files.VBS" and replace the existing file extension and DataPlugin name with ones that fit your data files.
I agree with Ingo, first go through the ASCII DataPlugin Wizard in DIAdem 10.0 or later to generate a DataPlugin which will automatically load one of your ASCII files. Then I would recommend using a VBScript that either concatenates data already loaded from multiple files into separate Groups in the Data Portal, or using a VBScript that additionally pops up a multi-select file dialog to automate both the selection and concatenation.
Below you will find an example of the latter,Brad TurpinDIAdem Product Support EngineerNational Instruments
P.S. You will need to edit lines 17 and 18 in the script "Importing Data From Multiple DataPlugin Files.VBS" and replace the existing file extension and DataPlugin name with ones that fit your data files.
Importing Data from Multiple DataPlugin Files.zip:
http://forums.ni.com/attachments/ni/60/8103/1/Importing Data from Multiple DataPlugin Files.zip
Brad Turpin
Feb 15, 2008, 10:40:13 AM2/15/08
to
Hi SethRow187,
Well, you can change the script to do anything you want. One way you could use the existing script to accomplish what you suggest is to save the intermediate group of processed or concatenated values to a new temporary file, then load in the additional data from the extra N files and have that data concatenated into one group, then save that group to another temporary file. Then you could run the script a final time to concatenate the results from the two temporary files.
It's your choice whether you want to adapt the script to do these sorts of things for you automatically, or whether you want to live with the clunkiness required to use the script as it is to accomplish your additional use cases. Certainly it is possible to concatenate from selected groups to a specific target group, without having to resort to unnecessary temporary files.
Well, you can change the script to do anything you want. One way you could use the existing script to accomplish what you suggest is to save the intermediate group of processed or concatenated values to a new temporary file, then load in the additional data from the extra N files and have that data concatenated into one group, then save that group to another temporary file. Then you could run the script a final time to concatenate the results from the two temporary files.
It's your choice whether you want to adapt the script to do these sorts of things for you automatically, or whether you want to live with the clunkiness required to use the script as it is to accomplish your additional use cases. Certainly it is possible to concatenate from selected groups to a specific target group, without having to resort to unnecessary temporary files.
Marse
Aug 12, 2008, 6:10:09 AM8/12/08
to
Hello Brad,
I want to creat a report for some measurements that I do with an equipment, and I must use Diadem, and for that I transfer the data( a .csv file) in Diadem and I've use your script "Importing Data from Multiple DataPlugin Files.zip" and that help me, but I want to modify the script, and when I start to run the script and load the .csv file to appear with other field (like in attachment - I insert with <freetext> the fields that I need).
Can you tell me how to modify the script, to start with the Fields that I need (see attachment)?
I'm new in working with Diadem, so I don't have good knowledge about that.
Thank you a lot.
I want to creat a report for some measurements that I do with an equipment, and I must use Diadem, and for that I transfer the data( a .csv file) in Diadem and I've use your script "Importing Data from Multiple DataPlugin Files.zip" and that help me, but I want to modify the script, and when I start to run the script and load the .csv file to appear with other field (like in attachment - I insert with <freetext> the fields that I need).
Can you tell me how to modify the script, to start with the Fields that I need (see attachment)?
I'm new in working with Diadem, so I don't have good knowledge about that.
Thank you a lot.
report1.pdf:
http://forums.ni.com/attachments/ni/60/9191/1/report1.pdf
Brad Turpin
Aug 12, 2008, 5:10:12 PM8/12/08
to
Hi Marse,
The example I sent that you are running loads a *.TDV file into the VIEW panel. If I understand you correctly, all you need to do is edit the *.TDV file to be what you want with the desired <freetext> fields in the legend, then save the *.TDV file and overwrite the one I sent you. The next time you run the example it will load the edited *.TDV with the desired <freetext>.
The example I sent that you are running loads a *.TDV file into the VIEW panel. If I understand you correctly, all you need to do is edit the *.TDV file to be what you want with the desired <freetext> fields in the legend, then save the *.TDV file and overwrite the one I sent you. The next time you run the example it will load the edited *.TDV with the desired <freetext>.
Marse
Aug 13, 2008, 7:40:26 AM8/13/08
to
Thank you Brad, I've found out later and I modify the .TDV file. Now is ok.I have one more question (I repeat, I'm new in Diadem), there is a way to creat the template in a way that the value for the fields that I creat to be near the field( like I draw in atachment)? Thank you again
report1.png:
http://forums.ni.com/ni/attachments/ni/60/9213/1/report1.png
Brad Turpin
Aug 13, 2008, 11:40:13 AM8/13/08
to
Hi Marse, If I understand your request correctly, you want the property name and the property value to be side by side (the name on the left, the value on the right) in the VIEW legend. This is not possible-- there is no setting in VIEW to repeat the property name for every channel in the legend and display the name and value side by side for each channel. What you can do with a bit of effort, though, is construct something similar with a few VIEW textbox areas and the corresponding channel and property references in @@ expressions. Try this example,
Brad Turpin
DIAdem Product Support Engineer
National Instruments
Brad Turpin
DIAdem Product Support Engineer
National Instruments
Textbox Legend.zip:
http://forums.ni.com/ni/attachments/ni/60/9220/1/Textbox Legend.zip
Marse
Aug 14, 2008, 7:40:08 AM8/14/08
to
Hy Brad, I have a question regarding Diadem, and I didn't find any topic on forum.I have a device compose by two motors and a controler from Baldor, and I've made a program with the Baldor soft ( the script is similar like the script used for Diadem -VBS) and I want to use Diadem to start the program from Baldor,and after that to analyze with Diadem the result. The Poject extension from baldor is .wbx ( see atachment) and he creat a file of data type .csv.Can I connect Diadem with the program from Baldor? If yes how can I do that?Why kind of application can I acces with Diadem , but not created with Diadem? Thank you again for your help.
Baldor's program.zip:
http://forums.ni.com/ni/attachments/ni/60/9226/1/Baldor's program.zip
0 new messages