Export package - empty file

  • Posts: 51
  • Thank you received: 4

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 !
The following user(s) said Thank You: admin
1 month 2 weeks ago #21891

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

  • Posts: 8507
  • Karma: 33
  • Thank you received: 570

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
1 month 2 weeks ago #21892

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

  • Posts: 51
  • Thank you received: 4

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
1 month 1 week ago #21895

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

  • Posts: 8507
  • Karma: 33
  • Thank you received: 570

Replied by admin on topic Export package - empty file

Still looking at it I am afraid
Mike
ETL Architect
1 month 1 week ago #21897

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

  • Posts: 8507
  • Karma: 33
  • Thank you received: 570

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
1 month 1 week ago #21898
Attachments:

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

  • Posts: 51
  • Thank you received: 4

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
1 month 5 days ago #21904

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

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies