Skip to Content (Press Enter)
Back to Ideas
36
Like
Follow Idea
Static Entity: Import records from Excel 
1355Views
7Comments
On our RadarOn our Radar
Backend

Just like you can import records from the database, add a feature to import records directly from an excel file.

18 Apr 2011
Copy link to comment
2014-02-07 17-02-43
Vasco Pessanha
Merged this idea with 'Static entities excel import' (created on 30 Jan 2012 13:53:32 by André Ramos)
07 Sep 2018
Copy link to comment
Allow the static entities to be constructed by the importation of an excel data file.

This comment was:
- originally posted on idea 'Static entities excel import' (created on 30 Jan 2012 by André Ramos)
- merged to idea 'Static Entity: Import records from Excel ' on 07 Sep 2018 15:04:20 by Vasco Pessanha
30 Jan 2012
Copy link to comment
This would be awesome

This comment was:
- originally posted on idea 'Static entities excel import' (created on 30 Jan 2012 by André Ramos)
- merged to idea 'Static Entity: Import records from Excel ' on 07 Sep 2018 15:04:21 by Vasco Pessanha
30 Apr 2015
Copy link to comment
2014-02-07 17-02-43
Vasco Pessanha
Merged this idea with 'Bootstrap static entity from excel' (created on 03 Nov 2018 20:09:39 by mariap)
04 Nov 2018
Copy link to comment

Hi,

Since some applications require static entities with lots of values, it would be useful to be able to just bootstrap a static entity with a list from an Excel file.



This comment was:
- originally posted on idea 'Bootstrap static entity from excel' (created on 03 Nov 2018 by mariap)
- merged to idea 'Static Entity: Import records from Excel ' on 04 Nov 2018 21:11:28 by Vasco Pessanha
03 Nov 2018
Copy link to comment

Instead of just a bootstrap to create a static couldn't this be a merge where the user informs the unique column and things are created, updated or deleted accordingly?

06 Feb 2020
Copy link to comment

Hi all,


This is a great idea. 

Just wanted to share that though it's not possible to do this directly, you can create a db entity and bootstrap data into it and then convert it to a static entity and import it's records as explained here.

Cheers,
Tiago Simões

30 Jun 2020
Copy link to comment