Synchronization passing in variable a different csvsys

Question

Hi, all 
 I have a synchronization project that has as target system some csv files. 
 I have 2 sets of csv files because I want to import same data from 2 different sources with same name same column names in 2 different path 
 how can I switch the path of target system from Startup configuration? 
 I tried to set 2 diifferent variable sets with the systemconnection parameter systemfile connection parameter converted to variable. 
 But the startup configuration take always one .csvsys 
 version 7.1 
 Thanks 
 Mik

Markus Weiss-Ehlers · Answer

Hi Michele, 
 you cannot switch the target path but you need to copy the CSVSYS file and the data to different folders. The reference to the CSVSYS file can be converted to a variable in the Sync Editor. 
 
 Create two variable sets, one for each of your CSVSYS files. Then create two different Startup Configurations, each pointing to a different variable set. 
 That should be it.

Markus Weiss-Ehlers · Answer

You can specify different CSV Systems in the variable and they will be used to determine the base path of the files, but the filenames or pathes cannot be changed. 
 For example the following works: 
 Folder A 
 - HRPeople.csvsys 
 - People.csv 
 Folder B 
 - ExternalPeople.csvsys 
 - People.csv 
 
 This does not work: 
 Folder A 
 - HRPeople.csvsys 
 - ExternalPeople.csvsys 
 - Externals.csv

Markus Weiss-Ehlers · Answer

The references to the CSVs (including pathes) cannot be change using the variables. 
 But if you have 2 CSVSYS files, lying in 2 different folders side-by-side with the CSV files to be imported, it works. You can point to the different CSVSYS and everything is working. 
 But, for your existing project, you have to change the CSVSYS to be side-by-side with the CSV file, check that the csv file is referenced without the path, and the reload the schema in the Sync Project, save the sync project and it should work.