PHP System PDF Conversion & Email -- (Complete Spec)

The project requires the following:

1. When the app is called, download all pdf's since the last successful download up to today's date. The pdf is from a public site. The name of the pdf changes based on the date. The file for December 10 was [login to view URL] whereas the file for December 11 was [login to view URL] See step 2 for info on the table to query to get the latest filename downloaded for you to determine which files need to be downloaded. There is only 1 file per day.

2. In a Microsoft SQL database, log that the file was downloaded (including the date/time stamp and the filename) in a table called "mi_spd_downloadlog". If the file was downloaded, do not allow it to be run again to re-download.

3. Scrape all data from the pdf. These are address records. There are 5 fields of information including Reported, Location, Activity, Incident Number and Disposition. Import all of this information into a table in the same Microsoft SQL Database into a table called "mi_spd_dailycalls" and include a foreign key to the log file in #2.

4. Match the addresses based on number and street to an existing table "mi_properties" in the same database. Note: You will need to do a comparison of just the street name and the number - this means you will need to strip other information from the address (like North or South, Drive, Street, etc). On a match, add a foreign key to the row in #3 to the PropertyID and LandlordID in the lookup table. A sample of the data in this table is attached as an excel spreadsheet, "[login to view URL]".

5. After importing all rows, send an email to the landlord of all properties they are associated with containing the imported information from the PDF. The format for this email should match the included word document "[login to view URL]". Do this for each LandlordID for that batch of imports.

6. Create a log entry into a table called "mi_spd_emaillog" for the email contents, to addres and send time/date. Do this for each email sent.

Note: We do understand that there may be a library requirement to extract the data from the PDF. We are looking for the freelancer to provide advice on which library we will need to use for this.


1. Solution must run on a WINDOWS 2012 server with IIS, PHP and Microsoft SQL.

2. Must be fully scripted in PHP.

3. Must be able to be scheduled from the operating system calling a PHP web page.

4. Must use only a Microsoft SQL pre-existing database.

Skills: IIS, Microsoft SQL Server, PDF, PHP

See more: php projects email chatting system documentation, php email support system, php email alerting system, php based email alerts system, pdf php email, implementing email confirmation system php, php email alert system, free php email blast system, ests email test system php, email alert system php mysql, email read attachment pdf php, odt pdf php conversion module, php match system, complete fill form pdf php, php invoice system pdf

About the Employer:
( 2 reviews ) Salisbury, United States

Project ID: #12490614

17 freelancers are bidding on average $439 for this job


Hello! With 98% to 99% completion rate, 900+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page !!)... y More

$1263 USD in 15 days
(879 Reviews)

Dear Employer,I am Software engineer in China. I’m interested in the project you recently posted. I'm a certificated freelancer with over 600 good reviews from clients. I have experienced knowledge in every part of More

$824 USD in 3 days
(552 Reviews)

Hello, Thanks for giving me the opportunity to discuss your project. I am a professional PHP developer with an experience of more than 8 years in creating and customizing PHP based websites, themes and plugins/m More

$1000 USD in 10 days
(161 Reviews)

Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further More

$618 USD in 15 days
(26 Reviews)

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore More

$257 USD in 10 days
(53 Reviews)

Dear Client, Greetings from Flowgica technologies, I have experience with these skills. We do have similar experience doing something similar to yours therefore I am looking forward to discuss and move ahead. please ch More

$175 USD in 4 days
(40 Reviews)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop/web software/macro/b More

$1000 USD in 5 days
(119 Reviews)

HI Greetings!! I am an EXPERT Developer and Designer, having more than 7+ years of experience in PHP, SQL ,WordPress, joomla, Woocommerce, Big-commerce, Shopify, Bootstrap, HTML5, Css3, XHTML, Ajax, JavaScript. More

$222 USD in 2 days
(68 Reviews)

Hello, Hope You are doing well. ARITY INFOWAY is complete web based solutions company. We able to provide web solutions from scratch to hosting . We always go through every point of your projects scope and prov More

$263 USD in 3 days
(121 Reviews)

I have experience witch extracting and filling PDF files. But my valuation is only valid if it is possible to use additional libraries like pdftk. Since use of main php functions to extract information is risky.

$200 USD in 5 days
(10 Reviews)
$155 USD in 3 days
(30 Reviews)

Hi, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements More

$299 USD in 5 days
(5 Reviews)

Hello I am software Engineer with experience in web application using PHP. I read your required work and I am very much sure that I can complete work as per your requirements. I assure you that I will provide you qual More

$200 USD in 3 days
(1 Review)

Hello sir, we are interested to helping you. We ensure to give a best quality website with good performance and responsive attractive UI. Work speaks more than words so please take a look at our company portfolio an More

$35 USD in 3 days
(6 Reviews)

Dear Client, Thank you for reviewing my bid! I read your description very carefully and i want to work with you. I am available for this job right now. I am looking forward to discussing with you about this job p More

$155 USD in 3 days
(3 Reviews)

Hello Sir/ Ma’am, We have pool of dedicated team consisting of certified developers capable enough to handle your project exactly according to requirements and within said time frame. As per shared project de More

$183 USD in 3 days
(2 Reviews)

A proposal has not yet been provided

$611 USD in 25 days
(0 Reviews)