InaPlex Forums

All; I have a customer who exports CSV files on a nightly basis, which must be imported in strict order into Saleslogix. What this means is: 1. We need to stop and write a record into SLX if there is a file out of order. 2. We need to process the files in numeric order. E.g. file 0001.csv first, followed by 0002.csv, 0003.csv etc. Does anyone have a suggestion on how this can be accomplished?

Hi

The Inaport text file connector can accept wild cards in the file name, and can also rename files after processing and/or move them to another directory. The rename capability can also use expressions, so the new name can incorporate (for example) a time stamp.

If you combine these capabilities you should be able to achieve most of what you want:

1. have the source path be (for example): c:\mydir\0*.csv

2. use the move capability to move each file to c:\mydir\done once it has been processed, to prevent it being found again by the wild card.

The wild card will present to files in alpha order.

I am not sure that it will be possible to stop and write a record to SLX if a file is out of order.

HTH

Regards

Admin