02-13-2014 04:46 PM - edited 02-13-2014 04:54 PM
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
Solved! Go to Solution.
02-14-2014 04:58 PM
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
02-19-2014 05:44 PM
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
02-20-2014 06:25 AM
Hi
Thank you so much for the reply.
I attached csv file.
Thanks in advance
Thanks
..............
dilip
02-20-2014 09:54 AM
Hi dilip,
Is this what you had in mind for that file?
Brad Turpin
DIAdem Product Support Engineer
National Instruments
02-20-2014 10:11 AM
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
02-20-2014 12:22 PM
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.
02-20-2014 12:38 PM
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
03-10-2014 09:49 AM
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
03-12-2014 05:40 PM
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