Withdata Software

Fixed-Width Text to MongoDB - Import Files into Collections

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 GUI mode, Step by Step, just a few mouse clicks.

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

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



Download Withdata FileToMongo Download FileToMongo



Import Fixed-Width Text to MongoDB in GUI



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

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:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for "Fixed-Width Text to MongoDB" conversion.
  2. 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 FileToMongoDownload FileToMongo