-
Notifications
You must be signed in to change notification settings - Fork 0
Readme
TrelloExcelImporter README
Coded summer 2012 README written summer 2013
Author: chipbite / mawi / marcus.widerberg@gmail.com
USAGE NOTES
- Worksheet needs URL for trello data & column/fields setup
CODE NOTES
TL;DR CopyActionsMap
FieldsToCopy (TableFieldCopyConfiguration) ColumnCopyConfig
/ m_fieldConfig CopyActionsMap CopyAction
Generic classes (interesting out of trello context): GenericIterator
- Wraps a VBA collection as an iterator (MoveNext, Current
- Can also accept jsonText and parse it using JSONLib
- TrelloImporter can almost set itself up based on a sheet reference.
- Items (GenericIterator) encapsulate the json data collections.
CopyActionsMap
- Simple CopyAction - processes a fieldName that is given in the excel sheet
- PrefixCopyAction - uses a prefix and a fieldname in the excel sheet
CopyActions
-
CopyAction - simple, field value is copied to cell ( ex: &idShort, &title )
-
CopyActionArray - Outputs json array into cell (&&idMembers)
-
CopyAction_MemberNames - highly customized action that looks up/gets a field value of a member
-
CopyActions_NameField - allows for getting fields in title/name of card. Does: estimate (nr in parens in name) & shortcrid (value before hyphen ie 10 from "10 - blabla")
-
CopyActions_CardListMoves - not done. to be developed.
Objective: Get Date when card moved from list A to list B Usage: In cardlisting, enter field &completed__ (4ff53edb8a4b45f6489d6b89 for Features Analysis in test project) This will search card history for date of move from Features Analysis to Features Todo, for instance.