My WebLink
|
Help
|
About
|
Sign Out
Home
Browse
Search
RON TURLEY ASSOCIATES 1C - 2011
Clerk
>
Contracts / Agreements
>
R
>
RON TURLEY ASSOCIATES 1C - 2011
Metadata
Thumbnails
Annotations
Entry Properties
Last modified
1/3/2012 2:16:59 PM
Creation date
6/28/2011 9:28:46 AM
Metadata
Fields
Template:
Contracts
Company Name
RON TURLEY ASSOCIATES
Contract #
A-2007-058-03
Agency
FINANCE & MANAGEMENT SERVICES
Destruction Year
0
Notes
A-2007-058: 01,02
There are no annotations on this page.
Document management portal powered by Laserfiche WebLink 9 © 1998-2015
Laserfiche.
All rights reserved.
/
4
PDF
Print
Pages to print
Enter page numbers and/or page ranges separated by commas. For example, 1,3,5-12.
After downloading, print the document using a PDF reader (e.g. Adobe Reader).
View images
View plain text
RON TURLEY ASSOCIATES, INC. <br />FLEET MANAGEMENT SOFTWARE & SUPPORT SERVICES <br />20823 N. 19th Ave., Suite 4 <br />Phoenix, AZ 85027 <br />Phone: 800-279-0549 • 623-581-2447 Fax: 623-582-1747 <br />Website: www.rtafleet.com Email: rtafleet(aD-rtafleet.com <br />To: Milanka Radic <br />City of Santa Ana <br />Date: 3/10/11 <br />RE: Custom Programming/Modification Quote # BK284 <br />ProiectScope• <br />Create a sql script to export part transactions posted in the work order module into a csv <br />file. The scripts will be setup by Santa Ana to run in a sql job scheduler and will also be <br />available to be run manually (externally from the RTA software). This utility could be <br />run daily, weekly, monthly, etc. <br />CSV file name: RTAExportCCYYMMDD.csv <br />CSV file format with no header record as per attached file provided by the City. Some <br />minor modifications may be needed prior to final approval. <br />Transactions will be flagged when exported, and the export will not select any <br />transactions that have been flagged. The flag will also include the date it was exported. <br />The extracts are based on transactions. Therefore, if some parts are posted to a work <br />order, then the extract is run, those parts will be extracted, even though the work order is <br />still open. If other parts are then posted, those will be extracted in the next run. Two or <br />more extracts may contain postings from a single work order. <br />A second script will be created to "unflag" transactions. This utility will need to be <br />executed manually, and prompt for a date and remove the flag for all that were exported <br />on that date. The extract script could then be processed in order to extract those records <br />again. <br />Notes: <br />This quote does not include parts posted in the fueling module. <br />This quote does not include emailing the file. <br />Proiect Cost and Timeframe: <br />The cost of this enhancement is 53200. RTA could program this in approximately 10 <br />weeks. We might be able to provide it sooner but I couldn't guarantee this based on our <br />current workload. This quote is valid for 90 days. <br />EXHIBIT A
The URL can be used to link to this page
Your browser does not support the video tag.