triplebeta / trelloexcelconnector Goto Github PK

Excelsheet asks for a 3 fields but the mechanism seems to have changed.

When publishing to a Trello board a new card can be added to an existing list (works great!!) but when a card needs to be added to a list that does not exist on that board the list is not created.
Can this be added?

Current behavior of Publish does not look at the id's of the cards that were already published once.
Would be better if it first checked if those cards are still at the board and if so, would update them instead of blundly adding a duplicate with another id. This would effectively sync the Excelsheet to the board.

When I enter a non-existing List for a card (e.g. "Todo" instead of "To Do") the card just does not get published and a technical error is logged. This is not visible to a user. Would be better to validate that all lists used in the sheet exist and if not, to show a warning and stop.

When I add custom fields to my cards, they do not appear in Excel.
See also: http://blog.trello.com/creative-uses-for-trello-custom-fields

When using Publish it would be handy to be able to indicate you want all existing cards to be removed from the board prior to publishing to it. This could be a checkbox in the Publish dialog.

When I assign multiple colors to a card, only 1 is retrieved in the Excelsheet.
I would expect all colors to be there, e.g. separated by semicolons.

Blue and yellow would then become: B;Y
This should be supported in the full roundtrip.

Hi, i would like to have for privat reasons some changes. i m willing to pay also if u are able to do that for me, maybe talk over discord or something?

I got the mention problem in first time with task assigned for multi users.
Dim frmForm As New ImportBoard
frmForm.Show
If frmForm.IsCanceled Then Exit Sub

Dim board As New TrelloBoard, Cards() As TrelloCard, Data As New Datasheet
board.Boardname = frmForm.Boardname
Data.Initialize frmForm.Worksheetname, RowIndexOfHeader

'Remove all existing rows
Data.RemoveCurrentRows

'Load all cards from the board, from all lists
'Iterate over the lists and their cards
Dim List As TrelloList, RowIndex As Integer, i As Integer
RowIndex = 0
For i = 1 To board.Lists.Count
    Set List = board.Lists(board.Lists.Keys(i - 1))
    Call Data.AddRowsFromCards(board, List.Listname, List.CardsAsArray(), RowIndex) <=yellow line when go into debug
    RowIndex = RowIndex + List.Cards.Count
Next

End Sub

Thank you.

After running the process to authorize the file, the buttons stay greyed-out.

'Sync from board' is great but 'sync TO board' would also be great.
This macro is just a bit too complex for me to add this feature.
Could this be added?

Hi. When I try to run "Publish" part it mixes up information.
Creates Card No.2 with information which was entered for Card No.3 and etc.
Any ideas on what can cause this?