Michael Koehler

Exploring the intersection of productivity, technology, and life.

Export Nozbe to CSV (and Excel), XML and JSON – ReVuDo 0.3.7!

with 7 comments

It is amazing what the focus of a vacation can do.

The day after tomorrow I will disconnect and spend a few days celebrating the wedding of a beautiful young couple. So, of course, the push was on to finish a new version of ReVuDo for Nozbe. I left work late, spent my commute through the NYC subway in design mode for the remaining features, and settled onto a crowded commuter train to bang out the code. All the prior planning, design and coding came together smoothly and I am happy to announce a new version!  Get ReVuDo 0.3.7 here.

A Missing Feature

First let me thank Alan Cochran for pointing out, earlier today, that I had not yet provided a way to undo selecting Auto Login on the login window. This is now available in the Options window. Thanks Alan!

Export!

Second, a Tools button is now available on the Projects window tool bar that lets you export all your Nozbe data to CSV, XML, or JSON.  For each one, you will be asked what folder to export the files to. After selecting the folder, the data will be exported.

The CSV format creates one .csv file for each Nozbe table; one for projects, one for contexts, one for labels, one for tasks, etc.  In addition, a sub-folder will be created for each project that you have uploaded files for.  All those files will be stored in the project sub-folders.  This is the ideal file for export to Excel.  Just double click a CSV file to open it in Excel.

The XML format will create just one Nozbe.xml file, but will also store uploaded files to project sub-folders.

The JSON format is the native format for Nozbe, so the Nozbe.json file it creates is probably the closest thing to a backup of Nozbe.  The uploaded files will be saved in the same project sub-folders as the other two formats.

This checks off another feature that I wished Nozbe had.  It’s exciting to see my goals getting checked off one by one.  I hope you find it as useful as I do!

What’s Next

The other exciting thing about this new version is, it marks the last read only, no way to make any changes, version of ReVuDo for Nozbe.  The next version you see will let you change something!  Hopefully it will allow a lot of changes, but that will depend on my available time over the next few weeks.  My goal is a complete weekly review in Nozbe. Wish me luck!

What Do You Think?

Let me know in the comments.  And if it is helping you, let others using Nozbe know.

Thank you for joining me on this journey.

Advertisements

Written by mwkoehler

2011/08/16 at 1:01 am

Posted in GTD, Nozbe, ReVuDo, Windows

7 Responses

Subscribe to comments with RSS.

  1. In an earlier version of Revudo I transferred my ‘next actions’ to Excel by copy-pasting. Unfortunately, this didn’t transfer contexts. I was hoping that the export function in 0.3.7 would help but it only seems to be available in the first/startup window, not in the ‘next actions’ window. Can you explain how I can quickly get the table that Revudo shows me in the ‘next actions’ window (including contexts), into Excel?
    Thanks!
    Paul

    Paul

    2011/09/04 at 8:51 am

    • I’ll have to look into what happened with the copy and paste. I have a suspicion, but I have to confirm that.

      Meanwhile, if you click the Tools button on the tool bar, and then click the Export as CSV button, it will ask you for a folder to export the information to. The task.csv file has all your actions. You can open it in Excel, and either sort or filter on the “next” column to get just Next Actions. Let me know how that works.

      mwkoehler

      2011/09/04 at 2:15 pm

  2. Hi Michael,
    Thanks for getting back to me. A few comments:
    1) It’s annoying having a collection of files exported every time, rather than just one.
    2) There are several columns in the task.csv file which seem useless (“name_show”, “project_hash”), although perhaps other people need these – I don’t know.
    3) The “name” column sometimes has corrupted entries eg: “Make sure s1j→s1k specification covers…” and “search is complete ⇒ dan”. (These strange characters are not in the name).
    Keep up the good work!
    Paul

    Paul

    2011/09/05 at 1:48 am

    • 1. Understood. My intention was to provide everything as a first step as you can always filter or ignore what you don’t want. Later I can provide options based on what people actually want. So I will add selecting specific parts like tasks to the list of enhancements. Selecting, copying and pasting is something that I would like to re-add first.

      2. The columns you mention are part of what Nozbe maintains. The project_hash on a task matches the hash field for example to link the task to a project. I include them for people who want them.

      3. Can you tell me what the field that is corrupted actually said? I will try to fix that.

      In the meantime, if you want to uninstall and re-install the previous version, 0.3.6 can be downloaded from http://dl.dropbox.com/u/18214371/ReVuDoSetup.0.3.6.0.exe

      Thanks for the feedback!

      mwkoehler

      2011/09/05 at 4:05 pm

  3. Cant this to log into Nozbe even through user name and password are correct

    Keith

    2017/06/13 at 5:45 pm

  4. I have it working but it crashes when trying to export as CSV
    works find under json but the other app can use either and json will not load

    Keith

    2017/08/07 at 10:55 pm

    • If you can send me your logs from %localappdata%\revudo\Errors to revudo at gmail.com I will look into it.

      mwkoehler

      2017/08/13 at 8:27 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: