SmartCSV.fx

SmartCSV.fx

Description

A simple JavaFX application to load, save and edit a CSV file and provide a JSON configuration for columns to check the values in the columns.

Motivation

At work I have the need to fix wrong CSV files from customers. It is hard to find the errors and fix them in a texteditor, even in a “normal” CSV editor. So I decided to write this simple JavaFX application.

JSON Configuration

{  
  "COLUMN NAME 1": { 
    "integer" : true, 
    "not empty" : true, 
    "maxlength" : 4, 
    "minlength" : 4 
  }, 
  "COLUMN NAME 2": { 
    "groovy" : "value.contains('a')? 'true' : 'no a inside'", 
    "alphanumeric" : true 
  }, 
  "COLUMN NAME 3": { 
    "date"

Read More

GeoFroggerFX 2.0 Development Preview

GeoFroggerFX 2.0 Development Preview

I rewrote the GeoFroggerFX application for several reasons.

1. Data Storage Performance

I was very unhappy with the performance of the H2 JPA version and tried some other data storages.
The first alternative attempt was in using the OrientDB as an object database. The performance got better but not good enough. Still had to wait more than a minute for inserting and/or updating 10.000 caches (also including waypoints).

As an object database seemed to be a good solution, I tried db4o. It performed a lot better than OrientDB and I thought this is the solution for GeoFroggerFX, but

Read More

Second preview of GeoFroggerFX the JavaFX application

Second preview of GeoFroggerFX the JavaFX application

This is the second preview of GeoFroggerFX my little geocaching application written in JavaFX.

Changes since the last preview:

  • progress listener for the file io
  • embedded database H2
  • progress listener for database handling
  • readonly form elements
  • tabs added
  • show the description of the cache with WebView if the description is html content or otherwise a TextArea is used

You can try the preview with Java8 installed

Download: 1000 Caches example

Download: 11334 Caches example

Read More

Video of GeoFroggerFX handling 11.334 Caches

Video of GeoFroggerFX handling 11.334 Caches

This little video shows a preview of the GeoFroggerFX application handling more than 10.000 items in the ListView. Currently the items are read and parsed from a gpx file with 124Mb and the domain objects are still in memory.

You can try the preview with Java8 installed

Download: 1000 Caches example

Download: 11334 Caches example

Read More

JavaFX: custom ListCell

JavaFX: custom ListCell

In my GeoFroggerFX (replacement for my GeoCachingFrogger based on Netbeans), I have a list of geocaches. This post shows the development of the list from a simple list to a multiline list with icons.

Simple List

The first and simplest version had some textual rows.
simple list

Custom CellList with more information

But this isn´t too sexy and I also wanted more information in my list. So I decided to use a custom ListCell to support more information in multiple rows and also some icons. The first version just added more information as text to the row.

public class CacheListCell extends

Read More