I gang

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 [url removed, login to view] 130 19 4/30/2008 SFD

91902 BONITA 24 803916 665000 19294000 4 597500 560000 2390000 [url removed, login to view] 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 [url removed, login to view] 51 11/30/2001 SFA

91902 BONITA 19 425781 8089856 12 503358 6040300 [url removed, login to view] 59 11/30/2001 SFA

...

Færdigheder: .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, sandicor, month 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, extracting data reports, extract data pdf, extract info pdf, extract tab delimited pdf, extract information pdf, sql reports, sql data, sample data, reports sql server, remove from, pdf file text

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

Projekt-ID: #276165

Tildelt til:

databuilders

Please see PMB

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

9 freelancere byder i gennemsnit $66 for dette job

SouthIndian

Please refer PMB. Thanks.

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

Please check PMB for details, Thank you

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

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)
5.2
mohanlg

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

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

Pl refer PM.

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

Hello sir, Please check your PMB

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

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)
0.0
xt3chnology2008

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

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