Search Members Help

» Welcome Guest
[ Log In :: Register ]

 

[ Track this topic :: Email this topic :: Print this topic ]

reply to topic new topic new poll
Topic: XML-Interface and a logs id< Next Oldest | Next Newest >
Team BMW-Biker Offline
Navicacher




Group: Members
Posts: 5
Joined: June 2004
    Posted: June 17 2004,8:02 am QUOTE

Hello Navicache-Admins,

i've programmed an activity map and a diagram for www.GeoCaching.de. You can see it at http://home.debitel.net/user/geocaching/stats.shtml.

The map shows how many logs were done in the last month and the diagram shows the development of caches and logs here in germany. I hope that's ok and i won't get trouble with you.

The data comes from the XML interface and i want to update the data incremental by using the 'NewOrModifiedSince'-attribute (so i haven't to download the whole .de dataset each month).

My problem is to actualize the logs because there is no id in the logs-record. Would be great if you could add a log_id (or something compareable) to the logs record.

Many thanks,
Oliver ... one of the Team BMW-Biker
Back to top
Profile PM 
PC Medic Offline
Cache Master




Group: Super Administrators
Posts: 1452
Joined: Dec. 2001
    Posted: June 17 2004,4:13 pm QUOTE

We can certainly look into what can be done to accomodate this and I will post any changes to this here.

--------------
'PC Medic'
Back to top
Profile PM AOL YIM 
Team BMW-Biker Offline
Navicacher




Group: Members
Posts: 5
Joined: June 2004
    Posted: June 18 2004,1:50 am QUOTE

Quote
We can certainly look into what can be done to accomodate this and I will post any changes to this here.


that's fine, thank you!

Seem's to be that one of the server's doesn't work ... you can see the map and the diagram here:

navicache activity map
navicache development in germany
Back to top
Profile PM 
GeoRockers Offline
Caching Maniac




Group: Members
Posts: 167
Joined: Feb. 2002
Posted: Feb. 26 2005,6:51 am QUOTE

Greetings Oliver of Team BMW-Biker!  :wave

Quote (Team BMW-Biker @ June 18 2004,12:50 am)
My problem is to actualize the logs because there is no id in the logs-record. Would be great if you could add a log_id (or something compareable) to the logs record.


Sorry about the long delay in the implementation of log_id.  :(

log_id is now a part of the logs record. :)


George


--------------
A 1/1 via the trail around the hill?
Nah... that's too easy!  Let's go up and over!
Why follow a trail when we can blaze our own? :p

We *make* mountains out of mole hills!
Back to top
Profile PM 
Scout Offline
Cache Master




Group: Members
Posts: 721
Joined: June 2001
    Posted: Feb. 26 2005,5:33 pm QUOTE

Quote (GeoRockers @ Feb. 26 2005,7:51 am)
log_id is now a part of the logs record. :)

Hmmm.... I noticed that the XML file I've been downloading for computation of the stats board has been breaking my script for the last week or so. I wonder if it's related...

--------------
Scout  ( http://GPSgames.org )
Back to top
Profile PM 
PC Medic Offline
Cache Master




Group: Super Administrators
Posts: 1452
Joined: Dec. 2001
    Posted: Feb. 26 2005,8:05 pm QUOTE

Some changes were made about that time (2/20 to be exact).

Could you drop us an email from the Contact Page with some specifics as to what is happening.


--------------
'PC Medic'
Back to top
Profile PM AOL YIM 
GeoRockers Offline
Caching Maniac




Group: Members
Posts: 167
Joined: Feb. 2002
Posted: Feb. 27 2005,9:42 pm QUOTE

Hi Scout,

Quote (Scout @ Feb. 26 2005,4:33 pm)
Quote (GeoRockers @ Feb. 26 2005,7:51 am)
log_id is now a part of the logs record. :)

Hmmm.... I noticed that the XML file I've been downloading for computation of the stats board has been breaking my script for the last week or so. I wonder if it's related...


