0

Hello I am importing CSV files from Resources folder to load data at runtime. By using ‘Import CSV Resource Data’ JA I am successfully able to import the data. But, if I have 10 CSV files (10 different entities) that should be imported, is there a way to use only one ‘Import CSV Resource Data’  activity to import all the files instead of using like in below picture (calling the activity 10 times)? Because, if I create a new entity and want to load data, I again have to add one more activity calling that entity csv file and commit the code.This is again some manual work which I do not want to do. Is there a way, where, if I add a new entity and add its CSV file. it will automatically be read and update corresponding entity?   Or, Is there a way that I can use a single file (instead of 10 CSV files) to load the data which will be updating corresponding tables automatically? May be I can write custom Java but not sure about it.  My agenda is to automate the whole process.(am ok with point 1 or point 2) Any suggestions would be appreciated. Many thanks in advance!

asked 2020-05-07

2 answers