Export package - empty file

More
10 months 4 weeks ago - 10 months 4 weeks ago #21891 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 !
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.

More
10 months 4 weeks ago #21892 by admin
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.

More
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

Please Log in or Create an account to join the conversation.

More
10 months 3 weeks ago #21897 by admin
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.

More
10 months 2 weeks ago #21898 by admin
Replied by admin on topic Export package - empty file
Can you try the latest version please and let us know the outcome.


Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.

More
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

Please Log in or Create an account to join the conversation.

Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.