Purchase Order

Page 1 of 5 Purchase Order 4000088524 ORNL SAP I Accounting I Employee Self-Service I HR Materials Management Reports I Training I Travel...
Author: Ronald Rogers
14 downloads 1 Views 2MB Size
Page 1 of 5

Purchase Order 4000088524

ORNL SAP

I

Accounting

I

Employee Self-Service

I HR

Materials Management

Reports

I

Training

I

Travel

I

Workflow I Help

Purchase Order 4000088524 Switch to summary view General Info Vendor

Order Type

Competition Code

230545 PIPS TECHNOLOGY INC Commercial Items

Date Created

SOLE SOURCE 12/14/2009

Buyer

Buyer Phone

Buyer FAX

Buyer E-Mail

96 Jo Ann Fitzpatrick

865-576-1543

865-241-1034

[email protected]

Description

Print Format

Performance Term Incentive

Spike High Def Compact ALPR Camera

Purchase Order No

Period of Performance

Subcontractor-Held Property

License Agreement

No

No

Incremental Funding Date

Funded Value: Total Value: Option Value: Total Value Incl Options: Attachments

Created

45,060.00

By

;h 400008852412/15/200917:16013100 Jo A Fitzpatrick General Provisions General Terms and Conditions - Commercial Items (CI Sept 2009) Special Provisions Company's Technical Contact: David E. Hill, (865) 576-9899, [email protected]

Delivery, Shipping, Packaging If total weight is under 60 pounds, please ship via Federal Express 2nd Day collect to DOE Account No. 1040-1750-9. If total weight exceeds 60 pounds, please ship via Roadway Express collect to DOE Tender No. 2914-12. ····DO NOT INSURE"" If you do not ship via this method or make other arrangements with the purchasing agent, you may not be paid for all shipping expenses. ***************************************************************

SHIP TO ADDRESSES: 1 Each of Items 1, 2, and 3 shall ship to:

- 6783 -

https:llhome.ornl.gov/sec-cgi-bin/cgiwrap?useFsapweb&script=PRDO 1O/purchaseOrder.c... 3117/2010

Page 2 of5

Purchase Order 4000088524

South Carolina Department of Public Safety State Transport Police 10311 Wilson Blvd. Blythewood, SC 29016 Attention: Sg!. Don Rhodes 1 Each of Items 1, 2, and 3 shall ship to: Mississippi Department of Transportation 7759 Highway 80 Newton, MS 39345 Attn: Captain Ronnie Harris Item 1. Part # P382-81 0-50-25; Model P382, Spike Expected Deliv Date

Quentity

Unit Price

Extended Price

Material Group

01/12/2010

2.000 EA

19,000.00

38,000.00

6720 Cameras, Non-Digital

Goods Recipient/Invoice Approver

Unloading PointlTask Auth.

033366 David E Hill

5100108

GL Account

was Element

42000652

33953637

SERRI Trusted Cooridor - Miss-Smith (WFOProgram 40)

Tracking No.

Vendor Part No.

Requisition Item

FGH

P382P-810-50-25

3400127907-00001

MSDS

Inspection Required

Quality - Significant

ES&H Review Required

Invoice Approval Required

~

~

No

No

Qty Received

Value Received

Last Receipt Date

Qty Invoiced

Value Invoiced

Last Invoice Date

2.000

38,000.00

02/08/2010

Tax Description

Non-Taxable Tax Calculation

