Results 1 to 6 of 6
  1. #1
    Newbie
    Join Date
    January 18th, 2005
    Posts
    22
    Hi everyone,
    I'm pretty new to this stuff.
    How do you merge two CSV? For example, Bill Bam which as two - or others which have five or even six csv files. How do you merge them? I'm using excel....
    And then, most importantly, how do you categorize them within webmerge so that you don't have fifty million index pages??

    I'm getting very confused!

    Thanks all....

    Claudia

  2. #2
    Affiliate Miester my2cents's Avatar
    Join Date
    January 18th, 2005
    Location
    far far away....
    Posts
    2,161
    I use Navicat and do it on my server...

    Navicat allow you to add to a table.. so I load the files one at a time into my mysql database table,,,

    Another thing I like about Navicat... is it strips out mal formed lines with a csv file...
    so only thing laoded onto the server are valid entries..

    Joe
    ++++++++++++++++++++++++++++++++++++++++++
    that's my2cents, 'cuz I'm a legend in my own mind....

  3. #3
    Animal Lover
    Join Date
    January 18th, 2005
    Location
    oz
    Posts
    1,210
    Did you apply for ftp access? Some of the feeds from SAS have ftp access and you can then download the feed as one file instead of the multiple ones that occurs when you download straight from SAS (because they limit each page to 1000 products). Otherwise I usually just copy and paste the individual files into the one. I believe with BillBam you can get ftp access so it makes life alot easier.

    Can't help you with webmerge - never used it myself - I use php and mysql to manage feeds.

    Oscar
    My DataFeed Scripts - php datafeed scripts for your site
    Shareasale datafeed scripts - to display Shareasale datafeeds
    Linkshare datafeed scripts - for multiple Linkshare merchants

  4. #4
    Member
    Join Date
    January 18th, 2005
    Location
    Australia
    Posts
    118
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by oscar:
    Did you apply for ftp access? Some of the feeds from SAS have ftp access <HR></BLOCKQUOTE>

    I applied to two of the SAS and didn't get a reply. The AcmeHardware feed in 33 parts is a dog's breakfast to merge and clean, so it's in my too hard basket for now. What is the criterion for these merchants to "approve" you for ftp access?
    [URL=http://www.netmagellan.com/]Net Magellan blog[/URL]

  5. #5
    Animal Lover
    Join Date
    January 18th, 2005
    Location
    oz
    Posts
    1,210
    Not sure about requirements to be approved - yes that AcmeHardware feed is very large. I can't remember how long it was before they approved me...didn't seem that long. Perhaps drop an email out to them to try to 'speed' things up a bit.

    cheers,
    Oscar
    My DataFeed Scripts - php datafeed scripts for your site
    Shareasale datafeed scripts - to display Shareasale datafeeds
    Linkshare datafeed scripts - for multiple Linkshare merchants

  6. #6
    Member
    Join Date
    January 18th, 2005
    Location
    Australia
    Posts
    118
    Thanks. My approval finally came through, but I'm none the wiser if my third request asking for some kind of response either way did it.

    It is quite a mess, even as a whole file. It seems that they import an HTML file to CSV and the bulleted items remain as &lt;li&gt;, causing lines to break. Finally cleaned it up.
    [URL=http://www.netmagellan.com/]Net Magellan blog[/URL]

  7. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. What do you think of the merge?
    By Rhia7 in forum Midnight Cafe'
    Replies: 14
    Last Post: November 5th, 2007, 03:57 AM
  2. Topic Merge?
    By WiredPages in forum Commission Junction - CJ
    Replies: 1
    Last Post: March 13th, 2005, 06:42 PM
  3. web merge
    By walleyewarrior in forum WebMerge (Fourthworld.com)
    Replies: 64
    Last Post: April 21st, 2003, 01:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •