Update my database whit an Excel

1
Hello i create an App from a spreadsheet!  That is very comfortable to create an Entity whit Attribute and fill up whit data. Is that also possible to update my database whit an Excel file afterwards to get fast new data in my Attributes?    
asked
5 answers
3

Andre,

Yes.  You can use the Excel Importer module from the app store to quickly load data into your application.  You can find that module here:  https://appstore.home.mendix.com/link/app/72/Mendix/Excel-importer

Mike

answered
0

Hello mike thx for the hint.
I`m now implement the excel importer module in my app and it works.

 

But i have one problem i have an entity whit some atrributes (shown in the picture below)
When i do an excel update only three data are updatete and two are empty?


   

answered
0

i configure the Excel importer  whit the ExcelImporter.Templates_Overview Site 

But the Mounting Attribute is also an Enum and there it works whit the import!

answered
0

Thx for the hint.
I add the under line in my excel file and now works!

 

I don`t kown why the under line comes in the Enum Attribute, maybe from the first excel import !?

answered
0

And is there also a possibility to delete the whole database?

answered