Results 1 to 10 of 10
  1. #1
    Newbie
    Join Date
    January 18th, 2005
    Posts
    14
    Which datafeed format results in the fewest errors: Tab, CSV, or Pipe?
    I was wondering which data feed format resulted in the least errors, in terms of MySQL and such.

    I would have though that Pipe would be best, since Pipe characters are rare; but the CJ transfer guide says that Pipe actually gives the most errors.

    What do most people use?

  2. #2
    Full Member markschok's Avatar
    Join Date
    January 18th, 2005
    Posts
    269
    I prefer pipe myself for the same reason, but I'd much prefer any format that works. Of course the only problem here is when a merchant includes the seperator in a product description and it breaks the whole feed. I noticed a post yesterday for a PHP script to 'mysql' your feed with error handling built in and have seen some other online services for feed cleaning.

  3. #3
    Newbie
    Join Date
    January 18th, 2005
    Posts
    14
    Thanks for the response.

    Do you by chance remember which topic the tool you mention was in?

    My ideal tool would be a server-side PHP tool where you can automate it (like with a cron job) and it would download and clean the feed...anyone know of anything like that? (commercial products are fine)

  4. #4
    Animal Lover
    Join Date
    January 18th, 2005
    Location
    oz
    Posts
    1,210
    I vaguely remember ChrisWSO mentioning that he had something like a feed cleaner but I never looked into it, not sure if it's what you are after.

    Oscar

  5. #5
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    If you're using PHP and MySQL, then you probably want to clean the feed on the fly. There are lots of threads here that give info about doing that. Do a search, you'll find it.

    The Cleaner that Chris has, is an app that one downloads and is used for cleaning up files you get from the merchant prior to utilizing it on your site (via PHP MySQL), or used to create static pages with something like WebMerge.

    Many here using PHP, have written scripts to clean-up feeds, perhaps they will share the info with you.

    Fred

  6. #6
    Affiliate Manager AmandaM's Avatar
    Join Date
    January 18th, 2005
    Location
    PA
    Posts
    204
    Anyone who wants to try AMWSO's free tool, you can download it here:

    http://www.amwso.com/affiliate_tools.php

    Works pretty well, IMO.
    [size=2]Amanda Moralis
    The Eastwood Company
    [email="affiliates@eastwood.com"]affiliates AT eastwood.com[/email]
    [url="http://www.eastwood.com/jump.jsp?itemID=34&itemType=CONTENT"]Sign-up Link[/url]
    [/size]

  7. #7
    Full Member markschok's Avatar
    Join Date
    January 18th, 2005
    Posts
    269
    here's the tools I could find for cleaning, exporting to mysql and some other stuff

    http://www.amwso.com/affiliate_tools.php - AMWSO's downloadable free tool
    http://home.hccnet.nl/s.j.francke/t2t/text2table.htm 2 csv handling programs here
    http://www.feedprocessor.com/ - online tools
    http://www.phpmill.com/feedparser/ - php script Datafeed-to-MySQL, also has error correction for feeds

  8. #8
    Newbie
    Join Date
    April 26th, 2005
    Posts
    27
    Where can I learn how to use datafeed from scratch? I have no clue?

  9. #9
    Newbie
    Join Date
    April 29th, 2005
    Posts
    9
    If a feed is going to contain errors, I like it to be CSV. Can open in excel or wordpad and correct errors in each b/c excel will remove quotes.

    This tool will test up to 20 rows of a feed for errors.
    http://www.phpmill.com/feedparser/demo.php

  10. #10
    Newbie
    Join Date
    January 18th, 2005
    Posts
    14
    I have seen the AMWSO feed tool previously, but that seems like something you have to use on your PC, rather than on the server.

    This phpmill script seems promising though. Thanks all for sharing that.

    Quote Originally Posted by Freebird
    Where can I learn how to use datafeed from scratch? I have no clue?
    Hmmm...well I personally don't know of any tutorials or anything. However the Data Feed forum (http://forum.abestweb.com/forumdisplay.php?f=193) should have some good resources. Basically you should know some server-side scripting language (PHP, ASP) and SQL. There are tools out there that can do a lot of the work for you (like Webmerge, which has a forum here too). I've never used any of them myself but they are popular.

  11. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Format Recommendation (tab/pipe/etc.)
    By meleemel in forum WebMerge (Fourthworld.com)
    Replies: 4
    Last Post: January 13th, 2006, 09:35 PM
  2. Changing Pipe delimited to CSV or tab
    By westgroup in forum Programming / Datafeeds / Tools
    Replies: 13
    Last Post: June 9th, 2005, 02:10 AM
  3. csv to pipe
    By admad1 in forum Programming / Datafeeds / Tools
    Replies: 3
    Last Post: June 4th, 2005, 07:59 AM
  4. Pipe delimited to tab
    By bbb in forum Programming / Datafeeds / Tools
    Replies: 10
    Last Post: August 30th, 2004, 06:03 AM
  5. tab or pipe delimited format in a .csv
    By hershey in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: July 17th, 2002, 08:52 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
  •