In a previous post I demonstrated how to create a Sales Order export using the Recurring Data Job Sales Order Composite Entity. This lets you export your sales orders including lines and miscellaneous charges. Then of course you can see the mapping from the values easier and create a sample schema and test file to demonstrate the import capabilities. To test sample files for creating / updating Data entity from a Data Project.
- Go to DATA MANAGEMENT (workspaces > System Admin > Data Management)
- Find the SALES ORDER IMPORT data project and choose RUN PROJECT
- Click on the IMPORT button on the JOB EXECUTION form to find/load your test sample file
Then click ok, then back on the JOB EXECUTION form click the IMPORT button
Which will bring you to the execution summarty screen, a message will appear notifity you the job is complete……click on the VIEW STAGING data
Once results are posted, click the EXECUTION LOG
Here you will notice every entity within the composite and its data
. If STAGING LOG DETAILS button is enabled then it means you gfot no data into the STAGING and there are errors you can see (see below screenshot of STAGING details for insance)
Positive signs are that you see records in the staging(in this case says 12 records in stage)…..that means it processed and just had issues with target….if we removed all business logic from running it would probably go in fine so we are close…..click each entity on the left and notice its LOG TEXT, then click on VIEW STAGING data so you can go thru each entity staging records and it should show something there
