Hello,
I an a new TOS user and I have problems when chaining jobs:
I have 2 jobs.
The first job browse a folder containing OFX files with a tFileList component. Each OFX file is convert to XML format with a java method that I wrote. Then I use a tFileInputXml with a tMap and a tPostgresqlOutput to fill a table in the database.
The second lod move the files from the original folder to an archive one. I use a tFileList to browse the original folder and a tFileCopy to copy each file. I have set the "delete source file" option.
When i run each job separately from the GUI, everything works OK.
The problem comes when I use a new job with 2 tRunJob components to chain previous one. In this case the second subjob (tFileList + tFileCopy) fails to copy the last 2 files processed in the first subjob.
I tried to insert a tSleep (5 or 10 sec) component between the 2 tRunJob. The problem is still present.
Does anyone have an idea?
Thanks.
Problem :
I'm having a directory with multiple files (name pattern is same). Now I need to read the file content and if the file content is having "TEST1" then move the file to test1 output directory and if the file content is having "TEST2" then move to test2 output directory and finally if file is not matching with any of the above contents we need to place in default output directory.
Can you tell me the route for implementing the above
I used tFileList --> On sub Ok --> tFileInputFullRow --> ????
Thanks in advance.
Kalyan M
Problem : I'm having a directory with multiple files (name pattern is same). Now I need to read the file content and if the file content is having "TEST1" then move the file to test1 output directory and if the file content is having "TEST2" then move to test2 output directory and finally if file is not matching with any of the above contents we need to place in default output directory. Can you tell me the route for implementing the above I used tFileList --> On sub Ok --> tFileInputFullRow --> ???? Thanks in advance. Kalyan M