Item Text/SOW/Specification Part # P382P-81 0-50-25; Model P382, Spike High Definition (HD), Compact ALPR Camera with OnBoard Illumination and Integrated ALPR Processor with ALPR/OCR Engine; Provides for a Dual Lens Camera Assembly of Infrared (IR) and Color for Vehicle Image OveNiew; Camera Hood Included; High Resolution IR Sensor provides full Lane Coverage with Each ALPR Camera; IR Lensing is 50; Color OveNiew is 25; all lensing distances will be determined with the final Camera configuration Item Note PIPS TECHNOLOGY,(A FEDERAL SIGNAL COMPANY); 804 INNOVATION DRIVE; KNOXVILLE, TN 37932 - ATTN: RANDY HENDERSON (865-392-55401 FAX 865-392-5599) REFERENCE QUOTE NUMBER 091029 Sole-Source Justification The Southeast Region Research Initiative (SERRI) project is working in Cooperation with the Mississippi Department ofTransportation (MDOT) and the South Carolina State Transport Police(SETCP) in Commercial Vehicle Enforcement. For this project itis necessary to procure an automatic License Plate Reader. Mississippi and South Carolina already has a large investment in LPR technologies and has

- 6784 -

https:/Ihome.ornl.gov/sec-cgi-bin/cgiwrap?user=sapweb&script=PRD01 O/purchaseOrder.c... 3117/2010

Purchase Order 4000088524

Page 3 of5

asked up to use Federal Signal as our procurementvendor for the purchase of the LPR for this project. Item 2. Part # X3821 001; Model P382 HD Expected Deliv Date

Quantity

Unit Price

Extended Price

Material Group

01/12/2010

2.000 EA

845.00

1,690.00

6720 Cameras, Non-Digital

Goods Recipient/Invoice Approver

Unloading PointJrask Auth.

033366 David E Hill

5100108

GLAccount

was Element

42000652

33953637

SERRI Trusted Cooridor - Miss-Smith (WFOProgram 40)

Tracking No.

Vendor Part No.

Requisition Item

FGH

X3821001

3400127907-00002

MSDS

Inspection Required

Quality - Significant

ES&H Review Required

Invoice Approval Required

~

No

No

No

Qty Received

Value Received

Last Receipt Date

QIy Invoiced

Value Invoiced

Last Invoice Dale

2.000

1,690.00

02/08/2010

Tax Description

Non-Taxable Tax Calculation

Item Text/SOW/Specification

Part # X3821001; Model P382 HD Termination Box for field installation; NEMA 4 Rated; Includes the P382 Power Supply, Primary Lightning Protection Circuitry and PowerlData Cable Assembly, 100 feet maximum in Length, to accommodate one (1) P382 Item Note

PIPS TECHNOLOGY,(A FEDERAL SIGNAL COMPANY); 804 INNOVATION DRIVE; KNOXVILLE, TN 37932 - ATTN: RANDY HENDERSON (865-392-55401 FAX 865-392-5599) REFERENCE QUOTE NUMBER 091029 Sole-Source Justification

The Southeast Region Research Initiative (SERRI) project is working in Cooperation with the Mississippi Department of Transportation (MDOT) and the South Carolina State Transport Police(SETCP) in Commercial Vehicle Enforcement. For this project itis necessary to procure an automatic License Plate Reader. Mississippi and South Carolina already has a large investment in LPR technologies and has asked up to use Federal Signal as our procurementvendor for the purchase of the LPR for this project. Item 3. Part # AP382QRPBCKT; Pole Mount Quick Expected Deliv Dale

Quanlily

Unil Price

Extended Price

Malerial Group

01/12/2010

2.000 EA

785.00

1,570.00

6720 Cameras, Non-Digital

Goods Recipient/Invoice Approver

Unloading PointJrask Aulh.

033366 David E Hill

5100108

GL Accounl

was Element - 6785 -

https:/Ihome.ornl.gov/sec-cgi-binlcgiwrap?user=sapweb&script=PRD01 O/purchaseOrder.c... 3117/2010

Purchase Order 4000088524

42000652

, Tracking No,

33953637

Page 4 of5

SERRI Trusted Cooridor - Miss-Smith (WFOProgram 40)

Vendor Part No,

Requisition item

FGH

AP382QRPBCKT

3400127907-00003

Inspection Required

Quality - Significant

ES&H Review Required

