Hi
I am trying export some data from a web page and import it to an Exel sheet or Google Sheet. The Website is Trello which i use for project management. In Trello there is lists and in the lists there are cards. In the cards there are checklists. I manage the construction of apartments. so i assign a building to a list, an apartment to a card and in each card a generic checklist, eg..
Task 1 Walls up,
Task 2 Cables in walls,
Task 3 Walls closed,
Task 4 Walls Painted and so on..
Once a task is complete a member of the Trello board will tick one of these tasks as complete. I then need to open each card individually and physically export this information to an Exel Sheet. I am trying to automate this process.
Below is a JSON file of a sample Trello board i made. in lines 572-579 is the code for the first checklist item. I want to export this item and its status (complete or incomplete) to a cell of an Exel Sheet or a Google sheet.
I am trying export some data from a web page and import it to an Exel sheet or Google Sheet. The Website is Trello which i use for project management. In Trello there is lists and in the lists there are cards. In the cards there are checklists. I manage the construction of apartments. so i assign a building to a list, an apartment to a card and in each card a generic checklist, eg..
Task 1 Walls up,
Task 2 Cables in walls,
Task 3 Walls closed,
Task 4 Walls Painted and so on..
Once a task is complete a member of the Trello board will tick one of these tasks as complete. I then need to open each card individually and physically export this information to an Exel Sheet. I am trying to automate this process.
Below is a JSON file of a sample Trello board i made. in lines 572-579 is the code for the first checklist item. I want to export this item and its status (complete or incomplete) to a cell of an Exel Sheet or a Google sheet.
// 20190511200807 // https://trello.com/b/bcCR15aF.json { "id": "5cd716ab87210e88cb780993", "name": "Test Python", "desc": "", "descData": null, "closed": false, "idOrganization": null, "limits": { "attachments": { "perBoard": { "status": "ok", "disableAt": 36000, "warnAt": 32400 }, "perCard": { "status": "ok", "disableAt": 1000, "warnAt": 900 } }, "boards": { "totalMembersPerBoard": { "status": "ok", "disableAt": 1600, "warnAt": 1440 } }, "cards": { "openPerBoard": { "status": "ok", "disableAt": 5000, "warnAt": 4500 }, "openPerList": { "status": "ok", "disableAt": 5000, "warnAt": 4500 }, "totalPerBoard": { "status": "ok", "disableAt": 2000000, "warnAt": 1800000 }, "totalPerList": { "status": "ok", "disableAt": 1000000, "warnAt": 900000 } }, "checklists": { "perBoard": { "status": "ok", "disableAt": 2000000, "warnAt": 1800000 }, "perCard": { "status": "ok", "disableAt": 500, "warnAt": 450 } }, "checkItems": { "perChecklist": { "status": "ok", "disableAt": 200, "warnAt": 180 } }, "customFields": { "perBoard": { "status": "ok", "disableAt": 50, "warnAt": 45 } }, "customFieldOptions": { "perField": { "status": "ok", "disableAt": 50, "warnAt": 45 } }, "labels": { "perBoard": { "status": "ok", "disableAt": 1000, "warnAt": 900 } }, "lists": { "openPerBoard": { "status": "ok", "disableAt": 500, "warnAt": 450 }, "totalPerBoard": { "status": "ok", "disableAt": 3000, "warnAt": 2700 } }, "stickers": { "perCard": { "status": "ok", "disableAt": 70, "warnAt": 63 } }, "reactions": { "perAction": { "status": "ok", "disableAt": 1000, "warnAt": 900 }, "uniquePerAction": { "status": "ok", "disableAt": 17, "warnAt": 16 } } }, "pinned": false, "starred": false, "url": "https://trello.com/b/bcCR15aF/test-python", "prefs": { "permissionLevel": "private", "voting": "disabled", "comments": "members", "invitations": "members", "selfJoin": false, "cardCovers": true, "isTemplate": false, "cardAging": "regular", "calendarFeedEnabled": false, "background": "5c369a71115e4a500728b342", "backgroundImage": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/1365x2048/2592a2c00c59bd676f116229de21ed87/photo-1467217440414-bf182fc492d9", "backgroundImageScaled": [ { "width": 67, "height": 100, "url": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/67x100/dd283766c268d815d9ebfaa14d0af899/photo-1467217440414-bf182fc492d9.jpg" }, { "width": 128, "height": 192, "url": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/128x192/dd283766c268d815d9ebfaa14d0af899/photo-1467217440414-bf182fc492d9.jpg" }, { "width": 320, "height": 480, "url": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/320x480/dd283766c268d815d9ebfaa14d0af899/photo-1467217440414-bf182fc492d9.jpg" }, { "width": 640, "height": 960, "url": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/640x960/dd283766c268d815d9ebfaa14d0af899/photo-1467217440414-bf182fc492d9.jpg" }, { "width": 683, "height": 1024, "url": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/683x1024/dd283766c268d815d9ebfaa14d0af899/photo-1467217440414-bf182fc492d9.jpg" }, { "width": 853, "height": 1280, "url": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/853x1280/dd283766c268d815d9ebfaa14d0af899/photo-1467217440414-bf182fc492d9.jpg" }, { "width": 1280, "height": 1920, "url": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/1280x1920/dd283766c268d815d9ebfaa14d0af899/photo-1467217440414-bf182fc492d9.jpg" }, { "width": 1066, "height": 1600, "url": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/1066x1600/dd283766c268d815d9ebfaa14d0af899/photo-1467217440414-bf182fc492d9.jpg" }, { "width": 1365, "height": 2048, "url": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/1365x2048/2592a2c00c59bd676f116229de21ed87/photo-1467217440414-bf182fc492d9" } ], "backgroundTile": false, "backgroundBrightness": "light", "backgroundBottomColor": "#66645b", "backgroundTopColor": "#85797e", "canBePublic": true, "canBeEnterprise": true, "canBeOrg": true, "canBePrivate": true, "canInvite": true }, "shortLink": "bcCR15aF", "subscribed": false, "labelNames": { "green": "", "yellow": "", "orange": "", "red": "", "purple": "", "blue": "", "sky": "", "lime": "", "pink": "", "black": "" }, "powerUps": [ ], "dateLastActivity": "2019-05-11T18:40:30.746Z", "dateLastView": "2019-05-11T19:08:07.505Z", "shortUrl": "https://trello.com/b/bcCR15aF", "idTags": [ ], "datePluginDisable": null, "creationMethod": null, "ixUpdate": "28", "actions": [ { "id": "5cd716f3dea0c166f7844d91", "idMemberCreator": "54d372bcf74d4723be02a89c", "data": { "board": { "shortLink": "bcCR15aF", "name": "Test Python", "id": "5cd716ab87210e88cb780993" }, "checklist": { "name": "Checklist Items to play with ", "id": "5cd716f3dea0c166f7844d90" }, "card": { "shortLink": "JOLfF8lA", "idShort": 1, "name": "First Card", "id": "5cd716d2c556ee88e239b3e3" } }, "type": "addChecklistToCard", "date": "2019-05-11T18:39:47.428Z", "limits": { }, "memberCreator": { "id": "54d372bcf74d4723be02a89c", "avatarHash": null, "avatarUrl": null, "fullName": "Shane Flanagan", "idMemberReferrer": null, "initials": "SF", "nonPublic": { }, "nonPublicAvailable": false, "username": "shaneflanagan2" } }, { "id": "5cd716d2c556ee88e239b3e4", "idMemberCreator": "54d372bcf74d4723be02a89c", "data": { "board": { "shortLink": "bcCR15aF", "name": "Test Python", "id": "5cd716ab87210e88cb780993" }, "list": { "name": "My Number 1 Sample List", "id": "5cd716c53037eb644c58fb82" }, "card": { "shortLink": "JOLfF8lA", "idShort": 1, "name": "First Card", "id": "5cd716d2c556ee88e239b3e3" } }, "type": "createCard", "date": "2019-05-11T18:39:14.294Z", "limits": { }, "memberCreator": { "id": "54d372bcf74d4723be02a89c", "avatarHash": null, "avatarUrl": null, "fullName": "Shane Flanagan", "idMemberReferrer": null, "initials": "SF", "nonPublic": { }, "nonPublicAvailable": false, "username": "shaneflanagan2" } }, { "id": "5cd716c53037eb644c58fb83", "idMemberCreator": "54d372bcf74d4723be02a89c", "data": { "board": { "shortLink": "bcCR15aF", "name": "Test Python", "id": "5cd716ab87210e88cb780993" }, "list": { "name": "My Number 1 Sample List", "id": "5cd716c53037eb644c58fb82" } }, "type": "createList", "date": "2019-05-11T18:39:01.718Z", "limits": { }, "memberCreator": { "id": "54d372bcf74d4723be02a89c", "avatarHash": null, "avatarUrl": null, "fullName": "Shane Flanagan", "idMemberReferrer": null, "initials": "SF", "nonPublic": { }, "nonPublicAvailable": false, "username": "shaneflanagan2" } }, { "id": "5cd716ab87210e88cb780995", "idMemberCreator": "54d372bcf74d4723be02a89c", "data": { "board": { "shortLink": "bcCR15aF", "name": "Test Python", "id": "5cd716ab87210e88cb780993" } }, "type": "createBoard", "date": "2019-05-11T18:38:35.833Z", "limits": { }, "memberCreator": { "id": "54d372bcf74d4723be02a89c", "avatarHash": null, "avatarUrl": null, "fullName": "Shane Flanagan", "idMemberReferrer": null, "initials": "SF", "nonPublic": { }, "nonPublicAvailable": false, "username": "shaneflanagan2" } } ], "cards": [ { "id": "5cd716d2c556ee88e239b3e3", "address": null, "checkItemStates": null, "closed": false, "coordinates": null, "creationMethod": null, "dateLastActivity": "2019-05-11T18:40:30.746Z", "desc": "", "descData": null, "dueReminder": null, "idBoard": "5cd716ab87210e88cb780993", "idLabels": [ ], "idList": "5cd716c53037eb644c58fb82", "idMembersVoted": [ ], "idShort": 1, "idAttachmentCover": null, "limits": { "attachments": { "perCard": { "status": "ok", "disableAt": 1000, "warnAt": 900 } }, "checklists": { "perCard": { "status": "ok", "disableAt": 500, "warnAt": 450 } }, "stickers": { "perCard": { "status": "ok", "disableAt": 70, "warnAt": 63 } } }, "locationName": null, "manualCoverAttachment": false, "name": "First Card", "pos": 65535, "shortLink": "JOLfF8lA", "badges": { "attachmentsByType": { "trello": { "board": 0, "card": 0 } }, "location": false, "votes": 0, "viewingMemberVoted": false, "subscribed": false, "fogbugz": "", "checkItems": 3, "checkItemsChecked": 0, "comments": 0, "attachments": 0, "description": false, "due": null, "dueComplete": false }, "dueComplete": false, "due": null, "email": "shaneflanagan+2jml9mjwmgnqycdh3fg+2sa8ibq0g0a577sw737+28awozdh0n@boards.trello.com", "idChecklists": [ "5cd716f3dea0c166f7844d90" ], "idMembers": [ ], "labels": [ ], "shortUrl": "https://trello.com/c/JOLfF8lA", "subscribed": false, "url": "https://trello.com/c/JOLfF8lA/1-first-card", "attachments": [ ], "pluginData": [ ], "customFieldItems": [ ] } ], "labels": [ { "id": "5cd716ab91d0c2ddc5b20b34", "idBoard": "5cd716ab87210e88cb780993", "name": "", "color": "yellow" }, { "id": "5cd716ab91d0c2ddc5b20b35", "idBoard": "5cd716ab87210e88cb780993", "name": "", "color": "green" }, { "id": "5cd716ab91d0c2ddc5b20b36", "idBoard": "5cd716ab87210e88cb780993", "name": "", "color": "orange" }, { "id": "5cd716ab91d0c2ddc5b20b38", "idBoard": "5cd716ab87210e88cb780993", "name": "", "color": "red" }, { "id": "5cd716ab91d0c2ddc5b20b3e", "idBoard": "5cd716ab87210e88cb780993", "name": "", "color": "purple" }, { "id": "5cd716ab91d0c2ddc5b20b3f", "idBoard": "5cd716ab87210e88cb780993", "name": "", "color": "blue" } ], "lists": [ { "id": "5cd716c53037eb644c58fb82", "name": "My Number 1 Sample List", "closed": false, "idBoard": "5cd716ab87210e88cb780993", "pos": 65535, "subscribed": false, "softLimit": null, "limits": { "cards": { "openPerList": { "status": "ok", "disableAt": 5000, "warnAt": 4500 }, "totalPerList": { "status": "ok", "disableAt": 1000000, "warnAt": 900000 } } }, "creationMethod": null } ], "members": [ { "id": "54d372bcf74d4723be02a89c", "avatarHash": null, "avatarUrl": null, "bio": "", "bioData": null, "confirmed": true, "fullName": "Shane Flanagan", "idEnterprise": null, "idEnterprisesDeactivated": [ ], "idMemberReferrer": null, "idPremOrgsAdmin": [ ], "initials": "SF", "memberType": "normal", "nonPublic": { }, "nonPublicAvailable": false, "products": [ 37 ], "url": "https://trello.com/shaneflanagan2", "username": "shaneflanagan2", "status": "disconnected" } ], "checklists": [ { "id": "5cd716f3dea0c166f7844d90", "name": "Checklist Items to play with ", "idBoard": "5cd716ab87210e88cb780993", "idCard": "5cd716d2c556ee88e239b3e3", "pos": 16384, "limits": { "checkItems": { "perChecklist": { "status": "ok", "disableAt": 200, "warnAt": 180 } } }, "checkItems": [ { "idChecklist": "5cd716f3dea0c166f7844d90", "state": "incomplete", "id": "5cd717024ec65679562e7eab", "name": "Taskio Number 1", "nameData": null, "pos": 16405 }, { "idChecklist": "5cd716f3dea0c166f7844d90", "state": "incomplete", "id": "5cd7170ae7189b28d5cc7659", "name": "Taskio Number 2", "nameData": null, "pos": 33624 }, { "idChecklist": "5cd716f3dea0c166f7844d90", "state": "incomplete", "id": "5cd7171a4e690b6639f0b36b", "name": "Taskio Number 3", "nameData": { "emoji": { } }, "pos": 50031 } ], "creationMethod": null } ], "customFields": [ ], "memberships": [ { "id": "5cd716ab87210e88cb780994", "idMember": "54d372bcf74d4723be02a89c", "memberType": "admin", "unconfirmed": false, "deactivated": false } ], "pluginData": [ ] }