Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.


If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping


Answers may be delayed for posts that do not include sufficient information.

Import fuzzy dates like "1945-10-00"?

I'm dealing with a dataset that stores dates in ISO8601 format, and uses "00" for month/day if they are unknown.

For example:
* 1945-10-00
* 1946-00-01

CA is very good with fuzzy date values, but when trying to import that value using the importer (spreadsheet mapping), it throws an error because it's an invalid date :cry:
I've read the documentation of the "dateAccuracyJoiner", but as I understand it, I would have to know the accuracy-level (day/month/year) beforehand. The source data accuracy is arbitrarily mixed though: Sometimes the dates are exact, sometimes they're fuzzy...

Any suggestions on how to import data like this?

Thank you very much in advance! :smile:

Sign In or Register to comment.