Invoice Approval Required

No

No

No

No

Qty Received

Value Received

Last Receipt Date

Qty Invoiced

Value Invoiced

Last Invoice Date

2,000

1,570,00

02/08/2010

MSDS

Tax Description

Non-Taxable Tax Calculation

Item Text/SOWISpecification

Part # AP382QRPBCKT; Pole Mount Quick Release Bracket Assembly for the P382; 9" Diameter Maximum Item Note

PIPS TECHNOLOGY,(A FEDERAL SIGNAL COMPANY); 804 INNOVATION DRIVE; KNOXVILLE, TN 37932 - ATTN: RANDY HENDERSON (865-392-55401 FAX 865-392-5599) REFERENCE QUOTE NUMBER 091029 Sole-Source Justification

The Southeast Region Research Initiative (SERRI) project is working in Cooperation with the Mississippi Department of Transportation (MDOT) and the South Carolina State Transport Police(SETCP) in Commercial Vehicle Enforcement For this project itis necessary to procure an automatic License Plate Reader. Mississippi and South Carolina already has a large investment in LPR technologies and has asked up to use Federal Signal as our procurementvendor for the purchase of the LPR for this project Item 4. Additional year of Hardware and Software Expected Deliv Date

Quantity

Unit Price

Extended Price

Material Group

01/12/2010

2.000 EA

1,900.00

3,800.00

DB Hardware Maintenance

Goods Recipient/Invoice Approver

Unloading PointlTask Auth.

033366 David E Hill

5100108

GL Account

was Etement

42000652

33953637

Tracking No,

Vendor Part No,

FGH

SERRI Trusted Cooridor - Miss-Smith (WFOProgram 40) Requisition Item

MSDS

3400127907-00004

Inspection Required

Quality - Significant

ES&H Review Required

Invoice Approval Requirad

~

No

No

No

Qty Received

Value Received

Last Receipt Date

- 6786 -

Tax Description

Non-Taxable Tax Calculation

https:llhome.ornl.gov/sec-cgi-bin/cgiwrap?user=sapweb&script=PRDO 1O/purchaseOrder.c...

3117/2010

Purchase Order 4000088524

Page 5 of 5

Qty Invoiced

Value Invoiced

Last Invoice Date

2.000

3,800.00

02/08/2010

Item Text/SOW/Specification Additional year of Hardware and Software Maintenance Support for P382 System. Item Note PIPS TECHNOLOGY,(A FEDERAL SIGNAL COMPANY); 804 INNOVATION DRIVE;KNOXVILLE, TN 37932 - ATTN: RANDY HENDERSON (865-392-55401 FAX865-392-5599) REFERENCE QUOTE NUMBER 091029

11/05/09 CHANGED MATERIAL GROUP FROM 6720 TO DB Sole-Source Justification The Southeast Region Research Initiative (SERRI) project is working in Cooperation with the Mississippi Department ofTransportation (MOOT) and the South Carolina State Transport Police(SETCP) in Commercial Vehicle Enforcement. For this project itis necessary to procure an automatic License Plate Reader. Mississippi and South Carolina already has a large investment in LPR technologies and has asked up to use Federal Signal as our procurementvendor for the purchase of the LPR for this project. Approval History Date Time Action Agent 12/15/2009 19:01 :02 Approve 013100 Jo A Fitzpatrick Document Reviews HMIS Review Not required Reload page with texts in fixed-width font (to improve display of tables) Switch to summary view ORNL SAP I ORNL Internal

I

Questions

I

Disclaimers

Powered by ORNL SAP

- 6787 -

https;1Ihome.ornl.gov/sec-cgi-bin/cgiwrap?user=sapweb&script=PRD01 O/purchaseOrder.c... 3117/2010

