Appending or Replacing data sets in DIAdem

[Stysley]

I was wondering if there was an easy way to take new data points and append them to old data points already loaded into DIAdem.  Similarly I would be interested in just replacing the old data with the new

I have a data set I have uploaded from an excel file into DIAdem.  Within DIAdem I have manipulated data and made several graphs for presentations.  Since that first upload of data I now have acquired new data.  That new data is in the same format as the old data, it's simply that there are more data points now.  So it would be nice to know how to either append or replace the old data while keeping all the formatting.  

Right now the easiest way I've found is to copy and paste data into a new Excel file and upload it.  DIAdem scripts have proven buggy and inefficient.  I can't believe Excel would handle appending better than DIAdem.  There must be an easy way to do this that I am missing.  Any help would be appreciated.  

[Matthew.cf828br]

Hi,

I think one possible solution to the problem is to create a new channel in your data portal containing the data which needs to be appended. For example call this new channel, channel_x. Now assuming that you already have your original data in the data portal in another channel called, channel_y, via a single line in a script it is possible to append one to another.

The code will be something along the lines of:

Call ChnConcat("channel_x","channel_y")

This single line appends the values in channel_x to channel_y.

Regards

Matthew

[Brad_Turpin]

Hi Stysley,

Unless you're talking about a huge amount of data, I'd say the easiest and cleanest way to do this would be to delete all your channels in DIAdem and reload them from the (now larger) data file.  Then all you have to do in REPORT is hit the "Refresh" icon.

It sounds like you are loading your data files into Excel-- does that mean that you have ASCII data files to start with?  The best approach in that case would be to create a DataPlugin for the ASCII data file format and avoid the intermediate Excel step.  Then re-loading the data would be as easy as hitting the "Delete Internal Data" icon in the NAVIGATOR and then dragging the ASCII data file from the NAVIGATOR tree view into the Data Portal at the right of DIAdem.

If you'll post or email me (brad.turpin@ni.com) several of your ASCII files, I should be able to send you back a DataPlugin you can use.

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[Stysley]

I do have them in text format (comma delimited) but the files range from 20 - 50 mb.  What is the best way to get that to you?

thanks

[Brad_Turpin]

Hi Stysley,

Why don't you post them to our incoming ftp site, then send me an email with the name of the ZIP file you uploaded:

ftp.ni.com/incoming

brad.turpin@ni.com

Note that WINDOWS Explorer (not Internet Explorer) works best with our ftp site.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Stysley]

I emailed you a week ago, did you get the files?

thanks

[Brad_Turpin]

Hi Stysley,

Sorry, no, I don't remember seeing an email from you.  Did you identify yourself as "Stysley"?  Did you include the data file as an attachment to the email or did you post it to the ftp site?  I think NI rejects any email attachments bigger than about 10 MB.  If you posted it to the ftp site a week ago, you'll likely need to post it again.

I am really willing to help,

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[Stysley]

Sent an email again.  I didn't get a bounce back.  The email should've contained the files

thanks

[Brad_Turpin]

Hi Stysley,

This is so weird.  I looked through the 20 emails I've received since 4:30pm yesterday, and none of them are from anyone I don't know.  I also see no emails with an attachment of data files.  I don't think it arrived, but I have no idea why it didn't bounce if your email server or mine refused to send/receive it.  Have you tried emailing me WITHOUT an attachment?  It would be nice to know what email address to look for.

Alternatively, you could choose to post to the incoming ftp site.  At least we can communicate through the Forum.

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[Stysley]

ok I just sent a test email at about 3pm est friday.