Introduction

Recently Steve Endow posted a question on X (formerly Twitter) about the possibility of importing data into system tables using Configuration Packages. This is a common limitation faced by many users of Microsoft Dynamics 365 Business Central, as system tables are considered sensitive and are not accessible by default.

Steve Endow's post

The Solution: A Custom Application

To address this issue, I developed a custom application (PTE) called UnrestrictedConfigPackage that extends the capabilities of Configuration Packages, allowing for controlled access to system tables.

How It Works

The app introduces a new setup in the ‘User Setup’ table that administrators can toggle to enable or disable system table access. This ensures that the functionality is controlled and can be limited to users who understand the implications of interacting with system data.

Key features:

  • Controlled Access: Only users with proper setup can access system tables
  • Configuration Package Integration: Seamlessly works with existing Configuration Package functionality
  • Safety First: Administrators control who can access sensitive system data
  • Easy Toggle: Simple on/off switch in User Setup

Get the Tool

Visit my GitHub repository to access the source code, make it your own, use it and abuse it… on your own risk 😁

Or contact me directly for help.

GitHub Repository: UnrestrictedConfigPackage

Bonus Content

The marketing text is stored in the table Entity Text in the field Text which is a Blob field. The rich text is stored in HTML format encoded in Base64.

Have questions or suggestions? Feel free to reach out via LinkedIn or Twitter.