| | How to determine the required fields for Legacy import jobs |
| Resolution | - Manually enter a sample entry into a data entry similar to the 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 the Accept button.
- Select the "Insert All Fields During Setup" checkbox.
- Select the Data tab, and all fields should be listed in the right-side window pane.
- Click the Accept button and click Yes to the prompt "Prepare this job for use?".
- Click Yes to "Execute Job?" and click the Test button.
- Select the "All Records" checkbox and click the 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 isn’t available in the import job, then it isn’t required. Also, numeric fields containing zeros are generally not required.
|
|