Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    January 18th, 2005
    Posts
    50
    How much further manipulation of data do you do after importing the initial feed file?

    For example, does the final DB schema that runs your website mimic the denormalized text files you downloaded? Or do you normalize the data -- ie. break out lists of categories and such into separate tables?

    Thanks

    [This message was edited by TVEye on October 16, 2003 at 12:53 PM.]

  2. #2
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    Utah
    Posts
    1,141
    If you're only using one merchant on your site, I don't see much reason to normalize the tables. I just keep it all in one table and work with it that way.

    A mall-type site may be another matter, though. Depends on how you build it.

    However, I have very few feeds where I don't fix problems that the merchants haven't gotten around to fixing. For example, categories spelled wrong, excessive HTML, etc.

    Michael

  3. #3
    Full Member
    Join Date
    January 18th, 2005
    Posts
    202
    So far I'm trying to incorporate 3 and soon 4 different datafeeds into one web site. They are all related and have many of the same product categories. They're just organized differently. I need to make a lot of changes so I'll have similar items in the same area.

    I did break out the main category into a separate table, that way I can add other fields to it. Those fields will change the way the categories are displayed on the page.

    I don't see any other reason to normalize the data in the feeds. There aren't that many fields in the tables and they are very relevant to each other.

    Don't make it more complicated than it needs to be.

    SJohnson@NO_Spam_ClickMagazine.Net
    www.ClickMagazine.Net

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. HELP! Affilliate Data feeds Don't Have All Data Needed?!
    By garyaggregator in forum Programming / Datafeeds / Tools
    Replies: 6
    Last Post: July 22nd, 2011, 04:40 PM
  2. Replies: 2
    Last Post: October 9th, 2010, 08:59 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
  •