web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Error While importing the Record Links using XMLPort in BC17 Online (SaaS)

(0) ShareShare
ReportReport
Posted on by 55

Hi,

Recently we have upgraded one of our clients from NAV2015 to BC17 Online. They are having Record Links and which not migrated to Online, we have reached Microsoft support and got the reply as standard migration doesn't support migrating the system tables.

We have exported the Record links from NAV 2015 (Note field which is blob converted Base64) and trying to import the same in the BC17 sandbox and getting the error as "The Type RecordID is not Supported".

I have exported the record links from Sandbox through xmlport and updated the now linkid and Record id and tried to import the same, then also got the same error.

is it possible to import the Record Links from NAV 2015 to BC 17 Online?

give me a direction if any one worked on this.

I have the same question (0)
  • Andy Sather Profile Picture
    on at

    I am not seeing anything internally where this was attempted.  I tried to find a table called Record Link, but I am not seeing an ID that has that description. Is there a specific table ID you are looking at?

  • Suggested answer
    JAngle Profile Picture
    137 on at

    Directly with a codeunit is not the approach to take. Success has been achieved by using a custom table to import the detail. Once done a codeunit is then used to iterate through the table records and use a add link function. Something like this:

    Trigger OnRun()

    Var

    CustomNotes: Record CustomNotes;

    Contact: Record Contact;

       begin

           GetLastEntryNo();

           if NotesImport.FindSet() then

               repeat

               if Contact.Get(NotesImport."Contact No.") then begin

                   CreateSystemLink(Contact.RecordId, NotesImport.Note);

                   NotesImport.Delete();

               end;

           until NotesImport.Next() = 0;

       end;

       procedure CreateSystemLink(IncomingRecordID: RecordId; NoteText: Text)

       var

           RecordLink: Record "Record Link";

           LinkManagement: Codeunit "Record Link Management";

       begin

           LastEntryNo += 1;

           RecordLink.Init();

           RecordLink.Company := CompanyName();

           RecordLink.Type := RecordLink.Type::Note;

           RecordLink.Created := CurrentDateTime;

           RecordLink."User ID" := UserId();

           RecordLink."Link ID" := LastEntryNo;

           RecordLink."Record ID" := IncomingRecordID;

           LinkManagement.WriteNote(RecordLink, NoteText);

           RecordLink.Insert(true);

       end;

       procedure GetLastEntryNo()

       var

           RecordLink: Record "Record Link";

       begin

           if RecordLink.FindLast() then

               LastEntryNo := RecordLink."Link ID"

           else

               LastEntryNo := 0;

       end;

       var

           LastEntryNo: Integer;

    }

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,638

#2
YUN ZHU Profile Picture

YUN ZHU 837 Super User 2025 Season 2

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 704 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans