Csv regnow integration

[cheetahscripts]

Looking for help to set up an automatic database upload via a regnow url
it will put all links into the correct categories once a month through cron.

Or just a custom import script i can run manualy to import a csv into the correct categories.

Anyone intrested please contact webmaster at cheetahscripts . com

The Largest Script Directory On The Net!

[Bruceper]

I think it would help if you posted a sample of the csv (say 3 lines) along with the field names and the fields you require.

I did something similar with a site but did it all manually. Since the csv only changes every few months for that data feed I'm comfortable doing it manually.

You can see that example at Woodworking tools, plans and products. The site is unfinished cosmetically but you can see what I've done with the database and the customization of the script so far.

[cheetahscripts]

You can look at the examples here oneNetwork Affiliate Datafeed Tool

What ever way is easyest to get the data to follow my category structure.
easiest and quickest.

Thanks

[Bruceper]

Out of the following fields, which ones do you want to display?

ProductID,ProductName,VendorID,VendorName,VendorSu pportEmail
VendorHomepageURL,USDPrice,EuroPrice,GBPPrice,AUDP rice,CADPrice
CategoryID,CategoryName,ShortDesc,LongDesc,TrialUR L,DirectPurchaseURL
Platform1,Platform2,Boxshot,Screenshot,Icon,Banner 125x125,Banner468x60
Banner120x90,Banner728x90,Banner300x250,Banner392x 72,Banner234x60
Banner120x240,Banner120x60,Banner88x31,OtherImg1,O therImg2,OtherImg3
TextLink1,TextLink2,TextLink3,PromoText,EncodingCh arSet,Commission,Add_Date

It looks like you're going to have to use additional fields no matter what, even if you only wanted to include the DirectPurchaseURL. Lots of those other fields could be incorporated in the details pages for sure and some of them in the browse page as well. A bit of customization but not impossible.

The issue is automating the CSV and I'm not good at that, but I can convert it manually.

[cheetahscripts]

Only the details that indexu has on the listing and detail page, the main thing i am looking for is to import the database so the products go into the correct categories.

Thanks

[Bruceper]

After a bit of checking and playing, I can do this for you.

I'd provide a complete category dump with all fields.

Links would be done this way
link_id category_id title url description

link ID would not use the numbers they provide, but this doesn't matter at all as link_id is only used to number the links in indexu.

There are issues with product images (not all of them have one). So if you want to use product images let me know as this will require more editing of the database and it may require a change in indexu depending on the image size used.

I'm willing to do this one time for $25.00 Canadian. If you're interested let me know and I'll PM you a link where you can pay by credit card (I don't do paypal). Files will be sent to the address you use at payment time.

I'll see about working on a script to automate these kinds of processes but I can't guarantee anything.

[inspireme]

you check if an image exists using smarty, to check if a field is empty, and then to check if a field needs an image to display you could do something like this

<%if $image1 %>
<!-- image is empty-->
<%else%>
<img src="<%$image1%>">
<%/if%>

oh, and where about us in canada are you? im leaving for cananda in 2 weeks time and staying for 2 months

[Bruceper]

I'm located in Winnipeg, hope you enjoy your trip here.