Introducing MARCXML manipulation tool

If you have to import/export your MARCXML records in Invenio, tind.io offers this great online utility: https://tools.tind.io/xml/xml-manipulation/ that allows to manipulate marcxml.

Marcxml manipulation tool tind.io

Exporting marc is not only useful on migration processes, but also when you have to perform changes to a lot of records in your Invenio system. It is way better than performing those changes at database level.

You can export records using web interface or command line. I prefer this second method, using BibExport:

First change this config file: /opt/invenio/etc/bibexport/marcxml.cfg

The MARCXML exporting method export all the records matching a particular search query, zip them and move them to the requested folder. The output of this exporting method is similar to what one would get by listing the records in MARCXML from the web search interface.

Default configurations are given below. The job would have exported all records from the Book collection into one xml.-file and all articles with the author “Polyakov, A M” into another.

[export_job]
export_method = marcxml
[export_criterias]
books = 980__a:BOOK
polyakov_articles = 980__a:ARTICLE and author:"Polyakov, A M"

the job is run by this command:

/opt/invenio/bin/bibexport -u admin -wmarcxml

Default folder for storing is:

/opt/invenio/var/www/export/marcxml

Google analytics: how to export more than 500 entries of data report [SOLVED]

Currently, only up to 500 rows of Analytics table data can be exported at a time into CSV format. If you need to export larger data sets, like exporting all keywords that sent traffic to your site, you can export multiple times as long as each batch contains at maximum 500 rows.

If you have thousands of rows that require multiple exports, you can use the convenient workaround below to export all your rows in one go.

1. Go the report that contains the data you want to export.

2. Append the query parameter ‘limit’ to the url (to the end of URL!), and hit enter to reload the report. The limit parameter is needed prior to every report export.
For example:

https://www.google.com/analytics/reporting/top_content?id=14120873&pdr=20090101-20091231&cmp=average&trows=5000&gdfmt=nth_day#lts=1268387872421&limit=50000

3. Hit ‘Enter’ and visually confirm that the report now has the new parameter appended to it. While there won’t be any visible difference in user interface, exporting will now yield more rows.

4. Select the Export tab, and click ‘CSV’ (not the option that says ‘CSV for Excel’).
5. The exported data should contain all the rows from your Analytics table.

Via: Google Analytics FAQ’s