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

İptal Edildi İlan edilme: 7 yıl önce Teslim sırasında ödenir
İptal Edildi Teslim sırasında ödenir

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.

Requirements:

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.

IIS Microsoft SQL Server PDF PHP

Proje NO: #12490614

Proje hakkında

17 teklif Uzak proje Aktif 7 yıl önce

Bu iş için 17 freelancer ortalamada $439 teklif veriyor

rajeshsonisl

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 https://www.freelancer.com/u/rajeshsonisl.html !!)... y Daha Fazla

$1263 USD in 15 gün içinde
(879 Değerlendirme)
8.5
Yknox

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 Daha Fazla

$824 USD in 3 gün içinde
(552 Değerlendirme)
8.7
Shopify

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 Daha Fazla

$618 USD in 15 gün içinde
(26 Değerlendirme)
6.9
prashushinde9

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 Daha Fazla

$257 USD in 10 gün içinde
(53 Değerlendirme)
7.1
mmadi

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 Daha Fazla

$175 USD in 4 gün içinde
(40 Değerlendirme)
6.9
arityinfoway

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 Daha Fazla

$263 USD in 3 gün içinde
(121 Değerlendirme)
6.8
SebaSWebDev

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 gün içinde
(10 Değerlendirme)
5.2
cracken

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 Daha Fazla

$299 USD in 5 gün içinde
(5 Değerlendirme)
4.0
khannouman

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 Daha Fazla

$200 USD in 3 gün içinde
(1 Yorum)
3.4
syncnologies

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 Daha Fazla

$183 USD in 3 gün içinde
(2 Değerlendirme)
0.5
a830144

A proposal has not yet been provided

$611 USD in 25 gün içinde
(0 Değerlendirme)
0.0