Ultipa Transporter supports cross platform operations of importing data from files (i.e., TSV, CSV), MySQL, BigQuery, etc. as well as exporting data as files.

Prerequisites

• data files, or the link of data source
• a command line terminal, such as:
  • Linux: bash, zsh, tcsh
  • MacOS X Terminal, iTerm
  • Windows: PowerShell
• a version of Ultipa Importer/Exporter compatible with your operating system

Change Log

V4.3.12

• Added support of sqlserver by mode

V4.3.10

• Supports CSV field separators: ^A，^B，^C，^D
• Supports data formats of point type:
  • {latitude:value,longitude:value} i.e.: {latitude:48.5, longitude:22.2}
  • [latitude, longitude] i.e.: [48.5, 22.2]
  • latitude, longitude i.e.: 48.5, 22.2

V4.3.8

• Supports value of mode: csv/bigQuery/postgreSQL/mysql
• Added sqlDatabase to configure database informationof MySQL and ostgresSQL
• Added quotes to configure the meaning of double quotation in the data field

V4.3.6

• Added mode to declare source type
• Added bigQuery to configure BigQuery project information
• Added sql to acquire data fields from BigQuery project (in replace of file)

V4.3.5

• Added new_name for modifying field name (under types)
• Modified logic when setting field type: yml > headers > default string
• Supports list, point type
• Parses null for no data between two delimiters