Wow! This is fabulous, Richard! It gets me really close to where I'm going!
Thanks so much!
Fatima
On Mon, Jul 1, 2019 at 3:23 PM Richard Grant <[log in to unmask]> wrote:
> Here is a SQL statement that will insert a FlexField.
>
> INSERT INTO UserFieldXrefs (UserFieldID, ID, ContextID, FieldValue,
> ValueRemarks, LoginID, UserFieldGroupID) SELECT [YOUR USER FIELD ID],
> Objects.ObjectID ,1, '[YOUR FIELD VALUE]', '[YOUR VALUE REMARKS]', '[YOUR
> LOGIN ID]' ,-1 FROM Objects WHERE ObjectNumber = 'YOUR OBJECT NUMBER'
>
> In order to create inserts for a large group of Flex Fields, the best
> approach is to put the data into an EXCEL spreadsheet and use a CONCATENATE
> statement to create the SQL lines. Attached is an example of how to do
> it. Click on cell F1 to have the CONCATENATE statement show up in the data
> entry box. Call if you need help.
>
>
>
> *Richard GrantExecutive Director*
> 3214 College Avenue
> Berkeley, CA 94705
> [log in to unmask]
> 510.428.1400 ext 4
> 510.459.4556 mobile
> Instagram
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fdiebenkornfoundation%2F&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7Ccdd10cf2205e46d9391408d6fe5c5d95%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636976069995527277&sdata=b5IXcIuKDTyqJnKTPE0LTtitn%2BJlqB%2FdUI4qLgSQAKI%3D&reserved=0>
> | Twitter
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Fdiebenkorn_fnd&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7Ccdd10cf2205e46d9391408d6fe5c5d95%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636976069995527277&sdata=J38BEUdUKWQhDQ93hdTIhLyZGX06VUh668xmdb8tshs%3D&reserved=0> [image:
> Richard Diebenkorn Fountation]
> <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.diebenkorn.org%2F&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7Ccdd10cf2205e46d9391408d6fe5c5d95%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636976069995527277&sdata=oLmoJNfvXCR7TXMSoTDwmwm9A6nhfgQsbHpMM7DJZvI%3D&reserved=0>
>
>
>
> On Mon, Jul 1, 2019 at 11:47 AM Mahdi, Fatima <[log in to unmask]>
> wrote:
>
>> Hello folks! Does anyone just happen to have a SQL statement for batch
>> adding flex fields to a group of object records, say for example an object
>> package?
>>
>> Thanks!
>>
>> --
>>
>>
>> *Fatima Mahdi*Collections Information Specialist/TMS
>>
>>
>> *Virginia Museum of Fine Arts *200 N. Boulevard
>> Richmond, VA 23220-4007
>> T 804.340.1443
>>
>> [log in to unmask]
>> 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.
>>
> 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.
>
--
*Fatima Mahdi*Collections Information Specialist/TMS
*Virginia Museum of Fine Arts *200 N. Boulevard
Richmond, VA 23220-4007
T 804.340.1443
[log in to unmask]
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.