Re: [WDB-Users] wdb-fastload data format

[Vegard B. <veg...@me...>]

Hi!

Each line fed to fastload will (should) create a single row in the database. The exception, of course, is the data provider line. Python code to create fastload output could look something like this:

def generate_data():
    in some loop:
        # assign value, place, referencetime, etc..
        yield value, place, referencetime, validfrom, validto, param, level, level_from, level_to 

def writeit(dataprovider):
    sys.stdout.write(dataprovider + '\n') # optionally add namespace identifier
    for data in generate_data():
        sys.stdout.write(str(data[0]))
        for element in data[1:]:
            sys.stdout.write('\t')
            sys.stdout.write(str(element))
        sys.stdout.write('\n')

Does this answer your question?


Level parameter is the z dimension. If you don't care about that, you can simply say something like

height above ground\t0\t0


VG



----- Original Message -----
Fra: "Filippo Locci" <fil...@gm...>
Til: wdb...@li...
Sendt: 30. april 2012 15:25:15
Emne: Re: [WDB-Users] wdb-fastload data format


Hi, 




I'm writing a program in python to translate my data in a format digestible from wdb-fastload; 

from the help I see: 


"When loading data, you need to follow the format described here: 


All files consists of sections, starting with a data provider name on 
one line, optionally followed by a tab character and a three-part namespace 
specification. Data listings should follow on the next lines, with no blank 
lines between data elements. 


The "current" data provider is reset after a blank line has been 
encountered. The next line is then expected to contain the name of the 
next data provider to use. 


The data listings follow the same pattern as the wci.write function 
call parameters, with a few exceptions: It should contain instructions 
for inserting a single tuple on each line. The elements on each line 
should not contain any quotation marks. Also, the separator between 
fields should be a single tab character. 


Here is the ordering of elements in the data list: 


* value 
* place name 
* reference time 
* valid from 
* valid to 
* value parameter name 
* level parameter name 
* level from 
* level to" 


Does each element in the data list write row by row? 
Otherwise: 


DATA_PROVIDER 
VALUE PLACE_NAME REF_TIME VALID_FROM VALID_TO VALUE_PAR_NAME LEV_PAR_NAME LEVEL_FROM LEVEL_TO 


What's the meaning of level parameter name; level from; level to? 
Thank you so much 
Filippo 

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
WDB-Users mailing list
WDB...@li...
https://lists.sourceforge.net/lists/listinfo/wdb-users