Hide Comments
Hide Comments

Upload Point Data with Attributes from a Text File

Comments (0)

WebOffice 10.9 SP2 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

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

Save CSV as TXT file

 

icon_comment

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).

 

icon_comment

Make sure you do not have any additional spaces at the end of the line.

 

Structure of the schema.ini file

Structure of the schema.ini file

 

icon_comment

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

Structure of the ZIP file

 

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

 

icon_cross-reference

See chapter Add Dynamic Workspaces to SynOutputService for details about adding dynamic workspaces to the SynOutputService.

See chapter Upload Local Geodata for details about the tool configuration in WebOffice author.

Comments (0)

Ⓒ Copyright 2022 by VertiGIS GmbH