- EBMS Knowledge Base
- EBMS Main Documentation
- Technical | Data Import and Export Utility
-
Client Resources
-
EBMS Main Documentation
- Introduction
- Getting Started
- Getting Started | Initial Installation
- Getting Started | Company Setup
- Quick User Guide | Financial Staff | Accountant
- Quick User Guide | Financial Staff | Accountant | Accountants Journal
- Quick User Guide | Sales Staff
- Quick User Guide | General Staff
- Features
- Reports
- Reports | Excel Add-In
- Reports | Excel Add-In | Troubleshooting
- Security
- Server Manager
- Technical
- Technical | Data Import and Export Utility
- Technical | SQL Mirror
- Automotive
- Automotive | Parts Catalog
- Automotive | Pricing
- Automotive | Point of Sale
- Automotive | Product Application
- Automotive | Keystone Interface
- Metal Supply
- Fuel Sales
- Horticulture
- Horticulture | Farm Setup
- Horticulture | Processing Payroll
- Horticulture | Managing the Farm
-
Sales
- Customers
- Customers | Miscellaneous Customers
- Proposals
- Proposals | Processing Proposals
- Proposals | Sets and Templates
- MyProposals
- MyOrders
- Sales Orders
- Invoices
- Materials Lists
- Sales and Use Tax
- Sales and Use Tax | TaxJar
- CRM
- CRM | Auto Send
- Recurring Billing
- Credits
- Customer Payments
- Payment Card Processing
- Payment Card Processing | Gift Cards
- Payment Card Processing | Loyalty Cards
- Payment Card Processing | Verifone Gateway
- Freight and Shipping Tools
- General Ledger Transactions
- Point of Sale
- Point of Sale | Point of Sale Hardware
- Point of Sale | Xpress POS System
- Point of Sale | Advanced Tools
- Signature Capture
- Salesperson Commissions
-
Inventory
- Product Catalog
- Product Catalog | Using Product Codes for No Count Items
- Product Pricing
- Product Pricing | Special Pricing
- Tracking Counts
- Unit of Measure
- Purchasing
- Special Orders and Drop Shipped Items
- Receiving Product
- Barcodes
- MyInventory and Scanner
- Components (BOM) and Accessories
- Components (BOM) and Accessories | Component Formula Tool
- Made-to-Order Kitting
- Configure-to-Order Kitting
- Multiple Inventory Locations
- Multiple Inventory Locations | Creating Locations
- Multiple Inventory Locations | Using Multiple Locations
- Multiple Inventory Locations | Product Catalog Sync
- Multi-Vendor Catalog
- Serialized Items
- Serialized Items | Purchasing or Manufacturing an Item
- Serialized Items | Selling and/or Associating an item with a customer
- Lots
- Product Attributes
- Product Attributes | Selling and Purchasing Items with Attributes
- Product Attributes | Custom Attributes
- Mobile Scanner (Legacy)
-
Labor
- Getting Started
- Workers
- Taxes and Deductions
- Work Codes
- Time and Attendance
- Time and Attendance | Time Track App
- Processing Payroll
- Closing the Payroll Year
- Processing Payroll - Advanced
- Salaried Pay
- Piecework Pay
- Direct Deposit
- 3rd Party Payroll Service
- Subcontract Workers
- Flag Pay
- Prevailing Wages
- MyDispatch
- MyTasks
- MyTime
- MyTime | Communications
- MyTime | Setup
- Tasks
- Tasks | Getting Started
- Tasks | Creating Tasks
- Tasks | Scheduling Tasks
- Tasks | Customizing Task Views
- Tasks | Managing Tasks
-
Financials
- Introduction
- Fiscal Year
- Chart of Accounts
- Budget
- Financial Reporting
- Transactions and Journals
- Transactions and Journals | Journals
- Account Reconciliation
- 1099
- Departments and Profit Centers
- Fund Accounts
- Bank Accounts
- Bank Feed
- Vendors
- Vendors | Miscellaneous Vendors
- Purchase Orders
- Expense Invoices
- Vendor Payments
- AP Transactions
- Landed Cost
- Fixed Assets and Depreciation
- Fixed Assets and Depreciation | Fixed Assets
- Fixed Assets and Depreciation | Fixed Assets | Adding Assets
- Fixed Assets and Depreciation | Processing Depreciation
- Fixed Assets and Depreciation | Disposing Assets
- MyJobs
-
E-commerce
-
Rental
-
Job Costing
-
Manufacturing
Data Import and Export Utility Overview
The standard Text Import/Export Mappings utility is a powerful conversion utility to convert text files such as CSV and TXT files to EBMS files. EBMS does NOT import or export a CSV UTF-8 file. This utility can process mapped EBMS files to update EBMS inventory information on a regular basis. This conversion process can be automated to update information from a user defined location such as a FTP site on a user defined schedule. This utility is used frequently to update vendor catalog files or product application files but can also be used to import information into standard EBMS files. Note that this standard utility is included in all EBMS versions 7.8 and higher.
Information is an important component in many point-of-sale or inventory management systems. This utility can automate the update of EBMS data from an outside source such as a text file from a vendor or manufacturer. The information source can post data to a standard FTP or other cloud based site for easy retrieval. EBMS can be scheduled to access this information from the cloud and update the EBMS information on a regular basis. Use the Import/Export Mappings dialog to launch this utility.
Text Import Export Mapping Insider Series
Complete the following steps to configure a Text Import Export Mapping:
-
Select File > Utilities > Text Import Export Mappings option from the main EBMS menu to launch the following dialog:
-
File relationship mapping must be configured for each text file to associate the text file information with the EBMS fields. Click New to create a new Import/Export Mappings record. Note that the Import/Export Mappings must be configured before the import process can be launched. Review Configuring the Import/Export Mappings for instructions on how to set up this utility. Setup must be configured before any imports can be launched.
-
Click Properties to review or make changes to the Import/Export Mapping details.
-
Click Delete to remove the Import/Export Mappings record. This step should only be done if the Import/Export files are no longer used within EBMS.
-
Click Export to reverse the import process and create a text file from an EBMS file. Review Export EBMS Data to a Text File for more details on this function.
-
Launch the import process by clicking Import. This process will update the file(s) based on the properties set for the selected Import/Export Mappings record. This process can also be automated by scheduling the import using the MS Windows scheduler. Review the Importing Text Files into EBMS section for details on scheduling an import process.
Create multiple Import/Export Mappings records for different file imports.
Review the following links for examples of processes that use this tool:
-
Vendor catalog: Review [Inventory] Vendor Catalog > Overview for details on the steps to import product information from electronic vendor supplied catalog files.
- Export/Import process to change inventory pricing: Review Export Import to Change Inventory Including Pricing for instructions to use the conversion utility with files exported from EBMS.
Related Videos and Content
Videos