Please provide your time and cost estimate with your proposal.
I need an application that scrapes data from this web form:
*needs to work on WIN + MAC*
I will use a barcode scanner attached to my computer via USB cable. I scan an 8 digit code which is inserted into where the mouse is clicked at the time.
This web form will generate results. This app needs to populate these in a CSV file with the information generated by the barcode scan.
Human Action: Scan certificate number via barcode on physical item with USB attached barcode scanner.
Computer Action take barcode into the web form extract the information and input into an CSV file. This App also needs to be able to do this in BATCH form. Example if I scan 1, 10, 100, 1,000, or 10,000 bar codes, this app needs to be able to take the information from all 1 - 10,000 barcodes from this web form and compile them into a CSV format.
Barcode scanner reads 25706046. The following information is scrapped from the web form and compiled.
CSV HEADER READS : ITEM INFORMATION, Certification Number, Hologram Security (Y/N), Reverse Cert Number/Barcode (Y/N), Year, Brand, Variety, Sport, Sport Category, Card #, Player Name, Grade, Grade extrapolate (1), Grade extrapolate (2), Grade Extrapolate (3), Population ( Placed into Item Information if value<25), Population /w Qual, Population Higher
Item Information will read “Year Brand # Player Name PSA Grade Population(if value<25)”, grade is placed into a different order when pulled from the web form. It will read “Grade: MINT 9” when it fills in on the spreadsheet it will read “PSA 9 MINT” in Grade Column, and in extrapolate (1) PSA, in extrapolate (2) 9, in extrapolate (3) MINT. The Grade may be followed by a “Qual”, these follow the grade on the form and will be in the form of 2 letters. These need to follow the grade in parenthesis “PSA 9 MINT MC” (as seen in example certificate 24651232).
Example certificate without “Variety”, Certificate number 08007717, ITEM INFORMATION column will populate with “1955 Topps #164 Roberto Clemente PSA 6 EX-MT”
Each of the rest of the columns on the spreadsheet will populate, starting with Certification Number, 08007717, YES, YES, 1955, Topps, (Blank), Baseball, 213, 164, Roberto Clemente, PSA 6 EX-MT, PSA, 6, EX-MT, POP 520, POP /w Qual 87, Pop Higher 630
Example certificate with “Variety”, Certificate number 25706046, ITEM INFORMATION column will populate with “2011 Bowman Sterling Pros. Auto. - RED REF. 1/1 #BSW Blake Swihart PSA 10 GEM MT POP 1”
Once this is successful, the project has more parts including API configuration (to input and pull information), and additional applications needed to connect to MSWORD/EXCEL