Welcome to WebmasterWorld Guest from 22.214.171.124
Forum Moderators: open
my main problem is that the url is missing from the cvs for excel I downloaded from phpmyadmin.
I have 4000/5000 items all with different urls and to add it manually is a problem.
only the item number is listed.
the correct url of the product would be the url plus the item number.
it seem I must master excel or hire somebody.
personally, i use microsoft bCentral, and we are able to download a csv file, but it doesn't have the urls either, so what i do is:
1. go into frontpage and pull all the product pages into a new page, which creates links to each page...
2. go into HTML view, and find all the <a href> tags, which link to the individual pages (not external links, but i'll get to that in a sec)... then i use the find/replace function to remove all data except the partial urls.
3. copy the partial urls into a new excel workbook, and again use the find/replace function to add in the first of the web address.
voilá, you have all the urls in an excel workbook, now you just copy/paste the column into the csv file, and save the properly formatted file as a tab-delimited file...
personally, it takes me about 2-3hours to go from the csv file i am able to download from bCentral to the properly configured and formatted tab-delimited file that froogle wants...
if you have any further questions/clarifications on the subject, don't hesitate to post them here, or send me a sticky mail.
there is not problem to add an url. The problem is when you have to do it to 4000/10000 items all with different urls.
I'm looking for a way to do it inside excel to all the items at once