Online Documentation for Data Import for PostgreSQL

EMS Data Import FAQ


Please read this page attentively if you have questions about Data Import for PostgreSQL.

 

Table of contents

 

 

Question/answer list

 

Q: What is EMS Data Import for PostgreSQL?

A: EMS Data Import for PostgreSQL is a powerful tool to import your data quickly from MS Access, MS Excel, DBF, TXT, CSV, XML, MS Excel 2007, MS Word 2007, HTML, ODF files to PostgreSQL tables. It provides adjustable import parameters, including source data formats for all the fields and destination data formats for the selected fields, commit options, number of records to skip, etc. Data Import includes a wizard which allows you to set all the import options for different files visually, and a command-line utility to execute import in one-touch.

 

 

Q: What do I need to start working with EMS Data Import for PostgreSQL?

A: First of all, you must have a possibility to connect to some local or remote PostgreSQL server to work with Data Import. You can download PostgreSQL database server from https://www.postgresql.org/download/. Besides, you need your workstation to satisfy the system requirements for Data Import for PostgreSQL.

 

 

Q: What is the difference between the Import feature of SQL Manager for PostgreSQL and the Data Import for PostgreSQL utility?

A: First of all, Data Import for PostgreSQL works faster as it is a considerably lighter application. Besides, it provides additional features for query building, namely:

  • import data to several tables simultaneously;
  • import data to tables selected from different databases;
  • the command-line version of the utility to import data using the configuration (template) file with all import settings;
  • automatically creates table structure.

 

 

Q: Are there any limitations implied in the trial version as compared with the full one?

A: Actually the trial version of the utility only allows you to import 20% of records into each table. With this limitation, you can test all the features implemented in Data Import for PostgreSQL within the 30-day trial period.

 

 Note: There is a 100 records (instead of 20%) limitation when importing from CSV, TXT or MS Access files.

 

 

Q: What is the easiest way to configure the template files for the Data Import console application?

A: You can configure the template files for each table visually using the Data Import Wizard application. Set the required options and select the Tools | Save Template menu item. All the options will be saved to the template file which can be used by the console application.

 

 

Q: I work behind a firewall (router). Can EMS Data Import connect to a remote PostgreSQL server?

A: If due to the security policy accepted in your corporate network or by your host provider you cannot connect to your PostgreSQL server directly through TCP/IP (for example a firewall prevents this), you can use SSH or HTTP tunneling feature of SQL Manager to fulfill your task.

 

 

Q: Why cannot I connect to PostgreSQL Server?

A: 1. Make sure that there is a record for your client PC in pg_hba.conf file on PostgreSQL server. This file can be found in database cluster's data directory.

2. If you connect to the remote server, then the TCP/IP connections should be allowed on the remote server. In this case you need to edit file postgresql.conf on the server: just add the name or TCP/IP of the client PC in the listen_addresses list. Or you can as well put * character; in this case the connection from any host will be allowed. You can get the same result if you run the server with -i option, which is the same as listen_addresses = '*'.

3. Make sure that you enter the correct login/password.

4. You use password authentication, but it is not supported in Data Import.

 

Scroll to top

 

If you still have any questions, contact us at Support Center.