Attachment_CC_SVC_Store_Deliverables_File_Upload_Process_Guideline.pdf

ATTACHMENT CC OF

PERFORMANCE WORK STATEMENT

SVC STORE DELIVERABLES FILE

UPLOAD PROCESS GUIDELINE

SNAP STORE VISIT CONTRACT

SVC Store Deliverables File Upload Process Guideline

Contractors must follow the following guidelines for successfully uploading store deliverables:

1) Create a folder and name of the folder should contain call order number and call order due date in the following format: <CO-Number>_<DueDate(MMDDYYYY)>

For ex: RO5-01213_15092014.

2) Inside this new folder, create sub-folders for each call order store and the name of this sub-folder should contain just the FNS Number of the store.

For ex: 0475826

3) Each sub-folder in turn should contain the actual deliverables related to that particular call order store in the form of .jpg for Store Visit photos or .pdf for Store Visit survey form. The name of

.jpg/.pdf file(s) should contain FNS Number, Store Name, Store Number, Post Date and Time, Sequence number in the following format:

<FNSNumber>_<StoreName> <StoreNumber>_<PostDate><PostTime>_<SEQ>.jpg/pdf

For ex: 0475826_Times Market 314_091020141206_1.jpg

0475826_Times Market 314_091020141206_2.jpg

0475826_Times Market 314_091020141206_29.pdf

0475826_Times Market 314_091020141206_30.jpg

4) The folder created in Step 1 should then be archived in .zip/.tar file and name it in the following format: <CO-Number>_<TransmissionDate(MMDDYYYY)>.zip/tar

For ex: RO5-01213_15092014.zip

5) This zip/tar file can be successfully uploaded into FNS Server.

MOVEIT

0250286

0250286_STORENAME_POST_DATE_1.PDF

0250286_STORENAME_POST_DATE_1.JPG

0212846

0212846_STORENAME_POST_DATE_1.PDF

0212846_STORENAME_POST_DATE_1.JPG

Represents FNS

Number transfer.fns.usda.gov/

Folder Structure for SVS

File Drop Specification for SVC

0253661

0253661_STORENAME_POST_DATE.PDF

0253661_STORENAME_POST_DATE.JPG

0249075

0249075_STORENAME_POST_DATE.PDF

0249075_STORENAME_POST_DATE.JPG

TRE-01361_DUE_DATE

Call Order Number

0232392

PHI-00905_DUE_DATE

WCH-00483_DUE_DATE

0250286_STORENAME_POST_DATE_2.JPG

0250286_STORENAME_POST_DATE_3.JPG

0212846_STORENAME_POST_DATE_2.JPG

Store

Visit

Photos

PHI-00905_TRANSMISSION_DATE.tar/zip

TRE-01361_TRANSMISSION_DATE.tar/zip

WCH-00483__TRANSMISSION_DATE.tar/zip

PHI-00905_TRANSMISSION_DATE.tar/zip

TRE-01361_TRANSMISSION_DATE.tar/zip

WCH-00483_TRANSMISSION_DATE.tar/zip

SFTP/SCP TCP 22

FTPS TCP 21 and 3000-3074

HTTPS TCP 443

Zip contents of each

Call Order

0212846_STORENAME_POST_DATE_2.PDF

0250286_STORENAME_POST_DATE_2.PDF

TRANSMISSION_DATE

DUE_DATE

POST_DATE

Store

Visit

Survey

Form

Date of File Transmission in

MMDDYYYY

Due date for the Call Order

MMDDYYYY

Date the files were posted

MMDDYYYY

Image 1: typical File structure of the Store Deliverable

“Post date” = date the files were posted to the website for users.

Include chain store unit number with name, like Circle K 4701, even if main name has to be truncated, like

Circle4701. Unless the website can pickup the name/number from STARS, based on FNS number, when the deliverable is received, so those items are displayed to the FO user, along with

FNS number.

Image 2: File structure of an actual Store Deliverable