Excel

I have several excel files that automatically update daily with the same name. I want to get the data to Domo. I was using File Upload Connector, it doesn't update when the excel was updated. (I tried using File upload connect with an excel by deleting and adding several rows, clicked update through setting, but the…

Applicable especially to tables when to save space developers choose to show only a limited number of rows. However, it might be benefic to have the option to show all rows for exported files.

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…

Hi Everyone, Happy Friday Eve. I have a shared Excel workbook with multiple sheets that are appended together via power query into a master list sheet. I'd like to set up a Domo connector to pull from this master list sheet only. Is this possible? What is the ideal connector for this, and where is the ideal place to store…

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…

When a user goes to export a table type card, it would be helpful if there was a notice or warning when selecting the excel option informing the user that there is a ~1 million cell export limitation and to consider using CSV. This limitation is not found in the card detail view and may be missed by users. By adding the…

We have a dashboard that has 4 different tables and we want to schedule a report to send these as either 4 different Excel files or 1 file with different tabs for each table. We're going to send these reports to people outside of our Domo instance, so the Excel file is a must. Is something like this possible? If not, is…

For the first 3 years at Domo there has been a warning about exports over 100,000 lines for .xlsx saying "there are possibly missing lines of data as you have reached the max data exported via .xlsx." The issues for us here is that people are going to be working with large data sets and then never know that data is…

I wish to upload specific sheets of these two .xlsb files in DOMO, how to proceed?

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? https://domo-support.domo.com/s/article/360043437933?language=en_US vs…

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…

When data get extracted from users across the dashboards the export file only has the content but no meta information (dataset, time of export, filters applied, person who exported). So when distributing or asked to update it's not always clear where the data come from. It would be useful to add this information to the…

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…

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…

I'm trying to create a dynamic Beast Mode that uses a window function to select the first value of a column (based on date) that is part of a function that sums other columns. In excel parlance I want to be able to vlookup start_date and grab the value for the associated column, then add that to a sum of another column…

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...

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…

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…

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…

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.…

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…

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…

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…

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…