CsvServices - Mendix App Store


The easiest and fastest way to get your excel data in and out of Mendix applications. Creates a Rest endpoint for every entity in your application, allowing you to upload and download data in comma separated values format. You will get the following endpoint for all entities: http:///ws-doc// You can upload multiple entities in one automated script using curl to post different csv files. Associations can be included in the csv files. This gives you a fast and reliable way to initialize application databases. You can download all objects in an entity in csv format using GET operation. Again you can automate this in a script using curl command. Some reporting tools also allow reading online csv files, for example R. This enables you to use a 3rd party reporting tool on mendix data without manually downloading the data. For documentation please check github readme: https://github.com/ako/CsvServices/blob/master/readme.md


CsvServices logo4 stars, based on 5 votes
Good one! Nice to have.
I just got this working on my project. A couple of observation to note, from my experience: -- This does NOT create the Entity. -- Attributes need to be defined in the Entity BEFORE the import process It was my assumption that the script would import and create the Entity as well as populate the Attributes. The lack of creating these steps is never stated in the documentation, but merely my assumption. I still like the capability of CsvServices. It will save me a lot of time working with test data locally. Thanks!
A really useful App for rapidly importing CSV data in a memory efficient way. I used it to import several thousand rows from a CSV file I placed locally in my resources directory. You pass in the name of the entity to use and the name of the CSV file. The App will then load the data, creating and committing the entities automatically.
Nice for the HappyFlow where all data is perfect. Nicely done, love the idea of making it a services and thus having the option to use curl. Export seems fast Downsides for import are that it is all in Java, large files (500k lines of 0,2kB each, so 100MB) generates gc overflow, there is only minimal errorlogging in the console and no direct feedback on importerrors. And one error breaks the entire import. So importdata-validation needs to done beforehand and be good.