Dynamics 365 Business Central Blog Series: Import and Export data

Dynamics 365 Business Central

Articles in this series:

  1. How to Export and Import Data (Using Configuration Packages)
  2. How to Export and Import Data (Using XMLports)
  3. How to use Excel Buffer to Export data
  4. How to use Excel Buffer to Import data
  5. How to export data to Excel in analysis mode
  6. Import Multiple Customer Pictures (Customization)
  7. How to import/create item picture from encoded text (Base64 String)
  8. Importing picture/image from URL
  9. How to import data from CSV (comma-separated values) file
  10. How to export data from tables to CSV (comma-separated values) file
  11. How to save the report as a PDF, Excel, Word, HTML, or XML file (Report.RunRequestPage Method and Report.SaveAs Method)
  12. FileManagement.BLOBExport only save last file? -> Adding multiple files into a zip file
  13. Using TextBuilder Data Type to export data to a text file
  14. How to import files from a zip file (Bulk import attachments and Excel files)
  15. How to export all item pictures – Customization
  16. How to directly export Report from page (Custom Filename For Report Export)
  17. Bulk export/download reports with different layouts to a zip file (Download Posted Sales Invoices/Posted Purchase Invoices to a zip file)
  18. How to bulk export/download attachments (Downloading multiple attachments via zip file) – Customization
  19. How to import Links and Notes (System Parts) – Customization
  20. How to export Links and Notes (System Parts) – Customization
  21. How to export all Media Contents (bmp, jpg,mp4…) from table 2000000184 “Tenant Media”
  22. How to import Dimension Combinations
  23. How to export all fields in all tables
  24. How to export all TableRelation information (For example, find all tables and fields related to Customer Table)
  25. How to export all pages with SourceTable number (list of pages with corresponding tables)
  26. How to export all keys in all tables
  27. How to export all page field caption in Dynamics 365 Business Central (table 2000000202 “All Control Fields”) – Comparing Table Field Caption and Page Field Caption
  28. How to export all actions in all pages in Dynamics 365 Business Central (table 2000000143 “Page Action”)
  29. How to export all fields/controls in all pages in Dynamics 365 Business Central (Page Control Field)
  30. How to easily export all AL file names and Object Details (Type, ID, Name)
  31. How to export Work Description (Blob) in Sales Documents to excel
  32. Export, import multiline text with Configuration Packages (Use BLOB type fields in Configuration Packages)
  33. Use drag and drop on file upload dialog to attach multiple files (New Documents Factbox)
  34. How to import data from a csv file to Business Central with Power Automate (No customization) – csv to JSON
  35. How to export data from Business Central to a csv file with Power Automate (No customization) – JSON to csv
  36. How to import data to Business Central by uploading a file with Power Automate (No customization)
  37. Create a flow in Power Automate to update multiple customer pictures in Business Central from OneDrive
  38. How to export data from Business Central to Google Sheets/Google Drive with Power Automate (No customization)
  39. How to import/read files from OneDrive to Business Central via AL (Graph API)
  40. How to upload files from Business Central to OneDrive via AL (Graph API)
  41. How to save reports directly to OneDrive via AL (Graph API) – Manual and Automatic
  42. How to import/read files from SharePoint (document library) to Business Central via AL (Graph API)
  43. How to upload files from Business Central to SharePoint (document library) via AL (Graph API)
  44. How to save reports directly to SharePoint via AL (Graph API) – Manual and Automatic
  45. Manage attachments in SharePoint (Save attachments externally and do not use BC capacity)
  46. How to Export Database and Restore it on Local SQL Server
  47. How to list all permissions (all users with permission sets or all permission sets with permissions…)

How to Export and Import Data (Using Configuration Packages)

How to Export and Import Data (Using Configuration Packages)

How to Export and Import Data (Using XMLports)

How to Export and Import Data (Using XMLports)

How to use Excel Buffer to Export data

How to use Excel Buffer to Export data

How to use Excel Buffer to Import data

How to use Excel Buffer to Import data

How to export data to Excel in analysis mode

How to export data to Excel in analysis mode

Import Multiple Customer Pictures (Customization)

Import Multiple Customer Pictures (Customization)

How to import/create item picture from encoded text (Base64 String)

How to import/create item picture from encoded text (Base64 String)

Importing picture/image from URL

Importing picture/image from URL

How to import data from CSV (comma-separated values) file

How to import data from CSV (comma-separated values) file

How to export data from tables to CSV (comma-separated values) file

How to export data from tables to CSV (comma-separated values) file

How to save the report as a PDF, Excel, Word, HTML, or XML file (Report.RunRequestPage Method and Report.SaveAs Method)

How to save the report as a PDF, Excel, Word, HTML, or XML file (Report.RunRequestPage Method and Report.SaveAs Method)

FileManagement.BLOBExport only save last file? -> Adding multiple files into a zip file

FileManagement.BLOBExport only save last file? -> Adding multiple files into a zip file

Using TextBuilder Data Type to export data to a text file

