Clone google docs templates into separate folder

[drzax]

Organisationally, it would be nice to keep the Google Sheets templates which are cloned for each new chart in a separate folder.

Currently, copies made for each specific chart are automatically added to the same folder/location as the templates. It would be ideal if they were kept somewhere separate.

I think this is the relevant function https://github.com/abcnews/dailygraphics/blob/master/fabfile/__init__.py#L427

[phocks]

I've been having a quick look at this. I've had some luck updating a doc's "parents" ie. put it in a folder on my own Google account using the code here https://developers.google.com/drive/v2/web/folder

    file_id = '1nWB9Lww_e8XNd2QcdhAyb4PnxQcR6rVsjPyt2THtlYs'
    folder_id = '0B3RxvOWyA3RdM1UyWkJ2WWowX0E'
    # Retrieve the existing parents to remove
    file = service.files().get(fileId=file_id,
                                     fields='parents').execute();
    previous_parents = ",".join(file.get('parents'))
    # Move the file to the new folder
    file = service.files().update(fileId=file_id,
                                        addParents=folder_id,
                                        removeParents=previous_parents,
                                        fields='id, parents').execute()

Chart builder uses Authomatic so the process will be a bit different, but I imagine if we just update this bit of code:

kwargs = {
        'credentials': get_credentials(),
        'url': SPREADSHEET_COPY_URL_TEMPLATE % graphic_config.COPY_GOOGLE_DOC_KEY,
        'method': 'POST',
        'headers': {'Content-Type': 'application/json'},
        'body': json.dumps({
            'title': '%s GRAPHIC COPY' % slug,
        }),
    }

to:

kwargs = {
        'credentials': get_credentials(),
        'url': SPREADSHEET_COPY_URL_TEMPLATE % graphic_config.COPY_GOOGLE_DOC_KEY,
        'method': 'POST',
        'headers': {'Content-Type': 'application/json'},
        'body': json.dumps({
            'title': '%s GRAPHIC COPY' % slug,
            'parents': ['0B3RxvOWyA3RdM1UyWkJ2WWowX0E']
        }),
    }

Then theoretically every time we create a doc it would put it in that folder. We then could keep the original templates separate. What do you think? I couldn't easily get Chart Builder working locally with Google OAuth, but I could try again.

[drzax]

That looks promising. Nice job.