search

xmlsquad / gsheet-to-xml

Given the url of a Google Sheet, this Symfony Console command fetches the Google Sheet and outputs it in the form of Xml.
Apache License 2.0
3 stars 1 forks source link

Multiple values in the Purpose column (sheets) #1

Closed zoka123 closed 6 years ago

zoka123 commented 6 years ago

Purpose column in the sheet is a single cell and therefore single string value. Purposes elements in the XML are array of Purpose elements.

If there are multiple values in the single cells, how are they delimited? Comma separated values?

forikal-uk commented 6 years ago

Thanks for raising this issue.

It is just one value. Not a comma separated list.

The XML is able to cater for more than one Purpose. However, our client interface (the sheets) do not document this feature to the clients. For now, we never have more than one Purpose.

So, we take the one value from Purpose column and place it as a "collection of one Purpose" in the Purposes element of the XML.