Yes, it was.  :(

log_id, state, and city were added to LogEntry, and there was a bug fix to return logs for a specified state when state was passed as an argument (thanks for reporting it gregwa).

I forgot to declare city as an attribute of LogEntry... :(

XML output now validated.

Thanks for taking the time to report the bug, Scout!  :2cool


George


Edited by GeoRockers on Feb. 27 2005,11:25 pm

--------------
A 1/1 via the trail around the hill?
Nah... that's too easy!  Let's go up and over!
Why follow a trail when we can blaze our own? :p

We *make* mountains out of mole hills!
Back to top
Profile PM 
Scout Offline
Cache Master




Group: Members
Posts: 721
Joined: June 2001
    Posted: Feb. 28 2005,7:10 pm QUOTE

Here's my call:

Code Sample
http://www.navicache.com/cgi-bin/db/XMLSearchResults.pl?NewOrModifiedSince=2000-01-01&LogStats=1


The file that's returned gets truncated at line 123409. The tail end of the file looks like:

 
Code Sample

<CacheDetails source='NaviCache'
         cache_id='6108'
         waypoint='N017DC'
         country_code='US'
         state='NY'
         city='Buffalo'
         name='Buffalo's Amazing Disappearing Creek'
         user_name='WhiteUrkel'
         hidden_date='2005-02-27'
         modified_datetime='2005-02-27 15:31:45'
         latitude='42.9237'
         longitude='-78.85705'
         difficulty='2.0'
         terrain='2.0'
         retired='no'
         cache_type='multi-part'
         cache_size='micro'
         open_cache='non_commercial_use_only'
          >
  </CacheDetails>

Could not perform command <br>


</CACHEDATA>


Edited by Scout on Feb. 28 2005,7:13 pm

--------------
Scout  ( http://GPSgames.org )
Back to top
Profile PM 
PC Medic Offline
Cache Master




Group: Super Administrators
Posts: 1452
Joined: Dec. 2001
    Posted: Mar. 01 2005,5:57 pm QUOTE

I have checked this out and you are correct when 'your' call (and several others I tried) are used, this error occurs. Yet other variations did not reproduce the error.

I will get together with George (Georocker) to track the cause and cure.


--------------
'PC Medic'
Back to top
Profile PM AOL YIM 
GeoRockers Offline
Caching Maniac




Group: Members
Posts: 167
Joined: Feb. 2002
Posted: Mar. 01 2005,9:08 pm QUOTE

Hi Scout,

Quote (Scout @ Feb. 28 2005,6:10 pm)
Here's my call:

Code Sample
http://www.navicache.com/cgi-bin/db/XMLSearchResults.pl?NewOrModifiedSince=2000-01-01&LogStats=1


The file that's returned gets truncated at line 123409. The tail end of the file looks like:

 
Code Sample

<CacheDetails source='NaviCache'
--- snip ---
          >
  </CacheDetails>

Could not perform command <br>


</CACHEDATA>


I've been working on this prior to Bryan's (PC Medic) post...

It's been very elusive... change the year to 2005 and it works... switch back to 2000 and it breaks.

The "Could not perform command" error is from MySQL - the same query entered via the console, with the year set to 2000, works beautifully....

You can access the previous version (without log_id, city, state) at:

http://www.navicache.com/cgi-bin/db/XMLSearchResults.Scout.pl



George


--------------
A 1/1 via the trail around the hill?
Nah... that's too easy!  Let's go up and over!
Why follow a trail when we can blaze our own? :p

We *make* mountains out of mole hills!
Back to top
Profile PM 
Scout Offline
Cache Master




Group: Members
Posts: 721
Joined: June 2001
    Posted: Mar. 03 2005,9:25 am QUOTE

Quote (GeoRockers @ Mar. 01 2005,10:08 pm)
You can access the previous version (without log_id, city, state) at:

http://www.navicache.com/cgi-bin/db/XMLSearchResults.Scout.pl

Thanks. I'm back in business again with the "Scout" special. I understand why you want to add a unique log ID, but I don't need it for my purposes. So, I'm fine with the old version until you can figure out what might be going wrong with the new version.


--------------
Scout  ( http://GPSgames.org )
Back to top
Profile PM 
Scout Offline
Cache Master




Group: Members
Posts: 721
Joined: June 2001
    Posted: Mar. 20 2005,8:54 am QUOTE

Quote (Scout @ Mar. 03 2005,10:25 am)
I'm back in business again with the "Scout" special.

I just had the same failure with the "Scout special" version of the XML export.


Edited by Scout on Mar. 20 2005,8:55 am

--------------
Scout  ( http://GPSgames.org )
Back to top
Profile PM 
Scout Offline
Cache Master




Group: Members
Posts: 721
Joined: June 2001
    Posted: Mar. 28 2005,4:13 pm QUOTE

This week's download of Navicache XML data failed altogether (I don't have any log or error message to provide). So, the stats I publish are now two weeks out of date.

--------------
Scout  ( http://GPSgames.org )
Back to top
Profile PM 
PC Medic Offline
Cache Master




Group: Super Administrators
Posts: 1452
Joined: Dec. 2001
    Posted: Mar. 29 2005,5:40 pm QUOTE

researching this issue now. Will fix as soon as possible.

--------------
'PC Medic'
Back to top
Profile PM AOL YIM 
PC Medic Offline
Cache Master




Group: Super Administrators
Posts: 1452
Joined: Dec. 2001
    Posted: May 13 2005,4:41 pm QUOTE

Quote (Scout @ Mar. 28 2005,6:13 pm)
This week's download of Navicache XML data failed altogether (I don't have any log or error message to provide). So, the stats I publish are now two weeks out of date.

Still working on this, but have just sent you the needed data to get your Stats back up and running.

--------------
'PC Medic'
Back to top
Profile PM AOL YIM 
Scout Offline
Cache Master




Group: Members
Posts: 721
Joined: June 2001
    Posted: May 16 2005,7:04 am QUOTE

Thanks. The stats are updated again. I haven't updated the script to automatically update it with an incremental update. But the ball is back in my court on that.

P.S. This means that the Navicache stats banners are updated again. Looking at my own (in my sig below) shows a pretty pitiful ranking. Ouch!


Edited by Scout on May 16 2005,7:06 am

--------------
Scout  ( http://GPSgames.org )
Back to top
Profile PM 
PC Medic Offline
Cache Master




Group: Super Administrators
Posts: 1452
Joined: Dec. 2001
    Posted: May 16 2005,3:16 pm QUOTE

Glad we could get you squared away.  :thumbs-up

By the way, your rankings are WAY better than my own so ......


--------------
'PC Medic'
Back to top
Profile PM AOL YIM 
PC Medic Offline
Cache Master




Group: Super Administrators
Posts: 1452
Joined: Dec. 2001
    Posted: June 05 2005,8:56 am QUOTE

The problem with the trunctated XML file has been corrected.

--------------
'PC Medic'
Back to top
Profile PM AOL YIM 
Team BMW-Biker Offline
Navicacher




Group: Members
Posts: 5
Joined: June 2004
    Posted: July 31 2005,4:04 am QUOTE

Quote
Sorry about the long delay in the implementation of log_id.  
log_id is now a part of the logs record.


wow, cool! Thanks a lot!

Since i moved my "homeserver" from windows to linux in december last year, my scripts didn't run ... now i've a bit of time to make a new script for linux ... with incremental upate ;)

Thanks again and sorry for the trouble related to this change!
Oliver
Back to top
Profile PM 
GeoRockers Offline
Caching Maniac




Group: Members
Posts: 167
Joined: Feb. 2002
    Posted: Nov. 28 2005,1:12 am QUOTE

Hi Folks!

Quote (Team BMW-Biker @ July 31 2005,3:04 am)
Quote
Sorry about the long delay in the implementation of log_id.  
log_id is now a part of the logs record.


wow, cool! Thanks a lot!

Since i moved my "homeserver" from windows to linux in december last year, my scripts didn't run ... now i've a bit of time to make a new script for linux ... with incremental upate ;)

Thanks again and sorry for the trouble related to this change!
Oliver


The frustration was caused by an anti-content spam measure implemented by our hosting service, which increased system resource usage.

The modifications to the XML script occurred on the same day as the anti-content spam measures were implemented... we didn't know about the anti-content spam measures, and assumed that all of the problems were on our side. :rolleyes:

The modified script failed because the system resource limits were reached... all a matter of bad timing. ::sigh::

GeoRockers


--------------
A 1/1 via the trail around the hill?
Nah... that's too easy!  Let's go up and over!
Why follow a trail when we can blaze our own? :p

We *make* mountains out of mole hills!
Back to top
Profile PM 
19 replies since June 17 2004,8:02 am < Next Oldest | Next Newest >

[ Track this topic :: Email this topic :: Print this topic ]

 
reply to topic new topic new poll

Quick Reply: XML-Interface and a logs id
iB Code Buttons
You are Posting as:
Guest
Do you wish to enable your signature for this post?
Do you wish to enable emoticons for this post?
Track this topic
View All Emoticons
View iB Code