Hi
I have check the service and should return all the records from the tables
request or params. See this:
https://github.com/geonetwork/core-geonetwork/blob/2.10.x/web/src/main/webapp/WEB-INF/config-statistics.xml#L223
https://github.com/geonetwork/core-geonetwork/blob/2.10.x/web/src/main/java/org/fao/geonet/services/statistics/TableExport.java#L97
One thing that looks strange is the naming of the file:
https://github.com/geonetwork/core-geonetwork/blob/2.10.x/web/src/main/java/org/fao/geonet/services/statistics/TableExport.java#L91
Maybe that causes some kind of caching, but looks strange is that even
deleting the file from images/statTmp, keeps returning the old
information.
Have you check after deleting the file in images/statTmp, to make a new
request and verify the content of the file in images/statTmp (not what is
returned to the browser)? If has still the old data?
If the data is not updated in the new file, maybe is more related to how
the resultset is managed. See this:
https://github.com/geonetwork/core-geonetwork/blob/2.10.x/web/src/main/java/org/fao/geonet/services/statistics/TableExport.java#L108
Not really clear why this service is not using the jeeves.dbms stuff for
the queries.
Regards,
Jose García
On Tue, Feb 24, 2015 at 7:20 PM, Jo Cook <jocook@anonymised.com> wrote:
Hi All,
I work with Ant, who sent the original email about this- and it has got us
quite confused. Can someone explain to us in detail what the process is for
generating the csv from the search statistics page? We can see that a csv
is generated in images/statTmp, but even if we delete this and then request
another download of the request statistics, the results returned stop
around 12 days ago- which is probably when we first tried to download them.
We really want to extend the statistics page to show a number of custom
statistics, and we can get to the point where it downloads the csv but if
the results are not updated then they are no use!
We've upped the logging of various components in log4j.cfg- mainly the
jeeves.dbms logging, but that isn't helping either. If someone can help us
debug this, we'd be extremely grateful.
Thanks for your help with this
Jo
On Mon, Feb 23, 2015 at 10:52 AM, Antony Scott <
antonyscott@anonymised.com> wrote:
> Hi Jean
>
> Thanks for the reply - actually my issue is with the CSV export from the
> Admin page under Search statistics, rather than the metada records - I've
> been trying to set up some custom exports, but for both these and the
> default exports, I'm getting a cached version of the data rather than the
> current one, even after restarting Tomcat and deleting the cached files.
Is
> this working OK for you?
>
> thanks
>
> Ant
>
> On 23 February 2015 at 09:26, Jean Pommier <
> jean.pommier@anonymised.com>
> wrote:
>
> > Hi Ant,
> >
> > I've tried on an instance of mine, it seems to work fine.
> > I would say your issue is a /selection/ issue : it will export the
> > /selected/ metadata entries. So, say, you selected all results from the
> > first results page (select->all in page). And you export it in csv, the
> > output matches the results. You move to page 2, and ask again for csv
> > export : you will still have your 20 or so entries, but it will still
be
> > the metadata from page 1. This is because you haven't updated the
> > selection. Ask again for select->all in page, for example, and export.
> > You will have the results from page 2.
> > I hope I'm clear enough.
> > Does it help you ?
> > If necessary, I can give you a link to my catalog, so that you can try
> it.
> > Cheers,
> >
> > Jean
> >
> >
> > *Jean Pommier -- pi-Geosolutions*
> >
> > Ingénieur, consultant indépendant
> >
> > Tél. : (+33) 6 09 23 21 36
> > E-mail : jp@anonymised.com
> > Web : www.pi-geosolutions.fr
> >
> > Le 23/02/2015 09:35, Antony Scott a écrit :
> > > Has anyone else had experience (good or bad) of using the CSV export?
> I'm
> > > still trying to track down where the apparent caching issue might be.
> > >
> > > thanks
> > > Ant
> > >
> > > On 18 February 2015 at 18:18, Antony Scott <
> > antonyscott@anonymised.com>
> > > wrote:
> > >
> > >> Hi,
> > >>
> > >> I've got an issue with downloading CSV from the search stats page,
in
> > that
> > >> it looks as though after the first download action the data isn't
> > getting
> > >> refreshed from the PostGreSQL database. The transformation to CSV is
> > taking
> > >> place each time I select the CSV Export options from the search
> > statistics
> > >> page, but the source data for that transformation is static, not
> > reflecting
> > >> subsequent changes in the database.
> > >>
> > >> We're running GeoNetwork 2.10 on Tomcat6 - have restarted Tomcat,
> > deleted
> > >> the temp files etc. It seems as though there is a cache between the
> > >> database and the transformation to CSV somewhere which isn't being
> > cleared.
> > >> The installation is all pretty much OK apart from this, and I'm not
> > seeing
> > >> any errors in geonetwork.log. Grateful for any suggestions.
> > >>
> > >> many thanks
> > >> Ant
> > >>
> > >> --
> > >> *Antony Scott*
> > >> Astun Technology Ltd, The Coach House, 17 West Street, Epsom,
Surrey,
> > KT18
> > >> 7RL, UK
> > >> t:+44 7866 455 515
> > >> iShare - Data integration and publishing platform
> > >> <http://www.isharemaps.com/>
> > >>
> > >> *****************************************
> > >>
> > >> Company registration no. 5410695. Registered in England and Wales.
> > >> Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT
> no.
> > >> 864201149.
> > >>
> > >
> > >
> >
> >
> >
>
------------------------------------------------------------------------------
> > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> > from Actuate! Instantly Supercharge Your Business Reports and
Dashboards
> > with Interactivity, Sharing, Native Excel Exports, App Integration &
more
> > Get technology previously reserved for billion-dollar corporations,
FREE
> >
> >
>
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
> > _______________________________________________
> > GeoNetwork-users mailing list
> > GeoNetwork-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> > GeoNetwork OpenSource is maintained at
> > http://sourceforge.net/projects/geonetwork
> >
>
>
>
> --
> *Antony Scott*
> Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey,
KT18
> 7RL, UK
> t:+44 7866 455 515
> iShare - Data integration and publishing platform
> <http://www.isharemaps.com/>
>
> *****************************************
>
> Company registration no. 5410695. Registered in England and Wales.
> Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
> 864201149.
>
>
------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
>
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
> _______________________________________________
> GeoNetwork-users mailing list
> GeoNetwork-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
> http://sourceforge.net/projects/geonetwork
>
--
*Jo Cook*
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
7RL, UK
t:+44 7930 524 155
iShare - Data integration and publishing platform
<http://www.isharemaps.com/>
*****************************************
Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website,
sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for
all
things parallel software development, from weekly thought leadership blogs
to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
--
*GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on
GeoServer and GeoNetwork. Visit http://geocat.net/> for
details. _________________________Jose GarcíaGeoCat bvVeenderweg 136721 WD
BennekomThe Netherlandshttp://GeoCat.net/>*