Where is the XML file that is produced?

lcanter · Joined: 28 Jan 2007 Posts: 4

I must be missing something here - I can see the formatted feed output, but where is the actual feed/xml file. It needs to be submitted to other sites.

MacSupport · Joined: 24 Feb 2005 Posts: 2805

lcanter wrote:

I must be missing something here - I can see the formatted feed output, but where is the actual feed/xml file. It needs to be submitted to other sites.

The resulting XML is returned to the web browser. To submit to other sites you just give them the URL that includes sql2rss.php

Jim

lcanter · Joined: 28 Jan 2007 Posts: 4

But what about something like Google Base which requires an actual xml file?

MacSupport · Joined: 24 Feb 2005 Posts: 2805

lcanter wrote:

But what about something like Google Base which requires an actual xml file?

As far as it is concerned it is an xml file.

Jim

lcanter · Joined: 28 Jan 2007 Posts: 4

To submit a bulk feed Google requires uploading of an xml file, not just a URL pointing to one. I don't see any way to create that separate file (other than copying the source code from a browser window and pasting it in a new text file).

Thanks.

MacSupport · Joined: 24 Feb 2005 Posts: 2805

lcanter wrote:

To submit a bulk feed Google requires uploading of an xml file, not just a URL pointing to one. I don't see any way to create that separate file (other than copying the source code from a browser window and pasting it in a new text file).

Thanks.

At this point, that is what you will have to do then, unless you can tell your browser to save the contents of the link to a file

Jim

lcanter · Joined: 28 Jan 2007 Posts: 4

OK, Thanks.

Larry

MacSupport · Joined: 24 Feb 2005 Posts: 2805

lcanter wrote:

OK, Thanks.

Larry

But I will add this option to my list of requested additions. Up until your messages, we had not been able to come up with a reason to want to do it.

Jim

web2pro · Joined: 13 Feb 2008 Posts: 8

Hi Jim,

Just reading through the forum and found this post, was wondering if there was any update.

Basically what I'm trying to do is this, I parse an xml feed into MySQL and update my tables, I then use SQL2RSS to produce my RSS 2.0 Feeds, which all works great. This though produces a file extention of .php, if I then want to take that .php file and use RSS2HTML (Pro) it complains when I input the .php file in place of the sample.xml file.

Because I use a lot of short small RSS feeds, I don't really want to go through and copy and paste the output from the php file to xml.

Any suggestions ?

MacSupport · Joined: 24 Feb 2005 Posts: 2805

web2pro wrote:

Hi Jim,

Just reading through the forum and found this post, was wondering if there was any update.

Basically what I'm trying to do is this, I parse an xml feed into MySQL and update my tables, I then use SQL2RSS to produce my RSS 2.0 Feeds, which all works great. This though produces a file extention of .php, if I then want to take that .php file and use RSS2HTML (Pro) it complains when I input the .php file in place of the sample.xml file.

Because I use a lot of short small RSS feeds, I don't really want to go through and copy and paste the output from the php file to xml.

Any suggestions ?

That error is easy to resolve. On about line 65 of rss2html.php is

Code:

$allowedFeedExtensions = Array('.xml', '.rss');

that lists the allowed feed extensions. Just add .php

Code:

$allowedFeedExtensions = Array('.xml', '.rss', '.php');

and all should be good.

Jim