Avoid creating empty export files

I have an export action triggered by Anaplan connect (export of POs)

So a file is created and placed in a folder, the ERP system then read from this file and creates POs in the ERP system.

This action runnes quite often and often the exported file is empty (only headers) so there is actually nothing to export. I would then prefer that the file is not created at all. How can I avoid creating files when there is nothing to export? Please help me figure this out.

Accepted answers

pyrypeura

All good with me! Hope you are well as well!

Unfortunately we can't make export action unavailable based on boolean. So will need that bit advanced modification of Anaplan Connect script. Probably starting with ChatGPT and question like "how to read cell b2 value from csv in windows batch script" would be good idea in addition in starting the script by exporting count of rows to be exported.

All comments

pyrypeura

Hi Caroline,

With bit of additional scripting and a count of rows to be exported in system module this would be possible within the Anaplan Connect. As first in a system module you would create count of rows to be exported. Then you would be modifying your Anaplan Connect script to read that count as first step and use exported value of that count line item as if statement in your Anaplan Connect script to determine if the main export should be run or not.

CarolineJosefsson

Hi Pyry,

That is actually exactly what I hoped someone would answere.. Because when I suggested that solution to our "Anaplan Connect integration person" I got the answere that Anaplan Connect is not smart enought to make those decitions, that we are not able to write a script like that. I dont have much at all knowledge in Anaplan connect.. but I will search on how to modify the script.

Thank you Pyry hope you are fine by the way!!

CarolineJosefsson

And it is not possible in some way to make the export action to be avaliable only if an statement is True and in that way not modify the Anaplcn connect script?.. all the methods I have tested - with selective access/read access on the module.. still generats empty files

pyrypeura

licx13

hi @CarolineJosefsson our project also meeted similar issue ，and there was really no good solution from Anaplan side .our Solution is still to export empty file even no data ,and update the script from the receiving end,if no data in file ,the script will not write into the third-part system ,the exported files are also as exported log .

hope it is helpful to you.

Stacey_Gibbens

Hi @CarolineJosefsson,

While it is true that AnaplanConnect is not smart enough to do that, AnaplanConnect is essentially just using Windows (or Linux) scripting to initiate an action of some kind in Anaplan — to feed or receive data, etc. Because of that, your developer would be able to write @pyrypeura's suggested logic in the appropriate scripting language to determine if the export should happen.

I wrote a blog post eons ago on setting up some methods of making complex AnaplanConnect integrations more manageable. There is a link at the top to a Windows Scripting language guide that could prove useful. Check it out! :)

https://community.anaplan.com/discussion/67536/tips-for-large-script-implementations-using-anaplanconnect-1-4-x

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385