dears
i want to use multi csv.
but,i have no idea to import these csvs in datamapper,
it’s possible ? plz help~
Assuming “multi csv” means CSV files whose number of fields may change from one record to the next, then these types of files are not natively supported in the DataMapper.
To be able to use these files, you will first have to run either a Workflow Process or a DataMapper preprocessor to normalize the number of fields on each row (by adding empty fields at the end of each record until all rows have the same number of fields)
thx,but i do not understand.
if i have 3 csv(tables) whit one or two keys.
csv1(table 1):studentName,course,score
csv2(table 2):studentName,cellPhone,address
csv3(table 3):studentName,experties,interest
one csv one table…
so i can not used in same datamapper ?
It`s not possible to load multiple csv files in one datamapper configuration. You have to merge the csv files in the workflow. There you can do it via scripting (e.g. vbscript), but you have to find your own scripting solution.
Another way in the workflow could be to store the data within a data repository. But you must also script it to merge the contents based on a foreign key.
Hope that helps.
Regards,
Thomas