-
In workbench is there a way to alter the "DataSet Job Id"?
We'd like to use the command line to queue jobs automatically but ideally would like to change the job ID to make the commands a little easier. Alternatively, if there was a way to queue jobs by the job name as opposed to the ID that would work as well.
-
Dataset Jobs in Folders
I would like to organize my DataSet Jobs into Folders, or other hierarchal structure. Does anyone know of a plugin that may allow this? Maybe I could request this as a feature in a future workbench update. My Jobs list is getting long and hard to sort through to find what I want. We have jobs that run on different…
-
How to access DOMO website through a virtual machine?
Currently the company I am working has no dedicated machine for workbench to be installed and maintained. Domo has suggested using a virtual machine, in which i have two instances created. The first instance I am using Amazon Web Services in which i have a virtual machine created that meets the requirements needed for Domo…
-
Filtering in Workbench
How do I filter out anything that would match *Text* (this is excel format) Example: Blah blah Text Blah blah (this would get caught by the filter). It isn't working. It errors with: [06.24.16 01:56:22] parsing "*START*" - Quantifier {x,y} following nothing. Filtering with: Total*,* worked in WB just like in Excel. Also…
-
Unable to import DataSet Jobs successfully
I am unable to import DataSet files and then succesfully uploading to our domo server. As a way to duplicate DataSet Jobs, in order to save time redoing schemas and transfroms I tested exporting a working DataSet job and then importing it back, changing the DataSet name when asked by workbench. when I then try to run the…
-
How put together "Date" and "Time" columns into a "Date and Time" column using transforms
Wath transform formula/method do I need to use to create a "Date and Time" from a "Date" column and a "Time" column? For example I Date I Time I I 1/1/2016 I 2:00 PM I Into: I Date andTime I I 1/1/2016 2:00PM I
-
Input string was not in a correct format.
In Workbench, I am not sure why, but I got this error when trying to run or preview the data from an excel file: Input string was not in a correct format. What does that mean?
-
How to set blank as encapsulating char in loading flat data files
Hi, I want to load data in flat files to DOMO using Workbench. My workbench is Workbench4. Each field is delimited by a Tab (so it is a TSV file) and there is no encapsulating char around a field. I want to load the files as they are, but Workbench does not allow me to set blank in "Encapsulate Fields With" text box in…
-
Unable to upload some .xls spreadsheets
I had this issue with some .xls excel spreadsheets. After selecting them and applying changes in workbench, the spreadsheet tab dropdown box would be blank so I was unable to select a tab and therefore unable to do any further work with that sheet.
-
WorkBench Installation for Mac OSX
I followed the guide for installation of workbench but it seems the installer is only for windows. Is there an installer for Mac OSX?
-
403 Forbidden Access Error
I have privlege access to my company's domo account but not able to create any jobs in workbench 4 to upload the data. I am getting 403 forbidden access error. Please help to resolve this issue.
-
403 error connecting to domo.com
Hello! I have been getting 'Error Processing Domo Request "api/data/v1/onboard/agents": The remote server returned an error: (403) Forbidden.' error everytime I connect to domo server on my workbench on my desktop. It works perfectly on my laptop indicating that my windows firewall/or other settings has gone rogue. Has…
-
Clearing the Queue
We keep getting this error when trying to run datasets. [04.12.16 07:39:17] Job could not be added to the queue because it is either already queued or currently executing. Does anyone know how to clear the queue so we can run them? THis particular dataset hasn't updated in 16 hours, even though it is set to every hour.…
-
Can Workbench be installed on Citrix?
Has anyone installed Workbench on Citrix? I can't find any documentation on this.
-
How to select distinct in workbench
I have a column with Firm and FirmId. Each Firm has multiple FirmId's. I want to select distinct Firms. How can i select distinct Firms regardless of FirmId. And how can I select distrinct Firms based on minimum FirmId?
-
How we can upload a data set from txt file using workbench 4 as we did on previous versions?
How we can upload a data set from txt file using workbench 4 as we did on previous versions?
-
Upload Error - Same Key?
Has anyone had errors upon upload that indicates "An item with the same key has already been added" and what causes this? I am simply replacing the last data set uploaded. Will keep trying, and if I figure it out will update
-
How do I use lastvalue variable in workbench 4
I am trying to use the lastvalue variable to append new records in workbench 4 but it is not working because I am not sure what I am supposed to put in as the value under replacement variables. Does anyone have an example of using this in workbench 4? I can only find examples from 3. The only time I even get it to run I…
-
workbench SQL data source - keep getting errors
I'm new to Domo and having a frustrating first experience. I'm trying to connect to the on-premise SQL database for our ERP system via ODBC I'm using the same connection information I use for SSRS reporting and MS Query. But I keep getting connection errors: error 28000 Login failed, error 01S00 invalid connection string…
-
Workbench v3 - Getting Error trying to import csv
I have a csv file that i am looking to import. would seem very straightforward, has a header row, i have the file on my local desktop, i am the admin on our DOMO instance. When i go to validate and/or preview i get the following: [19:00:30 UTC] ==========| Running Preview |========== [19:00:30 UTC] Opening CSV File:…
-
WB4: "Input String not in correct format"?
Does anybody have any ideas about this error? I'm running a WB4 job connecting to xlsx file. I've manually run this job 14 times successfully. I've tried to preview my data three or four times this morning, and am always met with the error "Input String is not in the correct format." Looking at the log for the job, I see…
-
How to do a partial replace in a dataset?
Time card data gets updated very frequently and is in a parent child relational database. I want to keep that structure at the base level in Domo. The tables are work summary and work detail. The details are deleted and recreated in the applicaiton when the time card is updated. How can I update the work summary record in…
-
Is there a way to start a workbench job via a script or API hook?
I find the DOMO workbench scheduling options limited. I would like to be able to have a batch file or a python/Javascript/.net whatever kick off a workbench job, and perhaps be able to pass in parameters. Is there a way to communicate with workbench or the system service (v3)?
-
Already in queue for execution
We are having a problem with Workbench where it looks as though the jobs are not running because the queue is backed up. When I look at the Workbench Service log files I see the following: Job Id 82 - next run date of 2015-06-26 05:30:00 Local is past due. Already in queue for execution. Any thoughts or ideas how to clear…
-
Workbench 3 issues with automatic upload
I just imported all the files from workbench 2 to workbench 3 and am able to upload the data into DOMO successfully if I do it manually, but when it goes to update it as per the schedule, it isn't working. Does anyone else have this issue or know if I'm doing something wrong?
-
How can I get data into Domo and automate it?
Greetings, Are you wondering how we get data into Domo and automate it? Read up on our Workbench tool. Click here.
-
Workbench 3 upload issues?
Is anyone having issues of workbench appearing to upload data but the cards that they job powers, are empty? We've noticed this a few times in the last week or so since transitioning to the new WB 3.x.
-
What is DOMO Workbench?
Click here
-
Differences Between Workbench 2 and 3?
The version of workbench I have been using so far for my data uploads is version 2. I found out in the Advanced domo presentation that there was data encryption offered in version 3, which is important given the PHI my company has to deal with. What are some of the most important differences between version 2 and version 3…
-
Domo Workbench executing jobs on a Group Schedule multiple times
Hello everyone, I have multiple Workbench jobs that run on a 4 hour schedule. What I have noticed is that when the jobs run, they run 4 times one after the other like they are trying to catch up to the fact that they did not run in the past 4 hours and now running 4 times they look like they they caught up for an hourly…