Automatic import of text file into mySQL table
$30-250 USD
Paid on delivery
I am building a WordPress website for a recruitment agency. They have an internal system that exports a text file ([login to view URL]) by FTP to a location on the web server. The file contains a number of fields separated by pipes (|).
I need the contents of this text file to be imported into a WordPress mySQL database table *as soon* as the file lands on the server. Each time a new file hits the server (a file of the same name overwrites the existing one) the old table should be truncated and the new information inserted.
As well as this importation process, a new table must be created called wp_jobs, using the relevant data types to store the information. The names of the columns required are:
• JobID
• SysKey
• Job_Title
• Consultant
• Consultant_Email
• Job_Location
• Job_Term
• DisplayRate
• HoursPW
• Category
• Job_Description
• StartDate
• EndDate
• ContractDuration
• Salary
• HourlyRate
• Area
• International
* An example of the text file is attached.
* I am using Bluehost for web hosting and cpanel access will be granted to the winning bid.
* Please provide details of how you would achieve the importation.
Good luck!
Project ID: #1458451
About the project
20 freelancers are bidding on average $116 for this job
Got Expertise in doing this sort of stuff... All payments through Milestone Payment (Escrow)... Online 16 Hours a day, Can start right away.. Thanks
We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.
Hello, allow me to help you. I have worked on many projects with PHP + MYSQL, Joomla CMS (many projects), and base knowledge of another Frameworks. So I can do this job for you. Please contact with me and we will w More
Dear Sir , I am a php developer for 6 years. Your statements so clear that I can figure out what need to. Hope to working with you.
Hi, I checked the functionality of your web hosting. In the past, I was creating similar programs. I send my suggestions to the PW.
Hello, I think it will be easy to do. I'll write about how to do this in PMB. Best regards, George
