PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > General Forums > General Discussion

General Discussion General use discussion forum for PhotoPost products.

Reply
 
Thread Tools Rating: Thread Rating: 24 votes, 5.00 average. Display Modes
Old February 2nd, 2006, 08:19 AM   #1
sailnet
Member
Verified Customer
 
Join Date: Jan 2006
Location: North East, MD
Posts: 40
need someone to write php data conversion

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.
sailnet is offline   Reply With Quote
Old February 2nd, 2006, 10:45 AM   #2
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,415
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.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old February 2nd, 2006, 11:21 AM   #3
sailnet
Member
Verified Customer
 
Join Date: Jan 2006
Location: North East, MD
Posts: 40
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 is offline   Reply With Quote
Old February 4th, 2006, 08:02 AM   #4
sailnet
Member
Verified Customer
 
Join Date: Jan 2006
Location: North East, MD
Posts: 40
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 is offline   Reply With Quote
Old February 6th, 2006, 02:51 PM   #5
sailnet
Member
Verified Customer
 
Join Date: Jan 2006
Location: North East, MD
Posts: 40
chuck - did you get my email this time?
sailnet is offline   Reply With Quote
Old February 6th, 2006, 03:25 PM   #6
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,415
yes I did although that email seems to be on some custom thing other than this. Your name is luke right?
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old February 6th, 2006, 03:38 PM   #7
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,415
Nevermind your Jeff and you where in my trash bin
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old February 6th, 2006, 03:41 PM   #8
sailnet
Member
Verified Customer
 
Join Date: Jan 2006
Location: North East, MD
Posts: 40
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.

sailnet is offline   Reply With Quote
Old February 6th, 2006, 04:08 PM   #9
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,415
Nope your about what a half hour or so from me maybe 45 mins
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old February 6th, 2006, 04:12 PM   #10
sailnet
Member
Verified Customer
 
Join Date: Jan 2006
Location: North East, MD
Posts: 40
Joppatowne is about 40 minutes from me... we're down there a lot during the summer.
sailnet is offline   Reply With Quote
Old February 6th, 2006, 04:16 PM   #11
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,415
30 minutes it is then cause I am in abingdon
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
write ti this forum bambrik Before You Buy 0 April 23rd, 2005 05:51 PM


All times are GMT -5. The time now is 10:22 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.