Thanks Alexei! It must be something specific to my files or my system setups And yes, I can create dates older then 1970 via the UI. It's just the import where those don't get accepted.
Galen, I believe Arches will generate it's own UUID if we pass as ResourceID values that are not valid UUIDs. The non-valid UUID will be stored as Legacy ID. The nice thing is that if I do another import and the new CSV import file also uses the Legacy ID in the ResourceID column, the imported (appended) data fill find its way to the correct record. So, in the CSV files I don't necessarily have to worry about the UUIDs. That is my experience so far. I will continue digging into my date issue. On Thursday, January 21, 2021 at 11:06:09 PM UTC-8 Alexei Peters wrote: > Hi Markus, > I just created a small graph based on your example. I allowed for > multiple values for the Evaluation Card. > With that setup, I was able to import a csv file structured exactly like > the one you specify above without any issue. > > Have you tried creating a date older than 1970 via the UI? If so did that > work? > If you can do that, maybe you should try exporting your data to see if the > format of the csv is the same as what you're trying to import. > > FYI I didn't need to specify resource ids as UUIDs for the import to work. > Cheers, > Alexei > > Director of Web Development - Farallon Geographics, Inc. - 971.227.3173 > <(971)%20227-3173> > > > On Tue, Dec 15, 2020 at 3:35 PM Markus S. <[email protected]> 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 [email protected]. To unsubscribe, >> send email to [email protected]. 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 [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/archesproject/3336c6e1-e9ad-4e86-8861-97a16c26d6cbn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/archesproject/3336c6e1-e9ad-4e86-8861-97a16c26d6cbn%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/4a1c9ec5-2565-4088-918f-b462bc17be27n%40googlegroups.com.
