1
javelin
RSS & ebay
  • 2006/8/4 0:12

  • javelin

  • Not too shy to talk

  • Posts: 160

  • Since: 2004/3/11


I'm trying to link ebay rss feeds onto my site.

I've tried xmline and planet but both store the rss line as a 255 varchar unfortunately the rss url from ebay, depending on the search parameters, can be over 300.

The end result is I can only run a rss if the rss url is under 255 characters.

Is it possible to modify the table to accommodate longer rss url's, as the max for varchar is 255
or is there another way of skinning this cat?
I might not be very clever but I can lift heavy weights!

2
javelin
Re: RSS & ebay
  • 2006/8/4 15:35

  • javelin

  • Not too shy to talk

  • Posts: 160

  • Since: 2004/3/11


An example rss feed I'd like to use is

http://rss.api.ebay.com/ws/rssapi?FeedName=Search
Results&siteId=3&language=en-GB&output=RSS20&copagenum
=1&fss=0&saprclo=&fscl=1ZQ1&fsop=1&fsoo=1&saslop=1&saslt
=2&catref=C6&coaction=compare&sorefinesearch=1&sacur=
0&saaff=afdefault&ftrv=1&ftrt=1&sacat=98952&from=
R10&fcl=3&ga10244=10425&satitle=%28%22sailing+dinghy
%22%2C+cleat%2C+block%2C+pulley%2C+sail%2C+sails%2C+
rope%29+-strand+-rya+-ski+-stainless+-anchor+-mooring
+-yachts+-yacht&saprchi=&coentrypage=search&frpp=200

(I've soft returned the above so it would fit)

some 470 characters long.
the Url is also very long at 517 Characters,

http://search.ebay.co.uk/search/search.dll?sofocus=
bs&sbrftog=1&fcl=3&fss=0&fscl=1&fscl=1&frpp=200&
sorefinesearch=1&catref=C6&saslt=2&sacur=0&from=
R10&saslop=1&saaff=afdefault&satitle=%28%22sailing
+dinghy%22%2C+cleat%2C+block%2C+pulley%2C+sail%2C+
sails%2C+rope%29+-strand+-rya+-ski+-stainless+-
anchor+-mooring+-yachts+-yacht&sacat=98952%26catref%
3DC6&bs=Search&fsop=1%26fsoo%3D1&coaction=
compare&copagenum=1&coentrypage=search&sargn=-
1%26saslc%3D3&sadis=200&fpos=nr34+7hu&ga10244=
10425&ftrt=1&ftrv=1&saprclo=&saprchi=


There must be a reader that can use this rss otherwise why would ebay generate it?

I guess I could put the page in an I-frame but would really like the rss to work.
I might not be very clever but I can lift heavy weights!

3
gestroud
Re: RSS & ebay
  • 2006/8/4 15:50

  • gestroud

  • Home away from home

  • Posts: 1538

  • Since: 2004/12/22


You have me wondering if it's possible to create usable RSS urls on TinyUrl.com. It may be worth a try.

Another possibility is the new version of the RSS Center .03 module at Happy Linux.

You'll also need to download another module at the site. He's creatively called it the Happy Linux module

Make sure to go through the language files. The developer is a whiz at module creation, but there are quite a few typos.

4
javelin
Re: RSS & ebay
  • 2006/8/4 16:15

  • javelin

  • Not too shy to talk

  • Posts: 160

  • Since: 2004/3/11


gestroud you are a complete Star

TinyUrl.com worked a trick,

Happy bunny now

I might not be very clever but I can lift heavy weights!

Login

Who's Online

138 user(s) are online (99 user(s) are browsing Support Forums)


Members: 0


Guests: 138


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits