sager29 Posted May 4, 2010 Share Posted May 4, 2010 Hi, I'm using MySQL 5.0 and am importing a CSV spreadsheet that contains URLs in each line. I'm also using phpMyAdmin. The field containing the URL is varchar. The import goes fine except that my URLs go from this: http://www.greenwichworkshop.com/images/gallery/images/prints/Bean/AB00052lg.jpg to this: http:\www.greenwichworkshop.com/images/gallery/images/prints/Bean/AB00052lg.jpg I would just erase the "http://" part in the spreadsheet but its thousands of lines long, and even with a find and replace command, it just adds another step to my process which will have to be re-uploaded every month. Any suggestions on how I can keep the "http://"? Thank you in advance Quote Link to comment https://forums.phpfreaks.com/topic/200718-importing-a-csv-with-urls/ Share on other sites More sharing options...
fenway Posted May 4, 2010 Share Posted May 4, 2010 Then your import is busted. Quote Link to comment https://forums.phpfreaks.com/topic/200718-importing-a-csv-with-urls/#findComment-1053292 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.