Has anyone successfully set up LinksSql to work with Linkshares Merchandiser Product File. It's in a tab delimited file, and is on a FTP site for download when you become a member.
To use this you would have to update the file daily by FTP, and was wondering the following:
Is there a way to have links automatically access a remote ftp, grab the file, and then update the current file listing. The reason I ask is once you become a linkshare affiliate, you have to pay an additional $250 to set up the Merchandiser Program, and if I can't get it to work, I would be out $250.
Also, is there any other merchandiser type affiliate feed that are out there other than Linkshare???
Thanks,

</not a clue>

It wouldn't be easy. I would imagine you would need to setup a croned script to grab the file, then slice it up, and insert it into LSQL. I doubt you will get this done for free :p Would the data from the delimited file need to go into specific categories, or would the script need to work this out too?

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

That's one of the problems, it would go in different categories. Here's an example off of Linkshares site:

HDR|111|LinkShare Merchant|2001-11-15/02:00:02
10100773|Dimension 2100|Dimension|Computer Hardware||http://click.linksynergy.com/fs-bin/click?id=lMh2Xiq9xN0&offerid=12345.10100773&type=15&subid=0|http://merchant.com/productimage.jpg|http://click.linksynergy.com/fs-bin/click?id=lMh2Xiq9xN0&offerid=12345.10100773&type=15&subid=0&lsnurltype=1|Dimension. 2100 Series Intel. Celeron Processor at 1.1 GHz|128MB SDRAM, 20GB Ultra ATA/100 Hard Drive (7200RPM)||amount||778||11/15/2001|XXX||computers~~desktops~~PCs|21CPW|XXX|"FREE Printer, Scanner, OR Digital Camera!"|||40|USD|||http://ad.linksynergy.com/fs-bin/show?id=lMh2Xiq9xN0&bids=12345.10100773&type=15&subid=0||||||||||
10100786|Dimension 4300|Dimension|Computer Hardware||http://click.linksynergy.com/fs-bin/click?id=lMh2Xiq9xN0&offerid=12345.10100786&type=15&subid=0|http://merchant.com/productimage.jpg|http://click.linksynergy.com/fs-bin/click?id=lMh2Xiq9xN0&offerid=12345.10100786&type=15&subid=0&lsnurltype=1|Dimension. 4300 Intel. Pentium. 4 Processor 1.7 GHz|128MB SDRAM, 40GB Ultra ATA/100 Hard Drive||amount||1128||11/15/2001|XXX||computers~~desktops~~PCs|43ISW|XXX|"FREE Printer, Scanner, OR Digital Camera!"|||40|USD|||http://ad.linksynergy.com/fs-bin/show?id=lMh2Xiq9xN0&bids=12345.10100786&type=15&subid=0||||||||||
10100787|Dimension 4300|Dimension|Computer Hardware||http://click.linksynergy.com/fs-bin/click?id=lMh2Xiq9xN0&offerid=12345.10100787&type=15&subid=0|http://merchant.com/productimage.jpg|http://click.linksynergy.com/fs-bin/click?id=lMh2Xiq9xN0&offerid=12345.10100787&type=15&subid=0&lsnurltype=1|Dimension. 4300 Intel. Pentium. 4 Processor 1.6 GHz|128MB SDRAM, 40GB Ultra ATA/100 Hard.......

This might be better suited for DbmanSQL than Links, anyone interested in tackling this???

Thanks,

</not a clue>