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!
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 work together.
Thanks.
Automation is what I love doing the best. Have good experience in scripting such stuff and handling databases.
# Will provide clean and efficient solution.
# Will take care of the disk space used in the process of data dumps and restores.
Happy to assist. Thanks.