Google News Sitemap Generator for Joomla

Hi Andrea,

Have been hunting for the same myself, hit upon your site on my search.

However I use sh404SEF (and it works really well) on my site and not OpenSEF.

Is there any work around for this in the package you’ve built ?

Arjun

Hello Arjun,

you’re the second person who ask me for a fork working with sh404SEF and I already realized that.

You can download it from here:

http://blog.andreaolivato.net/downloadsgooglenews_sitemap_1.5.x_mod_sh404.zip

I didn’t test this version as I don’t own the sh404 plugin however the other person who asked me for this fork, tried this and told me it works!

Let me know if it works for you too!

Hi Andrea,

great work – you are one of the best. I was looking into the code and the only thing I was missing is the function for joomla 1.x. Im not the best of programmer and after some tests I give up and I think its better to ask you whats the difference for joomla 1.x (1.15). Maybe you have an idea for the google news sitemap with sh404 (I think many people are using the 404sef because the opensef was stoped)

If you have an hint – it would be great.

Thankx a lot and have a nice day.
Gerd

Hello Gerd,

try this one, I think I successfully modified it for working on a 1.0.x installation…please give me a feedback so that I confirm this as working and publish for others

http://blog.andreaolivato.net/downloadsgooglenews_sitemap_1.0.x_mod_sh404.zip

hi Andrea,
thanks a lot for your work. I have seen the code and you make some changes. wow.

At thsi moment, there are no errors but also no news. The script brings the header
”

”
and than it is empty.

I use it with show errors too.

Hm..

Hello Gerd,

you were right I checked the files and there was a mistake on a control…can you please re-download the file

http://blog.andreaolivato.net/downloadsgooglenews_sitemap_1.0.x_mod_sh404-1.zip

and to use it? I believe it should work right now… I tested it with Joomla 1.0.15 Stable and Sh404 1.3.8_build_337

Hi Andrea,
great. The news are available. Thank you very much my friend.
I used it with joomla 1.0.15 and use sh404 1.38_build337
One question:
I have a lot of news in the domain and after some time the script end with the following error message:
HTTP/1.1 200 OK Date: Wed, 03 Dec 2008 17:11:41 GMT Server: Apache/1.3.39 (Unix) mod_auth_pam/1.1.1 mod_fastcgi/2.4.6 mod_ssl/2.8.30 OpenSSL/0.9.8g FrontPage/5.0.2.2510 X-Powered-By: PHP/4.4.9 Keep-Alive: timeout=15, max=97 Connection: Keep-Alive Transfer-Encoding: chunked Content-Type: text/html; charset=iso-8859-1
OK
Is the problem that I have to much news? If so and the timeout comes correct, I think we have to say a limit because all user will have the same problem. If you have an idea or a hint, it would be welcome.

I will publish the script now to google sitemap and we will see what google say. I give you a response.

have a nice day
Gerd (Munich)

Hi gerd,

try to change this one:
$ricerca_urls=”SELECT oldurl,newurl,rank,id FROM “.$tables_prefix.”redirection ORDER BY id DESC”;

into this
$ricerca_urls=”SELECT oldurl,newurl,rank,id FROM “.$tables_prefix.”redirection ORDER BY id DESC LIMIT 1000″;

this should limit to 1000 the number of urls written to the sitemap…obviously you can change the limit to whatever you prefer…

Hi Andrea,

good idea – it works. So I will send it again to Google and waiting for an accepting. If Google will accept it – I give you the response. For the moment I send you a “big thank you”.
have a nice day
Gerd

Hi Andrea,
I think, all code is ok but google send a warning message:
Name room of incorrect the name room is not declared in the XML Sitemap and/or in the XML-Sitemap-index regular.

I use it with:

and with

but the warning message comes again.

So I will test it with

and maybe this will work fine. The information for webmaster is not always the same and different from time to time. But it is in Germany a BETA and so I think the code from you is absolute ok. So let me see what google say if I use the sitemap. I give you the information.

BUT: google take the news and this is ok.

best regards,
Gerd

I can’t tell you how incredibly pleased I am that you have stepped in with this script. I have been using components not suited to the task for far too long!

Have almost got it working as I need it to – I have a large site with about 10,000 articles in it. Can you tell me how I get it to output in order of publication date?

Props again.

Hi ben!

Are you using the OpenSef version? If so it should be already ordered by creation date.

However just to be sure about it, open your

googlenews_sitemap.php

file and at the end of line 39 check that this string is present :

ORDER BY created

If you got a different version of my script please tell me which and also specify the version of Joomla are you using…

Hi Andrea,

Many thanks for getting back so quickly. It would have helped if I had been more specific about my set-up ! I am running sh404 SEF and Joomla 1.0.x.

Many thanks in advance.

All the best,

Ben

Hi ben, I tried to hack my script to order the sh404 redirections.

Try this one!

http://blog.andreaolivato.net/downloadsgooglenews_sitemap_1.0.x_mod_sh404-2.zip

Let me know if it fits your needings or not…

Y para joomla 1.15, sin usar sh404 hay alguna solucion

Perdon el mensjae anterior no es correcto queria decir joomla 1.5 sin sh404, hay alguna solucion

Hello Jose,

You can try using this one

http://blog.andreaolivato.net/downloadsgooglenews_sitemap_1.5.x_coreSef.zip

which uses the CoreSef . This means that if you want to use this plugin you need to activate Joomla 1.5 SEF component.

If you need more informations just ask me

**AUTOMATICALLY TRANSLATED**

Hola José,

Usted puede intentar usar este

http://blog.andreaolivato.net/downloadsgooglenews_sitemap_1.5.x_coreSef.zip

que utiliza el CoreSef. Esto significa que si desea utilizar este plugin que necesita para activar SEF componente Joomla 1.5.

Si necesita más información sólo me preguntan

Hi Andrea,

I uploaded my googlenews_sitemap succesfully but I got this message from google news

(Unsupported Sitemap format
Your Sitemap uses a News format that is no longer supported for newly-submitted sitemaps. Please update to the new format, which involves attaching a <publication> tag and other relevant tags to each url in your Sitemap.)

How can I add those tags? I have no knowledge of php.

Thanks,
Alex

Hello, Andrea:
Can you adapt your solution as Acesef Joomla 1.5 and SEF component, please?
Thanks for your help.

Thanks, this is very useful

This is very good, I am using the googlenews_sitemap_1.5.x_coreSef file…

My only problem is that it collects articles from section/category, only category.

The generated sitemap displays the article´s link in the following format:
http://www.mysite.com/category/article
but my site displays the link in this format
http://www.mysite.com/section/category/article
Notice that the sitemap generator doesn´t add the section to the url generated in the google news site map

Is there anway I can edit the code to add this? thank you!

Hello everyone. Because so many of you requested a new version I started working on it. You can already download an initial and working version on the new project page. Please refer to that new page for further updates and for support questions.

http://blog.andreaolivato.net/software/gnsg-goo…

Thanks everyone who supported my decision to keep developing the plugin, I really hope this new work could help you.