Skip to content

Instantly share code, notes, and snippets.

@rushirajnenuji
Created November 20, 2020 17:48
Show Gist options
  • Save rushirajnenuji/ba3e38cd33ef6d8615329eeb9ddc77bf to your computer and use it in GitHub Desktop.
Save rushirajnenuji/ba3e38cd33ef6d8615329eeb9ddc77bf to your computer and use it in GitHub Desktop.
Crossref Queue - Nov 20, 2020
MySQL [ezid]> select seq, identifier, owner, operation, status, message, batchId, submitTime from ezidapp_crossrefqueue;
+--------+--------------------------+----------------------+-----------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------+------------+
| seq | identifier | owner | operation | status | message | batchId | submitTime |
+--------+--------------------------+----------------------+-----------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------+------------+
| 233848 | doi:10.5070/BP328133885 | ark:/99166/p9vt1gs8k | C | W | Added with conflict
conflict_id=5460856
in conflict with: 10.5070/BP328133884 | 8f3b2336-4b6e-11e9-960d-0a9901e9a631 | 1553127383 |
| 233868 | doi:10.5070/BP327124511 | ark:/99166/p9vt1gs8k | C | W | Added with conflict
conflict_id=5460857
in conflict with: 10.5070/BP327124512 | e0b63c82-4b6e-11e9-960d-0a9901e9a631 | 1553127520 |
| 233869 | doi:10.5070/BP327120808 | ark:/99166/p9vt1gs8k | C | W | Added with conflict
conflict_id=5460858
in conflict with: 10.5070/BP327124500 | e0ea82a8-4b6e-11e9-960d-0a9901e9a631 | 1553127520 |
| 235280 | doi:10.20354/B4414110000 | ark:/99166/p9js9hb3n | U | F | ISSN "23771666" has already been assigned, title/issn: Proceedings of the Annual Meeting of the Berkeley Linguistics Society/23771666 is owned by publisher: 10.3765 | 3a2e9d7a-99f0-11e9-aa56-0a9901e9a631 | 1561759266 |
| 235326 | doi:10.5070/D6110000 | ark:/99166/p9rb6w21w | U | F | Error: cvc-datatype-valid.1.2.1: '' is not a valid value for 'integer'.
Error: cvc-type.3.1.3: The value '' of element 'ns0:year' is not valid.
Error: cvc-minLength-valid: Value '' with length = '0' is not facet-valid with respect to minLength '1' for type '#AnonType_volume'.
Error: cvc-type.3.1.3: The value '' of element 'ns0:volume' is not valid.
Error: cvc-complex-type.2.4.b: The content of element 'ns0:contributors' is not complete. One of '{"http://www.crossref.org/schema/4.3.5":organization, "http://www.crossref.org/schema/4.3.5":person_name}' is expected.
Error: cvc-datatype-valid.1.2.1: '' is not a valid value for 'integer'.
Error: cvc-type.3.1.3: The value '' of element 'ns0:year' is not valid.
| 0d385e04-a36f-11e9-a5f3-0a9901e9a631 | 1562803297 |
| 236003 | doi:10.5070/B89146420 | ark:/99166/p9vt1gs8k | U | W | Updated with conflict
conflict_id=5569418
in conflict with: 10.5070/B89146419 | b32b89d0-2f24-11ea-bdb1-0a9901e9a631 | 1578164526 |
| 236245 | doi:10.5070/B89146461 | ark:/99166/p9vt1gs8k | U | W | Updated with conflict
conflict_id=5569735
in conflict with: 10.5070/B89146451 | ac1d89dc-4ad0-11ea-9173-0a97c9d844ae | 1581207069 |
| 236251 | doi:10.5070/B89146419 | ark:/99166/p9vt1gs8k | U | W | Updated with conflict
conflict_id=5569418
in conflict with: 10.5070/B89146420 | ad41b4dc-4ad0-11ea-9173-0a97c9d844ae | 1581207071 |
| 239408 | doi:10.5070/B89249114 | ark:/99166/p9vt1gs8k | C | F | Error: cvc-pattern-valid: Value 'V9, N2' is not facet-valid with respect to pattern '[^\d\?]*[^\d\?\s]+[^\d\?]*' for type '#AnonType_surname'.
Error: cvc-type.3.1.3: The value 'V9, N2' of element 'ns0:surname' is not valid.
| f5955c74-c6d7-11ea-a7e0-0a97c9d844ae | 1594844143 |
| 245317 | doi:10.31223/X59880 | ark:/99166/p93776180 | C | F | Error: cvc-pattern-valid: Value '0000-0002-4587-8920' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0002-5774-1366' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0001-7116-035X' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0002-7494-9767' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0001-5070-7539' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
| 16898390-134c-11eb-b069-0a97c9d844ae | 1603250308 |
| 245320 | doi:10.31223/X5X30T | ark:/99166/p93776180 | C | F | Error: cvc-pattern-valid: Value '0000-0002-0370-5802' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0002-9902-8120' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0001-7775-5127' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
| e7654c4a-13b2-11eb-b069-0a97c9d844ae | 1603294467 |
| 245321 | doi:10.31223/X5S88B | ark:/99166/p93776180 | C | F | Error: cvc-pattern-valid: Value '0000-0002-9624-5146' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
| 19dd2d4c-13b7-11eb-b069-0a97c9d844ae | 1603296270 |
| 245336 | doi:10.31223/X58C7B | ark:/99166/p93776180 | C | F | Error: cvc-pattern-valid: Value '0000-0002-8713-1446' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
| 3b67128c-13b9-11eb-b069-0a97c9d844ae | 1603297185 |
| 245337 | doi:10.31223/X54K5D | ark:/99166/p93776180 | C | F | Error: cvc-pattern-valid: Value '0000-0001-7965-897X' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
| eee6d234-13b9-11eb-b069-0a97c9d844ae | 1603297486 |
| 245338 | doi:10.31223/X50W24 | ark:/99166/p93776180 | C | F | Error: cvc-pattern-valid: Value '0000-0001-9592-1053' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0002-3367-0065' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0003-3260-9227' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
| 376691e8-13ba-11eb-b069-0a97c9d844ae | 1603297608 |
| 245339 | doi:10.31223/X5W30H | ark:/99166/p93776180 | C | F | Error: cvc-pattern-valid: Value '0000-0002-2555-6860' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0002-5938-7698' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0002-2752-3528' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0002-0976-810X' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
Error: cvc-pattern-valid: Value '0000-0002-5092-0302' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
| eae25554-13ba-11eb-b069-0a97c9d844ae | 1603297909 |
| 245347 | doi:10.31223/X5V306 | ark:/99166/p93776180 | C | F | Error: cvc-pattern-valid: Value '0000-0002-4027-3965' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
| 8f533568-13d9-11eb-b069-0a97c9d844ae | 1603311070 |
| 245348 | doi:10.15697/0W3B | ark:/99166/p9kw57h4w | C | F | ISSN "19475578" has already been assigned, title/issn: Berkeley Review of Education/19475578 is owned by publisher: 10.5070 | 00d4fedc-24f2-11eb-905f-0aaca0e19d37 | 1605190738 |
+--------+--------------------------+----------------------+-----------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------+------------+
18 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment