DataSpy™ - AIM Technologies
Contents
1.2. Cose Text Output Clear results Table Display Name A Microsoft Dynamics GP A Project Accounting Display Name Type Time Series a y Physical Name Technical Name Dex Row ID Table Info Record Info Find Tables Options No information available b Several options are available to be selected including the following The table names displayed can be either the Table Display Name Table Technical Name or Table Physical Name For each table listed in the display window you can select to view either the Table Info or specific Record Info by clicking the appropriate button You can select whether to include the Dex Row ID field in the output data from the Options button DataSpy 2006 AIM Technologies All Rights Reserved 3 Process Transactions to be Monitored a You can now begin monitoring any processes within the Dynamics GP system that have been included in the products and series selected in section 4 above As an example after entering and saving a Purchase Order the following data might be displayed providing the names of all tables that had records added updated or deleted and additional detailed information for the record s processed Text Output Clear results Display Name Tse Time Series Physical Name Technical Name E Project Accounting Purchasing Setup Table Update 12
3. 54 20 AM 4 26 2006 PA Key Master Add 12 54 24 AM 4 26 2006 Purchase Order Line Add 12 56 39 4M 4 26 2006 Purchasing PA Customer MSTA Update 12 56 40 AM 4 26 2006 Project PA Contract Master File Update 12 56 40 AM 4 26 2006 Project PA Project Master File Update 12 56 40 4M 4 26 2006 Project PA Budget Master File Update 12 56 40 4M 4 26 2006 Project E Add 12 56 40 4M 4 26 2006 Project PA Contract Periodic Totals MS Update 12 56 44 AM 4 26 2006 Project PA Project Periodic Totals MST Update 12 56 444M 4 26 2006 Project Table Info Record Info Find Tables Options Field Name Physical Name Value 001 PA Purchase Order No _PApurordnum P02077 002 Ord ORD 16384 003 Break Field 1 BRKFLD1 jo _ 004 Item Number ITEMNMBR OFFICE SUPPL 005 Vendor Item Number VNDITNUM OFFICE SUPPL 006 DateValue _DATEVAL Apr 12 2007 12 7 007 Freight Amount FRTAMNT 0 00000 i 008 Item Tax Schedule ID ITMTSHID COMPANYPUR 009 Misc Charges Amount _MSCCHAMT 0 00000 010 Originating Freight Amount _ORFRTAMT 0 00000 b After completing the desired process you can export the results to a text file by selecting the Text Output button c The Clear Results button will remove all of the output from the DataSpy window making it ready to monitor a new transaction or process PaRI 2006 AIM Technologies All Rights Reserved
4. 9 0 InstallShield Wizard window opens gt Click Next gt Review the Software License Agreement and confirm or deny your acceptance of the terms described within If desired you can click the Print button to print a copy of the Software License Agreement for your records If you agree select I accept the terms of the license agreement and click Next to continue If you disagree select I do not accept the terms of the license agreement and click Cancel to exit the installation wizard Specify the folder where the Microsoft Dynamics GP SBF application is installed This folder is typically located on your local hard drive Important The installation routine will default the installation to a directory on the workstation If this is not the location where Microsoft Dynamics GP SBF is installed on your machine you will need to specify the correct directory Verify that it is the correct directory or use the Change button to select the location of the desired version of Microsoft Dynamics GP SBF gt After confirming the installation path click Next gt The Ready to Install window opens gt Click Install to copy all files to the appropriate directories The InstallShield Wizard Completed window opens when installation is done gt Click Finish eee 2006 AIM Technologies All Rights Reserved 2 Include the new code After the DataSpy files have been copied to your system Microsoft Dynamics
5. AIM Technologies DataSpy For Microsoft Dynamics Microsoft Dynamics GP Professional Microsoft Dynamics GP Standard Microsoft Small Business Financials Installation Setup and User Manual Version 9 0 pen 2006 AIM Technologies All Rights Reserved Product Overview Technical Support Installation 1 Install DataSpy Code 2 Include the new code 1 Login as System Administrator 2 Run Grant sql 3 Add Shortcuts for DataSpy Windows 3 Enter Registration Keys Begin Using DataSpy 1 Create or Modify DataSpy Setup Information 2 Open DataSpy 3 Process Transactions to be Monitored Trademarks Microsoft Dynamics GP Professional Microsoft Dynamics GP Standard and Small Business Financials are trademarks of Microsoft Business Solutions Other company or product names mentioned may be trademarks or registered trademarks of their respective holders i 2006 AIM Technologies All Rights Reserved Product Overview DataSpy is a powerful tool that can help eliminate the difficulty and frustration of tracking data through the system saving you valuable time and reducing expenses associated with development of reports and customizations within Microsoft Dynamics GP and third party modules Through a single window users can view all of the database information necessary to develop reports and customizations DataSpy gives you all of the pertinent information on the data flowing through the system sh
6. GP or SBF must then include the code For Small Business Financials After launching SBF the code will be included automatically For Microsoft Dynamics GP After launching Microsoft Dynamics GP you will see a prompt asking if you want to include new code similar to the following illustration iD exterity Runtime i Click Yes and allow the code to be included A progress bar will display while the unchunking process is executing This installation step performs the following tasks gt The DYNAMICS SET file is modified to include the information required to run DataSpy gt A dictionary named DATASPY DIC is created in your Microsoft Dynamics GP SBF application folder Perform steps 1 and 2 from above for every workstation on which you desire to run DataSpy Installation of DataSpy is now complete and you are ready to begin the Setup process DataSpy 2006 AIM Technologies All Rights Reserved Setup The procedures to setup and activate DataSpy for your company are as follows 1 Login as System Administrator a Login to the system as a system administrator sa or DYNSA b Select the company in which you want to setup DataSpy c You will receive a prompt similar to the following if DataSpy has not yet been initialized Select the Yes option to create the tables and stored procedures for DataSpy Microsoft Dynamics GP access has not been granted to the DataSpy tables YYould
7. owing which tables are updated added to or deleted from as you step though transactions DataSpy Allows You To View the technical physical and display names of tables Customize the results returned to suit your needs View the results of transactions including which tables are affected Create reports easily by viewing detailed information about tables and fields containing the data you are reporting eee 2006 AIM Technologies All Rights Reserved Technical Support AIM Technologies Technical Support is available Monday through Friday from 9 00 am to 5 00 pm Central time Technical Support can be reached via any of the following methods 985 951 7580 voice 253 295 0740 fax Support AIM Technologies com http www AIM Technologies com s uprequest htm Please include the following information with any support request Your company name and phone number Your name The name of the product you are working with Microsoft Dynamics GP Professional Microsoft Dynamics GP Standard or Small Business Financials The version of DataSpy you are running from the registration window A brief description of the problem ie oa 2006 AIM Technologies All Rights Reserved Installation The installation of DataSpy requires the following steps 1 Install DataSpy Code Unzip the DS90b zip file that was downloaded from our web site double click the Setup exe file to run the setup routine The DataSpy
8. y Installed Products Products To Be Monitored iD Product Analytical Accounting 0 Microsoft Dynamics GP Advanced Go Tos Advanced Security Add gt Electronic Reconcile Control Account Manage _ lt Remove Cash Flow Management eae Collections Management Revenue Expense D s Product ID K 258 gt Product Name Project Accounting Table Series To Be Monitored T Mark 2 Unmark All Financial T Online Documentation IV Sales I 31d Party IV Purchasing Payroll Tax T Inventory J Pathname I Payroll Tl Design Document IV Project T Dexterity I System I Dexterity System I Company J Report writer b Select one or more of the Installed Products to be monitored by selecting the product in the Installed Products window and clicking the Add button to insert the product into the Products To Be Monitored window Repeat this step for every product that you want to monitor c Click on the first product in the Products To Be Monitored window and mark each of the appropriate series of tables you want to monitor in the Table Series To Be Monitored window Repeat this step for every product listed in the Products To Be Monitored window Click the Update DataSpy button to allow the system to register all of the appropriate products and series to be monitored ie oa 2006 AIM Technologies All Rights Reserved 2 Open DataSpy a Click on the Shortcut you created above for DataSpy The following window will open
9. you i DataSpy needs to be initialized by the system administrator or like to proceed with the initialization now Initialization for DataSpy has been completed Run Grant sql For Microsoft Dynamics GP SQL installations run Grant sql against the DYNAMICS database For SBF no additional setup steps are required a Open the SQL Query Analyzer b Locate and open Grant sql in the sql util folder under the folder in which Microsoft Dynamics GP is installed c Run Grant sql against the DYNAMICS database ie oa 2006 AIM Technologies All Rights Reserved 3 Add Shortcuts for DataSpy Windows b c d e Login to the system as a system administrator sa or DYNSA Select the company in which you want to setup DataSpy Add the following windows to your shortcuts On the Shortcuts bar Add gt Other Window gt DataSpy gt 3rd Party DataSpy Registration DataSpy Setup DataSpy Click Done after adding all of the windows listed above Enter Registration Keys a b c DataSpy Click on the Shortcut you created above for DataSpy Registration Enter the registered company name and keys as provided to you Click OK to save the registration information and close the window 2006 AIM Technologies All Rights Reserved Begin Using DataSpy 1 Create or Modify DataSpy Setup Information a Click on the Shortcut you created above for DataSpy Setup Ei DataSpy Setup Update Datasp
Download Pdf Manuals
Related Search