I want to import data as per tablename

--oooo--
Tera Contributor

Hello All,

I want to import data tablewise .i have list of record and their target table name is different.as per tablename i want to import data.please guide me on this.

Thank Yiu.

2 REPLIES 2

Community Alums
Not applicable

Hi @--oooo-- ,

 i am assuming that u dont already have transform map for that destination table. if u have then use that



  1. go to system import sets-->load data module
  2. enter table name..chose file(.xls file) make sure 1st row in excel match fields in your destination table.so it will automap.
  3. then click on create transform link
  4. give it a name,select destination table(table in which u want to upload data)
  5. click on auto map matching fields..if required fields do not match then click on mapping assist and match fields.
  6. set colesce true to any one field from related list. it will be your unique field
  7. click transform

 

--oooo--
Tera Contributor

Hello, @Community Alums, I have a list of different ci classes as per the ci class name I want to add data .how can I achieve this functionality? I know how to import data manually .please guide me on how can i import data dynamically as per the table name.

thank you.