spreadsheet download categories

[millertg]

@wsalesky Help! Can you tell us how to tag our note fields so that they appear in the columns you already have set up for us? We want to tag our Getty scope note-en and hant, but can't figure out how to do so (see screenshot). We are just using note type=brief for the moment. What attribute are we missing? If we could know by tomorrow then I could have the kids add the tag before a meeting on Thursday. Thank you!

[wsalesky]

@millertg This is what the code is looking for: tei:note[@type="getty:scopeNote" or @type="Scope Note"]/tei:p[@xml:lang = 'en'

and

/tei:note[@type="getty:scopeNote" or @type="Scope Note"]/tei:p[@xml:lang = 'zh-Hant']

Does that help?

[millertg]

Yes! I will try it tonight. Thank you!

[wsalesky]

@millertg Just checking in, is this resolved?

[millertg]

@wsalesky yes, in a manner of speaking. I was able to use that tag and see the data in the tsv download. However, what I would like to do is to have a tag for a text paragraph that will pull one paragraph (actually 2, one in English one in Chinese) of text from within a "note" into a separate column, without displaying anything on the webpage. Do you happen to have an instant solution for that :-)?

[wsalesky]

@millertg I'm not sure I completely understand. Can you give me an example. The XML, and then how you want it to appear in the download?

[shubenda]

@wsalesky I just tried with tei:note[@type="Scope Note"]/tei:p[@xml:lang = 'en'] and tei:note[@type="Scope Note"]/tei:p[@xml:lang = 'zh-Hant'], see example: https://dev.architecturasinica.org/keyword/k000154 I duplicate the first sentences for both Chinese and English. but the duplicate contents don't show up either under Getty note or brief note. now sure what went wrong. can you help?

[millertg]

@wsalesky @shubenda Let me explain what we are trying to do. more in a second (building screenshots)

[millertg]

@wsalesky @shubenda experimenting on this record: https://dev.architecturasinica.org/keyword/k000154 trying to have Getty subsection of our Note (full) display in separate column

[wsalesky]

@millertg Try now.

[millertg]

@wsalesky @shubenda By george, I think you have done it. It works for zaojing--Yay!! Thank you! Yuh-Fen, do you want to give it a try with a different term (whose code you would have to edit, of course ;-))?

[shubenda]

@wsalesky@millertg yes, it works. Thank you, Winona! I just updated the: https://dev.architecturasinica.org/keyword/k000179 Is this the link we should use to download the keywords in the future? https://dev.architecturasinica.org/modules/data.xql?format=tsv&collection=keywords