My mistake deleted customer mater while uploading

Finance and Operations/AX Developer Forum
1

Dear all,

By mistake while uploading few customer record i have deleted all the records, so tried my best to get back the lost record how ever i found that i have a copy of same custtable in test company , so my whole idea was to copy the whole custtable from test company to live enviroment but it is not working tried other steps…

ran this job also :

CustTable Custtable1,custtable2;

changecompany(“TEST”)
{
while select Custtable1
{
changecompany("live_company ")
{
custtable2 = null;
buf2buf(custtable2, Custtable1);

if (!custtable2.validateWrite())
{
throw Exception::Error;
}

custtable2.insert();
ttscommit;
}
}
}

it says

:Field ‘Customer account’ must be filled in.

Field ‘Customer group’ must be filled in.

Field ‘Currency’ must be filled in.

Field ‘Language’ must be filled in.

Field ‘Address book type’ must be filled in. all these are warining and nothing is getting uploaded

2

using AX 2009

3

The only reasonable solution is restoring the database from backup, because delete actions removed data from many other tables. The full recovery model (which is the only one you should be using) supports the point-in-time recovery, so you can restore the database to the point just before you ran the import and you won’t lose any older data.

4

Yeah i dropped the idea of transferring the data through coding now trying to export the custtable from test and then import it to live company by importing will check it works or not…