{"action":"created","issue":{"url":"https://api.github.com/repos/keeps/db-preservation-toolkit/issues/171","repository_url":"https://api.github.com/repos/keeps/db-preservation-toolkit","labels_url":"https://api.github.com/repos/keeps/db-preservation-toolkit/issues/171/labels{/name}","comments_url":"https://api.github.com/repos/keeps/db-preservation-toolkit/issues/171/comments","events_url":"https://api.github.com/repos/keeps/db-preservation-toolkit/issues/171/events","html_url":"https://github.com/keeps/db-preservation-toolkit/issues/171","id":145172662,"number":171,"title":"Extracting siard-2: problem with year 207","user":{"login":"BorisDomajnko","id":17564757,"avatar_url":"https://avatars.githubusercontent.com/u/17564757?v=3","gravatar_id":"","url":"https://api.github.com/users/BorisDomajnko","html_url":"https://github.com/BorisDomajnko","followers_url":"https://api.github.com/users/BorisDomajnko/followers","following_url":"https://api.github.com/users/BorisDomajnko/following{/other_user}","gists_url":"https://api.github.com/users/BorisDomajnko/gists{/gist_id}","starred_url":"https://api.github.com/users/BorisDomajnko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BorisDomajnko/subscriptions","organizations_url":"https://api.github.com/users/BorisDomajnko/orgs","repos_url":"https://api.github.com/users/BorisDomajnko/repos","events_url":"https://api.github.com/users/BorisDomajnko/events{/privacy}","received_events_url":"https://api.github.com/users/BorisDomajnko/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/keeps/db-preservation-toolkit/labels/module-db:%20MS%20Access","name":"module-db: MS Access","color":"207de5"},{"url":"https://api.github.com/repos/keeps/db-preservation-toolkit/labels/type:%20bug","name":"type: bug","color":"c0392b"}],"state":"closed","locked":false,"assignee":{"login":"chalkos","id":98429,"avatar_url":"https://avatars.githubusercontent.com/u/98429?v=3","gravatar_id":"","url":"https://api.github.com/users/chalkos","html_url":"https://github.com/chalkos","followers_url":"https://api.github.com/users/chalkos/followers","following_url":"https://api.github.com/users/chalkos/following{/other_user}","gists_url":"https://api.github.com/users/chalkos/gists{/gist_id}","starred_url":"https://api.github.com/users/chalkos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chalkos/subscriptions","organizations_url":"https://api.github.com/users/chalkos/orgs","repos_url":"https://api.github.com/users/chalkos/repos","events_url":"https://api.github.com/users/chalkos/events{/privacy}","received_events_url":"https://api.github.com/users/chalkos/received_events","type":"User","site_admin":false},"assignees":[{"login":"chalkos","id":98429,"avatar_url":"https://avatars.githubusercontent.com/u/98429?v=3","gravatar_id":"","url":"https://api.github.com/users/chalkos","html_url":"https://github.com/chalkos","followers_url":"https://api.github.com/users/chalkos/followers","following_url":"https://api.github.com/users/chalkos/following{/other_user}","gists_url":"https://api.github.com/users/chalkos/gists{/gist_id}","starred_url":"https://api.github.com/users/chalkos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chalkos/subscriptions","organizations_url":"https://api.github.com/users/chalkos/orgs","repos_url":"https://api.github.com/users/chalkos/repos","events_url":"https://api.github.com/users/chalkos/events{/privacy}","received_events_url":"https://api.github.com/users/chalkos/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/keeps/db-preservation-toolkit/milestones/1","html_url":"https://github.com/keeps/db-preservation-toolkit/milestones/v2.0.0","labels_url":"https://api.github.com/repos/keeps/db-preservation-toolkit/milestones/1/labels","id":892729,"number":1,"title":"v2.0.0","description":"Added support for input and ouput into SIARD, a database preservation format created by the Swiss National Archives","creator":{"login":"luis100","id":631728,"avatar_url":"https://avatars.githubusercontent.com/u/631728?v=3","gravatar_id":"","url":"https://api.github.com/users/luis100","html_url":"https://github.com/luis100","followers_url":"https://api.github.com/users/luis100/followers","following_url":"https://api.github.com/users/luis100/following{/other_user}","gists_url":"https://api.github.com/users/luis100/gists{/gist_id}","starred_url":"https://api.github.com/users/luis100/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luis100/subscriptions","organizations_url":"https://api.github.com/users/luis100/orgs","repos_url":"https://api.github.com/users/luis100/repos","events_url":"https://api.github.com/users/luis100/events{/privacy}","received_events_url":"https://api.github.com/users/luis100/received_events","type":"User","site_admin":false},"open_issues":40,"closed_issues":20,"state":"open","created_at":"2014-12-05T10:08:48Z","updated_at":"2016-07-05T10:16:56Z","due_on":"2016-06-29T23:00:00Z","closed_at":null},"comments":5,"created_at":"2016-04-01T12:47:23Z","updated_at":"2016-07-05T10:16:56Z","closed_at":"2016-07-05T10:16:56Z","body":"Description: There is a wrong date in the table (207 instead of 2007). I cannot restore the table from siard2 file. Manually I was able to enter such a year into the PostgreSQL table therefore I assume siard is checking the syntax.\r\nIf the user has wrong values and this is not resolved before the ingest, we should be able to restore such tables as they are.\r\n\r\ndbptk-app-2.0.0-beta4.0.jar:\r\n\r\n1. MS Access -> siard-2\r\n2. siard-2 -> PostgreSQL\r\n\r\nINFO [14:27:52] Exporting data for PUBLIC.Izpiti\r\nERROR [14:27:52] line: 1; column: 280530; cvc-datatype-valid.1.2.1: '207-10-03T23:00:00.00Z' is not a valid value for 'dateTime'.\r\n                 cvc-datatype-valid.1.2.1: '207-10-03T23:00:00.00Z' is not a valid value for 'dateTime'.\r\nERROR [14:27:52] line: 1; column: 280530; cvc-type.3.1.3: The value '207-10-03T23:00:00.00Z' of element 'c3' is not valid.\r\n                 cvc-type.3.1.3: The value '207-10-03T23:00:00.00Z' of element 'c3' is not valid.\r\nERROR [14:27:52] Unexpected exception\r\n                 207-10-03T23:00:00.00Z\r\n\r\nAttach the dbptk-app.log.txt file below.\r\nDEBUG 2016-04-01 14:27:52,680 (JDBCExportModule) timestamp after: 2002-06-21 00:00:00.0\r\nDEBUG 2016-04-01 14:27:52,680 (JDBCExportModule) timestamp after: 2003-09-26 00:00:00.0\r\nERROR 2016-04-01 14:27:52,686 (SAXErrorHandler) line: 1; column: 280530; cvc-datatype-valid.1.2.1: '207-10-03T23:00:00.00Z' is not a valid value for 'dateTime'.\r\n                 cvc-datatype-valid.1.2.1: '207-10-03T23:00:00.00Z' is not a valid value for 'dateTime'.\r\nDEBUG 2016-04-01 14:27:52,686 (SAXErrorHandler) line: 1; column: 280530; cvc-datatype-valid.1.2.1: '207-10-03T23:00:00.00Z' is not a valid value for 'dateTime'.\r\n                 cvc-datatype-valid.1.2.1: '207-10-03T23:00:00.00Z' is not a valid value for 'dateTime'.\r\norg.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 280530; cvc-datatype-valid.1.2.1: '207-10-03T23:00:00.00Z' is not a valid value for 'dateTime'.\r\n        at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)\r\n"},"comment":{"url":"https://api.github.com/repos/keeps/db-preservation-toolkit/issues/comments/230440786","html_url":"https://github.com/keeps/db-preservation-toolkit/issues/171#issuecomment-230440786","issue_url":"https://api.github.com/repos/keeps/db-preservation-toolkit/issues/171","id":230440786,"user":{"login":"chalkos","id":98429,"avatar_url":"https://avatars.githubusercontent.com/u/98429?v=3","gravatar_id":"","url":"https://api.github.com/users/chalkos","html_url":"https://github.com/chalkos","followers_url":"https://api.github.com/users/chalkos/followers","following_url":"https://api.github.com/users/chalkos/following{/other_user}","gists_url":"https://api.github.com/users/chalkos/gists{/gist_id}","starred_url":"https://api.github.com/users/chalkos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chalkos/subscriptions","organizations_url":"https://api.github.com/users/chalkos/orgs","repos_url":"https://api.github.com/users/chalkos/repos","events_url":"https://api.github.com/users/chalkos/events{/privacy}","received_events_url":"https://api.github.com/users/chalkos/received_events","type":"User","site_admin":false},"created_at":"2016-07-05T10:16:56Z","updated_at":"2016-07-05T10:16:56Z","body":"Fix confirmed. Closing the issue."}}
{"actor":{"display_login":"chalkos"}}