Fixed-Width Text to MongoDB - Import Files into Collections as Scheduled Task

Sometimes you need to import Fixed-Width Text to MongoDB, you can use Withdata FileToMongo as fixedwidth to MongoDB Converter (Importer / Loader).

"Fixed-Width Text to MongoDB" tool - FileToMongo

Works GREAT on Windows, Mac and Linux.

Support Windows, Linux, and macOS.

Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.

Can run in CLI (Command Line Interface), for Scheduled Tasks and Streams, for Automation.

Download Withdata FileToMongo

Import Fixed-Width Text to MongoDB in GUI

1 to 1 - Import Fixed-Width Text to MongoDB collection
n to 1 - Import multiple Fixed-Width Text files to a single MongoDB collection
n to n - Batch import Fixed-Width Text files to MongoDB collections

Start Withdata FileToMongo, connect to MongoDB.

connect to mongodb

1 Fixed-Width Text to 1 Collection

Click "1 File To 1 Collection" at task dialog.

Import file data To MongoDB collection - task window

Select the "Fixed-Width Text" file type.

Import Fixed-Width Text file data To MongoDB collection - select file type

1. Open a Fixed-Width Text file.

Import Data From Fixed-Width Text File To MongoDB collection - open Fixed-Width Text file

The source Fixed-Width Text file like this:

import Fixed-Width Text file to MongoDB collection - source Fixed-Width Text file

2. Choose collection and map columns.

Load Data From Fixed-Width Text File To MongoDB collection - set collection options

3. Preview and set rows options.

Transfer Data From Fixed-Width Text File To MongoDB collection - preview

4. Import Fixed-Width Text to MongoDB collection.

Copy Data From Fixed-Width Text File To MongoDB collection - import data

After importing, you can view imported data in MongoDB collection.

view MongoDB data

N Fixed-Width Text to 1 Collection

Click "N File To 1 Collection" at task dialog.

Import multiple Fixed-Width Text files data To a single MongoDB collection - task window

Select the "Fixed-Width Text" file type.

Import multiple Fixed-Width Text files data To 1 MongoDB collection - select file type

1. Open Fixed-Width Text folder.

Import multiple Fixed-Width Text files to 1 MongoDB collection - set Fixed-Width Text folder

2. Set Fixed-Width Text options.

Import multiple Fixed-Width Text Files To 1 MongoDB collection - config Fixed-Width Text file

3. Choose collection and map columns.

Load multiple Fixed-Width Text Files To 1 MongoDB collection - select table

4. Preview and set rows options.

Transfer multiple Fixed-Width Text Files To 1 MongoDB collection - preview

5. Import Fixed-Width Text to MongoDB collection.

Copy multiple Fixed-Width Text Files To 1 MongoDB collection - import data

After importing, you can view imported data in MongoDB.

Import multiple Fixed-Width Text Files To Single MongoDB Collection - view data

N Fixed-Width Text to N Collections

Click "N File To N Collection" at task dialog.

Batch Import Fixed-Width Text files data To MongoDB collections - task window

then show the wizard.

Select the "Fixed-Width Text" file type.

Batch Import Fixed-Width Text files data To MongoDB collections - select file type

1. Open Fixed-Width Text folder.

Batch Import Data From Fixed-Width Text Files To MongoDB collections - set Fixed-Width Text folder

2. Set Fixed-Width Text options.

Batch Import Data From Fixed-Width Text Files To MongoDB collections - config Fixed-Width Text file

3. List collesions, set "Import Type".

Batch Load Data From Fixed-Width Text File To MongoDB collections - select table

4. Map files to collections.

Batch Load Data From Fixed-Width Text File To MongoDB collections - select table

5. Summary.

Batch Transfer Data From Fixed-Width Text Files To MongoDB collections - preview

6. Import Fixed-Width Text data to MongoDB collections.

Batch Copy Data From Fixed-Width Text Files To MongoDB collections - import data

After importing, you can view imported data.

view MongoDB data

Repeat "Fixed-Width Text to MongoDB" in Command Line

After importing Fixed-Width Text to MongoDB in GUI, and Saving "Fixed-Width Text to MongoDB" session, then you can:

Scheduled task for "Fixed-Width Text to MongoDB"

After importing Fixed-Width Text to MongoDB in Command Line, then you can schedule and automate "Fixed-Width Text to MongoDB" conversion task by:

Save session and create .bat (Windows) or .sh (Linux/macOS) file for "Fixed-Width Text to MongoDB" conversion.
Set scheduled task: On Linux/macOS, use Crontab. On Windows, use scheduled task.

FAQ

How long does it take to import Fixed-Width Text to MongoDB?

Is it safe to import Fixed-Width Text to MongoDB using FileToMongo?

Can I import Fixed-Width Text to MongoDB on Linux, Mac OS?

Can I import Fixed-Width Text to MongoDB in command line?

Can I batch import Fixed-Width Text files to MongoDB collections?

Download Withdata FileToMongo