Upgrade Question From SP2 To SP3

costas

Hi all,

The Item table has a new field and some minor changes in The On Validate of field 24 "Standard Cost". The new field is 99000779 "Trans. Req. Shipment (Qty)". I made a lot of customizations on the Item table so i was wondering if there is a way to just import the new field into my table.

Thanks.

ara3n

You have to export the table as text and merge your changes manually.

matteo_montanari

costas wrote:

Hi all,

The Item table has a new field and some minor changes in The On Validate of field 24 "Standard Cost". The new field is 99000779 "Trans. Req. Shipment (Qty)". I made a lot of customizations on the Item table so i was wondering if there is a way to just import the new field into my table.

Thanks.

Import worksheet:
Look "Merge: Existing<-New" option

Matteo

ara3n

I don't trust it. I've been told to only use it to merge two addons

Alex_Chow

Or just replace the table and merge back in the modifications you've made.

kriki

ara3n wrote:

I don't trust it. I've been told to only use it to merge two addons

It is usefull if both addons have fields in existing tables and your license doesn't have permission to add those fields. Even importing a textfile with fields of both addons is refused by the license.
The only way to create fields from both addons is to MERGE the tables (but I don't know what that does to the code inside the object). After that you can import your textfile with fields of both addons and the correct code in it.

ara3n

Right, in his case he has to move his modification in text file into the sp3 text file that is all he has to do. He doesn't import and merge anything.


The only thing I wish they could change with merging of two addons that you don't have in dev license would be if they could not compile the table. That way you don't have to clean all the code before importing and letting Navision merging them.

David_Singleton

ara3n wrote:

Right, in his case he has to move his modification in text file into the sp3 text file that is all he has to do. He doesn't import and merge anything.


The only thing I wish they could change with merging of two addons that you don't have in dev license would be if they could not compile the table. That way you don't have to clean all the code before importing and letting Navision merging them.

Ahh the newbies, allwasy wishing for things we had 15 years ago. IN earlier versions of Navision, the Table structure, adn the Triggers were stored seperately, so you could first import adn merge the fields, and then you could import the Triggers (code).

Ah the good ole day. or.... whan ay were a we laddie....

costas

How i did it.

1. I exported the modified item table as text.
2. I added the SP3 changes to the text file.
3. I added the custom fields to the SP3 table and removed all the code and local variables that could cause any problem.
4. I exported the modified SP3 table as fob.
5. I Imported the SP3 table into my database.
6. I Imported the text file that i created in step 2.

Thanks all for your help.