Data Import Guide
The DBA Manufacturing Data Import Guide provides instructions for importing and updating company data using CSV files and the built-in data import utilities.
DBA Manufacturing includes data import screens that simplify initial system implementation and ongoing maintenance by allowing customers to import large quantities of information without manually entering individual records.
Data Import Capabilities
The guide provides detailed import specifications and field mapping instructions for:
•Customers and Suppliers – Import customer and supplier records, contacts, and delivery addresses.
•Inventory and Stock Items – Import inventory locations, item categories, new stock items, and updates to existing items.
•MRP Settings – Import planning settings for manufactured and purchased items, including demand-driven replenishment settings.
•Item Suppliers and Manufacturers – Import supplier relationships, manufacturers, and manufacturer part numbers.
•Pricing – Import base prices and quantity-based price breaks.
•Bills of Manufacturing – Import BOM components, routings, and reference information.
How the Import Process Works
DBA Manufacturing uses a three-phase data import process:
1.Export Your Data – Export information from your existing system into a spreadsheet.
2.Prepare Your CSV File – Organize and format the data according to DBA's import specifications.
3.Map and Import Fields – Use DBA's built-in import screens to map spreadsheet columns to database fields and validate the information before importing.
Initial Implementation and Ongoing Maintenance
Data imports are commonly used during initial DBA Manufacturing implementation to populate company master records.
The same utilities can also be used for ongoing maintenance, including updating stock items, changing MRP settings, revising pricing, and maintaining Bills of Manufacturing.
Important: Always use the data import screens provided within DBA Manufacturing. Direct database imports or third-party import utilities are not permitted and can compromise database integrity.
Who Is This Guide For?
This guide is intended for system administrators, implementation coordinators, inventory managers, purchasing personnel, and anyone responsible for importing or maintaining company data in DBA Manufacturing Software..
