Skip to content

Given the url of a Google Sheet, this Symfony Console command fetches the Google Sheet and outputs it in the form of Xml.

License

Notifications You must be signed in to change notification settings

xmlsquad/gsheet-to-xml

Repository files navigation

sheet-to-xml

Symfony Console command that, given the URL of a (specifically structured) Google Sheet or Google Drive folder of sheets, outputs the contents (perhaps in multiple tabs) in the form of Xml.

Designed be used in the context of the Symfony Console application at https://github.com/xmlsquad/xml-authoring-tools which, in turn, is used in the context of a known directory structure which is based on xml-authoring-project.

Documentation

See: https://github.com/xmlsquad/gsheet-to-xml/blob/master/DOCUMENTATION.md

Original Specification:

Schema descriptions

I have published

Naming convention.

Given a Google Sheet, unless the sheet's name implies it is 'ignored', it is assumed that its structure is valid structure of an Inventory sheet. Given a Google Drive folder, it is assumed that any Google Sheets found within have the valid structure of an Inventory sheet (unless the sheet's name implies it is 'ignored').

A Google sheet's with a trailing underscore in their name imply that it should be 'ignored'. A Google sheet tab's with a trailing underscore in their name imply that it should be 'ignored'.

If a file is called foo, then it is validated as normal. If a file is called foo_, then it is assumed to be 'private' and should be explicitly ignored, but it should be noted (in any feedback) that it was ignored. If a Google Sheet's tab is named foo, then it is validated as normal. If a Google Sheet's tab is named foo_, then it is assumed to be 'private' and should be explicitly ignored, but it should be noted (in any feedback) that it was ignored.

Input

  • driveUrl: The URL of the Google Drive entity (Google Sheet or Google Drive folder).

  • is-recursive: if the Google Drive entity is a Google Drive folder, this option specifies whether or not to recurse through sub-directories to find sheets.

Behaviour

If the driveUrl is a Google Sheet write out the contents as Xml. If it is a Google Drive find all Google Sheets within the directory (recursively, if specified) and write out the contents as Xml.

Output

STD_OUT

Streamed output.

Xml representation of the Inventory data in the Google Sheet.

About

Given the url of a Google Sheet, this Symfony Console command fetches the Google Sheet and outputs it in the form of Xml.

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages