#GPPT Using the Clipboard to copy from Excel into Microsoft Dynamics GP

Today, we are covering an exciting new sample customization that is now possible due to Clipboard and Parsing Data Helper Functions added to recently released Build 29 of GP Power Tools.

The customization shows how any data in a Microsoft Excel spreadsheet can be copied via the Clipboard into any window of Microsoft Dynamics GP.

The specific examples in this project will add lines to an existing transaction in the Item Transaction Entry window or create new transactions in the same window. The project contains two triggers, one for copying lines and one for copying entire transactions.

The triggers add menu items to the window using the Additional menu. The trigger scripts copy the contents of the clipboard to a text field which can then be parsed as a tab delimited data set. The first row is parsed to check that the column headers match the expected data set.

Then each subsequent row is parsed and the data entered into the window as though it is being typed by the user using the Dexterity map command.

The trigger for entering entire transactions uses a sequence number to define when a new transaction starts. It can also automatically create the Batch record if it does not exist.

This is just an example and the same techniques can be applied to copy data from Excel into any window in Microsoft Dynamics GP. Note it does required Build 29 of GP Power Tools.

Note: The archive file contains the exported project and a sample Excel spreadsheet that was used to test with the Fabrikam sample company. This sample project does not support Serial Numbers, Lot Numbers or use of Bins, but that functionality could be added fairly easily.

Downloading and Installing

Using Build 29 or later, download the example code, import using the Project Setup window:

• GP Power Tools Settings Clipboard Trx.dbg.zip

The code will be active on next login or after switching companies, or you can use start the triggers manually from the Project Setup window.

More Information

For more information see:

• GP Power Tools Portal: http://winthropdc.com/GPPT
• GP Power Tools Samples: http://winthropdc.com/GPPT/Samples
• GP Power Tools Videos: http://winthropdc.com/GPPT/Videos

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.