Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Export Notes From NAV 2015 and Import To Business Central Online?
azharsaeedkhan
Member Posts: 34
I am trying to export all the customer Notes from NAV 2015 to BC Online. I have developed an XMLPort to export the notes from "Record Link" table. For the Field "Note" of type BLOB i am reading the data into BigText using streams.
The Export part is successfull and i have a file containing all the customer Notes.
But now to import it back to Business Central, i need to write the data bit by bit into "Note" field of Table "Record Link".
I am unable to do so.
Do you have any idea how to do that? Can we directly use data migration tool to migrate data from system tables? or is there any other way to do so?
The Export part is successfull and i have a file containing all the customer Notes.
But now to import it back to Business Central, i need to write the data bit by bit into "Note" field of Table "Record Link".
I am unable to do so.
Do you have any idea how to do that? Can we directly use data migration tool to migrate data from system tables? or is there any other way to do so?
0
Answers
You can use TempBlob Table to import/export BLOB to text (WriteAsText and ReadAsText functions)
After inport Data to TempBlob you can copy it to Record Link table
If you write to "Note" field of "Record Link" table directly like you suggested above, it doen't show the notes but will show something like this
You need to write it through Binary Writer Bit by Bit, otherwise it will not properly show the notes and in cloud version we cann't use DotNet variables.
In on-prem version we have a function "WriteRecordLinkNote" to write notes in "Type Helper" codeunit.