Missing required prefix when trying to use dates for object properties or Individuals

Question

Missing required prefix when trying to use dates for object properties or Individuals

vipeReu opened this issue 5 years ago · 6 comments

I have a couple of data sets in excel and one of them had columns with dates stored.
I used the instructions mentioned in #59 to change the dates and it worked fine.
When creating the transformation rules declaring the dates as data properties with the type xsd:dataTime, it works as intended.
But I can't use the dates in ObjectProperties or in the Individuals declaration.

As an example if I try to use mm:prepend to prepend a date from column @b to something from column @e (that is not a date) it will throw me a "Missing required prefix".
Changing the @b to a different column source that doesnt contain dates makes the transformation work with no issues.

Is is intended that I can't use dates in the ISO8601 format in object properties and individuals or is it something else?

Answer 1 · 2019-03-22T16:42:15.000Z

I am not fully following. Can you give some example cell value and Mapping Master expressions that illustrate what you are saying.

Answer 2 · 2019-03-22T16:43:05.000Z

Ideally, post a spreadsheet and file containing Mapping Master expressions so that we can quickly identify the issue.

Answer 3 · 2019-03-22T16:44:14.000Z

I will do so tomorrow since I will be busy till then. Thank you for the quick reply :-)

Answer 4 · 2019-03-22T16:55:53.000Z

Another quick question, to try to understand the problem:
Are you trying to use the dates as part of the IRI of the newly created individuals (or object properties)?
That may not be a good idea. You should at least strip the colons from them (maybe by preprocessing them in another column of the spreadsheet, if doing the processing in MM is too difficult), because those would likely cause a confusion for the entity matcher.

Answer 5 · 2019-03-22T17:25:25.000Z

Another quick question, to try to understand the problem:
Are you trying to use the dates as part of the IRI of the newly created individuals (or object properties)?
That may not be a good idea. You should at least strip the colons from them (maybe by preprocessing them in another column of the spreadsheet, if doing the processing in MM is too difficult), because those would likely cause a confusion for the entity matcher.

exactly what I attempted to do!
I will try to get rid of the colons if I get back to my project and will write here if I have new information on the matter.
Thanks in advance :-)

Answer 6 · 2019-03-27T09:06:35.000Z

Another quick question, to try to understand the problem:
Are you trying to use the dates as part of the IRI of the newly created individuals (or object properties)?
That may not be a good idea. You should at least strip the colons from them (maybe by preprocessing them in another column of the spreadsheet, if doing the processing in MM is too difficult), because those would likely cause a confusion for the entity matcher.

So I managed to get back to my data today and removing the colons fixed the issue. It apparently really was the entity matcher being confused by the colons inside the particular data. Thanks for the tip and the quick replies from everyone :-)