Start a new topic

Importing gifts with multiple attributes

Hello everyone!

 

I have been working on trying to figure out how to import gifts that have multiple attributes and have had no luck so far. We record gifts of works of art as gifts in kind and if someone gives several objects with the same classification (like a collection of 40 photographs) it is recorded as a single GIK with multiple attributes, as you can see in the example below:


image


Every gift has one TMS Object Classification line and at least one TMS Object ID. 

Is there a simple way to import multiple TMS Object ID attribute comments into a single gift in the same import file?

 

Thank you for you help.

 

Phoebe


Hi Phoebe,

IOM isn't able to update an existing gift, unfortunately.

This is something you could accomplish using the API, though. If you have someone on staff who can write code in Visual Basic they can write this for you. We can also write it as a customization.

Otherwise you would need to edit the file so that each gift is on a single line, with each attribute in its own column.

Please let me know if you would like to hear more about a possible customization.

Thank you,
Amanda
Omatic Software
Hi Amanda,

No, unfortunately there is a separate row for each attribute. Each row is a single object with unique information in several columns (it's a bit of a hot mess at the moment). I guess what I'm hoping is that they can be imported the same way split gifts are processed. If not, I figured I could import the attributes separately with a gift ID or import ID.
Does that sound feasible?

Thanks!

Phoebe

Hi Phoebe,

Is each attribute in its own column in the file? If so you can map each one separately:

image




Please let me know if you have any other questions!

Thank you,
Amanda
Omatic Software

Login or Signup to post a comment