export data from prod instance and importing in dev instance ,how?

[manmathpanda]

Hi Developers,

AS my production data is already in sync , so i want to export all data/records of one table and import into development instance. But while importing data in development instance , it is showing as below.

so what will be the best practice to export and import , whether it will be export to xml,excel .

PLease suggest me what to do?

Regards,

Manmath

[Michael Fry1]

Best practice would be to use XML. That way the sysIDs remain the same between instances.

[manmathpanda]

Hi Michael,

But htere is no xml option while importing as below , instead it is asking for excel template, please look below image and let me know what should i do

[Michael Fry1]

Don't use Easy Import, but instead go to a List View, then right-click on header and scroll to the bottom and find Import XML.

[Nithish1]

Hello Manmath,

The best practice would be exporting to XML and import XML.

Regards,

Nithish