Extract data from PDF reports

Extract data from PDF reports is project number 276165 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider databuilders
Budget:	$30-250
Created:	06/18/2008 at 11:03 EDT
Bidding Ends:	06/22/2008 at 11:03 EDT
Project Creator:	SoCalDevelopment   Buyer Rating: (7 reviews)
Description:	Convert data from 78 PDFs to tab delimited files that are ready to import into SQL Server. The source PDFs are available on a public website. [this information also attached in text document] Source PDFs: http://sandicor.com/ click Sales Statistics click a year click a month click Single Family Detached export data, adding two new columns: 1 - month from top of page 2 - "SFD" (indicating Single Family Detached) close PDF click Single Family Attached export data, adding two new columns: 1 - month from top of page 2 - "SFD" (indicating Single Family Detached) repeat for each month and year since November 2001 Destination files: The PDF format changed in January 2004. Some columns are not available before that date, so 2 files will be created. 1 file for November 2001 through December 2003 A separate file for January 2004 through current date tab delimited format first row should include column names as shown below in sample data 1 record per row after remove dollar, percent and commas ($%,) Example of new data file: From January 2004 to current, the format will be: ZipCode NewListings AverageListPrice MedianListPrice TotalNewListingValue SoldListings AverageSoldPrice MedianSalePrice TotalSoldValue PercentSalePriceToListPrice AverageDaysOnMarket MOINV MonthEnding PropertyType 91901 ALPINE 30 634863 559000 19045907 11 451500 425000 4966500 94.20 130 19 4/30/2008 SFD 91902 BONITA 24 803916 665000 19294000 4 597500 560000 2390000 93.07 120 10 4/30/2008 SFD ... December 2003 and before will have the format: ZipCode NewListings AverageListPrice TotalNewListingValue SoldListings AverageSoldPrice TotalSoldValue PercentSalePriceToListPrice AverageDaysOnMarket MonthEnding PropertyType 91901 ALPINE 37 441135 16322018 16 363550 5816800 0.96 51 11/30/2001 SFA 91902 BONITA 19 425781 8089856 12 503358 6040300 0.96 59 11/30/2001 SFA ... Additional files submitted: GetAFreeLancer Estimate.txt
Job Type:	.NET Data Entry Data Processing System Admin. Visual Basic
Database:	(None)
Operating system:	(None)
Bid count:	9
Average bid:	$ 66