Data Import Utility
Use the Data Import utility to bring records from outside sources into the Vision database.
You can import the following types of data:
- Data Entry — Create transaction files for review and posting, including Timesheet, Journal Entry Units, Prints and Reproductions, Miscellaneous, Accounts Payable Voucher, and Fixed Assets System (FAS) transaction files. When you import transaction (data entry) data and check its validity, you can then post it as you would any other transaction entry batch.
- Info Center — Update existing records or create new records, including Clients, Contacts, Leads, Marketing Campaigns, Opportunities, Employees, Projects, Vendors, Accounts, and Custom tab fields and grids.
-
Historical Data — Populate a new
Vision database.
You can load historical Project Detail, Accounting, and General Ledger data.
Data Import Actions
When you import a record, Vision:
- Brings the record into the Import utility.
- Validates the record against your database and configuration, checking it for errors.
- Displays a count of the number of rows imported (labeled Input Rows).
- Imports all valid records into Vision.
- Leaves any non-valid records in an error table for review, correction, and re-validation.
Considerations in Using Data Import
You can run the Data Import utility yourself. However, Deltek strongly recommends that you discuss the process with a Deltek representative before you begin.
You may also need help from external system vendors, for example ADP or Equitrac.
To access all of the record tables from this utility, you must contact your Deltek representative for a password.
Before you begin importing data, you should:
- Discuss your firm's work breakdown structure with your Deltek representative.
- Determine which transaction types to use.
- Organize and map data into the correct format.
Field Inclusion and Order When Importing
The Import utility allows you to determine which fields you want to import and their sequence. Certain fields are required. If you do not include a required field, Vision displays a message on an error report to alert you.
Vision Tables
You use Vision tables to update and correct invalid records. Contact a Deltek representative for more information.
Import Excel Files
To import an Excel file, save the Excel file as a comma-delimited text file. Then import the Excel file with the same steps you use to import a text file. This can be a comma-delimited .csv file or a tab-delimited text file.
Update Existing Records
To update existing Info Center information, select the Allow updates option on the Main tab of the Import Utility form. This option only applies to individual Info Center records.
If you are updating an existing record, you need to map the key field (for example, Employee Number) and the fields that you are updating. Include only those records in the source file that have a value. If a blank is found in the source file, the blank is imported over the data currently in the field.
Best FAS (Fixed Assets System) Interface
You can import data via the Fixed Assets System interface.
Related Topics
- Data Import Security
Vision closely controls who can use the Data Import utility. - Validating Data
Before you import a table into Vision, Vision must validate its contents. During validation, Vision compares the project numbers, employee numbers, accounts, and other information in the table to the setup information previously entered into Vision. - Vision Table Names
The Vision tables have corresponding import files. - Preparing Files for Import
To be loaded into Vision, a file must be either a text file (with the extension .txt or .csv) or an ODBC DSN file (with a FoxPro file, Access table, or another SQL Server database). - Table Formats Overview
When you use the Data Import utility, you must follow the prescribed formats for certain types of data. - Procedures
You can import text files or OBDC DSN files. - Screens
Use the form and dialog boxes in this utility to import data.