So far I and my colleagues at our museum are very pleased with how things are going and we're going to ask our historical society to approve going live with the project soon.
But there are two data items that still won't import. I've tried lots of data types, bundle codes, and refineries. Nothing is working. So I'm asking for help with my mapping file again!
[https://docs.google.com/spreadsheets/d/1KO3zyic2rTSAr5CtvHSv87GRXEMkLt2n/edit?usp=drive_link&ouid=110939141714824481342&rtpof=true&sd=true](https://)
[https://docs.google.com/spreadsheets/d/18tq5y15nKKNpJH9wyRoV_uXo9z5niCBQ/edit?usp=drive_link&ouid=110939141714824481342&rtpof=true&sd=true](https://)
The date the photograph was created should be in the record. Unfortunately, museum assistants have entered this data in various different forms. All we want is for the text to be included in a date field with each record. If it says ca. 1866, the that's what we want. We don't want it converted into 01/01/1866. But right now I can't even get anything to show up.
Although the creator import works well, i.e. the photographer, we can't get the donor's name to import. Sometimes it's a person, sometimes it's an organization, so again, we don't want any fancy formatting. We just want the original text.
Any advice would be terrific. Thanks!