Import embargo information of files

[sebdeleze]

Provide a script that updates embargo dates and file access

[sebdeleze]

Someone can give me some examples from RERODOC, which have files with embargo date?

[sebdeleze]

@jma For doing this, I need :

• Add embargo information for files in MarcXML
  OR
• You give me a new dump file containing this information
  OR
• You give me an access to the mysql database and I do the dump.

[sebdeleze]

Here's a dump of files status and the query used to retrieve them:

select distinct id_bibrec, status, docname from bibrec_bibdoc INNER JOIN bibdoc on bibrec_bibdoc.id_bibdoc=bibdoc.id where status!='' and status!='DELETED';

files_status_2020-03-12.zip

[sebdeleze]

Test CSV file for testing all permissions possibilities

"id_bibrec";"status";"docname"
14278;"status:PA16JU";"PAL_E1518"
29506;"status:NEUCHATEL";"Soys_ren_Ibrahim_-_La_sociologie_d_Abdelmalek_Sayad_et_l_expulsion_des_trangers_d_linquants_en_Suisse_UNINE_MEMOIRE_2012"
465;"status:RERO";"s550142"
23234;"status:UNISI";"T541_BLUE"
22130;"status:INTERNAL";"KuJB"
232563;"firerole:
    allow roles /.*,INTERNAL,.*/
    allow from ""2015-02-15""
    allow any
";"Fragniere_Catenazzo_2014_Satisfaction_pricing"
209243;"firerole:
    allow roles /.*,UNIFR,.*/
    allow from ""2014-07-14""
    allow any
";"boc_tps"
289209;"firerole:
    allow roles /.*,CSAL,.*/
    allow from ""2018-01-07""
    allow any
";"stu2500"
292071;"firerole:
    allow roles /.*,CSAL,.*/
    allow from ""2020-08-01""
    allow any
";"S1935789315000403"
324197;"firerole:
    allow roles /.*,UNISI,.*/
    allow from ""2020-08-17""
    allow any
";"Palomino-Segura_JVE_2018"
328224;"firerole:
    allow roles /.*,INTERNAL,.*/
    allow from ""2022-01-09""
    allow any
";"semitotal_rero"

And corresponding oaiharvester commands:

invenio oaiharvester harvest -u http://doc.rero.ch/oai2d -m marcxml -i oai:doc.rero.ch:20091210001703-ZZ -q
invenio oaiharvester harvest -u http://doc.rero.ch/oai2d -m marcxml -i oai:doc.rero.ch:20120629155123-IQ -q
invenio oaiharvester harvest -u http://doc.rero.ch/oai2d -m marcxml -i oai:doc.rero.ch:465 -q
invenio oaiharvester harvest -u http://doc.rero.ch/oai2d -m marcxml -i oai:doc.rero.ch:20110616171237-KC -q
invenio oaiharvester harvest -u http://doc.rero.ch/oai2d -m marcxml -i oai:doc.rero.ch:20110316145620-YX -q
invenio oaiharvester harvest -u http://doc.rero.ch/oai2d -m marcxml -i oai:doc.rero.ch:20141021134941-IJ -q
invenio oaiharvester harvest -u http://doc.rero.ch/oai2d -m marcxml -i oai:doc.rero.ch:289209 -q
invenio oaiharvester harvest -u http://doc.rero.ch/oai2d -m marcxml -i oai:doc.rero.ch:292071 -q
invenio oaiharvester harvest -u http://doc.rero.ch/oai2d -m marcxml -i oai:doc.rero.ch:20190219111855-YI -q
invenio oaiharvester harvest -u http://doc.rero.ch/oai2d -m marcxml -i oai:doc.rero.ch:20200309134011-NO -q
invenio oaiharvester harvest -u http://doc.rero.ch/oai2d -m marcxml -i oai:doc.rero.ch:20140214134013-OI -q