Single User: Importing Data requires that no other user is logged on to TelcoMgr apart from a single TelcoMgr Uitility program user.

 

Import Features:

 

Import from Comma Separate Value (CSV) or Excel standard files.

 

Duplicate checking can be enabled at the end-user levels. The user has the option to process, ignore duplicates or update the original record. The contents of the dupes can be saved to a text file.  At the end of the import run the Duplicates text file can be viewed/printed.

 

File information such as field names,types,sizes is read straight from the database header record and displayed in a browse.

 

The user can then match up fields by a Map by Name button (for similar labels) and then drag and drop.  These Map Structures can be saved for future use.

 

At runtime the user can "override" incoming text for a particular field with their own choice of text (or date).

 

For testing purposes a set number of records can be imported.

 

Records are added to your existing data file and if there is an Auto Number key the autonumber field will be incremented automatically.

 

For ASCII or CSV files there is the option to skip the header record (useful if this record is just field names) and allow double quote marks, or not.

 

Files allowed for Import:

 

 

User Tip: Export a TelcoMgr Locaton, Circuits and/or Directory file as a Comma Separated Value (CSV) file to create a file template for importing data.

 

User Tip: IMPORT THE LOCATION FILE FIRST SO TELCOMGR CAN CREATE THE CUSTOMER SYSTEM ID (CusSysID) number automatically. The appropriate CusSysID must appear in each record that is imported into the CIRCUITS and DIRECTORY files.

 

User Tip: Do not import data into [RESERVED]fields.

 

Page url: http://impex.sword-field-service-software.com?advancedimport.htm