Closed

Web Automation needed

I need to automate some online work. I have a used car dealership. I receive credit application online from a form on my website where customer fill out the needed information to apply for an auto loan for the car they would like to buy. Once customer submit the application, I get an email with a txt file attached. TXT has the info the customer submitted. Then I log in to a third party website, to which I have my own log in. I fill the customer information manually then I choose the leander I want to send the application to.

What I need is:

I need to convert the txt to a csv.

(I can do that manually if I have txt attachment in google drive by importing txt to spreadsheet then from google sheet I can download it as csv.) I convertit to csv because later I want to fill the bank form with this data to submit to the lender.

But I don't want to manually do that. I want a code to convert it to csv automatically as soon as I get the email!.

(Once that is done , I need to automate the process of submitting it to the bank.)

I want a code or way to log in automatically to the website I use to submit the leander. when I log in, i want to go the a new application page. In that page, there is a form. I want the code to feed the customer information to it. It's a 4 pages form. Fill up the first page then click next then it takes to the send page ....... till I fill up the 4th one a click select lender. Then it takes me to a page has the leander I deal with. I choose the leander I want to send the application to.

All the information need to fill out the form in the txt file I get in the email.

I need that to be done automatically with my doing any manual work.

I have been reading on how that can be done because I kind of know where to start, I would just need to do a lot of research to get it done since I don't really know exactly how.

If it helps I will share what I came up to do it. You can use that way or if you can think of any other way as long as it gets the job done!

I would create a new gmail account and forward all the online application I get to it. Then, through a google script, save the attachment to Google drive as a .txt. Through Google sheets script, import the txt file to a spreadsheet and save it as csv.

Using Autoit, automate the login to the website where i can submit the customer info to the lender. Once I log in, it would go to the new application page where the the first page of the form is. then will fill out the form using the date from the csv file and click on next until goes through all the pages and clicks next to go to the page where the list of the lenders are. csv fill has a unique value to represent each leander. Then a laender will be chosen and submitted to that bank.

** you can skip the whole transfire from gmail to Google Drive the from txt to csv if there is a better way that you know.

I have gotten in touch with a local compony and a company online who can do the job just how I want it. A friend of mine told not to sign up right away before looking through here and see may be some else has different way to get the job done.

I have more and more work I need to done and a build up on top of this project. the up coming work would include, just to name some, web programming, mobile creation and design, cloud hosting and backups, .

I'm looking for a long term relationship. Once this project is done, more work will provided.

Documentation is needed in case I need to outsource some work somewhere else. providing a timeline and sticking to it!

A txt file would be provided and more info that needed after we chat about it to make sure we are not wasting each other time.

Thank you,

Mike

Skills: PHP, Software Architecture, Test Automation, User Interface / IA, XML

See more: who to design web page for mobile, who can you outsource research, where to start programming and web design, where to start programming, where can i outsource research, what really needed when i want to be a design, what is web research job, what is web programming, what do i need to start php programming, website design outsource online, website design automation, website 2016 top web design, web research outsource, web programming using php, web programming online job, web programming online, web programming company, web programming c#, web programming by php, web page mobile design

About the Employer:
( 6 reviews ) Sacramento, United States

Project ID: #9649456

52 freelancers are bidding on average $570 for this job

A2Design

Hello, We are A2 Design , a Russian-Canadian web development company. We're a full-cycle team of LAMP developers (Linux, Apache, MySQL, PHP) with 14 years of experience. We can build the necessary functionality f More

$721 USD in 10 days
(109 Reviews)
8.6
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 More

$526 USD in 3 days
(895 Reviews)
8.5
KESHAVINFOTECH

Hi Thanks for your valuable time. :-) Please check below points : 1. I need to automate some online work. I have a used car dealership. I receive credit application online from a form on my website where custo More

$750 USD in 30 days
(650 Reviews)
8.6
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$721 USD in 20 days
(409 Reviews)
8.3
manpreet

Dear Mike, I can make this website as required in PHP and MySQL. Please respond so we discuss further. Waiting for reply, Manpreet Singh

$1500 USD in 30 days
(257 Reviews)
8.4
mistersoft

Hello! I am PHP/MySQL programmer with over 10 years experience in automating web-jobs. I can recommend other solution to you ) I can do script on your server (where you have form filled by customer) and there More

$250 USD in 3 days
(474 Reviews)
7.9
hwanghendra

Hi Sir/Madam. Ready to start. Thanks. Our slogan :  ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **

$736 USD in 10 days
(454 Reviews)
7.5
phpdevindia

Hello Mike, This is Prasun from Webgen Technologies. I did had a chance to gone through your project scope and understand your point of view and needs. What I have understood that you are going to have a platform wh More

$1789 USD in 35 days
(168 Reviews)
8.0
extreamcode

I can assist you with this Project. Please reply back so we can discuss. Find my portfolio at: [login to view URL] Should you have any questions please feel free to ask. Looking forward to hear More

$684 USD in 30 days
(70 Reviews)
7.5
pytho

Hi, Please tell me what is your deadline for this project? I am managing a Web Design Agency located in Romania and I am really interested to help you complete your PHP website. Based on your response I will be able t More

$799 USD in 15 days
(47 Reviews)
7.1
gangabass

I'm one of the best web automation experts here with HUNDREDS of completed projects that's why I'm sure you'll be impressed with my work. I can create the program which will automate whole process. The program will More

$263 USD in 3 days
(352 Reviews)
7.0
JoomlaVogue

Hello Sir, First of all, we would like to tell you how we will initialize the project with you. We insist to follow these steps before you award the project to us: - We (technical team) will review the job and More

$515 USD in 10 days
(109 Reviews)
7.6
alifinteractive

Dear client, We have a great team of expert coders and responsive website designers in New Delhi [login to view URL] have many satisfied clients all over the [login to view URL] already have successfully launched many eCommerce,blog, socia More

$600 USD in 15 days
(93 Reviews)
7.3
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & More

$515 USD in 10 days
(48 Reviews)
6.9
$350 USD in 20 days
(51 Reviews)
6.4
ydanila

Hello, my name is Yakov. I ame experienced software developer. Top 7% by C# tests. Previously I completed projects which required authorizing and submitting forms. So I think I can help here too. Everything depen More

$622 USD in 10 days
(18 Reviews)
6.3
shreeyait

Hello Sir, Hope you are fine there. We are having good experience with CorePHP projects and the reason we came across here to give the best output to your project with supreme quality. We have develope More

$530 USD in 15 days
(67 Reviews)
7.1
awaise17

This kind of automation is possible in various ways. One you have mentioned already is Autoit. The others could be directly writing a script using python or if your site is in WordPress, then it would be the best. We'l More

$700 USD in 10 days
(62 Reviews)
6.5
afifaumersl

Hi there, I am confident that we can deliver what you are looking for. We have experts on board with extensive level of creative designs and development experience. Our dedicated experienced team will stand beside y More

$1578 USD in 35 days
(35 Reviews)
6.6
dobreiiita

Hello I am Java expert and interested in this project. I have reviewed your requirements for automation, I propose a selenium based solution for you needs. It will cover all your needs and will be object oriente More

$631 USD in 10 days
(132 Reviews)
6.5