If you wish to import data from a CSV file into Data Share or any other PostgreSQL database this can be done using the Spatial Data Transformation Task.
| Info |
|---|
| If you CSV contains Easting & Northing attributes, and you wish to spatialise your data, then you may wish to read Spatialise a CSV file with Easting & Northing attributes for more information. |
Task Name
Enter a name for the task.
Source Data
Select Comma-Delimited Text File as the Source Data.
| Note |
|---|
If Comma-delimited Text File does not exist in the list of "Source Data" types then you will need to edit the ConTypes.xml file, which you will find in the ...Astun\iShare\n.n\Studio\config folder. If you open ConTypes.xml with a text editor you will see options for DBConTypes (servers, such as PostgreSQL and Oracle) and FileConTypes (file formats such as shapefile or mapinfo tab). Create a new FileConType entry after the last closing </FileConType> tag (but before the closing </ConnectionTypes> tag as follows: |
| Code Block | ||
|---|---|---|
| ||
<FileConType> <Name>Comma-Delimited Text File</Name> <FormatName>CSV</FormatName> <Direction>Both</Direction> <FileFilter>Comma-Delimited Text files (*.csv)|*.csv</FileFilter> </FileConType> |
Filename
Enter the path to the .csv file that you wish to Import.
Output
Select the PostgreSQL database where you wish to store this data.
Table
Enter the table name where you wish to store the data in the database.