• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 94 subscribers
  • Views 3217 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

How to manage file using .csv synchronization project connector?

mustapha.gaies
over 6 years ago

Hello,

 

I have got some questions about how to manage .csv files when setting up a .csv connector :

 

1) Is it possible to load a .csv file hosted on a FTP server?

2) Can we easily deal with filenames that have timestamp? For example, let's say I want to load on a daily basis a file with the following filename : "MyFile_MMDDYYYY.csv".

3) Is there an easy way to set up the synchronization project so that the source file is moved to an archive folder once it has been loaded?

 

I know I could tackle all these issues through extensive customization but I would like to avoid that as much as possible.

 

Thank you!

 

Best Regards,

Mustapha

  • 0 over 5 years ago

    Hello,

    I will also be really interested in having answers to these questions.

    Thanks in advance.

    Regards,

    Maxime HENRY

  • 0 over 5 years ago in reply to maif gdi gdh

    1. I don't think you can have the sync project reference an FTP server directly, but it's easy to add a pre-sync process to retrieve the file and place somewhere the job service can access.

    2. Last time I checked the schema is linked to the filename, so you need to keep the filename the same. A pre-sync process, as mentioned in 1, could rename the file to the sync filename.

    3. There is an OotB event postsync which allows you to trigger a process, so you could configure a simple process to archive the file.

    I would tackle this in the following way:

    - Create a process that is executed before the sync. This would retrieve the file to a staging folder, validate its format and then move the file to the sync processing folder and rename the file with the sync filename.

    - Create a process that responds to the postsync event which moves the file to the sync processing folder the archive folder.