-
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:…
-
Workbench connecting to MS SQL Server "Value cannot be null. Parameter name: input"
Hi all, I am trying to set up a Workbench job to connect to a MS SQL Server databsae and am getting the error: "Value cannot be null. Parameter name: input" I have tried with the AWS RDS instance I am connecting to as well as a local MSSQL DB instance on my laptop. Could you please explain what is the "input" parameter…
-
DataSet Name has no DataSets listed in Workbench 5
When I setup a Workbench Job, I manually typed in the DataSet name. When it ran it created a new DataSet. I tried to use the Browse to link it to the correct DataSet, however it is blank. No DataSets listed at all. How do I get the DataSet Name under Domo Details on the Overview tab in Workbench 5 to populate?
-
Workbench Jobs not running on a schedule
I've seen issues posted by other community members in the past, but it doesn't seem as if anyone has posted a solution to this problem. As of Monday morning, all of our scheduled jobs have not been running on their normal schedule. I've tried reauthorizing our account and setting all the schedules again, but they still…
-
Jobs are running constantly and ignoring their schedule on workbench
Hi Dojo Community, I have come across this issue were handful of jobs were running constantly and ignoring their schedule on workbench. Restarted the services but that had no effect, ended up changing the scheduler for each job from manual and back to its schedule run time and that worked. That tells me that most likely…
-
Max Column Width?
We have a vendor that is sending us data where one of the columns has HUGE strings, but they are all being cut off at 1024 characters. We can't figure out if workbench is cutting it at 1024 characters or if it is on their side. Does anybody know offhand if this is a workbench limitation? Thanks
-
Quickbooks On Workbench - Sequence contains no matching element
Unable to load quickbooks on premise data through workbench. QB file located on local computer(Accessing the remote computer that's always logged in through anydesk. Report selected, authorized workbench to access quickbooks. Error : Job requires interactive session, but no interactive session available. WorkItem…
-
Setting up Workbench on new server - "Key not valid for use..." Error occurring
I have set up Workbench on a new server and I have imported and updated a job that was previously running on another machine. On my first and all subsequent attempts at running the job on the new server, I receive the following two notifications: [02.05.20 5:02:50 PM] Determining execution parameters [02.05.20 5:02:50 PM]…