Articles in this section

Import FTP data into MongoDB

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.

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.