Showing posts with label Export. Show all posts
Showing posts with label Export. Show all posts

Sunday, 29 November 2015

Page Metadata Delta Field / Read BLOB data and Export into a File

User Metadata Table

Stores the personalization of metadata. The content can be viewed by exporting the BLOB. When troubleshooting, you can delete a user’s personalization for a specific page by modifying the data in this table.

Page Metadata Delta Field in User Metadata Table

An XML BLOB that contains the deltas or changes for the personalization. This can be exported and viewed.

In Navision tables we can create BLOB fields to store large amount of data. It is not possible to read the data in the BLOB fields directly.

Below I show an Example how to achieve this, you can adjust the code accordingly for other table fields.

How to get this done, Write below Codeunit:

Define below variables:

UserMetaData-1

Write below function:

UserMetaData-2

You can adjust above code accordingly to read to BLOB fields from other tables and fields.

 

 

Wednesday, 1 July 2015

Import and Export a Word Report Layout

From the Microsoft Dynamics NAV Development Environment, you can import and export built-in Word report layouts of report objects as Word document files (.docx file type). This enables you to modify a built-in Word report layout on a report. For example, you can export a built-in Word report layout to a file on your computer or network. Then, you open the file in Word and modify the report layout. Finally, you import the file back to the report object. The existing built-in Word report layout on the report is overwritten by the content in the imported file.

To export a Word report layout from a report to a file



  1. In the development environment, open the report in Report Dataset Designer as follows.




    1. On the Tools menu, choose Object Designer.

    2. In Object Designer, choose Report, select the report, and then choose the Design button.




  1. On the Tools menu, choose Word Layout, and then choose Export.


Export

  1. Browse to the location where you want to save the exported file, and then choose the Save button.


To import a Word report layout from a file into report



  1. In the development environment, open the report in Report Dataset Designer as follows.




    1. On the Tools menu, choose Object Designer.

    2. In Object Designer, choose Report, select the report, and then choose the Design button.




  1. On the Tools menu, choose Word Layout, and then choose Import.


Import

  1. Locate the file that you want to import, and then choose the Open