Upgrade Record Links

shrekutshrekut Member Posts: 27
I am having trouble finding help with upgrading Record Links from NAV 2015 to NAV 2018? Nay help would be appreciated. The client did not bring over all their old data, like customers and items. I have tried following Gunnar's suggestion found here: https://dynamics.is/?p=1193. I was able to get the data out and decoded the Record ID to give me the table No. and primary field values so that I could tell if the record exists in the 2018 database, but have run into issues with Notes. There must be a better way.

Best Answer

  • shrekutshrekut Member Posts: 27
    Answer ✓
    Thank you. This problem is resolved. The first problem that I encountered was getting the Record ID deconstructed so I could identify the record the link was for in 2015. Gunnar Gestsson, was able to help me with that here (https://dynamics.is/?p=1193). He also was very helpful with the next problem I which was how to get the BLOB field exported in an XMLPort. I used the TempBLOB Table and the Blob Management Codenit. Next, in 2018 I had to work through finding the record and using the ADDLINK function, and then get the BigText, that stored the BLOB data in the XMLPort, converted back into a BLOB. For this I was able to create an OutStream using TEXTENCODING::UTF8 and the using DotNet (System.IO.BinaryWriter.'mscorlib') converted the BigText into the BLOB.

Answers

  • DRBDRB Member Posts: 105
    shrekut wrote: »
    but have run into issues with Notes. There must be a better way.
    What are those issues? Where do you need help?
    -Dhan Raj Bansal
    Linkedin Profile: http://in.linkedin.com/in/dhanrajbansal
  • shrekutshrekut Member Posts: 27
    Answer ✓
    Thank you. This problem is resolved. The first problem that I encountered was getting the Record ID deconstructed so I could identify the record the link was for in 2015. Gunnar Gestsson, was able to help me with that here (https://dynamics.is/?p=1193). He also was very helpful with the next problem I which was how to get the BLOB field exported in an XMLPort. I used the TempBLOB Table and the Blob Management Codenit. Next, in 2018 I had to work through finding the record and using the ADDLINK function, and then get the BigText, that stored the BLOB data in the XMLPort, converted back into a BLOB. For this I was able to create an OutStream using TEXTENCODING::UTF8 and the using DotNet (System.IO.BinaryWriter.'mscorlib') converted the BigText into the BLOB.
Sign In or Register to comment.