Extract data from PDF reports

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:

[url removed, login to view]

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


Evner: .NET, Dataindførsel, Databehandling, System Administrator, Visual Basic

Se mere: extract data pdf report, extract data pdf reports, top statistics, top data, sql pdf files, sql pdf file, sandicor com, sandicor, month of january, for the month of january, click sales, extract data secure pdf, extract data pdf website, extracting information secure pdf, extract data pdfs, extract data report, extract data report files, pdf extract data sql net, money extracting data pdf reports, extracting data reports, extract data pdf, extract info pdf, extract tab delimited pdf, extract information pdf, Sql reports

Om arbejdsgiveren:
( 12 bedømmelser ) San Diego, United States

Projekt ID: #276165

Tildelt til:


Please see PMB

$30 USD in 3 dage
(2 bedømmelser)

9 freelancere byder i gennemsnit $66 på dette job


Please refer PMB. Thanks.

$40 USD in 2 dage
(146 bedømmelser)

Please check PMB for details, Thank you

$30 USD på 1 dag
(94 bedømmelser)

Hi, I am full of confident to provide you prominent service having high professional work unite as to accomplish your each and every single requisite. Kindly allow PMB for more details. Thanks

$50 USD in 0 dage
(46 bedømmelser)

Hi, I am interested in your project and ready to start. Please check PMB. Thanks Sunny

$145 USD in 3 dage
(24 bedømmelser)

Pl refer PM.

$50 USD in 2 dage
(4 bedømmelser)

Hello sir, Please check your PMB

$120 USD in 7 dage
(2 bedømmelser)

I already have an application that does what you request, I only need a few hours to adapt it, if you want we can begin now.

$50 USD in 0 dage
(0 bedømmelser)

Dear Sir/Madam, I can deliver you the solution asap. Thanks

$80 USD in 2 dage
(0 bedømmelser)