axStart: Import 3.0 company data into 4.0

[Blog bot]

Источник: http://axstart.spaces.live.com/Blog/...C0A0!253.entry
==============


Sometimes the migration does not always works out. In that case we have to copy the data from 3.0 to 4.0 by hand.
As you know you can’t normally import 3.0 data into 4.0. If we compare the def files of 3.0 and 4.0 exports, we see some small differences. The changes are printed red in below example. After these changes you can import the 3.0

Changes to make:
· Change ver from 3.0.1 to 4.01
· Remove company from TableFef line
· Add line PTRECORDIDMIN with table id and value from RECORDIDMIN
· Add line PTRECORDIDMAX with table id and value from RECORDIDMAX

Of course this is not supported by MS and you get some errors while importing, but the data is there J

"EXPFORMAT VER. 3.0.1","Comma"
"TABLEDEF",50019,"Pro_TimeSheet","pro"
"RECORDDEF",50019,27,"ProjId",50001,"ActivityId",50002,"CategoryId",50003,"EmplId",50004,"LinePropertyId",50005,"TaxItemGroupId",50006,"TaxGroupId",50007,"CurrencyId",50008,"SalesPrice",50009,"costPrice",50010,"Txt",50011,"Dimension",50012,"Dimension",50012,"Dimension",50012,"FromTime",50013,"ToTime",50014,"HoursDay1",50015,"HoursDay2",50016,"HoursDay3",50017,"HoursDay4",50018,"HoursDay5",50019,"HoursDay6",50020,"HoursDay7",50021,"PeriodStartDate",50022,"PostedJournalId",50023,"PostedDate",50024,"Posted",50025
"RECORDCOUNT",50019,2663
"RECORDIDMIN",8738
"RECORDIDMAX",141814
"CREATEDTRANSIDMIN",0
"CREATEDTRANSIDMAX",0
"MODIFIEDTRANSIDMIN",0
"MODIFIEDTRANSIDMAX",0
"RECORDCOMPANY","pro"
"EXPFORMAT VER. 4.01","Comma"
"TABLEDEF",50019,"Pro_TimeSheet"
"RECORDDEF",50019,28,"ProjId",50001,"ActivityId",50002,"CategoryId",50003,"EmplId",50004,"LinePropertyId",50005,"TaxItemGroupId",50006,"TaxGroupId",50007,"CurrencyId",50008,"SalesPrice",50009,"costPrice",50010,"Txt",50011,"Dimension",50012,"Dimension",50012,"Dimension",50012,"FromTime",50013,"ToTime",50014,"HoursDay1",50015,"HoursDay2",50016,"HoursDay3",50017,"HoursDay4",50018,"HoursDay5",50019,"HoursDay6",50020,"HoursDay7",50021,"PeriodStartDate",50022,"PostedJournalId",50023,"PostedDate",50024,"Posted",50025,"recVersion",61450
"PTRECORDIDMIN",50019,8738
"PTRECORDIDMAX",50019,141814
"RECORDCOUNT",50019,2663
"RECORDIDMIN",8738
"RECORDIDMAX",141814
"CREATEDTRANSIDMIN",0
"CREATEDTRANSIDMAX",0
"MODIFIEDTRANSIDMIN",0
"MODIFIEDTRANSIDMAX",0
"RECORDCOMPANY","pro"

Источник: http://axstart.spaces.live.com/Blog/...C0A0!253.entry