This is just hypothetical because I didn't actually do this for the Google
Art Project, but you should be able to query TMS in a way that outputs the
data so it conforms to the XML specification (
https://support.google.com/culturalinstitute/partners/answer/2995053?hl=en).
I left off location and image but otherwise it would look like this for SQL
Server (assuming that the code and special characters are sent via our
email and received via yours)...
DECLARE @string NVARCHAR(MAX);
-- note that it starts with just 10 records
SET @string = '<?xml version="1.0" encoding="UTF-8"?>' + (SELECT
(SELECT TOP 10 O.ObjectNumber AS '@identifier',
(SELECT O.Title AS 'text'
FOR XML PATH ('title')),
(SELECT O.Description AS 'text'
FOR XML PATH ('description')),
-- this is a hack around the date that Google expects
(SELECT CAST(O.DateBegin AS NVARCHAR(4)) + '-01-01' AS 'dateValue'
FOR XML PATH ('dateCreated')),
(SELECT OD.DisplayName AS 'text'
FOR XML PATH ('creator'))
FROM Objects O
INNER JOIN ObjectDescription OD ON O.ObjectID = OD.ObjectID
-- WHERE {add some qualifier for the GAP objects}
FOR XML PATH ('item'))
FOR XML PATH(''),
ROOT('itemset'));
-- change to your language
SET @string = REPLACE(@string, N'&lt;text&gt;', N'<text
lang="en">');
SET @string = REPLACE(REPLACE(REPLACE(REPLACE(@string, '<', '<'),'>',
'>'),'&lt;', '<'),'&gt;', '>');
SELECT @string;
Steven Moore
Database Administrator
The Museum of Modern Art (MoMA)
11 West 53 Street ~ New York, NY ~ 10019
[log in to unmask]
Phone: 011.33.62.782.1223
On Mon, Mar 16, 2015 at 5:46 PM, Frances Lloyd-Baynes <
[log in to unmask]> wrote:
> We have some data in Google Art Project (158 records) and are about to add
> a bit more (10 new records) to join up with some new gigapixel images
> they took of our art work. We have not had a great experience, having come
> into the project it late. (Our initial data was published in January 2013.)
> Our first experience involved a large amount of manual work directly in the
> Google interface - very slow and laborious.
>
> As in so many other data aggregation projects over the years, Google
> essentially requires one to match their spec. They say they align with
> LIDO, but unfortunately we do not at present, so did/are once again having
> to manually prepare the data for load via CSV. There remain issues re:
> their documentation (delivered via pdf) and the instructions stated
> online not matching up in rather serious ways. Somehow I feel it ought to
> be easier...
>
> If you want to talk more specifically, please feel free to call me.
>
> Cheers,
> Frances
>
> On Mon, Mar 16, 2015 at 4:00 PM, TMSUSERS automatic digest system <
> [log in to unmask]> wrote:
>
>> There are 2 messages totaling 314 lines in this issue.
>>
>> Topics of the day:
>>
>> 1. TMS and Google Art Project (2)
>>
>> 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.
>>
>> ----------------------------------------------------------------------
>>
>> Date: Mon, 16 Mar 2015 17:24:02 +0000
>> From: Cristina Lichauco <[log in to unmask]>
>> Subject: TMS and Google Art Project
>>
>> Good Moring!
>>
>>
>> I was wondering if anyone on the list is using TMS and participating in
>> the Google Art Project. I'd love to talk to you. We are moving forward on
>> our participation and I have some questions about how others are preparing
>> TMS data and media files to meet the Google metadata specs. Thanks!
>>
>>
>> Cristina Lichauco
>> Collections Database Administrator
>> Asian Art Museum
>> 200 Larkin Street
>> San Francisco, CA 94102
>> E: [log in to unmask]
>> T: 415-581-3676
>>
>> SEARCH THE COLLECTION
>> http://searchcollection.asianart.org
>>
>> 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.
>>
>> ------------------------------
>>
>> Date: Mon, 16 Mar 2015 14:09:59 -0400
>> From: Deborah Wythe <[log in to unmask]>
>> Subject: Re: TMS and Google Art Project
>>
>> The Brooklyn Museum is in Google art, but we had the GAP staff pull our
>> data using our API, so there wasn't a lot of work on our end, besides
>> reviewing their field mapping from the website data (which is scripted from
>> TMS) to the GAP fields.
>>
>> Deborah
>>
>> Deborah Wythe
>> head of Digital Collections nad Services
>> Brooklyn [log in to unmask]
>>
>> Date: Mon, 16 Mar 2015 17:24:02 +0000
>> From: [log in to unmask]
>> Subject: TMS and Google Art Project
>> To: [log in to unmask]
>>
>>
>>
>>
>>
>>
>>
>>
>> Good Moring!
>>
>>
>>
>> I was wondering if anyone on the list is using TMS and participating in
>> the Google Art Project. I'd love to talk to you. We are moving forward on
>> our participation and I have some questions about how others are
>> preparing TMS data and media files to meet the Google metadata specs.
>> Thanks!
>>
>>
>>
>>
>>
>>
>>
>> Cristina Lichauco
>>
>> Collections Database Administrator
>>
>>
>> Asian Art Museum
>>
>>
>> 200 Larkin Street
>>
>>
>> San Francisco, CA 94102
>>
>>
>> E: [log in to unmask]
>>
>> T: 415-581-3676
>>
>>
>>
>>
>>
>> SEARCH THE COLLECTION
>> http://searchcollection.asianart.org
>>
>>
>>
>>
>>
>>
>>
>> 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.
>>
>> ------------------------------
>>
>> End of TMSUSERS Digest - 13 Mar 2015 to 16 Mar 2015 (#2015-48)
>> **************************************************************
>>
>
>
>
> --
> Frances Lloyd-Baynes | Content Database Specialist
> Minneapolis Institute of Arts
> 2400 Third Avenue South
> Minneapolis, MN 55404
>
> 612-870-3189 | [log in to unmask] | www.artsmia.org
>
>
> 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.