How to create dataplugin using .csv file?

[musunurudiadem]

I have a csv file iam traying to create dataplugin ...what are the steps to do.

I am trying for this from last 3 days ...data is not updating into the database.

i hope iam not creating dataplugin in correct way ...

please send to mdilip.sp@gmail.com

[K_Joy · Accepted solution]

Hello musunurudiadem,

Have you tried the process in these documents?

http://www.ni.com/white-paper/13758/en/

http://digital.ni.com/public.nsf/allkb/AB28139F280CC3E586257563005B9664

In the first link, if you click on the boxes in the flowchart it will take you to walkthroughs for different part of getting data into DIAdem.

Since your data is in a CSV file, you may be able to use the Wizard:

http://www.ni.com/white-paper/13789/en/

If you can't use the Wizard, here are some resources for programming your own plugin:

http://www.ni.com/white-paper/13803/en/

Kelsey Johnson

Applications Engineer

National Instruments

[Brad_Turpin]

Hi musunurudiadem,

If you will post a sample data file, I can tell you how hard it will be to create a DataPlugin for it and whether the ASCII DataPlugin Wizard is a good tool to use for that file.  If it's simple enough, I might be able to crank out a quick DataPlugin for you.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[musunurudiadem]

Hi

Thank you so much for the reply.

I attached csv file.

Thanks in advance

Thanks

..............

dilip

[Brad_Turpin]

Hi dilip,

Is this what you had in mind for that file?

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[musunurudiadem]

Hi Brad,

Thank you so much , I appriciated for your kind help.

Now I will test the applicaiton using this dataplugin and i will let you know the result .

Onces again Thank you

[musunurudiadem]

Hi Brad,

AMERROR: Cache import Failed  'E:\Incoming\PM_LAB LEVEL_LL_SC03_CELL3_20131009_005_R02.csv' into cache: Microsoft VBScript runtime error(500):Variable is undefined

any clue ?

Thanks in advance.

[Brad_Turpin]

Hi musunuru,

Did you double-click the *.uri file to register the DataPlugin?  Did you thereafter drag the *.csv file you sent me into the DIAdem Data Portal?  If not, what actions on your part caused the reported errors?  What version of DIAdem are you using?

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[musunurudiadem]

Hi Brad,

How are you? I hope every thing is fine from your end.

Sorry for late reply, Here

In that csv file every row of first colum we created as a colum in the oracle table.

So according to that i need to create the dataplagin.

I tried but iam getting only Itemid,section,value,unit as a channels not like 64rows as channels

c_PM_Weighted_Total,..,...

Please help me

[Brad_Turpin]

Hi Musunuru,

It looks like this latest file with the same name as the last one has a few more commas in the first line.  I tweaked the DataPlugin to be happy with that variation, but I have not changed the declaration of a DIAdem channel for every column in your data file.  I understand that you are saying you want each row in the data file to become a channel in DIAdem, but I have not implemented that yet.  First I want you to tell me what you want to do with 62 channels that each have 1 data value.  Also, you mentioned an Oracle data base-- where does that figure into your data handling process?

Brad Turpin

DIAdem Product Support Engineer

National Instruments