Overwrite File After Reformat

Support/help with CloverETL implementation problems

rickymartin06
Posts: 20
Joined: Tue Jun 14, 2016 3:19 pm

Overwrite File After Reformat

Postby rickymartin06 » Tue Nov 14, 2017 4:31 pm

Im having this simple problem that im not being able to solve,

Im receiving some .txt files from a jobflow to be procesed in a graph the problem is that i read the file use a reformatter fix the errors but then i need to replace the file i just fixed with the same name, but i dont have the name of the path:
and if i use ${INPUTFILE} in the data writer it erase all the data in my .txt files. if i replace ${INPUTFILE} with something like this ${DATAIN_DIR}/outputtest.txt and append the data it shows all the data correctly.
Jobflow:
Capture.PNG
Capture.PNG (14.68 KiB) Viewed 115 times

Graph:
Capture1.PNG
Capture1.PNG (12.58 KiB) Viewed 115 times

vazquezrosariop
Posts: 111
Joined: Mon Feb 29, 2016 5:33 pm

Re: Overwrite File After Reformat

Postby vazquezrosariop » Tue Nov 14, 2017 7:31 pm

Hi rickymartin06

From the screenshot you sent me and the issue you described, I would recommend putting the UniversalDataWriter in a higher phase, thus resolving the issue. With the UniversalDataWriter being in the phase the file is being prepared as soon as the process starts to be written.
---
Pedro Vazquez Rosario
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support

rickymartin06
Posts: 20
Joined: Tue Jun 14, 2016 3:19 pm

Re: Overwrite File After Reformat

Postby rickymartin06 » Wed Nov 15, 2017 6:56 pm

By higher phase you mean putting the graph in a jobflow and then add an Execute Graph with a universal data writer in it?

Can you explain a bit how to accomplish that, Thanks.

Ricardo

vazquezrosariop
Posts: 111
Joined: Mon Feb 29, 2016 5:33 pm

Re: Overwrite File After Reformat

Postby vazquezrosariop » Thu Nov 16, 2017 3:43 pm

Hi rickymartin06,

Each graph can be divided into several phases by setting the phase numbers on the components, which is located on the upper right corner. At the moment all your components are in phase 0, please change the UniversalDataWriter to phase 1. You can accomplish in one of two ways, by selecting the component in question and typing 1 or by right-clicking on the component Edit->Common->Phase
---
Pedro Vazquez Rosario
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support

rickymartin06
Posts: 20
Joined: Tue Jun 14, 2016 3:19 pm

Re: Overwrite File After Reformat

Postby rickymartin06 » Fri Nov 17, 2017 2:32 pm

Ohh the Phases, i just did that and.... worked like a charm!! How could i forgot about that... Gracias Vazquez!