How to import one table data to another table

[Elin25]

How to import core_company table data which is in global application into customer_account data which is in customer service application 

[Gunjan Kiratkar · Accepted solution]

hi @Elin25 ,

I have two ways :-

1) Goto core_company table and from list view change the class of company as 'Account' and Customer as 'true'.

Record will automatically create in account table.

2) Export Data from core company table in excel formate and then import the data into customer_account table using transform map.

[Gunjan Kiratkar]

Hi @Elin25 ,

You can goto the fixed script from application navigator and then writedown script as below :-

Then click on run script- Before that apply your own encoded query for which you wanted to update the data. Copy query from list view filter. First try to update only 2-3 records for testing.

var gr=new GlideRecord('core_company'); 
gr.addEncodedQuery("city=Shanghai"); //Apply query as per your requirement
gr.query(); 
while(gr.next()){ 
gr.sys_class_name='customer_account'; 
gr.customer='true'; 
gr.update(); 
}

[Elin25]

Thank you so much appreciated

We have so many records if possible can we update records in batch wise if yes how can we do using script and it shouldn't create duplicate please suggest

Thank you 

[Elin25]

Hello gunjan 

I tried above changing class name but records(data) is not showing for different module  

I mean record is not showing in core_company table and it is visible for customer_account table