This article assumes the following:
- You have data in a CSV file on an FTP host and you want to import that data into a table in MySQL.
- You have already established connections for FTP and MySQL.
See also:
Use the following steps to import data into MySQL:
- Create or open an integration.
- Click + Create flow.
- In the Destination & Lookup Applications section, enter or select appropriate details in the following fields:
Field Name |
Description |
---|---|
Name |
Enter a name for the flow that you are creating. For example, "Contact Data." |
Description |
Enter a brief description of what this export does. |
Application |
Select FTP. |
Directory Path |
Select the FTP connection from which you will be retrieving the data. |
Output Mode |
Select Records. Note: Enable Developer Mode to see this field. |
File Name Starts With |
Enter the filename that contains the data. |
File Type |
Select CSV. |
Column Delimiter |
Select Comma. |
File Has Header |
Select this checkbox. |
File Encoding Type |
Select UTF-8. |
- Click Next.
- In the Source Applications section, enter or select appropriate details in the following fields:
Field Name |
Description |
Name |
Enter a name for your import. For example, MySQL Import. |
Description |
A short description that describes what this import does. |
Application |
Select MySQL. |
Connection |
Select the connection that you created for MySQL. |
Query Type |
Select Insert. |
Click Next.
- Click Define query.
- Modify the sample text present under Template to reflect your INSERT query for the MySQL table.
Note: Under Template, you also get a list of all the record fields and available functions the moment you type an open curly brace ({).
- The SQL query builder contains two tabs where you can review or provide data:
- Sample data previews any records found in a valid MySQL statement.
- Default data lists default values per field, in JSON format, to prevent errors when inserting missing required values into the database. Enter
"NULL"
for any default NULL values.
- Click Save.
- Schedule or run the data flow.
Troubleshooting
Question: I am getting an invalid_parameter error while exporting data from NetSuite to PostgreSQL.
Answer: When you are exporting data from NetSuite to a database, such as PostgreSQL, ensure that you enable Skip grouping in NetSuite export. By default, NetSuite results are returned as an array of arrays, whereas integrator.io expects a simple (not nested) array of results. When you enable Skip grouping, the results are received as a simple array.
Comments
0 comments
Please sign in to leave a comment.