The project is as follows:
1. Replace the flat file storage method with storage in mysql.
2. Revise the existing code to (a) connect to a mysql database, (b) write new forum posts to a mysql table, and (c) write profiles to a mysql table.
3. Revise the existing code to read all forum menus, forum posts, and profiles from the mysql table.
4. Scrape approximately existing 800,000 flat files and save the data to a mysql table. All files are in exactly the same format as the one attached.
This is a fairly complex project and I do not expect you to estimate it based on the information posted here. Please examine the attached files and PM me with your qualifications and any questions. I will send the complete perl code to a subset of interested programmers, as well as a link to see the live forum. Based on that information I would like a bid.
I will award the project to a programmer with strong communication skills, experience in perl, and a clear understanding of what needs to be done.
Expert in doing this sort of stuff... No upfront needed, all payments through Milestone Payment (Escrow).. Online 16 Hours a day, Can start right away.. Thanks
I have created many data base loaders in the past, including some that loaded over 100K files per day. Modifying the existing code should also be accomplished easily.
I have done many data imports in the past using perl or php-cli. From millions of CDRs (Call Records for a telephone exchange) to insurance contracts.
Although it would be easier if the files were in a txt format (csv, txt etc) and not in doc format.
I am a perl programmer. Worked on such projects number of times.
Here are my understandings :
Current storage of flat files is to be databased through perl scripting & this process is to be automated through cron job. Eliminating manual intervention & track records through properly designed database.