Exercise #5 - Run the Transform Load Job to Import CSV Data
- Jason Hoekstra
At this point, we've defined a mapping from CSV to ODS JSON entities, and have uploaded a file to be processed. Now, we start the background job that will process the file and post to the ODS. The TransformLoad executable takes each row of the uploaded CSV file, uses our map to convert the row to valid ODS JSON, and posts it to the ODS.
#1 - Run TransformLoad
Open a console window and cd to the directory with the TransformLoad executable:
cd C:\Temp\DataImportDemo\DataImport.Server.TransformLoadRun the TransformLoad executable:
DataImport.Server.TransformLoad.exe- Scan the console output for success or diagnostic information.
#2 - Verify the import job using Data Import Logs
In addition to logging in the console window, TransformLoad logs data ingestion messages that are visible in the web application. In the top menu bar, click Logs and then the Ingestion tab to view the results of our data import.