Struggling to import data using Libreoffice generated Excel Files

Support
1

I am currently doing some testing with Triggre and I am struggling importing some core data.

I created a new data type consisting of three numeric fields and a text field, nothing spectacular. I built a small spreadsheet filling teh text column with a custom date format(for later use) and two of the numeric columns with sample data(all data is between zero and 10 with two decimal digits). As I am not using any MS technology I am exporting the data into MS xls and xlsx format, but do not get any usable results with the standard wizard.

Using the xlsx file I am getting “Data item ‘Ovum’ not set to importable“ hundreds of times while my sample record only has ~30ish records. => Any ideas what might be wrong here?

Using the xls file in contrast fails either fails, but crashes into the front door with “Failed to read your file. Check that it’s a valid Excel document.“

Is there anything I might be able to change or just do a CSV import instead?

2

Hi Roland,

To be able to import data via the Excel import you need to set the data-item as importable. Follow these steps to do that:

  1. Login to your designer
  2. Go to Design
  3. Go to Data
  4. Click on the data item “Ovum”
  5. Click on the pencil on the right of “Ovum”
  6. Check the checkbox “Allow users to import this data item”
1 Like