Laserfiche WebLink
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