-
Is there a way to remove historical data from an "appending" DataSet.
Is there a way to remove rows/data from a DataSet that has been appending rows since its creation? The data I need to remove is older so it is not able to be removed from the History tab, nor is the data from a single upload anyways. As the DataSet is also a Legacy DataSet from a credit usage point of view, a new…
-
Workbench Enterprise - Any experience with it.
Has any one had any real experience with Workbench Enterprise? When I saw it on an presentation I was very excited about as I thought that I would be able to control our existing workbench set-ups via the web. Due to IT's concerns (don't get me started on that) I cannot control one of my Workbench PCs remotely, so being…
-
MQTT duplicating data, eventually failing
Hi I managed to set-up the MQTT connector with our Siemens WinCC SCADA system. The data however keeps duplicating each run until it eventually stops transfering. On the Siemens side eventually it start getting errors and the transfer stops. In the image below you can see and example. The data being uploaded is only 3…
-
Siemens WinCC MQTT connection
Does anyone have any experience (and hopefully success) connecting Siemens WinCC 7.5 to DOMO via MQTT. I have not been able to get this to work. I can get it to the point where I get a successful connection on WinCC. As a test I have changed different parameters and the connection fails (so the connection test does work)…
-
Emailed DataSet date conversion
Hi I have a DataSet that get updated via the email connected. The data includes a date column, I am having issues with the automatic date conversion on the DataSet. See below an example for the data in the CSV file, both dates are on March 2024 2577,Benjamin,12/03/2026 date gets converted automatically and incorrectly to 3…
-
How do I reproduce this type of graph in all view
I would like to have all the "turned off" variable lines in a graph turn grey when not turned off and get them to have their selected colour when turn on. See the attached images for a better explanation that makes actual sense. The attached images are all of the same card. The "turned off" variables were turn off in the…
-
User not a member of the 'Domo Workbench User' - But only when using impersonation
I am currently transferring my workbench jobs to a new computer on a new network system. I keep getting "User not a member of the 'Domo Workbench User' group" when setting up impersonation on network file jobs. My username, which I use for impersonation, is already part of the 'Domo Workbench User' group. I can run jobs…
-
How to prevent WB from disabling jobs if source file is not found
How can I prevent WB from disabling jobs if source file is not found. Most of my files are located in a server. If for whatever reason the WB PC loses connection to the server and it attempts to run a job using a file that it cannot temporarily access, the job gets disabled. Generally, soon after connection is gained again…
-
ETL so much faster than SQL at joining
Not so much a question but a statement of my experience with DOMO I am not a SQL person (if that is a thing). I had only been using SQL to join datasets where ETL would run into the 10 000 repeats limit that would prevent it from running a Left Join. I later realised that you cna go around the 10000 limit by using a Right…
-
Email connector unable to receive more than 1 email at a time. Any workarounds?
So as it turns out the email Connector, great as it is, has a key flaw, if two emails arrive at close to the same time one of them will not be imported. Silly as this sounds, the following error comes up " The import has been cancelled because a new request has been submitted." I originally noticed the issue when I created…
-
Modify Business in a Box derpartments
Is there a way to modify the Departments shown in hte Business in a Box page. I like the idea of the Box but non of it applies to us. I can add custom dashboard but as not even the Departments titles work for us it would be pointless in helping people find things. I would like turn the Box into a sort of Library of pages…
-
Index was out of range. WB 5 Error
I started getting the following error on one of my jobs: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index". Any idea about what it means. I beilve it is related to the Lookup transform used in the job I havent run the job nor made chagnes to the data sources for…
-
WB Custom Date Format to working for 20180704130000 format
Hi I am unable to get the following format date 20180704130000 (or 2018/07/04 13:00:00) using the workbench data transform. As I see it the Date Format I should use would be yyyyMMddHHmmss Schema for the filed is set to STRING as suggest in the topic below. I had a look at the following dojo topic and article but I still…
-
How do I to get the Watch File function to work?
I seems pretty straight forward, select "Watch File" instead of schedule update every 15 min or something else, but I have tried it with some 40 jobs and not a single one job has ever updated automatically that way. Even after a couple of days an several cahnges to the files it never works. All our files are on our server…
-
How to change the name of a DataSet uploaded using the workbench and retain the change
I am unable to permanently change the names of DataSets created in the workbench. I can change the names form the Domo intance and I can see that change from the workbench, but as soon as the DataSet Job is run the name reverts to the original name.
-
Getting "Access to path 'C:\WINDOWS\TEMP\DomoCache\3d4edfasdf3.... is denied" error
I keep get a t least once a day on 2 to 3 what appear to be random jobs: Execution Status: Error Execution Message: "Access to path 'C:\WINDOWS\TEMP\DomoCache\3d4ed4ta6dfas.... is denied" (the numbers and text string being different every time). At that point the jobs may upload again on their next cycle but sometimes they…
-
WB 4.5 Lookup Transform bug/error (Not present in WB 4)
Since updating from WB 4 to 4.5 the lookup transforms not no longer work properly. I keep getting "Object reference not set to an instance of an object." on most of the jobs that have lookup transforms. I think I isolated the problem to jobs that have more than 1 lookup transfrom. It worked perfectly fine on WB 4.0. I have…
-
"Proper" Online form as data input
Is there a way to use Domo in conjunction with either a built in feature or easy to set-up add-on/connector to directly add data to a DataSet using a online form. Ideally it would be set up directly on Domo like the Poll function but feed a DataSet like Domo webform. The built i Domo Webform is a bit too crude compared to…
-
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
-
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.
-
Option to show periods with no data in graphs
At the moment depeding on the graph type adn source data periods with no data are not show on graphs. For example, in the attached image Jan, Feb, Apr Jul are not shown (on the last 12 month range). Thsi makes the graph confusing or missleading. I would like to have the option to show the missign peroids and/or to show…
