Hi Markus, For Arches5, values for the column "ResourceID" must be uuid's. Given that you've got integers there instead, I'm wondering if the csv import is improperly handling an error it would encounter when trying to ingest those as uuids.
I would recommend trying this: - rename the first column: legacyid - add an additional column at the end called: ResourceID and append an additional comma to the end of every line in your csv Best, Galen On Wednesday, January 20, 2021 at 2:19:50 PM UTC-8 Markus S. wrote: > Hi Lindsey, > > No, I still cannot import dates earlier than 1970-01-01. It has not been a > huge issue since we are only building towards a demo site, but it would > need to be resolved sooner or later. > > Markus > > On Tuesday, January 19, 2021 at 4:51:47 PM UTC-8 Lindsey Gant wrote: > >> Hi Markus, >> >> Thanks for your message. I see that your question has not been answered >> yet. Have you had any success importing dates from a CSV file? If not, >> let me see if someone in the group can follow up. >> >> Thanks, >> >> Lindsey >> GCI Arches Project Team >> >> On Tuesday, December 15, 2020 at 3:35:30 PM UTC-8 Markus S. wrote: >> >>> Hi, >>> >>> I ran into a bit of a curious issue while importing dates from a CSV >>> file to a date field or fields in Arches v5.1. >>> >>> The CSV file looks roughly like this: >>> >>> *ResourceID,Period of Significance From Date,Period of Significance To >>> Date* >>> 3215,1985-01-01,1986-01-01 >>> 3215,1964-01-01,1965-01-01 >>> >>> For any date before 1970-01-01, Arches import function (append to an >>> existing record) produces Error #22: "invalid argument or is not a >>> prefLabel in the given collection". Since it's a date import, not a >>> concept, we can interpret this as "invalid argument". From the above >>> sample, only the first row would get imported because the dates included >>> are later than 1970-01-01 (which is the Unix epoch date, weirdly). >>> >>> In the Cards, the Minimum Date has been left empty. I also tried a >>> minimum date a few hundred years back - did not make a difference. >>> >>> In the Resource Model, the branch is a simple one. Something like this: >>> >>> - DEMO model (E18) >>> - Evaluation (E13) (semantic) >>> - Period of Significance (E52) (semantic) >>> - *Period of Significance From Date (E49) (date ISO-8601)* >>> - *Period of Significance To Date (E49) (date ISO-8601)* >>> >>> >>> Any advice? >>> >> -- -- To post, send email to archesproject@googlegroups.com. To unsubscribe, send email to archesproject+unsubscr...@googlegroups.com. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to archesproject+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/1f1b8dac-3549-45e4-8bb3-5a2e6a13e7d9n%40googlegroups.com.
