-
Domo Workbench 5: Unable to Query Provider Types
Hello folks, We use Quickbooks Desktop 22 (queue eye roll) and use Domo WB to connect to the network files and send data over to Domo. I have been seeing this error alot lately. Has anyone ever specifically ran into this type of error and if so what did you do to resolve it? [INFO] [3532:12] 2023-05-18 00:03:30,774 -…
-
For those using Domo Workbench with Quickbooks Enterprise, how do you deal with modal dialog boxes?
Intuit login, errors pertaining to the qbsdklog.txt file, etc…we are getting multiple errors every single day which hang up all of our Workbench jobs. How does everyone else deal with these? We have implemented a Power Automate script on our servers housing our Workbench jobs, but some of the dialog boxes, particularly the…
-
Best Practice: ETLs Vs SQL ETLs
We are trying to rebuild a tool Domo Tech built for us called Domo Stacker. Its main purpose is to aggregate many datasets together. Our current datasets are 250+ recursive ETLs that output a dataset that is growing (think: historical + appended new data) for four buckets of categorized data (four separate outputs when…
-
Quickbooks Online - received $ transactions
Hello, we are trying to get our received $ transactions at the lowest level of detail /and at day level from quickbooks online with domo cloud connector(s). To be clear we are not talking about invoices, but rather paid invoices (e.g. deposited in the bank, so QBO registers it as a paid invoice in QBO). Can anyone give me…
-
Quickbooks Enterprise - ETL Transaction Pickup Issue
The nuts and bolt of the issue is our Quickbooks ETL logic is not picking up edits made by end users. We are wanting to pick up the latest transaction. We validate or process on the date and transaction number field. So say there is transaction number (TN) 123 on 1/29 and TN 124 on 1/30. If the user edits then edits 123 it…
-
Filtering out rows by column value doesn't work?
I'm relatively new to Domo, but I feel like I've mastered most of it, including Workbench (I'm a software developer, so I can usually get ahead on things like this fairly quickly). Specifically, I've had plenty of success with using lookups to join data in Workbench, as well as regular expressions to transform data.…
-
Domo Workbench - Workbench Quickbooks connector - TIPS, TRICKS & NOTES - ***BETA***
Domo Workbench - Workbench Quickbooks connector - TIPS, TRICKS & NOTES * I have had to enable the local 'Administrator' account and impersonate the 'Administrator' local user account to get the jobs to run. * I am unable to get Microsoft accounts to run Quickbooks jobs. * Do not follow suggestions to change properties of…