Sunday, February 17, 2019

eConnect Performance: Using GetNextDocNumbers vs taGetNext stored procedures

New blog post at blog.steveendow.com:


eConnect Performance: Using GetNextDocNumbers vs taGetNext stored procedures

https://blog.steveendow.com/2018/11/econnect-performance-using.html


This image shows 3 instances of my load test application simultaneously retrieving a total of 3,000 JE numbers over about 45 seconds.

3,000 JE Numbers


Dynamics GP Document Attach Record Type (Origin Description) Codes

New post at blog.steveendow.com:


Dynamics GP Document Attach Record Type (Origin Description) Codes

https://blog.steveendow.com/2019/01/dynamics-gp-document-attach-record-type.html

Dynamics GP Document Attachments Listed in the CO00101 Table


Bulk Export Dynamics GP Document Attachments using .NET

New post at blog.steveendow.com:

Bulk Export Dynamics GP Document Attachments using .NET

https://blog.steveendow.com/2018/12/bulk-export-dynamics-gp-document.html


I created a .NET solution to allow a user to select a Database, Record Type, and indicate whether Deleted attachments should be exported.

Export Dynamics GP Document Attachments

Once those options are selected, the user can retrieve a list of all of the attachments, which shows the type, the associated record number, the file name, and file size.

The user can then select an export path and click a button to export all of the attachments to disk.