Another project has migrated 40.000 Trac/Trello tickets, and they are sharing their scripts:

https://secure.phabricator.com/T3179#81309

https://secure.phabricator.com/P1407

Anybody willing to get in touch with them?

This is the blocker for UX and Design research to port our planning boards. Just a heads up.

I'm looking at this, notes at Trello to Phabricator wiki page.

cburroughs' scripts have issues: "This script uses a trello enterprise export", some missing undocumented pieces like conf/trello-scrub.yaml , etc. It might be better to start from our BZ migration code and borrow stuff from cburroughs' work. I'll talk to @chasemp

@Jaredzimmerman-WMF points out checkbox lists in Trello as something that's beyond BZ import. I'm sure there's more.

In T821#790802, @Qgil wrote:

Still, I hope he has some time to help you reusing his import script.

Or explore the code at https://git.wikimedia.org/tree/phabricator%2Ftools.git

In T821#790338, @Spage wrote:

cburroughs' scripts have issues: "This script uses a trello enterprise export"

This part is not a problem. Apparently "Trello Enterprise" is now called Trello Business Class. That says:

"Business Class gives you easy and powerful bulk data exports in CSV and JSON."

so presumably that is what the script needs (regardless of whether cburroughs' code is used, the Business Class export may prove useful).

WMF has the Business Class service currently (see https://trello.com/wikimediafoundation).

I have a business class account if anyone needs an export to play with

If the script being discussed doesn't work out for whatever reason, the Trello API is fairly straightforward. I put together a basic Trello API wrapper for Bingle/Bugello which may be useful, though it would require some augmentation for this usecase (as I understand the API, shouldn't be too much effort): https://github.com/wikimedia/bingle/blob/master/lib/trello.py

@Spage, can you post an update here?

There is an increasing interest in Trello migrations (i.e. Jaredzimmerman-WMF is happy to migrate the Design boards as soon as the script is ready). Mingle actually stepped in first with P129. And on the other hand, according to @mattflaschen the Collaboration team seems to be happy copying existing Trello cards to Phabricator manually for now... (source, board)

In T821#790802, @Qgil wrote:

Trello to Phabricator is an interesting wiki page. Should we bring it to the Main namespace

Done, https://www.mediawiki.org/wiki/Phabricator/Trello_to_Phabricator

and link it properly from the corresponding Phabricator pages? It could serve as landing page for anything related t this topic, pretty much like the /versus_Bugzilla page.

In T821#836350, @Qgil wrote:

@Spage, can you post an update here?

Sure, and it's on that page. I have some simple code in a "trabulous" branch of phabricator/tools

There is an increasing interest in Trello migrations (i.e. Jaredzimmerman-WMF is happy to migrate the Design boards as soon as the script is ready).

But @Jaredzimmerman-WMF wants attachments, comments, etc. As you note, Collaboration-Team-Triage was happy just with basic import of Title and Description, for which I used the conduit createtask form.

Mingle actually stepped in first with P129.

Yup, @Gilles code looks excellent.

And on the other hand, according to @mattflaschen the Collaboration team seems to be happy copying existing Trello cards to Phabricator manually for now... (source, board)

Currently, my trello_create.py just improves the copy and paste of Title and Description, appending a link to the trello card. See sample at T76818. Next step is to adapt some of P129's code.

Attachments and comments are clear requirements for a migration script, yes. About checklists, what Phabricator can offer is described in T1141.

Have you decided which route is best to take to support this. We have not one but three scripts that could be adapted for this. Is "This script uses a trello enterprise export" the only problem of cburroughs' one (the only one that has been used to migrate from Trello to Phabricator)? I think Jared mentioned that we can use an available Trello license, somewhere.

I have merged T36: Migrate Trello data to Phabricator here because migrating all the Trello data is not a goal in itself. At least the Collaboration team is considering to take this chance and make a clean room, cloning only the Trello cards involved in new sprints. (A similar approach is being taken by Fundraising Tech and Mingle.)

The real blocker is the Trello migration script that at least the Design team requires to migrate their tasks.

In T821#948647, @Qgil wrote:

At least the Collaboration team is considering to take this chance and make a clean room, cloning only the Trello cards involved in new sprints.

We're doing that as a stopgap since neither we nor anyone else has yet written/adapted a migration script. I would prefer to migrate everything (I believe this is the general Collaboration-Team-Triage consensus as well).

In T821#939498, @Qgil wrote:

Is "This script uses a trello enterprise export" the only problem of cburroughs' one (the only one that has been used to migrate from Trello to Phabricator)?

This is not a problem at all. We have Enterprise export. See https://phabricator.wikimedia.org/T821#800192

In T821#939498, @Qgil wrote:

Attachments and comments are clear requirements for a migration script, yes.

Yup, those are what I'll work on after basic task creation.

Have you decided which route is best to take to support this.

1. Someone exports a Trello board as JSON.
2. Dev runs trello_create.py script in phabricator/tools repo.
3. trello_create.py makes Phab API calls to create tasks, comments, and attachments from data in the JSON export, reusing code from the bugzilla_create and mingleterminator import scripts.

This handles username mappings, and detects and reports Trello labels. Still no comments, history, or attachments. See https://gerrit.wikimedia.org/r/188287

I need to migrate the tasks in the Flow backlog Trello board's Send to Phabricator - Collaboration-Team board column. Either by adding a`--column` command-line argument or just edit the JSON output. Before doing that I need to write out a Trello UID -> Phabricator task PHID map file so that an improved script could later be run that would handle comments, history, and attachments without duplicating cards.

Change 179057 had a related patch set uploaded (by Spage):
Import Trello card JSON into Phabricator

https://gerrit.wikimedia.org/r/179057

Patch-For-Review

Change 179057 merged by Rush:
Import Trello card JSON into Phabricator

https://gerrit.wikimedia.org/r/179057

I haven't tested this at all as I don't have any trello data, but the string of dependencies leading up to https://gerrit.wikimedia.org/r/#/c/179057/ have been merged.

I ran the scripts to migrate the Trello "Gather backlog" board to Phabricator Gather project, one column at a time. Seemed to work, see log.

Gerrit 193316 has the updated username mappings and comment tweaks.

The latest version of the migration script links to all the Trello attachments in the task description, for example T92059.