-
Workbench Job Hanging, Dataset stuck on 'Preparing'
I have a scheduled Workbench job to update a dataset that typically takes 30ish mins to run. The job started yesterday at 1:37pm and has been stuck on 'Preparing..' in the Result field (on the History tab) since then. I just canceled the workbench job and started a new manual run. It started a new run, but the history tab…
-
Automating job creation in Workbench
Hi all, When my company opens new stores, there is a standard practice of creating 4 new particular jobs in Workbench. Am I able to utilize the Workbench SDK to do this? I cannot find any examples of using the SDK for something like this, and would appreciate any help. Thanks!
-
Calling JSON webhook from Browser return 403.
Hi there. I've setup a JSON webhook connector and I'm trying to push data into it from a browser, using Javascript and I keep getting a 403 response. I suspect it's a CORS issues. Has anyone seen and solved something similar?
-
Workbench won't update dataset after reversion.
I hope you guys can help. I had to revert a dataset on the Domo platform because there was an error in excel that broke the data. The reversion worked fine and it went back to an earlier version. HOWEVER, workbench does not realize that the dat has been reverted. so every time I try to update with the new data, it says…
-
Scheduled update of an Excel with date in the title possible ?
Hello all, I need to configure a job that has to be updated every day, but the bad thing is that the Excel file source is an extract from a database that is daily generated with the date of the day in the title (then it means a different title then a different file each day). Do you know if it is possible to let Workbench…
-
Unsupported SQL Functions in Workbench
Is anyone aware of some SQL functions being unsupported in Workbench? I have been using a small query that contains both charindex and substring. When I run it directly against our database in SSMS it works fine, but it seems Workbench is not interpreting correctly. It would be helpful to know if there's a document…
-
WB5 time settings
I was wondering if there is a setting in WB5 that allows you to change the schedule time from UTC to your current business time zone? For example I would need MST. Thank you.
-
Process for using Workbench to read a Sharepoint Excel File
Hi, I'm trying to set up Workbench to read a sharepoint stored excel file. While in sharepoint I am generating a link to the file (which is a web https:// link) but after putting this into Workbench as a "local file" it fails to reach the file. Guidance on what I'm missing in Workbench or Sharepoint to get this working…
-
Workbench query changing column values
I've connected Workbench to my Postgresql DB and using a posgresql function. Workbench is incorrectly displaying the numeric column fields. Postgresql returns as: with the exact same query, domo workbench displays: What is causing workbench to incorrectly display the values? Thanks for the help, Don
-
File of Workbench job moved; created two (2) datasets with the same name in DOMO
Aloha: I had to re-download my workbench onto another remote computer; which moved my file locations for my current jobs. The jobs ran fine; however, when I looked on my DOMO instance, I had two (2) jobs with the same dataset name. What is the easiest fix for this? Thank you, in advance, for any assistance provided. Salina
-
Changing URL to text
I have a report from Salesforce that I moved into DOMO. In this report, there is a Website column, which acts as a hyperlink instead of text. However, I just want the text portion of the column, not the hyperlink. Whenever I export it as a .csv, the column changes to text but has a lot of other nonsense along with it. Is…
-
DOMO not calculating Weeknum correctly
I am fairly new to DOMO and below are couple of issues while working. 1. I was working on getting the Week number from Date Timestamp column. I could see that Date formula and Date function in ETL are considering date Timestamp from 4 AM. For Eg :- Week 45 is from 12 AM of 1st Nov 2020 through 12 AM of 7th Nov 2020 but…
-
Workbench 5 - Job Scheduling: Ability to stagger start times?
Our group recently upgraded to Workbench 5. In previous versions of Workbench, there was an option to be able to schedule a job to run at a specific time. For example, Job 1 could be scheduled to start at the top of the hour, Job 2 to begin 10 minutes later, and so forth. In Workbench 5, the option for scheduling is…
-
Import multiple files into single Dataset
Every day a new Excel file is dropped into a shared network folder. Every file is in the same format, and each file contains one day's data. Is there a way, using Workbench or any other method, to transport all Excel files from one local folder into a single Domo DataSet? Since a new file is added every day, every file…
-
How to delete rows automatically based on a date in a dataset ?
I am inserting new rows in a dataset on daily basis, and now the dataset size has became huge since the rows are added daily. I want to delete the rows from this dataset based on date criteria (Dataset has a column type of "date" in it). So the criteria is like I want to maintain rows in dataset for last 30 days. eg assume…
-
Rename Filename on appending report from Workbench
Weekly I am appending the reports using workbench. I want to rename the Filename column into week number so that I could use this for my Week Over Week analysis. For example: my report names are "Jan 10", "Jan 17" and so on and Filename column generated as C\:work\Jan 10.xlsx. I want this filename to be look like "Jan 10",…
-
Cancel sharing all cards on a page
Please let me ask to solve my issue. For instance I shared Tom to PageA. All cards on PageA are shared to Tom automatically, and Tom can see all cards on the pageA. After that, I canceled sharing PageA to Tom. Although I canceled sharing PageA to Tom, all cards on the PageA remained to be shared to Tom still. Is there any…
-
Number of rows updated
Hi, When I monitor the datasets and look at the history sometimes I see "-" or same number of rows as previous update or increment/decrement in the count if rows for the updated rows. In case, the updated rows is shown as "-", and in workbench the message for the job is "Zero rows returned from Dataset Job execution", how…
-
Deleted a job without exporting
Hi, I deleted a job without exporting, is there a way to recover the deleted job? Thanks
-
One workbench, multiple Domo instances
Hello! Our organization works with customers using different instances of Domo. (Example: ClientA.domo.com and ClientB.domo.com) Does anyone know if one instance of Workbench 5.0 can send jobs to both ClientA.domo.com and ClientB.domo.com? If so, can someone share the configuration magic that needs to be set up for that to…
-
Global Replacement Variables syntax
I understand the use of Global Replacement Variables compared to Replacement Variables but I can't get it to successfully get it to run. I can get the Replacement Variable to work fine but when I try to make it a Global Variable, I get this error. "Replacement parameter does not contain a value for column Incremental_id" I…
-
Deleting and recreating jobs in Workbench
Hi, Some of the jobs in workbench were not running on schedule and when I checked the log viewer and it says “Local is past due. Queued for execution”. I went ahead and recreated the same job just to check if they run on schedule and they do as expected. My query is if I delete the old jobs(which weren’t running on…
-
Unable to fetch data from Oracle ODBC in Workbench
Hello, I'm trying to extract from Oracle using ODBC in workbench. I have follow following step for this 1) I have created System DSN for Oracle DB and tested connection its showing message " Connection successful". 2) Created workbench job for data extraction - 3) My Data extraction Query - SELECT country_id FROM countries…
-
TDS Stream Errors
Good afternoon, I'm trying to pull about 300k records via a Workbench 5 that is on my local PC by using an ODBC connection to a SQL Server and I'm getting the below two errors. When I try and pull anything under 100k, the job works just fine but as soon as I try anything 100k+ I get the errors below. I have plenty of…
-
Execution of Workbench job scheduled from windows task scheduler gets skipped
Hello, Have multiple task scheduler tasks with each scheduled to execute 'N' number of Workbench jobs. Sometimes execution of one or more jobs from the task gets skipped. No error message or logs either in Task scheduler or Domo. Has anyone else faced this issue ? if so, whats the solution to over come this. Regards, Rohil
-
Could not connect to the Workbench service to execute DataSet Job
Hi, Does anyone encounter the same issue: Could not connect to the Workbench service to execute DataSet Job The workbench was working before the restart of the computer. Thanks.
-
Checking the status of a job in the command line
Hi Everyone, Is there a way to check the status of a workbench job from the command line without combing the log files? We use A LOT of automated scripting to route files both before and after they are uploaded into Domo and I'd like to be able to make sure we don't accidentally move a file while it is currently in the…
-
lastvalue not updating when setting up UPSERT
I'm using Workbench 5 to set up some new datasets, on transactional tables which are updated often. I'm testing this on a simple example, and have followed the guides https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Using_Upsert_in_Workbench_5 , Section How Do I Change Data Capture…
-
Workbench Job Types (Workbench Excel v. Excel)
With the new Workbench all of our Excel job types are now named "Workbench Excel" and all of our jobs created previously are named "Excel". Is there any difference in how these function? Would it be beneficial from a perfomance standpoint to delete the old "Excel" jobs and recreate them as the new "Workbench Excel"?
-
SFTP Filename with Rnadom Number
I'm having an issue where the Excel filename provided to us in a SFTP repository contains a random 9 digit number. Is there a way to include a wildcard character or possibly regex in the filename? Example: Company_Daily_Extract_667819222.xlsx I have tried various methods when setting the Remote Filename:…