| | How to determine required fields for Legacy import jobs |
| Resolution |
- Manually enter a sample entry into data entry similar to one desired to be imported
- After completing the entry, select Visual Integrator, Main, Export Job Maintenance and enter a desired Job Name such as PR_EXPORT
- Click the Table Name lookup and select the table that will be used for the import job, such as PR.DATAENT, and Click Accept button
- Select "Insert All Fields During Setup" check box
- Select the Data tab and all fields should be listed in right side window pane
- Click Accept button and click Yes to the prompt "Prepare this job for use?"
- Click Yes to "Execute Job?" and click the Test button
- Select "All Records" check box and click OK button
- Click the Yes button at the prompt "Do you want to view the export log"
- Double click a record from the job log and make note of all the populated fields. The fields that are populated are the required fields for the import.
- Note: Some of the populated fields may be Read-Only fields. If the populated field is not available in the import job, then it is not required. Also, numeric fields containing zeros are generally not required.
|
|