Create a generic, reusable script that can convert data from DBF (Database File Format) to MongoDB. Many legacy systems and government datasets are still stored in .dbf format (used in FoxPro, dBASE, etc.). This script will serve as a bridge to modernize data infrastructure by importing those datasets into MongoDB collections.

This task aims to build a conversion bridge that will help teams migrate such legacy data into MongoDB, enabling easier access, querying, integration with web services, and analytics.

The script should be flexible, handle large files efficiently, support minimal configuration, and ensure data integrity during the conversion process.

1. Read .dbf files and convert records into valid JSON documents
2. Insert converted documents into a specified MongoDB collection
3. Provide flexibility to map field names or handle data type conversions
4. Log success/failure statistics (e.g., records inserted, skipped, etc.)

A working Python script or CLI tool that:

1. Reads any standard .dbf file
2. Inserts data into MongoDB
3. Handles exceptions gracefully
4. Logs output clearly (inserted count, errors, etc.)
5. Auto-detect field types (strings, dates, numbers)
6. Handle special characters and encoding issues
7. Batch insert with performance optimization
8. Option to preview sample records before inserting

1. Clone the Repository: Start by cloning the project’s repository.
2. Create a Branch: Use Git to create your branch for the task.
3. Generate a Pull Request: After completing your audit, submit your findings by generating a pull request.

https://openforge.gov.in/plugins/git/abc-collabwithgov/DBF-MONGO.git

Organization Type: Government Publisher Name: Academic Bank of Credits (Digital India Corporation)