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


Kemahiran: .NET, Pemasukan Data, Pemprosesan Data, Sistem Admin, Visual Basic

Lihat lagi: 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

Tentang Majikan:
( 12 ulasan ) San Diego, United States

ID Projek: #276165

Dianugerahkan kepada:


Please see PMB

$30 USD dalam 3 hari
(2 Ulasan)

9 pekerja bebas membida secara purata $66 untuk pekerjaan ini


Please refer PMB. Thanks.

$40 USD dalam 2 hari
(146 Ulasan)

Please check PMB for details, Thank you

$30 USD dalam sehari
(94 Ulasan)

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 dalam 0 hari
(46 Ulasan)

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

$145 USD dalam 3 hari
(24 Ulasan)

Pl refer PM.

$50 USD dalam 2 hari
(4 Ulasan)

Hello sir, Please check your PMB

$120 USD dalam 7 hari
(2 Ulasan)

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 dalam 0 hari
(0 Ulasan)

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

$80 USD dalam 2 hari
(0 Ulasan)