Question:
Hi folks,
Is there a way of creating an infopackage that will load multiple csv files automatically?
For example, say you had 10 files on your server entiled file1, file2....file10, could an infopackage be configured to load all these files automatically rather than having to run the infopackage for each csv file?
I'd be grateful for any advice.
Answer:
Hi folks,
Is there a way of creating an infopackage that will load multiple csv files automatically?
For example, say you had 10 files on your server entiled file1, file2....file10, could an infopackage be configured to load all these files automatically rather than having to run the infopackage for each csv file?
I'd be grateful for any advice.
Hi there,
i donīt think that there will be a way to upload more than one flat file at once. Check the infopackage and you will find that you have to tell the path and the file name where the data is stored.
Best regards
Hermann
Answer:
workaround : copy the infopackage 10 times, and in each one enter another file. Then group the infopackages together in in an InfoPackageGRoup or ProcessChain so that they are all loaded sequentially
Answer:
Thanks for the update folks.
Your workaround may well be the way to go TFR. In my example I said 10 files but in reality we will probably have around 50. Is there a limit on the number of InfoPackages you can have in a Group/Process Chain?
Thanks again,
Darren
Answer:
is there a limit on the number of InfoPackages you can have in a Group/Process Chain?
not that i know of... i worked with IPG / PCh with more then 50 InfoPackges, so i don't think this is an issue
Answer:
Why don't you merge the files on the system into 1 unique file, then load the file ?
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
That is the way we do things at the moment. We're just trying to weigh up whether an automated way would be quicker.
InfoPackage Group/Process Chain would be a one-off set-up exercise whereas making the single file has to be done each month we load the data.
Answer:
Do the name of your files respect a rule for ? If they are incremented as file001, then file002, etc. ... you can create a file name variable into the infopackage.
Then, you launch as many times as necessary the same infopackage.
No need to create as many as file's number
_________________
Laurent THIBERT
Business Connection Amerique