Bulk upload virtual meters

Avatar

sdg.marinusvz
2013-06-22 18:56

Hello Marinus
I am trying to do a bulk upload of virtual meters for testing purposes on the Hydrosave account. They just need to be simple virtual water and electricity meters to facilitate cellphone-based manual readings.
I have included all columns in the .csv file according to the source page for adding a new virtual meter.

The upload consistently returns the error ?Please make sure that your Meter does in fact log this specific event,? although no events have been specified.

Below is what the sample file looks like. Can you please tell me if I?m on the right track here?
advar_class,name,vserial,util,meterSerialNumber,IncomermeterSerialNumber,eventid,phase
151,vm_1,abc123,Water,,,,

Avatar

sdg.marinusvz
2013-06-22 18:56

Go look at the form that you get from the Add button. Look at the HTML source. Is there maybe a column missing for the submit button?

Avatar

sdg.marinusvz
2013-06-22 18:57

I tried adding a column for the submit button with no luck. It brings up a number format exception due to a null string.

I seem to be missing a column but after checking the HTML source again it appears that all columns have been included in the .csv.

Could it be that I need to fill in a value for ?meterSerialNumber?, ?IncomermeterSerialNumber?, ?eventid? or ?phase?? I don?t touch these when adding new virtual meters manually?

Avatar

sdg.marinusvz
2013-06-22 18:57

Do they have default values in the HTML INPUT tags?

Avatar

sdg.marinusvz
2013-06-22 18:57

Most of the defaults are empty “”. For “phase” and “eventid” the default values that appear in the “add new” screen are represented by “%” in the first “option” tag under their respective “select” tags. The default value for “util” is “Electricity”. I have replaced this with “Water”, which works when done manually in the “add new” screen.

After adding the “%” as values for “eventid” and “phase” the following error still arises:

advar_class,name,vserial,util,meterSerialNumber,IncomermeterSerialNumber,eventid,phase,Finish
151,vmtest1,abc123,Water,,,%,%, Finish ,"Exception: java.lang.NumberFormatException: For input string: 'null'"
So your upload as per your second post in this thread should have worked. Why didn't it? Perhaps you can post an example of it please?

Avatar

sdg.marinusvz
2013-06-22 18:58

You left out the Finish button.
Try this example, it works:
advar_class,name,vserial,util,meterSerialNumber,IncomermeterSerialNumber,eventid,phase,Finish
151,vm_1,abc123,Water,,,,,Finish

Please log in to post a comment