FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 how to use FeedForAll? View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.This topic is locked: you cannot edit posts or make replies.
Author Message
lustrousjewellery



Joined: 24 Jun 2008
Posts: 2

PostPosted: Tue Jun 24, 2008 9:46 am Reply with quoteBack to top

Hi there

I downloaded FeedForAll and was following the instruction...and got confused, we have hundreds of products on the website, do I have to manually input every single product detail to creat the RSS feed? ;o

Can FeedForAll automatically get the product details on our website for the feed? or am getting things wrong? how should I produce a RSS feed including ALL the products/URLs on our website?

Thanks in advance
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2806

PostPosted: Tue Jun 24, 2008 5:03 pm Reply with quoteBack to top

FeedForAll is an RSS feed creation tool. You will need to use it to create an RSS feed manually.

If you data is in an SQL database on your webserver, then there is a chance that our SQL2RSS php script would work better for you.

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
lustrousjewellery



Joined: 24 Jun 2008
Posts: 2

PostPosted: Wed Jun 25, 2008 4:43 am Reply with quoteBack to top

Thanks for your answer, our database is on an SQL Server, can you please explain in a bit more detail 'how your SQL2RSS php script would work better for me'?

Will that script automatically get the product information from our database? and is it still going to create an RSS feed for us? where is this product?

Thank you
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2806

PostPosted: Thu Jun 26, 2008 12:12 pm Reply with quoteBack to top

Here are the instructions for SQL2RSS, perhaps it will help:

Code:

SQL2RSS v3.x Instructions

Contents
  Introduction
  Installation
  Channel Template
  Item Tempalte
  Usage

Introduction:
=============

SQL2RSS allows easy creation of RSS 2.0 feeds from your existing database or one created by RSS2SQL.  SQL2RSS has 2 modules.  sql2rss_install.php will create the database configuration file.  sql2rss.php is used to build configuration files and to create the feeds.


Installation:
=============

1) Unzip the contents of the sql2rss.zip file, and copy the extracted files to a folder on your webserver.  The folder should be accessible from the Internet, like your regular webpages.  In fact, the destination folder could be the same folder that you keep your webpages in.

2) In your browser, enter the full URL to the location of the sql2rss files, and run the install module (rss2sql_install.php).

Example: http://www.feedforall.com/sql2rss_install.php

This will bring up a page for the creation of the parameters needed to access your database.  You will need the configuration file name later, you can keep the default of "sql2rss_DBconfig.inc.php".

3) In your browser, enter the full URL to the location of the sql2rss file, and use 'buildConfig' for a parameter. 

Example: http://www.feedforall.com/sql2rss.php?buildConfig

This will bring up the configuration screen for sql2rss

4) On the configuration screen, enter the names of the two template files and a valid SQL query

5) Hit the 'Generate configuration data' button at the bottom of the screen.

6) The screen will refresh and display the contents of a new configuration file in your browser.  You now need to highlight that data, and copy it to an editor on your local computer (like notepad).

7) Save the new configuration file locally, being sure to use .php for the extension.

8) Upload the configuration file, and put it into the same folder as your sql2rss.php file

9) Test sql2rss by entering its URL into your browser, and including your new config file as a parameter.
Example: http://www.feedforall.com/sql2rss.php?CONFIGFILE=mynewconfig.php


Channel Template:
=================

The channel tempalte file must be a valid RSS 2.0 feed with only the <channel> level taga, without and <item>'s.  It will be copied without doing any subsitutions, with a <pubData> and <lastBuildDate> set to the current time.


Item Tempalte:
==============

The item template must contain a single valid RSS 2.0 <item>.  Any text between a pair of "~~~" will be subistuted with the contents of the database field of that name, if any.  There is one special tag "~~~RSSDATE(fieldname)~~~" which will take the contents of the database "fieldname", which must be a date, and convert it to a valid RFC 822 date format needed by RSS 2.0.


Usage:
------

After creating your new configuration, copy the configuration file from the sql2rss.php?buildConfig page to a file ending in .php on your server.  You can specify this file as your feed.  If you name the file "myfeed.php" you could access the created feed in two ways, http://www.your-web-server.com/sql2rss.php?CONFIGFILE=myfeed.php , which will work but is messy.  You can also produce the exact same results with http://www.your-web-server.com/myfeed.php .  Using this shortened version makes much cleaner URLs for your users or as the input to other FeedForAll scripts.


Copyright 2006-2007 NotePage, Inc. All rights reserved


_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
greenfin1



Joined: 10 Jan 2009
Posts: 1

PostPosted: Thu Jan 15, 2009 8:55 am Reply with quoteBack to top

i was also facing the same problem when i was feeding for my jingle site. any ways thanks a lot for the information.
View user's profileVisit poster's website
Display posts from previous:      
This forum is locked: you cannot post, reply to, or edit topics.This topic is locked: you cannot edit posts or make replies.


 Jump to:   



View next topic
View previous topic


Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme