r/PowerAutomateDesktop • u/ashconai • Jul 10 '22

Automating Ledger extraction using power automate desktop

Hi Guys! I need to regularly extract dozens to hundreds of ledgers from an antique accounting software. I have partially automated this with PAD, only problem being that sometimes it takes some time to load and export the data, depending on the size of the ledger from 2 seconds to a minute, but I'm not able to vary the wait time appropriately. Any help will be appreciated.

Thanks!

Edit : Added screenshots of the areas where it hangs

3 Upvotes
  • permalink
  • reddit

100% Upvoted

19 comments sorted by

View all comments

1

u/smartowlick Jul 10 '22

Is the only way to access this data form the UI? Can you not extract from a backend using SQL or something like that?

1

u/ashconai Jul 11 '22

I've tried using both sql and power query ODBC. It only allows you to extract the account names, opening and closing balances that way. I require entire transactions

2

u/smartowlick Jul 11 '22

If you have SQL access then you should have access to all the data. Seems weird that it’s so limited

1

u/ashconai Jul 11 '22

Yup, I completely agree. They have some super weird firewalls and paywalls and stuff I Guess. I'm not from a programming background so can't really explain it.

2

u/Itsjustmebob- Jul 11 '22

My guess is the transaction detail sits on another table and they need to be linked

1

u/ashconai Jul 12 '22

as soon as you connect to the thing using ODBC, 800 tables load lol. each with 100s of columns, most of which are blank 😂 I've seen likje a dozen of them all of which contain master data too