importing ansi date time format into diadem

[adek]

Hi,

I have an ANSI data log txt file with the time channel format  30/03/2006 15:51:08.846 and i am trying import into DIADEM  using the date/time format dd/mm/yyyy hh:nn:ss.fff , but when the file is imported, the time channel cells appear as NO VALUE. Can anybody help please ?

AdeK

[Brad_Turpin]

Hi adek,

Are you using the "ASCII Import Wizard" or the "ASCII DataPlugin Wizard"?  Either one will successfully import your date/time column, but in both cases you will need to specify the European date/time format and the 3 millisecond digits as part of your date/time formatting string.

Could you please post a data file for us to look at?
Brad Turpin
DIAdem Product Support Engineer
National Instruments

[adek]

Hi Brad,

I'm using the ASCII import wizard, upon step 3 of 3 , highlighting the time column header and changing to the date/time format previously discribed in the dropdown box.

I can email the log file, where do I find your email address ...?

Ade K

[adek]

Brad,

File attached

Ade

[Brad_Turpin]

Hi Ade,

What version of DIAdem are you using?  If you're using DIAdem version 9.1 or later, I'll create a DataPlugin for you that reads this file in-- that'll be superior to using the ASCII Import Wizard.  If you're using DIAdem 9.0 or earlier, we'll have to go the ASCII Import route.  It's possible that DIAdem versions that long ago did have a problem with some time formats, but the file you sent me could be loaded perfectly in DIAdem 9.1 or later, for sure.

Brad Turpin
DIAdem Product Support Engineer
National Instruments

[adek]

Hi Brad,

I'm using DIADEM 10.2, so it should work ? maybe there's another setting I should be applying perhaps ?

I assume a data plugin is simple to use ?

Thanks for your help.

Ade 

[Twigeater]

Hello Ade!

The ASCII Import will work if you set the Textseperator (I don't know the exact english phrase, it is on the second page of the wizard in the upper/right corner) to no and use the format "DD/MM/YYYY HH:NN:SS.FFF" (with the quotes!).

Matthias

[Twigeater]

Here is my configuration file!

[adek]

Hi Matthias,

The setup file works perfectly.

Thanks for your help.

Ade

[Brad_Turpin]

Hi Adek,

Here is a DataPlugin which loads your data file into DIAdem 10.2.  There are a number of advantages to using a DataPlugin over the ASCII Import Wizard, so long as your data files follow a similar data file structure.  To register the DataPlugin, just detach the ZIP file, unzip the URI file within, then double-click on the URI file in Windows Explorer.  After that, you will be able to load your TXT data files by dragging&dropping them directly from the NAVIGATOR tree view or Search Results into the Data Portal on the right hand side of DIAdem.  DataPlugins also support selective loading, register loading, reduced loading, and DataFinder indexing, so all of these immediately become available to you with your TXT files.  Note also that header lines 2-4 are now declared as both File and Group properties.

Ask if you have questions using the DataPlugin,
Brad Turpin
DIAdem Product Support Engineer
National Instruments