Import and Export Axapta Objects in .xpo format (Data Problem)?

Finance and Operations/AX Technical Forum
1

Hi All,

Hope all of You are Doing well !!

I am Exporting one of my own created table in .xpo format with some data then I delete the table. When I was Importing the Table it was Imported but the Data was not there.

Please Help me if You have some Solution.

Thankx in Advance…

Kuldeep Singh

2

HI

.XPO is only used for applocation object not for data.

3

Hi Reyaz,

Thankx for the Reply, But let’s say I have the .xpo file of Table and anyone Delete my table from Axapta, so in this case I will be able to restore the table but not the data.

Is there anyway to restore the Data as well.

Thankx,

Kuldeep Singh

4

Hi Kuldeep,

By exporting/importing XPO, only table meta data gets exported/imported.

To export/import actual data, you have to use Data export/import functionality in standard Ax (under Admin → Periodic).

Best wishes,

5

Hai Harish,

Thanks For Information.i have a doubt when am exporting the data prom Periodic -->DataExport.Data exporting as (.dat)

is it .dat saved in any where?

Thanks & Regards

6

Hi Naresh,

You should be able to store the physical file in a location of your choice. For more info, press F1 on the form.

Best wishes,

7

When you delete a table - the sql data base will drop the table.

so there wont be any data in sql - again when you restore the table.

8

Hi guys,

i have a doubt , if will delete a layer of a table , IS data is also delete from the last layer. for eg, if i insert a some records in custTable in usr layer nad now i am delete it to var layer so the data will remain same or wat???

9

Hi,

Actual data and development changes (ex - schema changes, classes etc) are 2 different things.

So inserting data in USR layer and then deleting it to VAR layer will not affect data.

But if there were development done in USR layer, then deleting to VAR layer will result in loss of data.