How do we Import files csv,json data into database in jmix

Hi Jmix Team,
I am having different project,And now i would like to integrate into Jmix.For that i would have the data base records as csv files or json.Do we have any import options for csv,json import into our specific entity or data grid.If any one know about this ,please reply asap.

Greetings,

The best way to import the data is to use third-party libraries to your database. Only manually, Jmix doesn’t provide such tools to import csv or other, but i almost sure that a lot of tools that provides that functionality. So best steps is:

  1. Create postgres database (or other)
  2. Find tool to import your data into RDBMS (postgres e.g.) - i found this thread
  3. As your data been fill, you can do reverse engineering from RDBMS into JPA Meta Model (Auto-generate all data from database into Jmix Entities)
  4. Be happy :slightly_smiling_face:

Best regards,
Dmitry

Thanks Dmitry,

Thank you for your suggestion! I am familiar with the approach you mentioned. However, I’m currently following a different method based on the guide from this link: Jmix Data Import. It offers a more direct solution for handling data imports within Jmix itself, which aligns well with the requirements of my project.

Best regards,
Md Danish

Be careful with this solution for your way because before import you need to configure whole data model before import, i think this is harder way,

Good luck!