How to automate FBDI file preparation?
For bulk data loading with FBDI, as far as I learn, manual work is still needed to download template (xlsm) file, copy & paste data to the sheet and click button to generate zip file. Is it possible to automate this process?
I believe the answer is definitely YES, but what is the common practice to achieve the automation?
I come up with some ideas that some rules may be followed no matter what technology stack is used:
- the link for the template (xlsm) file should be configurable or retrievable, whenever the system is upgraded, the link can be updated correspondingly.