Import Templates

SRM Software includes many data update utilities that can be used to import an external data file, if it is in a tab-delimited format.
When the Client is installed, templates for these import files are either downloaded into the SCSBIN\Templates directory on the workstation, or can be created from the corresponding import utility with or without being populated with existing data.
The templates can be used to determine the format and requirements of the tab-delimited data file in preparation for importing.

Many of these templates are for use in loading startup data using Data Import or Import/Export Selected Data.
Other templates can be used to load additional data records, such as in Miscellaneous Journals, Standard Journals and Import Budgets or to update a specific data field throughout a file such as in Import Product Replacement Costs, Import Min/Max Inventory Quantities, or Restructure Class/Group/Rates/Tag.

Some of these templates include:

Budget Figures.xls - created and used by Import Budgets
Journals.xls - template used by Miscellaneous G/L Journals and Standard G/L Journals

Customer Credit Cards.xls - created and used by Data Import
Customer Balances.xls - created and used by Data Import
Customer Job Sites.xls - created and used by Data Import
Customer Type Codes.xls - created and used by Data Import
Customers.xls- created and used by Data Import
Customer Drivers License.xls - created and used by Data Import
Equipment Specifications.xls - created and used by Data Import
Operators.xls - created and used by Data Import
Products.xls - created and used by Data Import
Rental Item Special Pricing.xls - created and used by Data Import
Safety Notes.xls - created and used by Data Import
Suggested Sales List.xls - created and used by Data Import
Vendor Balances.xls - created and used by Data Import
Vendors.xls - created and used by Data Import

Product Min And Max.xls - template used by Import Min/Max Inventory Quantities
Product Replacement Costs.xls - template used by Import Replacement Cost

Refer to the Data Export/Import Utilities sub-menu to access additional export/import tools.