EPrints Technical Mailing List Archive

Message: #08397


< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] ImportId


CAUTION: This e-mail originated outside the University of Southampton.

Hi everybody


The 'eprint' table has an 'importid' field, linked to the 'import' table, which
main/first fields structure is :
  `importid` int(11) NOT NULL,
  `datestamp_year` smallint(6) DEFAULT NULL,
  `datestamp_month` smallint(6) DEFAULT NULL,
  `datestamp_day` smallint(6) DEFAULT NULL,
  `datestamp_hour` smallint(6) DEFAULT NULL,
  `datestamp_minute` smallint(6) DEFAULT NULL,
  `datestamp_second` smallint(6) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `source_repository` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT
NULL,
  `url` longtext CHARACTER SET utf8 COLLATE utf8_bin,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_bin,

According to https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2Fw%2FNew_Features_in_EPrints_3.1%23Import&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cf021d7ef92bb480ce01a08d89b71559e%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637430258365361595%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=%2BQMwGjZR6Q%2BOXub5LVMXmvYJ7g1OLvbe%2F78aayEnQQ0%3D&amp;reserved=0, this
importid is used to link the eprints to the related import object.

In fact, on our repository, it is used to "tag" eprints harvested from another
OAI-PMH repository - through a script (scheduled into crontab) using a
configuration file and a import plugin PERL module...

Is there a "best practice" way (other than accessing the database) to create a
new 'importid' row into the 'import' table, and how free are we to choose
'datestamp_' (y/m/d/m/d/s) values ???


Thanks in advance for your help, and best regards...
--
Laurent Cloarec
Service Commun de la Documentation - Service du Numérique Documentaire
Université Toulouse 1 Capitole