how to show two different values from different file in one graph in DIAdem?

[dianasaleh]

hello,

i'm very new to DIAdem. I have to show 2 different values from 2 different files. For example;

File1:

at Frequency: 850MHz ; Voltage is: 2V

File2:

at Frequency: 850MHz ; Voltage is: 0.03V

My question is, how can i show both value in one graph in View or Report?

Confused,

Diana

[hass]

Hi Diana,

there are so many different ways to do that. To decide which way is the best, we need more information from what file do you get the values and what do you want to do with these values besides showing in VIEW or GRAPH and which version of DIAdem(?) you use.

I think the best way is to 'save' the values in channels, ie with ChnVal, ChD or ChDx:
ChD(Column,ChannelNo) = value

So, I see the following steps:
1. load (import) the first file and extract the values and save the values in variables
2. load (import) the 2nd file and extract the values and save the values in variables
3. prepare channels to include the values, call ChnAlloc("Frequency",2) and call ChnAlloc("Voltage",2)
4. save the values with ChD in the channels
5. showing the (two) channels in VIEW or GRAPH

Hope that helps

[dianasaleh]

Hi. I'm using DIAdem Version 10 and I import both files from Excel. What I did is:

1. convert the excel file to the tdm file

2. drag and drop the tdm file, the one i want to look at the values

3. For example. if i drag 2 files at the 'datenportal' then i just mark the channel i want for both files and  drag them to  view.

I hope it's correct. But can we just do a programming to call the graph that we want for certain values from multiple files. For example, i have 10 diffent files with same measurement only the values for every measeurement for every files are different. Do i have to convert every excel files that i have to tdm file first then only i can find the values using drag and drop function?

Diana.

[stefan.henke]

Hi Diana,

are you using the Import Assistant to load the XLS Files?

Remember, that you can save the Importconfiguration for the XLS, if your using Files, in which Data is organized the same way.

If you have alot Files from the same "Type" it might be effective to create a DataPlugin. Due this Plugin, DIAdem is able to interprete the Files so that you can handle them like TDM Files. If you have access to DIAdem 10.1, than you can use a DataPlugin Assistant to create this PlugIn.

After you have decided how to import the Files, we can talk about displaying Channel in a VIEW or REPORT.

Like you said, the Data will be available as TDM once they are in the Dataportal.

You can add channel via D&D from the Dataportal to a VIEW or REPORT.

The Record Modus of the Script Modul can help you to create VBS Syntax for the Steps you want to fulfill. Just start the Record Modus and do your Steps.

After the Code is created, you can make changes to add additional functionality if needed.

If there are further questions, feel free to post again.

Regards,

Stefan Henke

NIG

[dianasaleh]

Hi Stefan,

I got your point.Thank you. But is there any easy way to import multiple excel files via Script?

[stefan.henke]

Hi Diana,

I guess you did try the Record Modus in Script.

If you load multiple selected XLS Files you will still receive the Dialog, even if you use a saved Configuration. You have to quit every File.

Only due a DataPlugin DIAdem knows, how the Data is organized in the File and so only like that there is no Dialog needed.

In the script you can use a Loop and a Filelist or a Sequenze loading multiple Files.

Hope that helps a bit.

Regards,
Stefan

[Brad_Turpin]

Hi Diana,

Here is a DIAdem VBScript application which imports multiple Excel files.  It was originally designed to also concatenate the channels of the different files together, but I commented out the concatenation calls so that it only loads the Excel files into the DataPortal.

Brad Turpin
DIAdem Product Support Engineer
National Instruments

[dianasaleh]

Hi Brad!

I've tried the VBS File that you gave and it's working only with the Excel Files attached. Maybe there are something wrong with my excel files. Maybe they are not in the right format. When I start the script, only my excel files were loaded but the channel did not appear. Is the way I assigned my channel in the excel file wrong? Or because I have 60 channels? But I think the quantity of the channel is not a problem. In my excel file, the header of the file were written from A1 to A7, starting from A8 are the values of the measurement. Is that the problem?

Thank you by the way.

Diana

[dianasaleh]

I've figured out  the problem. I change the stp file  but still didn't work. Why?

[Brad_Turpin]

Hi Diana,

Yes, you would need to replace the STP file for the example Excel files I sent with your actual STP file.  So, you say it still doesn't work.  What does it do instead of working, exactly?  Is there an error?  Are the channels in the Data Portal not what you expect?

Brad Turpin
DIAdem Product Support Engineer
National Instruments