CSV file Import into RTM
jfch says:
I love SmartAdd, but it would also be great to have a CSV import tool for larger-scale imports.
This would help with (1) migrations from other software (many apps can export to CSV, or something that can be converted to CSV), and (2) it would help with PROJECT TEMPLATES, stored as CSV files, imported whenever a project arises (e.g., expense reports, etc.).
Thanks!
This would help with (1) migrations from other software (many apps can export to CSV, or something that can be converted to CSV), and (2) it would help with PROJECT TEMPLATES, stored as CSV files, imported whenever a project arises (e.g., expense reports, etc.).
Thanks!
dale.neuman says:
Trying to transfer Trello boards into RTM. CSV or JSON import would really help.
Wow. From today's release notes for Version 2275 — November 27, 2018: "New: Import your Remember The Milk data (JSON format)."
Cautious excitement. Does this mean it can solve my problem of importing tasks? Or is this intended as a way to restore a backup wholesale? I've not found any documentation for this new feature yet, but I'll keep digging.
Cautious excitement. Does this mean it can solve my problem of importing tasks? Or is this intended as a way to restore a backup wholesale? I've not found any documentation for this new feature yet, but I'll keep digging.
From the looks of it, it is meant as backup&restore or migrate. The documentation suggests to use the export feature to create the JSON file to do the import. I looked at the contents and the export.json contains literally everything in an account, in a relational format, i.e. there are lists that have IDs and those IDs are referenced as a preference in the account settings, etc. Also, the JSON includes task IDs and metadata.
I assume that upon importing, most of this data is discarded because it would thoroughly mess up another account when imported whole.
I am actively looking for a mass import (I have a semi-automatic system for firing off dozens of separate emails but the email import feature is broken at the moment) so I will investigate what happens if I construct a JSON file with an empty skeleton and only data for tasks.
NB: notes are treated as separate entities linked via ID to the task they belong to. Fine, but this makes it impossible to include notes upon import, because the ID is not known at that time. I will try random (but dummy) IDs for tasks and coupling notes to those tasks via that dummy ID. With a bit of luck, the importer is clever enough to figure out from an import file what goes with what.
Note to RTM staff: documentation, even "this may or may not be fully accurate, but here are the lab notes" would go a long way to helping out tinkerers like yours truly and many others on this forum.
I assume that upon importing, most of this data is discarded because it would thoroughly mess up another account when imported whole.
I am actively looking for a mass import (I have a semi-automatic system for firing off dozens of separate emails but the email import feature is broken at the moment) so I will investigate what happens if I construct a JSON file with an empty skeleton and only data for tasks.
NB: notes are treated as separate entities linked via ID to the task they belong to. Fine, but this makes it impossible to include notes upon import, because the ID is not known at that time. I will try random (but dummy) IDs for tasks and coupling notes to those tasks via that dummy ID. With a bit of luck, the importer is clever enough to figure out from an import file what goes with what.
Note to RTM staff: documentation, even "this may or may not be fully accurate, but here are the lab notes" would go a long way to helping out tinkerers like yours truly and many others on this forum.
Log in
to post a reply.