External Email - Exercise Caution
Hello,

Has anyone inserted Flex Field Groups into TMS for a large set of records using SQL? I am looking to insert 4 FF groups (each containing between 5 and 17 fields, for a total of 32 individual fields) into roughly 2500 Events records and am having difficulty with it. If you have done this successfully, would you mind sharing the SQL insert script?

TIA!

Sincerely,
Alison

__________________________________
Alison Anderson, MSLIS, DAS, CA (she/her)
Senior Processing Archivist
Harvard Planning Office
Property Information Resource Center
1350 Massachusetts Avenue, Suite 585
Cambridge, MA 02138
T 617-495-4353  F 617-495-0559
https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.planningoffice.harvard.edu%2Fpirc&amp;data=04%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7C186993c8287947cde5d308d976b9b0da%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637671362609546471%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=reqXOlR3oorcTctt1Glw9xiwJcM5C1b3oRMHmnkSNQQ%3D&amp;reserved=0 <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.planningoffice.harvard.edu%2Fpirc&amp;data=04%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7C186993c8287947cde5d308d976b9b0da%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637671362609546471%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=reqXOlR3oorcTctt1Glw9xiwJcM5C1b3oRMHmnkSNQQ%3D&amp;reserved=0>


To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.