Hi,
I’m implementing a workflow with EasyMorph. I receive text files through mail, detach them, test the quality of the data, and sort them OK (and add them to a database) or not OK (in that case, I send a mail back indicating the errors)
Is there a simple way to identify the encoding of an input text file? (UTF7 or UTF8)
Is there a way to perform the equivalent of
copy \workinprogress*.* \OK
with the File Command Copy list of files(I’m currently using the Run program action for that)
What’s the smartest way to proceed to the following operation :
I’ve got N=2 files in a folder (2 pieces were attached in the mail). The name of the file is constantly changing (the file is time stamped)
after loading both of them (via load multiple uniform files), I’ve got one OK after a test and the other one is not OK
I want to move the OK one to an OK folder and the other one to a KO folder
As far as I know, there is no reliable way to detect encoding. You may want to try to check the existence of particular characters.
Use the “List files” action first, then use the “Copy/move list of files” command (from the “File command” action) with the list of files obtained in the 1st action.
In the import action, you can enable the option that adds a column with file name, so you know exactly which file is OK and which isn’t.
Alternatively, consider importing both files in an iteration. In this case, the iterated module can move each file into the appropriate folder in each iteration.
Thanks Dmitry,
«In the import action, you can enable the option that adds a column with file name, so you know exactly which file is OK and which isn’t.»
That is exactly what I get!
But what is the next step when you get this?
Do an iteration and then in the iterated module move each file to the right folder. The file path and the destination folder are parameters of the iterated module. You may need to calculate the full destination folder path in a new column before iteration.