Trusted Corridor Weigh Station Software Installation 04/20/2010 Operating System and networking The system has a base install of Windows 7 64 bit edition. In addition, the machine has 2 network cards. The first is for connectivity to the state network and internet. The second network interface is for a private network to the PIPS camera. On the second network interface, set a private static IP address and ensure that windows firewall is completely disabled. Also, be sure to make note of the IP address because the PIPS camera will later need to be configured to send data to this machine. Install Java 1) Install the Java development kit. Included on this CD as jdk-6u18-windows-x64.exe. Accept all default options. Ignore the registration web site that pops up after installation. 2) Create a JAVA_HOME system environment variable: JAVA_HOME=c:\Program Files\Java\jdkl.6.0_18 3) Edit the PATH system environment variable add %JAVA_HOME%\bin To set environment variables, click the windows logo in the bottom left of the screen. Then right click on "Computer" menu option, then click the "Properties" option. Click "Advanced system settings" on the left of the screen. The System Properties dialog will appear. Click the "Environment Variables ... " button to variables.

-- -, -...".."""'

...

... ....,.."" .....

-~

s"w.,,_. ___..... _ .._

Create and Copy Config templates 1) Create directory c:\etc\tc 2) Copy config template tc.properties file into c:\etc\tc 3) Open c:\etc\tc\tc.properties in a text editor to set the configuration options 1.

station.name: Name of the weigh station

2. inspection.length: Length in milliseconds for the length of an inspection. It is recommended to leave this at 500 3.

mail. host: IP address or host of SMTP server for sending the email report

4.

mail. port: SMTP server port

5.

mail.ssl: true or false depending on if the mail server requires SSL

6. mail.authenticate: true or false depending on if the SMTP server requires authentication to send email

- 6788 -

7. mail.username: ifmai1.authenticate=true then this is the username to authenticate

8. maiI.password: if mai1.authenticate=true then this is the password to authenticate

9. mail.to: the email address to send the weigh station report to. It would be best if the email admin would create a group to send this to, so the email administrator can manage who gets the email without touching this system 10.

mail.from: the email address the report appears to come from

11.

maiI.subject: subject line ofthe email

report.cronExpression: The cron expression to schedule the report generation (example: 0 0 0 * *? is midnight every night. See www.guartzscheduler.org/docs/tutorials/crontrigger.html for cron trigger documentation) 12.

13. data.daysToKeep: 31 days is recommended as the queries run to generate the report query for the past 30 days worth of data. 14. files

cview.sftpHost: IP address or host name of SFTP server to retrieve cview update

15.

cview.sftpPort: SFTP server port

16.

cview.sftp User: username to connect to SFTP server

cview.sshKeyPath: location on the local machine of the ssh key to connect to the 17. SFTP server. Later these instructions have you generate this key and place it in c:\etc\tc. So a value of /etc/tc/id rsa would be correct 18. cview.sftpPath: Directory location on the sftp server where the update files are located

cview.cronExpression: The cron expression to schedule the report generation (example: 0 0 1 * *? is 1 AM. See www.guartzscheduler.orgldocs/tutorials!crontrigger.html for cron trigger documentation) 19.

Install Putty and generate SSH keys These keys will be used for connecting to the cview data SFTP server 1) Create a directory c: \putty 2) Copy putty. zip into c:\putty 3) Unzip c:\putty\putty.zip 4) Run c:\putty\puttygen:

- 6789 -

I

_i!,:t..:::L0:.!,,..~,., ""'.,;>~,;~\: ',. ~~ir' L.t.L. ',,~_ ',.",,-,=l,.::! ~'_ ~ fill! ~ Co~~_ J;!....~_ .. ~~ ______ ~ __.___ ~ ______ ~__

""

No "".

-..

_H

Gener
. " -,

.u,

~~cy-_£~--~~--

""

-. GonoO~

L_~~o

loadane:xioli-lgprtv .... keyfico

r-~~----l

I

l. _~o_!'P-::~:r_! L~~"¢,.
s.yolh8~key

