Import FTP data into MongoDB – Celigo Help Center

Before you can import

There are a couple of things you'll need to understand and have in order to be able import your data.

Establish your connections

You will need to set up an FTP and MongoDB connection before you can configure your import. Make sure you understand that process.

Put your data in the right format

To to pull your FTP data into MongoDB, it will need to be in a specific format.

Sample Data

{
   "orderID": "TAG-Address-1",
   "FirstName": "John",
   "LastName": "Miller",
   "ItemName": "ACC00002",
   "Quantity": "100",
   "Amount": "280",
   "Notes": "My notes here",
   "units": "100",
   "PO#": "656",
   "Date": "07/15/2017",
   "id": "1"
 }

Import data into MongoDB

1. Enter appropriate details in the following fields.

Field Name	Description
Name	Enter a name for the MongoDB import that you are about to create. For example, MongoDB Import.
Description	Enter a brief description of what MongoDB is importing.
Application	Select MongoDB.
Connection	Select the MongoDB connection that you have already created.
Method	Select the method to use for adding or updating documents in your MongoDB instance. For example, you can select Insert Many as you may want to import all the data that is coming from the FTP export. For more information on the available methods please refer to the MongoDB documentation.
Collection	Enter the MongoDB collection name into which you want to import the export data. For example, MyCollection.

2. Click Next.

3. On the Map page, click Launch Field Mapper.

4. On the MongoDB Data Builder window,

Under "Template": You can specify the fields that you want to map based on the Sample Data received.
Under "Preview": You can see the data that is mapped.

5. Click Save.

Before you can import

Establish your connections

Put your data in the right format

Import data into MongoDB

Related articles