SnapShot for Microsoft Dynamics GP

re: SnapShot for Microsoft Dynamics GP

jivtesh — Mon, 28 Jul 2008 14:07:17 GMT

Hey David, Its great to read your posts with these stories :) Are the rapid application tools for migrating data from Quickbooks built on top of the Snapshot tool ?

Jivtesh

re: SnapShot for Microsoft Dynamics GP

David Musgrave — Mon, 28 Jul 2008 15:32:50 GMT

No, SnapShot was not adopted by the development team, even though the technique that I developed to allow any table in any dictionary to be opened twice in two locations with potentially different database types has been used by the later versions of the GP database migration tool.

David

re: SnapShot for Microsoft Dynamics GP

PM2885 — Tue, 29 Jul 2008 01:46:32 GMT

The ability to backup, move and restore data makes SnapShot a valuable tool. I find the part that I use most often is SnapShot’s ability to export table and field data to an Excel spreadsheet (via a TAB delimited file). This functions as a replacement to 'Resource Descriptions' table and field listings. SnapShot is several magnitudes easier, and actually produces useful reports.

You have the ability to choose your tables you require across multiple dictionaries and modules. You may export just the tables or include the fields.

Great for Report Writer, SmartList, SmartList Builder, Dexterity, etc.

Paul

re: SnapShot for Microsoft Dynamics GP

David Musgrave — Mon, 04 Aug 2008 19:54:09 GMT

Posting from VSToolsForum.com

http://vstoolsforum.com/forums/p/524/1208.aspx#1208

re: SnapShot for Microsoft Dynamics GP

David Musgrave — Mon, 04 Aug 2008 19:56:39 GMT

Posting from About Dynamics, Development and Life (Jivtesh Singh's Blog)

http://www.jivtesh.com/2008/07/snapshot-tool-from-david-musgrave.html

Finding Table and Field Information in Microsoft Dynamics GP

Developing for Dynamics GP — Fri, 10 Oct 2008 12:00:15 GMT

This is an updated version of an article I wrote a while back for the Microsoft Dynamics GP community

re: SnapShot for Microsoft Dynamics GP

David Musgrave — Tue, 28 Oct 2008 03:28:41 GMT

Posting from the Dynamics GP Blogster

http://dynamicsgpblogster.blogspot.com/2008/10/often-overlooked-yet-powerful-table.html

Finding Table and Field Information in Microsoft Dynamics GP

Developing for Dynamics GP — Tue, 28 Oct 2008 17:18:31 GMT

This is an updated version of an article I wrote a while back for the Microsoft Dynamics GP community

How to transfer Security Tasks and Roles between Systems

Developing for Dynamics GP — Mon, 10 Nov 2008 18:07:36 GMT

From the Microsoft Dynamics GP Application Level Security Series . With the change from the optimistic

re: SnapShot for Microsoft Dynamics GP

Teguh — Tue, 03 Mar 2009 07:42:41 GMT

Hey David, I want ask about use this tools in GP 10 SP 3, because i got error must upgrade version when deploy in GP 10 SP 3.

Teguh

re: SnapShot for Microsoft Dynamics GP

ABower — Tue, 26 May 2009 15:23:18 GMT

Hi David,

Was looking at this handy tool, and reading through the docs, there is reference to using a conversion table for handling acct framework differences. I can't seem to find where/how you actually set that up however. Am I missing something, or is that function not in the app at the present time ?

Thanks,

ABower

re: SnapShot for Microsoft Dynamics GP

David Musgrave — Tue, 02 Jun 2009 11:19:34 GMT

Posting from the Dynamics GP Blogster

http://dynamicsgpblogster.blogspot.com/2009/05/moving-data-between-microsoft-dynamics.html

re: SnapShot for Microsoft Dynamics GP

HFLo — Mon, 13 Jul 2009 06:29:50 GMT

Hi, David:

I'm not if I'm using the latest version of SnapShot.

I notice that when copying Company Addresses, the CMPANYID in SY00600 does not 'update' accordindly. It still retains the originating company ID value.

re: SnapShot for Microsoft Dynamics GP

Patrick Roth [MSFT] — Mon, 13 Jul 2009 06:41:13 GMT

HFLo,

I would suspect that it would. In a tool such as this, data is copied in and out of a table of the same structure without regard to what the columns are. To that end, it would seem unlikely that the app would know that if it finds a "company id" value to switch it to a different value.

Meaning that you'd likely have to update the value yourself once the data is in the table or else just use sql to copy it and adjust the query as you require.

re: SnapShot for Microsoft Dynamics GP

David Musgrave — Mon, 13 Jul 2009 13:52:45 GMT

Hi Lo

Patrick is correct. Snapshot does not alter any data, it just copies it (via Ctree tables).

The latest version is the one attached to this post.

David