Downloads
Below are files of importance to the University community that can be downloaded to ones PC and utilized in the mentioned applications.
Attachmate Extra Scripts
The first and most important file is titled Winsnap.ebm and what this script will do is to scrape a query answer set data from ones PC screen and write that financial data to a file located at "C:\" and the file name is "Winsnap.txt". Once the script has concluded the recipient can import the data into virtually any application that will accept a text file. Some applications would be Word, Excel, Lotus 1-2-3, or even Access. To see how winsnap functions please view this page and read carefully for it is a bit technical.
The second script I have written is titled Parse.ebm and this is a parsing routine that complements the Winsnap script. What parse will do is to read in the Winsnap.txt file and you must provide each field with a start/stop value and the type of field data element. All parse does is to break up the string data contained within Winsnap.
Now for us Temple FMS users that have both command line access and CQUBR query access, I have created a script that will work with the G5002, GCT01, GPH01, UPX01, FMAU1, FMAU2, FKT19, F45US, ACK01 & NDXLS screens. The name of this script is Full_Screen.EBM and basically here is how it works. When you run a query, instead of naming display fields you simply instruct FMS to display the full screen of the record. For example, on the first display field you would put "*01" (omit the double quotes) and the GCT01 screen record will be displayed. There cannot be any other data fields displayed on the CQUBR screen or the query will not function. For fixed assets you could display the FMAU1 screen as "*U1". The query will run and based upon any of the above ten screen ID's, it will jump to screen row/column coordinates and scrape the field data. The data will be written to 'C:\FullScreen.txt' on your local hard drive and parsed with the tilda "~" as a delimiter. Now the user can use the applications import wizard to import the tilda delimited text record.
For screen ID's ACK01, NDXLS & G5002 you can simply fill in the command line to display the range of records you wish to view. Once your first screen is displayed you can run the script and it will scrape the screen data to the text file and when the last screen is displayed, the script will terminate.
I have found that on some machines writing the screen data to the root drive (C:\) is not allowable by Windows XP. In order to alter the destination simply open the macro in Extra editor and change the line of code " Open "C:\FullScreen.txt" for Output as #1 " to a new drive such as H:\.
Microsoft Internet browser
Located at http://www.microsoft.com/downloads/search.asp is Microsoft's download center. This site has numerous download capabilities so please review the pull down boxes and select the download in need.
Access Snapshot viewer
Access can export out a report in a file that the user can view but cannot alter the contents. To download and install, the web location is at http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3BQ175274. This is a great utility that permits any application to print out into PDF format. After you install the program take a look at your available print drivers and you will notice that you now have a print driver "CutePDF Printer".
Access PDF
Since Access cannot export out a report in PDF format there is an alternative I have just recently used quite successfully. Simply go to www.acrosoftware.com/products/cutepdf/printer.asp and download the FREE executable to your hard drive. You need to then run the executable and let it install onto your machine. The next time you wish to produce a PDF format in any Windows application instead of printing to your printer change drivers to the "CutePDF" driver. You will be prompted for a file name, but your output will be on PDF format.
FMS on the Web
To log onto FMS, users will still need their SecureID card, however users can view financial data via their web browsers. To utilize this system please go to FMS.Temple.edu