Run the data import and the following error generates:
Orchestrate data flow import has failed. The detailed information is as follows:
ERROR[M002][Microsoft][ODBC Driver Manager] data source name not found and no default driver specified
Import Command: N/A
Please complete the following steps if importing from CSV:
Log into Orchestrate System Manager
select file
Select data import configuration
select data source configuration
Click New
select ODBC data connections from Data Source Type dropdown list
Click Next
Click Manage ODBC source
Select System DSN tab and select the relevant name e.g. CSV import, 32 bit, Microsoft Text driver
Click Configure
Click Select Directory
Click OK
You may find a data sequence is missing from the data flow or a field mapping is missing in a existing data sequence. Also, the data source may be directed to the wrong database. Please check the following:-
Log into Orchestrate System Manager
select file
Select data import configuration
select data flow configuration
Select CSV import and click Edit
Check each bulk copy into table data sequence and click settings
Check CSV data source is selected from drop down list
Check source table has the name of the CSV file e.g. data sequence Bulk Copy into Table orc_Items should contain Items.CSV in the source table field
Check there is a correct source expression in the equivalent Orchestrate Field Name
Note: if no CSV is configured, you can show the user how it works but cannot create all the data sequences. This would be chargeable consultancy and you would need to raise a self gen case.
Alternative solution is:-
Launch ODBC from windows
Select System DSN tab
select Add button and enter a name e.g. 'CSV Import'
Launch Orchestrate System Manager
select file
Select data import configuration
Select excel/CSV import configuration
Click new, next, select which orchestrate table the data will import to e.g. Purchase Orders
Click browse to enter source data location i.e. ‘Excel workbook file’
Click preview, next
Select Map Fields and when complete, click finish
Log into Orchestrate and select file
Select import
Import excel/CSV data