Find Jobs
Hire Freelancers

Capture Website Database Updates - Automated script

$30-250 USD

已完成
已发布将近 10 年前

$30-250 USD

货到付款
Attached is a slide deck illustrating the business challenge for automating a search to find website database fields that were once blank but now are filled. An online database includes the name of individuals to which post mail is sent for marketing purposes. These are Personal Representatives (PR) of Estates and Wills. When a website record is filed, sometimes the individual (personal representative) is not listed on the record. Subsequently, when the PR is added to the record, I want to capture that information, so that a letter may be sent. Responses should indicate understanding of the website and how it maintains records. Then, responses will describe how automation can periodically check the database to see if the PR record has been filled.
项目 ID: 6097553

关于此项目

15提案
远程项目
活跃10 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi, I got your message regarding posting of this project. I completely agree that you might be able to get different solution approaches that you can choose from. From what ever tool that I have built earlier, and understanding the complexity of this website, I know how I should try to solve this business problem. I have detailed below the steps considering the additional project description you have given. - Solution will use the existing tool - The existing tool will be enhanced to write all the records with no PR information to a CSV on a daily basis or what ever frequency you run the tool - The information will contain the unique key (Estate #, County) that can be used to retrieve the record from website - The existing program will be further enhanced to run a routine that will process the records from the CSV file that contains records with missing PR data. This routine will process the missing PR records from earlier runs only - If PR information is updated in website, the record is extracted in full from website as usual and the corresponding entry in the missing PR CSV file will be deleted - This way the CSV file will always contain the missing PR records only Please let me know if this solution works for you. Thanks & Regards Excel Solution
$200 USD 在8天之内
4.6 (5条评论)
3.6
3.6
15威客以平均价$308 USD来参与此工作竞价
用户头像
Hello, I can make this crawler for you with separate PR addon. However you'll need VPS or dedicated server for this script to work, that said it won't be able to run on godaddy's shared hosting.
$255 USD 在15天之内
5.0 (280条评论)
8.7
8.7
用户头像
Hi Can you accept a desktop application? I can work on a demo if you want. Thanks
$888 USD 在3天之内
5.0 (130条评论)
7.6
7.6
用户头像
Hi, I'm expert in web scraping that's why I'm sure you'll be impressed with my work. I have read you project description and I can provide you a program which will periodically check target site and find such updated fields. Each time it will process records it will compare current record state with previous saved state. If we have difference than the field was updated. To be honest such check is pretty easy if we have saved previous check state. I highly recommend to use database (like MySQL) to save data between each run because spreadsheet is not suitable for this. But of course you'll get all results (updated records) in any format you need. We will use database only to save check state. Thanks. Roman
$210 USD 在3天之内
4.9 (386条评论)
7.3
7.3
用户头像
Hello Sir/Madam, I am an expert in web scraping (ranked #1 for Web Scraping https://www.freelancer.com/freelancers/skills/Web_Scraping/). I have done many similar jobs. Ready to start. Thanks, Alex
$357 USD 在5天之内
5.0 (212条评论)
7.2
7.2
用户头像
A proposal has not yet been provided
$631 USD 在5天之内
4.8 (235条评论)
7.2
7.2
用户头像
Dear employer, I've gone through the attached PDF. I can design a tool that will check for whether the field has been populated or not and update the data. I can give you a java program which can be scheduled to run periodically. Please let me know if this works for you. I'm ready to start working on the project. Looking forward to working with you. Awaiting a positive reply from you. Thanking you Shaik Allabakash.
$199 USD 在7天之内
5.0 (52条评论)
5.4
5.4
用户头像
So the main problem is when the data is added in an already made database. Well that is easy. The Java app which I will make will have its own databse offline one. I will fetch the data from the site completely once every day and check whether its database is upto date. The ones which are new will be made into a new database with their ID numbers and the changes in them stored. Please view my profile and see my work. If you are interested hit me up!
$155 USD 在2天之内
5.0 (25条评论)
4.8
4.8
用户头像
Dear Hiring Manager, We can do this job efficiently and effectively Have a great day to you, I am interested to do this job, I have over 15 years experience in the field of web research, data collection, market research, email collection, data-entry in excel, social media research, Facebook marketing and as admin/ virtual assistant. And I am a computer and web savvy, my goals are to make the employer/ customer happy and give better quality of work and I am ready to dedicate time for this project. Thank you Kind regards Heric. P. Note: I am quick, detail oriented and have expert team members with me to do this job and have high speed internet connection and I look forward to hearing from you to start this job soon. Thanks
$133 USD 在4天之内
4.6 (37条评论)
4.6
4.6
用户头像
I have tested the site to retrieve the data you want by record ID. By my experience when dealing with an asp site like this, you can either try to do it the long way or the easy way. The long way being screen scraping, which is a tediously long process which will necessitate going through ALL of the data, or simply get all of the new records for the day, and check ONLY the data that you want to check. I have verified that the latter is possible on this site, so I actually know it is possible to do what you are requesting by the ID of each record individually. I'd be happy to discuss it with you, just contact me. Thanks, Warren
$222 USD 在3天之内
4.8 (7条评论)
3.4
3.4
用户头像
Hi There, How are you doing? I can finish this project within a few days and my price is negotiable. have 8+ years of experience in IT programming and good knowledge in VBA, Access/Excel , SQL and web development tools. Moreover have done a lot of similar scrapping automation projects in the past. You may find my profile overview with the good reviews - couple of projects received some bonus as well :-) have gone through the document - it is pretty details with the problem statement . << It can be done by incrementally checking based on the LAST UPDATE DATE and personal reps field of the record on every run of the script >> Please contact me to discuss further about the requirements in detail and get started. My goal is win-win for both of us to establish a long good standing relationship and gain good reputation. Wish you all success. Thank you .
$250 USD 在4天之内
5.0 (1条评论)
2.6
2.6

关于客户

UNITED STATES的国旗
Columbia, United States
5.0
9
付款方式已验证
会员自4月 26, 2007起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。