1__ go.n!lPflv"'elooylile

I

s..v.. thegen ....edkey

~P\l!lkkey

II

liiIv!>J)liYukey

I

,-~

Typelikeylogo""r.lI5: SSH-l(RSA)

T)'I>Odkoylogene",\e:

@SSH·2£\S1I

NunberclQl;'''a_$r.(~kvJ·

SSH·2.1lSA

_

[i§=-~--==)

o SSH-l(RSA)

@SSH·2RSA

Numberafl!hlnagoneratedkey:

0 SSH·2I:!.SA

1024

6) Click the "Save public key" button and save it to c:\etc\tc\id_rsa.pub 7) Click the "Save private key" button and save it to c:\etc\tc\idJsa 8) Once you save the private key file, the file will be named c:\etc\id_rsa.ppk. Rename it to get rid of the extension so the file is just named id_rsa. 9) Contact the maintainer of the SFTP server (Iteris or other), and tell them you need a new directory for a new weigh station. Give the the public key file idJsa.pub. Do NOT give them the private key file. They should give you a username, server ip, server port, and path to the new directory for this new weigh station. Take those values and configure them in c:\etc\tc\tc.properties as described in a prior section of this docnment.

Database Install/Setup Install mysql I) Run the mysql installer (mysql-essential-5.1.44-winx64.msi) 2) Choose "Typical" installation

- 6790 -

S-etuptw>e

Chooo ......WIl... thotboot..otsl"""_ . ...........

-------,

3) When you get to the end of the setup wizard, Check to "Configure the MySQL Server now", and Uncheck the "Register the MySQL Server now". Then click "Finish" to run the MySQL Server Instance Wizard.

4) Choose "Detailed Configuration" "'~l'''''_'~ ("""I"'''·....'1Q11.1'It ...

to ..... u..~Ql_Se....,..l!e IUR.~

6) Choose "Multifunctional Database"

- 6791 -

My5QI._In_C........ u......," Coni, ...... tn. MysQL 5 ...... 5.1 ••

IV.' 'n..

~nfiGn

...... ,...".... ""'_ ......"er.lI ........_~ .... _ I'''.

1

Click the "Execute" button to create the configuration MjSQI. 5", ..

_","Co"IIg" .. ~."

ConfIlII'''th'M)lSQtS.""S,1 """'n~lJI".

OPr....«~~,otlon OWlilO'OflIiIIuriIiOnfJI'

OSbtt ....... O""'"~,_Q'

_

...... IfMcuteIIo_ ....

~

14) MySQL should now be installed 15) Copy MySql.sql to the desktop 16) Open a command prompt and cd to Desktop

- 6793 -

17) Run the command "mysql -u root -p < MySql.sql" to create the database, user and tables. Enter the root password you created in step 12.

18) Install the MySQL workbench (mysql-workbench-oss-5.2.16-beta-win32.msi) as a tool for a database savvy person to look into the database for troubleshooting purposes.

Load Baseline CView Data I) Via any available mechanism copy the zipped baseline files from the cview provider to the local system. The data format and filename formats should be the same as the description of the cview data files in the File Format document. 2) Copy the BaselineLoader directory from the installation distribution to the local system (C:lBaselineLoader) 3) Open a command prompt, CD to C:\BaselineLoader and execute "java -jar BaselineLoader.jar ". The tool should then load all the data into the local database.

Install Tomcat Application Server This is the server the main web application is hosted from. 1) Run the tomcat installer (apache-tomcat-6.0.24.exe) 2) Agree to license and select default options until you get to the "Choose Components" screen. From there, expand "Tomcat" in the component tree and select "Service". Leave all other options default. Click "Next".

- 6794 -

chod!he~ yru .....,tlll n.t.I mcI\11Chedr. the~1s yru don't nanl Ia r.staII. adi:NoxtIa infomlation colkclillll is 1116-00 10. Sl~nd commen!~ regur