Results 1 to 10 of 10
  1. #1
    Newbie
    Join Date
    January 18th, 2005
    Posts
    11
    Question Datafeed spliter?
    I'm having a problem with some very large feeds that I'd like to split up. Does anyone know where to get a macro for Excel (or a program that does the same) which automatically splits my datafeed, creating a new spreadsheet per category? I've done a lot of looking but haven't come across anything yet that does this.

    Any help would be appreciated.

    -Adam

  2. #2
    Member Core's Avatar
    Join Date
    March 16th, 2006
    Location
    Cornfield, Illinois
    Posts
    95
    I have found that it is easiest to split them up once they are in a temporary database. I just run a query to sort them.

    Core

  3. #3
    Outsourced Program Manager John Jupp's Avatar
    Join Date
    January 23rd, 2005
    Location
    England
    Posts
    1,502
    If you are using MySQL and you're looking to create new feeds out of a single large feed so that you create static pages just covering a specific category then a filter system is not only possible but available, whereby you download multiple copies of the feed and extract the appropriate portion you require.
    Flambi Media Limited - USA/UK/EU Affiliate Management Expertise

  4. #4
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    Los Angeles
    Posts
    4,053
    Look up file splitter on Google, it's right up top. It was just recommended to me by a friend and it works!

  5. #5
    Newbie
    Join Date
    June 3rd, 2007
    Location
    the Netherlands
    Posts
    46
    Quote Originally Posted by John Jupp
    If you are using MySQL and you're looking to create new feeds out of a single large feed so that you create static pages just covering a specific category then a filter system is not only possible but available, whereby you download multiple copies of the feed and extract the appropriate portion you require.
    Why would you downoad multipal copies? If it's in a database you can select the categories and display the products that belong to that category...or am i missing something?

  6. #6
    Outsourced Program Manager John Jupp's Avatar
    Join Date
    January 23rd, 2005
    Location
    England
    Posts
    1,502
    The reason for multiple copies is that one category could be listed on website A and the second on website B and both categories on website C, creating 3 websites from one feed but in 3 separate databases.
    Flambi Media Limited - USA/UK/EU Affiliate Management Expertise

  7. #7
    Newbie
    Join Date
    June 3rd, 2007
    Location
    the Netherlands
    Posts
    46
    I understand. But I do guess you need to manage where you leave what as when the original database gets updated you need to update x other databases

  8. #8
    Outsourced Program Manager John Jupp's Avatar
    Join Date
    January 23rd, 2005
    Location
    England
    Posts
    1,502
    That's right and managing that can either be a simplified task or a real pain but either way, the preparation is always the hard part as that can take a long time as you know.
    Flambi Media Limited - USA/UK/EU Affiliate Management Expertise

  9. #9
    Newbie
    Join Date
    June 3rd, 2007
    Location
    the Netherlands
    Posts
    46
    it does...I am having several projects but one I can't wait to get out there but it takes time.

  10. #10
    Member
    Join Date
    October 6th, 2006
    Posts
    45
    Hi

    It might be a bit late in the day with this suggestion, however, I had this problem so I downloaded the latest trial of MS Excel (3 month trial) this handles over a million rows at one time. Works for me.

    Delboy

  11. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Replies: 4
    Last Post: June 23rd, 2009, 07:39 PM
  2. My first datafeed Website -- Which merchant datafeed do you recommend for a newbie?
    By kingsleys123 in forum Programming / Datafeeds / Tools
    Replies: 27
    Last Post: January 3rd, 2005, 09:25 AM
  3. Datafeed/webmerge VS Php/mysql datafeed
    By Lasthope in forum Programming / Datafeeds / Tools
    Replies: 7
    Last Post: November 25th, 2004, 10:23 PM

Posting Permissions

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