need someone to write php data conversion

sailnet · February 2nd, 2006, 08:19 AM

I need someone to convert data for me. I have review data in a similar format to reviewpost and I'll pay $200 for someone to write php code to convert the tables into reviewpost tables.

you should have written conversions before. The data is from a sql server database but I've converted it into mysql format and converted dates to unix timestamp format and the tables to be converted are right in the reviewpost database....

I need this done asap.

pm me if interested.

Chuck S · February 2nd, 2006, 10:45 AM

Your just trying to do a direct read from one database and write the information to another?

That would not cost $200.00

email me and let me know the fields of this one mysql table and what those contain so we know where we are throwing info.

sailnet · February 2nd, 2006, 11:21 AM

check - I'll get it together for you. I am running out of time and need it done. I just finished the classfieds conversion and theremore data manipulation that needs to occur in the reviews and I have to work on the aesthetic portions of the site - I will be in touch later today when I get more stuff done.

sailnet · February 4th, 2006, 08:02 AM

by the way chuck - thanks to the wonders of microsoft access and odbc connectors I was able to import the data from sql server into an ms access table then make some changes and export it to a mysql table for importing and manipulation. the file structues and foreign keys were quite different not to mention sql server date/time stamps vs. unix time stamps. I was able a to write an access function to convert from sql date format to unix time stamp format while converting to data that I have forwarded to you.

thanks

sailnet · February 6th, 2006, 02:51 PM

chuck - did you get my email this time?

Chuck S · February 6th, 2006, 03:25 PM

yes I did although that email seems to be on some custom thing other than this. Your name is luke right?

Chuck S · February 6th, 2006, 03:38 PM

Nevermind your Jeff and you where in my trash bin

sailnet · February 6th, 2006, 03:41 PM

Quote:

Originally Posted by Chuck S

Nevermind your Jeff and you where in my trash bin

so...are we set? I did my best to get the data as normalized as possible before ceating the additional tables and zipping up the db. I see you're not too far down the road from me.

Chuck S · February 6th, 2006, 04:08 PM

Nope your about what a half hour or so from me maybe 45 mins

sailnet · February 6th, 2006, 04:12 PM

Joppatowne is about 40 minutes from me... we're down there a lot during the summer.

Chuck S · February 6th, 2006, 04:16 PM

30 minutes it is then cause I am in abingdon