WebOffice 10.9 R4 allows an upload of point data with attributes from a text file (optional with layer file) with the Upload Local Geodata tool. For the upload from a text file you will need data from of the following formats:

•.txt

•schema.ini

•.lyr (optional)

 

These data have to be packed into a zip file by taking care of the names (.txt, .lyr and .zip file must have identical names e.g. point.txt, point.lyr and point.zip).

 

Prepare the Text File

Create an excel table with attributes and coordinates of the points. Format the table as text and be sure, that the coordinates do not have any delimiters and that a point . is used for the comma. Save the excel file as CSV file.

 

 

Next step is to open that CSV file in a text editor and save it as TXT file.

 

 

 

Prepare the schema.ini File

Additional information on how to prepare the schema.ini file you will find in http://msdn.microsoft.com/en-us/library/windows/desktop/ms709353(v=vs.85).aspx.

The name of the text file has to be written in square brackets. To identify the decimal places of the coordinates you will have to use a point as decimal symbol. After that define the columns, types and field lengths. The format defines the limitation symbol of the columns in the text file (in this case we use ; as limitation symbol).

 

 

 

 

Prepare the ZIP File

Create a zip file with the .txt and the schema.ini file by considering identical names for the ZIP file and the TXT file. Optionally you can put a LYR and/or a PRJ file into the ZIP (also same name as the ZIP file).

 

 

Now you can upload the created ZIP file, see chapter Add Data for details.