Modern CSV

Modern CSV version 2.3

Modern CSV version 2.3 has several improvements:

  • UUID/GUID Generation
  • JSON and XML Import Performance
  • A bunch of bug fixes

You can download it here:

UUID/GUID Generation

The command is called Fill Selected Cells with UUID/GUID. You can then decide whether they’re upper or lower case and whether they’re contained in braces or not. The default option is lower-case without braces.

It also comes with a global setting called UUID Type. The two options are:

  • Random (v4)
  • Time-ordered (v7)

In a nutshell, Random (v4) UUIDs look truly random and they mostly are, or at least pseudorandom. Time-ordered (v7) look pretty much the same for the first two fields (first 12 hex characters) because they represent a time stamp. After that, they’re mostly random. This post describes them in greater detail.

This version also made it possible to add new UUIDs by middle-mouse clicking on one, dragging it, and hitting the + button.

JSON and XML Import Performance

Before, JSON and XML import struggled with large files. I fixed that by improving 3 things:

  • Improved the speed of the preview text field.
  • Truncated the preview to 10,000 lines.
  • Improved the performance of the actual conversion by about 30-fold.

Bug Fixes

Here is a list of the bugs that were fixed:

  • Fixed dragging cells below the frozen header rows or to the right of the frozen header columns.
  • Fixed a bug in Add or Update ID Column where it would sometimes fill cells to the end of the viewable table rather than the end of the data.
  • Fixed the location of popup windows so they don’t appear in random places on the screen.
  • Middle-mouse button click-drag increment/decrement improvements: It now respects leading zeros in numbers, handles large numbers better, and does not interpret values like “INV-1001” as negative numbers. Also, hitting the key again now undoes the increment/decrement.
  • Fixed ctrl+left in Launcher. The shortcut to go back to the previous option is now ctrl+minus (or cmd+minus on Mac).

Plus a few minor bug fixes.

Once again, here are the download links: