{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Main","Dropdown Choices","Connect to FTP"],"not_rendered":{"images":2,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":1,"n_cols":22,"rows_kept":1}
["LAB NAME","WORK NUMBER","CERTIFICATE NUMBER","SCI FV187 NUMBER ISSUED","CUSTOMS ENTRY NUMBER","IMPORTER","APPLICANT","COUNTRY OF ORIGIN","COMMODITY","DATE SAMPLED","DATE RECEIVED","DATE TESTED","DATE CERTIFICATE ISSUED","TESTER NAME","CONTAINER NUMBER","TOTAL WEIGHT","UNIT OF MEASURE","INSPECTION RESULT","AFLATOXIN RESULT","LOT NUMBER","SAMPLE NUMBER","TESTING METHODOLOGY"]

{"sheet":"Dropdown Choices","index":1,"n_rows":34,"n_cols":6,"rows_kept":34}
["COMMODITY-COLUMN   I","Inspection Result-Column R","AFLATOXIN RESULT-Column S","UNIT OF MEASURE-Column Q","LAB NAME Column A","Testing Methodology-Column V"]
["Pistachios","Meets ","Meets ","LBS","ADVANCE MYCOTOXIN LABORATORY","HPLC"]
["Peanut","Fails ","Fails ",null,"ADVANCED PRECISION LABORATORIES LLC","Fluorometry"]
[null,"Destroyed",null,null,"ALABAMA FEDERAL STATE INSPECTION SERVICE","TLC"]
[{"$nulls":4},"EMSL ANALYTICAL INC"]
[{"$nulls":4},"HORIZON NUT COMPANY, LLC"]
[{"$nulls":4},"IEH - FRESNO"]
[{"$nulls":4},"IEH LABORATORIES AND CONSULTING GROUP "]
[{"$nulls":4},"IEH QUANTA LABORATORY"]
[{"$nulls":4},"IEH-JL ANALYTICAL "]
[{"$nulls":4},"JLA INTERNATIONAL ALBANY"]
[{"$nulls":4},"JLA INTERNATIONAL ASHBURN"]
[{"$nulls":4},"JLA INTERNATIONAL BLAKELY"]
[{"$nulls":4},"JLA INTERNATIONAL BROWNFIELD"]
[{"$nulls":4},"JLA INTERNATIONAL COLQUITT"]
[{"$nulls":4},"JLA INTERNATIONAL DAWSON"]
[{"$nulls":4},"JLA INTERNATIONAL DELEON"]
[{"$nulls":4},"JLA INTERNATIONAL DOUGLAS"]
[{"$nulls":4},"JLA INTERNATIONAL EDENTON"]
[{"$nulls":4},"JLA INTERNATIONAL HEADLAND"]
[{"$nulls":4},"JLA INTERNATIONAL SYLVESTER "]
[{"$nulls":4},"KEENAN FARMS INC"]
[{"$nulls":4},"MARS CHOCOLATE NA ALBANY PLANT"]
[{"$nulls":4},"MICHELSON LABORATORIES OF NORTHERN CALIFORNIA"]
[{"$nulls":4},"NICHOLS FARMS "]
[{"$nulls":4},"SAFE FOOD ALLIANCE DBA DFA OF CALIFORNIA / FRESNO"]
[{"$nulls":4},"SAFE FOOD ALLIANCE DBA DFA OF CALIFORNIA / KERMAN "]
[{"$nulls":4},"SAFE FOOD ALLIANCE DBA DFA OF CALIFORNIA / MODESTO"]
[{"$nulls":4},"SAFE FOOD ALLIANCE DBA DFA OF CALIFORNIA / YUBA CITY"]
[{"$nulls":4},"SETTON PISTACHIO OF TERRA BELLA, INC."]
[{"$nulls":4},"SNYDER'S LANCE INC."]
[{"$nulls":4},"USDA AMS S&T PROGRAM NATIONAL SCIENCE LABORATORY AT BLAKELY"]
[{"$nulls":4},"USDA, AMS, S&T NATIONAL SCIENCE LABORATORY BLAKELY DAWSON SATELLITE LABORATORY "]
[{"$nulls":4},"VA DEPT OF AGRICULTURE & CONSUMER SERVICES SUFFOLK AFLATOXIN LAB"]

{"sheet":"Connect to FTP","index":2,"n_rows":34,"n_cols":1,"rows_kept":34}
["Version : 1.5\nDate: 12-05-2016"]
["Connect to SFTP server"]
["Start WinSCP. Login Dialog will appear. On the dialog:"]
["·         Select your File protocol as SFTP. "]
["·      Enter the host name ftp.ams.usda.gov to Host name field, username to User name and password to Password"]
["·      You may want to save your session details to a site so you do not need to type them in every time you want to connect.     \n       Press Save button and type site name."]
["·         Press Login to connect."]
{"$rows_empty":24}
["Uploading"]
["Once you are connected to your account of FTP/SFTP server, you will see content of default remote directory on the right panel."]
["Now you can simply drag the local files and drop them on remote file panel on the right. Uploading will proceed. Once it finishes, you will see uploaded file in remote file panel."]