-
Workbench Job Runtime
Does anyone have any tips or best practices for improving runtime on workbench jobs? We have a job that updates almost 82 million rows of data daily and takes about 3 hours to run. It varies day to day anywhere from 2 hours to 3 hours. I do not have access to workbench as it is controlled by my IT but I am looking for tips…
-
How do I use Workbench to Writeback a dataset to ms sql
😫 I'v been around for while using workbench to upload MS SQL data into DOMO. I heard there is a Writeback ability in workbench. Any help would be appreciated. Thanks
-
Scheduled Workbench Jobs not Running: The communication object, System.ServiceModel.Channels.Service
We have several scheduled Workbench jobs that are extracting data from SQL Server tables and loading to DOMO data sets. The jobs are failing to run at their scheduled times, but I am able to run them manually without issue. They are showing this error: Strangely, only some of our jobs are showing this error. We have other…
-
Domo requests "save" when no modifications
Is anyone else losing their mind (and modifications made when Domo open in duplicate tabs) due to the request to save changes when no modifications have been made to a transform? Screenshot attached.
-
Workbench ODBC - Dynamic query/parameter
When we are establishing a new job in Domo Workbench of the type ODBC, we write the query in the box of Database Query Editor as in the image below. However the query we want to do should not be static and we would like to modify that query based on external triggers. For example, in the image, is it possible to pass a…
-
Re-running a failed job in workbench using automation
We are currently using Domo Workbench to pull in data from various 3rd party property management information systems and this requires a large amount of jobs to be run. The problem comes when one job fails for one reason or another and there seems to be no way to automatically set it to rerun, causing someone to have to go…
-
No embed dashboard option in share dropdown.
I'm wanting to test the embedding option - however my dashboard hasn't the option in the share dropdown. How can I enable this?
-
DOMO Workbench 4 Log Export
We have been having some issues recently with Workbench jobs and I would like to be able to compare the job activity between jobs that were successful and jobs that had errors. I can select only one line on the log at a time and export that (using copy/paste) I was wondering if there was a way that I could export all log…
-
Workbench 5 Crashes w/ custom plugin
Hello Domo Experts, I am having problems trying to create a custom, transform, plugin for Workbench. Workbench 5.0.7: When I use Visual Studio to create a new plugin, with no changes to the default code, and add it to WB, everything is fine until I try to configure the Transforms option. When I do this WB crashes. When I…
-
Its showing me "Live updates are not available" as the status, how do I solve it?
I uninstalled and installed the domo workbench multiple times to try and solve this problem but it seems i cannot get rid of this. I need some help to know why it is happening and how do I solve it.
-
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…