WebOffice 10.9 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.
Save Excel table as CSV file
Next step is to open that CSV file in a text editor and save it as TXT file.
Save CSV as TXT file
Note: The name of the TXT file is not allowed to start with a number or with an underscore.
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).
Note: Make sure you do not have any additional spaces at the end of the line.
Structure of the schema.ini file
Note: Before creating the .zip file ensure a successful import in ArcMap with the tool "Data Management Tools / Layers and Table Views / Make XY Event Layer" from the toolbox.
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).
Structure of the ZIP file
Now you can upload the created ZIP file, see chapter Add Data for details.
Note: See chapter Add Dynamic Workspaces to SynOutputService for details about adding dynamic workspaces to the SynOutputService.
Note: See chapter Upload Local Geodata for details about the tool configuration in WebOffice author.
Comments
0 comments
Article is closed for comments.