• State Suggested Answer
  • Locked Locked
  • Replies 7 replies
  • Answers 3 answers
  • Subscribers 95 subscribers
  • Views 6372 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Synchronization passing in variable a different csvsys

michele.polizio
over 7 years ago

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

  • 0 over 7 years ago

    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.

  • 0 over 7 years ago

    I did.

    I copied my csvsys file changing just the path of the csv files:

    targetSystem1.csvsys :

    FileName="..\Synchronization\DaProcessare\SystemAccess\wf.csv"

    targetSystem2.csvsys :

    FileName="..\Synchronization\DaProcessare\Aida\wf.csv"

    Created 2 variable sets and associate different path in the systemfile variable (the variable trasnformed from connection parameter)

    But when I run the startup configuration associated with the copied file it goes in the old folder to take files

     

    As you can see is looking for the file in the first csvsys  file

     

    Mik

  • 0 over 7 years ago

    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

  • 0 over 7 years ago
    I don't understand
    I have the folllowing situation:

    I have csvsys files in the same folder (C:\ImportsTemplates):

    I have in
    C:\ImportsTemplates\CostaImport.csvsys with defined inside the
    path:
    FileName="..\Synchronization\DaProcessare\SystemAccess\wf.csv"
    ...
    and other csv files in the same location

    because i have in the folder Synchronization\DaProcessare\SystemAccess all the csv file from target system SystemAccess
    then

    C:\ImportsTemplates\AidaImport.csvsys with defined inside the
    path:
    FileName="..\Synchronization\DaProcessare\Aida\wf.csv"
    ...
    and other csv files in the same location
    because i have in the folder Synchronization\DaProcessare\Aoda all the csv file from target system Aida

    Thanks Mik
  • 0 over 7 years ago

    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.

     

     

  • 0 over 7 years ago

    I moved CostaImport.csvsys into the folder c:\\Synchronization\DaProcessare\SystemAccess
    with defined inside the
    path:
    FileName="wf.csv" (withoutpath)
    same story for the AidaImport.csvsys put in the other folder
    what do you mean with reload the schema in the Sync Project?
    Edit connection and pointing to the new file c:\\Synchronization\DaProcessare\SystemAccess\CostaImport.csvsys ?

  • 0 over 7 years ago
    Go to the target system connection, click edit connection, change the location of the CSV file, close the connection, click on Reload Schema, save the sync project.