Search

Export to CSV and Re-Index (1.59)

Updated: May 25

This entry was imported from Group's former blog on Blogger written in 2020


1.59 allows Groups to export your organigram in CSV format. This will allow you to edit your group outside the app using your PC (note: Groups can now also be directly used on your PC)


To export, simply choose the menu option "Export to CSV" from within your group's CSV extension.


This menu is very similar to the Import from CSV menu. The Import from CSV guide can be read to understand how it works (just keep in mind you're working in reverse) Note: Google Sheets mobile app will not correctly open csv files with non-latin alphabets. If your group contains non-latin characters and you are using Google Sheets make sure to use a computer and the "Import" option

1.59 Also includes an option to "Re-Index" your group. This is not a strict DB re-index, but I chose the word "re-index" because of its familiar meaning. Groups increases the server size of your organigram with each little change you make and submit. For example, if you create a node but then delete it, 2 transactions are still logged and kept. This is because the nature of Groups is to keep track of all your changes and allow you to revert any whenever you need to.

Groups' organigrams take very little space. But if your group includes thousands of members and has a long history of constant changes, re-indexing could make a difference. To re-index, simply go to the "Sync Data" menu and tap on "Re-Index". What re-indexing really does is it creates a unique commit that baselines your organigram to its current state. New group users won't need to get the entire history upon joining as grabbing the changes since the most recent "re-index" will suffice

Importing from CSV re-indexes by default from 1.59 onwards

In other news:

Bubble chart can now be zoomed out as far as you want. I never thought that this was going be necessary, but given the size of some groups I think it now makes sense.

A new option to "renew RSA keys" can be seen in the Help menu. Groups now generates a unique RSA asymmetric key pair on each device. This currently isn't used but I added it to this version so that user public keys start getting saved on server-side user settings. This will be useful when I roll out chats which will be end-to-end encrypted. Users will automatically grab other users' public keys from their public settings in order to initiate a private encrypted channel. The private key goes through a second AES encryption and gets securely stored on each device. If a hacker were able to decrypt it I'd give him a reward simply out of compassion. The option to renew a device's private key mitigates this extremely unlikely scenario