How to upload data into tables manually in Mendix 10.0.0?

0
Hello there!    We are currently doing a project in class, and we are absolutely green and very new to Mendix (only done RAD module) and app building as a whole. We were told by the Professor to find a way to upload data into tables manually and to skip out building forms to upload data through that. We are using Mendix Studio 10.0.0 and we cannot find anything on this with step by step instructions. We have a couple of different pages, and the domain model has over 7 entities. We are only building a few parts of the app development instead of building the whole app itself. I was looking through Mendix help documentation too but couldn't see anything on this.    We are looking for a relatively easy solution to do this. I don't think we need more than 10 records for each entity. Would someone with experience know how we can do this in a relatively easy manner? Your help in the matter would be greatly appreciated.   Thanks!
asked
2 answers
1

Hello Tanu Notra,

 

Things you could try and where there also are some learning paths for are the following:

 

- Use an excel upload to fill the data with the excel importer

https://academy.mendix.com/link/paths/44/Importing-and-Exporting-Your-Data

- Use an RESTful Interface and fill it with sending files to the API with for example Postman

https://academy.mendix.com/link/paths/133/Design-and-Publish-a-REST-API

- Use a connector to the database that allows you to use oql/sql to insert data into the database

https://marketplace.mendix.com/link/component/66876

- Do a csv upload and create an import to process the csv

https://marketplace.mendix.com/link/component/108605

 

Hope this helps, 

Good luck

 

 

answered
0

Hi Tanu,

 

Building pages is easy with Mendix. Right-click on the Entity ( Tables) and Select Generate Overview Pages. Mendix will create the CRUD Operation Pages for you. Map the Overview pages to the Navigation Menu and add your data to the application.

 

To Answer your question - 

Use the Excel Importer module to import the data. 

Follow this link for Easy Understanding: 

Excel Importer

Note : Download the dependency modules for your project from Studio Pro IDE.

 

But still, you will have to create Overview pages to see the data for your tables. 

 

Since you are new to Mendix:  Have a look at this Learning path

 

Rapid Developer : https://academy.mendix.com/link/paths/31/Become-a-Rapid-Developer

 

- Use an excel upload to fill the data with the excel importer

https://academy.mendix.com/link/paths/44/Importing-and-Exporting-Your-Data

 

I hope it helps !!

answered