Using TextBuilder Data Type to export data to a text file

How to import files from a zip file (Bulk import attachments and Excel files)

How to import files from a zip file (Bulk import attachments and Excel files)

How to export all item pictures – Customization

How to export all item pictures – Customization

How to directly export Report from page (Custom Filename For Report Export)

How to directly export Report from page (Custom Filename For Report Export)

Bulk export/download reports with different layouts to a zip file (Download Posted Sales Invoices/Posted Purchase Invoices to a zip file)

Bulk export/download reports with different layouts to a zip file (Download Posted Sales Invoices/Posted Purchase Invoices to a zip file)

How to bulk export/download attachments (Downloading multiple attachments via zip file) – Customization

How to bulk export/download attachments (Downloading multiple attachments via zip file) – Customization

How to import Links and Notes (System Parts) – Customization

How to import Links and Notes (System Parts) – Customization

How to export Links and Notes (System Parts) – Customization

How to export Links and Notes (System Parts) – Customization

How to export all Media Contents (bmp, jpg,mp4…) from table 2000000184 “Tenant Media”

How to export all Media Contents (bmp, jpg,mp4…) from table 2000000184 “Tenant Media”

How to import Dimension Combinations

How to import Dimension Combinations

How to export all fields in all tables

How to export all fields in all tables

How to export all TableRelation information (For example, find all tables and fields related to Customer Table)

How to export all TableRelation information (For example, find all tables and fields related to Customer Table)

How to export all pages with SourceTable number (list of pages with corresponding tables)

How to export all pages with SourceTable number (list of pages with corresponding tables)

How to export all keys in all tables

How to export all keys in all tables

How to export all page field caption in Dynamics 365 Business Central (table 2000000202 “All Control Fields”) – Comparing Table Field Caption and Page Field Caption

How to export all page field caption in Dynamics 365 Business Central (table 2000000202 “All Control Fields”) – Comparing Table Field Caption and Page Field Caption

How to export all actions in all pages in Dynamics 365 Business Central (table 2000000143 “Page Action”)

How to export all actions in all pages in Dynamics 365 Business Central (table 2000000143 “Page Action”)

How to export all fields/controls in all pages in Dynamics 365 Business Central (Page Control Field)

How to export all fields/controls in all pages in Dynamics 365 Business Central (Page Control Field)

How to easily export all AL file names and Object Details (Type, ID, Name)

How to easily export all AL file names and Object Details (Type, ID, Name)

How to export Work Description (Blob) in Sales Documents to excel

How to export Work Description (Blob) in Sales Documents to excel

Export, import multiline text with Configuration Packages (Use BLOB type fields in Configuration Packages)

Export, import multiline text with Configuration Packages (Use BLOB type fields in Configuration Packages)

Use drag and drop on file upload dialog to attach multiple files (New Documents Factbox)

Use drag and drop on file upload dialog to attach multiple files (New Documents Factbox)

How to import data from a csv file to Business Central with Power Automate (No customization) – csv to JSON

How to import data from a csv file to Business Central with Power Automate (No customization) – csv to JSON

How to export data from Business Central to a csv file with Power Automate (No customization) – JSON to csv

How to export data from Business Central to a csv file with Power Automate (No customization) – JSON to csv

How to import data to Business Central by uploading a file with Power Automate (No customization)

How to import data to Business Central by uploading a file with Power Automate (No customization)

Create a flow in Power Automate to update multiple customer pictures in Business Central from OneDrive

Create a flow in Power Automate to update multiple customer pictures in Business Central from OneDrive

How to export data from Business Central to Google Sheets/Google Drive with Power Automate (No customization)

How to export data from Business Central to Google Sheets/Google Drive with Power Automate (No customization)

How to import/read files from OneDrive to Business Central via AL (Graph API)

How to import/read files from OneDrive to Business Central via AL (Graph API)

How to upload files from Business Central to OneDrive via AL (Graph API)

How to upload files from Business Central to OneDrive via AL (Graph API)

How to save reports directly to OneDrive via AL (Graph API) – Manual and Automatic

How to save reports directly to OneDrive via AL (Graph API) – Manual and Automatic

How to import/read files from SharePoint (document library) to Business Central via AL (Graph API)

How to import/read files from SharePoint (document library) to Business Central via AL (Graph API)

How to upload files from Business Central to SharePoint (document library) via AL (Graph API)

How to upload files from Business Central to SharePoint (document library) via AL (Graph API)

How to save reports directly to SharePoint via AL (Graph API) – Manual and Automatic

How to save reports directly to SharePoint via AL (Graph API) – Manual and Automatic

Manage attachments in SharePoint (Save attachments externally and do not use BC capacity)

Manage attachments in SharePoint (Save attachments externally and do not use BC capacity)

How to Export Database and Restore it on Local SQL Server

How to Export Database and Restore it on Local SQL Server

How to list all permissions (all users with permission sets or all permission sets with permissions…)

How to list all permissions (all users with permission sets or all permission sets with permissions…)

コメント

Copied title and URL