-
Why is my custom connector stuck on "creating dataset"
I'm having an issue when trying to test my connector. When I Run Script and have "Create/Update DataSet" checked, it finishes the "Sending Data" portion but then just stays on "Creating Dataset" without ever letting me look at it. Am I doing something wrong to cause that?
-
salesforce: Sales report issue
I am importing the sales report from salesforce as the currency symbol is of indian rupees which is not a known currency symbol in DOMO. When the dataset is created in the preview i can see another blank column created with the same name (for the columns that are updated witht he indian currency symbol) Any solution for…
-
Column Appended Current Date with SQL Transform
Hello, I was trying to append a table to add the date to it using: ALTER TABLE `pos_left_by_week` ADD 'date' TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, however, I am getting the error: The database reported a syntax error. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server…
-
Trying to connect to MYSQL and keep getting error "Something went wrong getting data"
I am easily able to connect to this same data source using Microsoft Power BI. Using same credential I keep getting the error "Something went wrong getting data"
-
Smartsheet connector to pull in Sheets from Folder into one DOMO Dataset
Hello All, I am looking to see if someone is using DOMO and Smartsheets. Have you collected a large number of sheets in DOMO and created visual of a PMO dashboard? Are you able to get multiple sheets from Smartsheets and placed into DOMO in a single dataset. The current method I am using is to get each sheet as a SOLO…
-
Can an alert trigger an API call?
If I define an alert, can that trigger an API call to an external resource located within our AWS infrastructure?
-
Data Origin
Is there a way to show the origin of the data in the final file? Meaning if I have multiple input files and/or a mix of files, databases, etc, can I add the provenance/data origin of a specific piece of data in the file file created? So if I have 3 columns in Excel file called "Works" (say Columns A, B, C) and I have a ETL…
-
DomoR connector error : Not Acceptable (HTTP 406)
Hi, I was trying to use DomoR package directly to download a dataset onto R. I used below codeset - > library(DomoR) Welcome to DomoR > DomoR::init('XXXXX',…
-
Fetch Dataset based on some selection criteria using DomoR
Hi, I use DomoR package to download a Dataset onto my R environment for further processing. I am wondering is there is any possibility to fetch data based on SQL query. Like, instead of fetching entire dataset, it is possible to fetch data like select * from Dataset where Age > 20 My original Dataset is quite huge so I…
-
xml advanced
I have an sftp folder where xml files are getting dropped multiple times a day, sometimes with the same timestamp. Is there a way to add all of the files in that folder to a dataset? I tried keeping the file path open ended, ending with the folder. sftp://IP/FOLDER/FOLDER/ I think this method works with CSV Advanced. Is…
-
How do we use Domo for Asana dashboards?
I found Domo via searching through Asana forums which lead me to this page: https://www.domo.com/connectors/asana That example is EXACTLY the type of thing I'm looking for but can't seem to figure out how to replicate in Domo. I'm looking for a tool that will help me analyze how our company is using Asana and dashboarding…
-
Can I use Domostats to see which datasets feed into dataflows?
I've started using Domostats to see how many datasets and dataflows we have and to start building a holistic view of the system and a naming convention for our internal datasets. I can pull in the names and Id's of the dataflows and datasets, and I can pull in the history of the datasets which gives me which dataflow…
-
Data Connector Fields Refresh?
I have a question and I'm not sure if this has been asked (couldn't find it) and I'm not sure if anyone else has this issue, but: If I set up a data connection with columns A, B, and C and then I add column D, all columns show as expected. However, if I have columns A, B, and C and then delete C from the import, the data…
-
Upload Connector - Field with "%" in it coming over as scientific notation (E-)
Hi! So I have a bunch of spreadsheets that I'm loading into Domo using the Upload Connector. These are far from ideal and are manually populated by users but it's the world I'm living in right now. The problem I ran into today is there is one set of fields where the field in Excel contains a value with a % symbol keyed…
-
Questions about Domo pre-built Connectors
Hello we are new to Domo and I had a couple of basic questions related to Domo pre-build Connectors: * Is there a way to get notified when Domo makes an update to a Connector we are using? * When a Connector is updated do we need to do anything on our side to use the updated version or is it automatic? Thanks!
-
Connecting to Outlook
Our customer service center would like metrics on emails sent and receive. Since we use personal and shared inboxes using Outlook, I'm trying to connect to the data using the Exchange app. So far, attempts have been unsuccessful. Has anyone successfully been able to acquire email data for Outlook before? If so, what worked?
-
Connect DOMO to Table in MS Access Database Saved to Local Hard Drive
Hello, I've read the existing "asked and answered" post on this subject but am still at a loss in understanding what should be (?) a simple connection to an existing table in a locally-stored MS Access database. I can create a .dsn file to the database but am unable to point to it using a DOMO connector and/or Workbench.…
-
GDPR - Search and Clean Datasets
Was wondering if anyone has come up with a good plan for handling GDPR in Domo? If requested, you may need to search and remove out the name of someone whom has requested the cleasne to be performed. Trying to plan for this in Domo, and wanted to see what others may have done? Thanks!
-
PostgreSQL connector shows dabase content
I am trying to pull in a dataset with PostgreSQL, and when I put in the credentials it shows the database, however it will not run. I am told that the database is called acct.chartofaccounts, although it just shows chartofaccounts. Is there something that needs to be entered in addition to pull in this database?
-
How to get the data from S3 into Domo for multiple dynamic folder levels?
I have the directory structure in S3 as follows: bucket / year / month / day / filenameyyyymmdd.csv with year, month, day and filename change every day. how to get data into a domo dataset. Ex: bucket/2019/05/01/filename20190501.csv bucket/2019/05/02/filename20190502.csv .... bucket/2019/06/01/filename20190601.csv Please…
-
Domo Workbench connection to mysql error (on premise)
Hi, I'm trying to connect Domo workbech to my mysql database, this connection is by System DNS
-
MS Sql Server error Domo is ready but Sql Server returned: Connection reset
Hi, I am using Microsoft SQL Server. We had our user configured and working in multiples datasets. But 4 days ago we started seeing a problem when updating the data from our server the error description is "Domo is ready but SQL Server returned: Connection reset". Complete error description when I tried to create a new…
-
BOX import assigns column schema as number, causing leading zeros to drop, cannot add back
I've connected a number of CSV files via the BOX connector. There are a few columns that may have data with leading zeros. The box connector is automatically assigning the schema for these columns as number, which drops the zeros. The data is not patterned in a way that would allow me to add the zeros back in by padding…
-
Hadoop connector
Hello, I'm looking for the Hadoop connector in Domo without any success. However, I found some new and topic speaking about this connector : https://www.domo.com/connectors/hadoop Somebody use it ? Is it an option at extra cost or did I have to turn on some features ? Thank you in advance for your help. Philippe.
-
Google Analytics Connectors
I am attempting to use the Google Analytics or Google Analytics Enterpise Connectors and whenever I try to create a custom report I receive the error "Selected Dimensions and Metrics cannot be queried together". I can make a successful connection and import data but only by removing metrics and dimensions one by one and…
-
Editor Access rights to Data Source
Hi Guys What I`m looking for is as follows - I`ve a user that I`m looking to change permissions, so that they can create a card/s etc and view the datasources BUT have their ability to delete/amend/upload datasources "disabled" ( if that makes sense) So I guess a user permission of between participant and editor I`ve taken…
-
Can Activity Log track Dataset/Card Tags
I've got a large number of cards and datasets that I want to track activity on but would appreciate a way to quickly track the various groups that I've tagged. Is there anyway to do this?
-
Double Click Campaign Manager Connector Error
I'm facing an issue with this data connection and get the error below: Domo is ready, but received the following error from the API: Active schedules can't have a past expiration date. I'm not sure what the issue is, I'm using a manual report ID and the connection details are pretty straightforward.
-
Ebay Connector
Hello, Has anyone had any luck connecting to Ebay? I know that they are a DOMO customer but curious if anyone has had any luck with this? Appeciate it. Jerry
-
How to get the information for Domo Governance Datasets to the lowest level?
Hi, I am helping the IT team in my company to trace each Domo card to ALL of its dataflows and datasets behind. Domo has provided data governance datasets that are automatically generated by Domo itself everytime a new dataset or card is created. But it doesn't enable me to see all of the datasets behind, only the last…