Append view layouts/worksheets with automatic increase of link to datasets in the DataPortal - DIAdem VIEW

[Stijn80]

Hello,

Unfortunately I couldn't find a solution for the following problem yet.

When I run for instance 10 time the same kind of test with only a small difference in what I am testing. The labels, frequency etc. is the same, but I have 10 seperate logfiles. I load these files as 10 seperate groups in the DataPortal and I make a VIEW layout with labels from the 1st group. 

How can I easily create 10 VIEW worksheets with in the 1st Worksheet links to data in the 1st group in the DataPortal in the 2nd Worksheet links to the data in the 2nd group in the DataPortal,...etc.

What I do at the moment is make a VIEW layout with data from the first group. Save this VIEW layout and append this VIEW layout and change all the links in the 2nd group in the DataPortal. With for instance 10 logfiles this is in case of a comprehensive VIEW layout a lot of work and the risk is high that faults will be made.

I hope someone can help me!

Thanks in advance!

Stijn

[Brad_Turpin]

Hi Stijn,

If you'll post or email your VIEW layout and a few data files, I can create a VBScript that does that channel reference replacement automatically.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Stijn80]

Hello Brad,

Thanks for your reply! Is it possible to make this script for different kind of VIEW layouts and/or different kind of recorders/amount of recorders? I do a lot of different kind of tests, so I am not using the same VIEW layout all the time.

It would be nice if I can get a general script for this.

With kind regards,
Stijn

[Brad_Turpin]

Hi Stijn,

I can make the script general purpose, but I still want to test it with your data and one or more of your TDV files.

Brad Turpin

DIAdem Product Support Engineer

Naitonal Instruments

[Stijn80]

Dear Brad,

See attached an example of 6 different measurements which I would like to display in the VIEW in 6 separate worksheets with the 1st worksheet which is in the ZIP file as an example for the 2nd, 3rd, 4th, 5th and 6th worksheet with links to the  2nd, 3rd, 4th, 5th and 6th test in the Data Portal.

It would be really nice if you can create a script for general purpose.

Thanks in advance!

With kind regards,

Stijn

[Brad_Turpin]

Hi Stijn,

Sorry for the delay.  I'm attaching a script that should give you a solid foundation.  It iterates over all loaded Groups and loads a VIEW sheet for each of those Groups, then opens up any tables or 2D graphs on the VIEW sheet and rewires the column or curve references to point to the associated Group.  All you need to do is place this VBScript in the same folder as the files you sent me and run it in DIAdem SCRIPT.  I'd be happy to discuss making it easier to run from the DIAdem GUI, once you're happy with it.

If you need support for further VIEW objects, please send me a TDV and TDM/TDX sample to test with.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Stijn80]

Hi Brad,

Thanks a lot for the script! It works very good and it saves a lot of time!

Is it hard to change the script to use it for the same purpose but then with the REPORT instead of the VIEW or can you easily change the script for this purpose?

With kind regards,

Stijn

[Brad_Turpin]

Hi Stijn,

The commands are significantly different in REPORT.  I have most of it implemented using the pre-2012 REPORT functions.  If you'll send over a TDR file to go with the data set, I'll verify that what I have works for you and send it back.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Stijn80]

Hi Brad,

See the attached file with an example TDR file.

Thanks!

Stijn

[Brad_Turpin]

Hi Stijn,

Looks like it works just fine.  See the attached file.

Brad Turpin

DIAdem Product Support Engineer

National Instruments