some examples of bulk csv file uploads that worked:
active etherpad:
advar_class,PORT,Name
104,13001,Norwood 1
sim:
advar_class,sim,cell
102,8927000000638549010,+27810312250
elster A1140:
advar_class,p3_num,p3_num0,SNUMBER,PLACE,ZONE,SITE,FULLLOAD,MNAME,CTPRIM,CTSEC,VTPRIM,VTSEC,PRIMARYM,COMDATE,PASSWD,MDID,WIRES
106,1,$eid{key2:Milling Plant;cid:138},71503586,,,,500,Milling Plant,500,5,1,1,Y,2012-11-21,FEDC0003,001,4
meter account:
advar_class,p6_num,p6_num0,p7_num,p7_num0,CNAME,ANUMBER,S0_portion,deftar,NMD0,START0
109,1,$eid{key1:61105001;cid:106},1,$eid{key2:Tshwane Business;cid:111},Norwood Shop 1,,+1.0,3,n.a.,2011-06-01
meter account linked to 2 tariffs:
advar_class,p6_num,p6_num0,p7_num,p7_num0,p7_num1,CNAME,ANUMBER,S0_portion,deftar,NMD0,NMD1,START0,START1
109,1,$eid{key1:55090106;cid:173},2,73,88,JWIK PROPERTY DEVELOPMENT 1,,+1.0,5,n.a.,n.a.,2012-10-17,2012-10-17
SL7000:
advar_class,p37_num,p37_num0,SNUMBER,PLACE,ZONE,SITE,FULLLOAD,MNAME,CTPRIM,CTSEC,VTPRIM,VTSEC,PRIMARYM,COMDATE,WIRES,nextb
140,1,3105,31501838,a,b,c,100,test3,100,5,400,400,Y,2013-04-02,4,Y

Common problem: remember to spell FULLLOAD with 3 L's :)

Brilliant

---

Common problem: remember to spell FULLLOAD with 3 L's :)

I will never forget!!!

Adding a Itron 6000 meter:
advar_class,p75_num,p75_num0:$eid{key1::},nextb,SNUMBER,PLACE,ZONE,SITE,FULLLOAD,MNAME,CTPRIM,CTSEC,VTPRIM,VTSEC,PRIMARYM,COMDATE,WIRES,PASSWD,MDID
173,1,203.4.11.201:10001,Y,63023062,,,,5,"Pro Range Bellville",5,5,400,400,Y,2013-04-04,4,,

Yes, it is very important to note that you can specify the $eid{} in the heading column, after the field name specifier, instead of on every line with the data. This is so that you can specify e.g. the serial number alone, in the column value, instead of the funny format/field specifier.

Basically, the first line's column name (before the optional : ) is the name of the HTML form variable as submitted to the add web screen of the entity. Bulk upload uses exactly the same functionality to add entities in PNPSCADA as the user when he uses the Add button on the Overview screen.

You can also use the pk1 (parent key1) or pk2 (parent key2) to specify an entity, and in case of non-unique fields, it is sometimes useful to also specify the class id of the kind of entity. The class id is a number. To see what the class id of an entity type is, refer to the web service documentation, or select the entity on the overview screen and hover over the entity type descriptor in the graphical square depicting the entity, and it should display as a tool tip, like so: 'cid: 109'

Also note that the key1, key2 and key3 fields, and the pk1 and pk2 fields, are matched using a case insensitive 'like' clause of an sql statement. What this means, is that you can specify wild cards. For instance if you want to specify the meter account number, you can specify the column heading e.g. like so:
interfList:$eid{key2::;cid:109}
and the value in the table cell like so:
%Electricity%; AN000123 %
where AN000123 is the Account Number of the meter account entity you want to specify, and 'Electricity' is somewhere in the meter acount name. (In SQL syntax, the % is like a * in Windows file system searches)

When you need to specify multiple items in a list, create a new column for each one, and give the heading the same name, e.g.
interfList:$eid{key2::;cid:109},interfList:$eid{key2::;cid:109},interfList:$eid{key2::;cid:109}
%Electricity%; AN000123 %,%Effluent%; AN000123 %,%Water%; AN000123 %
The above can be used pretty much like that within the greater Role bulk create csv upload file, to specify 3 entities to which the Role must have access.

Basically, when you look at the Add dialog for any type of entity, look at the HTML form. The names of the columns should correspond to the names of the FORM variables.

All that Bulk Add does, is it takes each line, then calls the Add dialog code with the values you specified in the columns of the spreadsheet.