Import Master Data from Excel into Macola ERP Software
The Macola Import Utility by Harvest Ventures enables users to import master data such as sales orders, purchase orders, items, customers and vendors from an Excel spreadsheet directly into the Macola or Progression database. This utility is available for purchase in full or based on specific data import requirements.
This tool is commonly used for:
- Importing orders from websites
- Copying orders between different databases
- Copying a large number of repetitive master orders to live orders each month
- Loading new items from a recently acquired company
- Loading a new item number schema
This Business Automation Tool offers flexible options including the ability to input the source database and the destination database.
Users can run multiple import routines automatically, one after another. As an example, this functionality is great for companies that require customers or items to be entered in a particular sequence.
The dynamic mapping tool included with this utility enables the source file to be saved in any format. Users can also save several maps related to different import file layouts, functions, users and/or internal databases.
The Macola Import Tool also allows users to execute a query from a selected database to generate an Excel file that can then be import into Macola.