- Posts: 51
- Thank you received: 4
Export package - empty file
10 months 4 weeks ago - 10 months 4 weeks ago #21891 by BPO
Export package - empty file was created by BPO
Hello,
I am making a package using the export object.
All work perfectly expect when query do not return results in this case (tested with both header option ticked and not) the file is generated but is empty or have only header line, it can be troublesome with other systems which have to integrate this file.
I also tested a workaround by using the "check file" to check if file is above 1 byte to let it in the folder on success and move the empty file on error. It work with empty results with header, but on empty file (no header : 0 byte) it looks like the "check file" object do no output the error result but by success result anyway.
Perhaps I missed something.
It can anyway be both good options on objects to have :
- on "export" : do no generate file if empty return of query
- on "check file" in check type : Check if file is empty
Thank you !
I am making a package using the export object.
All work perfectly expect when query do not return results in this case (tested with both header option ticked and not) the file is generated but is empty or have only header line, it can be troublesome with other systems which have to integrate this file.
I also tested a workaround by using the "check file" to check if file is above 1 byte to let it in the folder on success and move the empty file on error. It work with empty results with header, but on empty file (no header : 0 byte) it looks like the "check file" object do no output the error result but by success result anyway.
Perhaps I missed something.
It can anyway be both good options on objects to have :
- on "export" : do no generate file if empty return of query
- on "check file" in check type : Check if file is empty
Thank you !
Last edit: 10 months 4 weeks ago by BPO.
The following user(s) said Thank You: admin
Please Log in or Create an account to join the conversation.
10 months 4 weeks ago #21892 by admin
Mike
ETL Architect
Replied by admin on topic Export package - empty file
Thank you for the feedback we will have a look at it for you
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
10 months 3 weeks ago #21895 by BPO
Replied by BPO on topic Export package - empty file
Were you able to check theses aspects ?
I you have any need of further infos do not hesitate
I you have any need of further infos do not hesitate
Please Log in or Create an account to join the conversation.
10 months 3 weeks ago #21897 by admin
Mike
ETL Architect
Replied by admin on topic Export package - empty file
Still looking at it I am afraid
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
10 months 2 weeks ago #21898 by admin
Mike
ETL Architect
Replied by admin on topic Export package - empty file
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
10 months 2 weeks ago #21904 by BPO
Replied by BPO on topic Export package - empty file
Sorry for my late reply,
I work perfectly, thank you for the improvement !
Also for your information
I downloaded latest version (with the new code) but it is still versioned 9.2.8.1 not 9.2.10.4.
Benjamin
I work perfectly, thank you for the improvement !
Also for your information
I downloaded latest version (with the new code) but it is still versioned 9.2.8.1 not 9.2.10.4.
Benjamin
Please Log in or Create an account to join the conversation.