You’re offline. This is a read only version of the page.
5
I am working on a BC Premises.
I need to automate upload of excel files to general journal lines without posting them from a folder which is on the same server as BC.
The process should be unassisted, I mean, we do not expect any person to execute the tasks or initiate the upload.
How would you do this?
I would recommend you put them on a Azure blob storage instead of putting them on a local server.
It is easier to automate the process within Business Central if you put your files on an azure blob storage.
Here are some sample codes that reads a CSV file from a azure blob storage and imports it as General journal lines in BC.
The same method can be used for Excel files using the Excel buffer instead of the CSV buffer that I am using in this code.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (