-
Scheduled Report - Excel Attachement
Allow scheduled reports to attach the data in excel format rather than csv. CSV files don't keep special characters in the data, so accented characters are messed up in the CSV.
-
I have two files as .xlsb in my shared google drive folder,
I wish to upload specific sheets of these two .xlsb files in DOMO, how to proceed?
-
Difference between excel plugin and excel addin.
When using the excel add from the excel windows store the domo content would disconnect and I would have to reconnect to the domo database to refresh it. Will the plugin provide a better experience? vs
-
How can I convert an Excel date code into a normal M/D/Y formatted date?
Hi All, I have some data that I link to DOMO via the Google Analytics connector. It's provided by a 3rd party and contains dates in Excel codes in their 4** format. Is there a recommended Beast Mode or other way to fix the date formatting? Due to IT policy, I can't access google sheets to change it manually. Plus, I would…
-
Increasing spreadsheet attachment size on scheduled deliveries of cards
I have a client who is requesting a scheduled daily email of one of their cards with a csv spreadsheet attached. Sadly the limit for the attached spreadsheet is 5mb, and the reports are usually 10-15mb depending on the day. Increasing the size limit would be a big help in our efficiency of supplying them with the…
-
Refresh Excel datasheets that have been uploaded via Plugin
I recently started using Domo and have an Excel spreadsheet with several tabs that I uploaded to Domo via the plugin. I created a dataset for each tab and then appended them for a single output. This spreadsheet is updated by a few different people and I need to update it probably 2-3 times/month. I tried searching the…
-
Sending Card Data via SFTP
Is there any way to send the output of a card (XLSX or CSV format) to an SFTP server? We are looking for a way to schedule weekly updates of a report and have it automatically sent to an SFTP directory. I saw that there is an SFTP writeback connector available as part of the Domo Integration Studio, but that appears to be…
-
Replace an excel file uploaded using File Upload Legacy connector
Hi All, I need to re-upload an excel file that I uploaded using the File upload legacy connector ...Can you please let me know how to do this...
-
SharePoint REST Connector
Hoping someone has run into this when connecting an Excel sheet from a SharePoint. My header row (row 10 as it happens) has a blank in cell A of that row. Instead of pulling it in as Column_1 as I would expect, it removes that cell and shifts all other headers over. Not only do the headers end up shifted, but it fails to…
-
Export Dashboard to Excel
Hello, I've built a dashboard with multiple tables - each with unique datasets. How can I export to excel without having to select each table, manually export each table to excel, and then combine in the same excel workbook in excel? Ideally, each table from the dashboard would export to its own tab in the same excel…
-
Line breaks and special characters are being added to a webform
We use a webform for our Sales roster. We have had an intermittent issue with line breaks and special characters being added to the rep's names which causes quite a few issues. The very first sales rep on the roster is getting a line break added to her name. There's another sales rep getting multiple line breaks and…
-
Exporting as .xlsx is exporting a 0 KB file when it worked for this card before?
We've got a card that is essentially a transposed Excel table. Employees have been able to export this card as .xlsx before with no issue. However, now Domo is exporting a 0 KB .xlsx file that when attempting to open, Excel says it is corrupted or an invalid file format. I can export the dataset powering the card just…
-
Email connector not finding link
Hi there! According to the KB article for the Email Connector this should be working correctly, but here I am :) I receive a nightly scheduled XLSX report from a third party reporting tool. They recently stopped attaching the report to the email and instead put it a link to a page which then downloads the file from AWS.…
-
Box advanced connector multiple excel files
In the Details section of the Box Advanced connector, the information icon next to the "Would you like to choose a file from folder" indicated that if selected as Yes, then the connector should pull the files from the folder specified in the "Folder name or ID" field. However, when I execute this data load with a folder…
-
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…
-
Unique Values Pulling Through twice
I've used an excel upload method and I'm tidying up the dataset using Magic ETL. On one of my columns there is a value labelled "Test". For some reason it is pulling through as two unique values when it should only be one. I have tried to use 'replace text' but whatever I replace it with it pulls through again as two…
-
Market Share (% of Total) and % Change/Trend Calculations
Is there a way using beast mode, or some other functionality, to create the following two equations in a DOMO card — to display on graphs as well as in a table/pivot table. 1) Market Share as a percent of total. In other platforms like PowerBI with DAX this would be achieved with something like the following random…
-
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…
-
CSV (or Excel) Export without Header Row
DOMO Team, I need a way to export data from a card or dataset to CSV (or Excel) without a header row or column names included in the output. Thanks! --Nick
-
Can we upload single excel file with multiple sheet into DOMO and use it?
Hi Dojo, I have many small small data set in excel which is in 12 sheet in single excel file. Can I upload single excel file with 12 sheet of data and use it in domo to create a report or I'll have to create 12 separate data source into DOMO? Thanks Suman
-
Using Sharepoint online connector to extract excel file
I am wondering if anyone has been succesful in pulling an excel file from sharepoint using the online connector. It seems I have tried every variation of the file's server relative URL with no luck. Thanks in advance for any help.