Report

Simple Data Toolkit - Tutorial - GUI - Java

July 12, 2022 at 10:10 AM PST
This post has no media.
Profile picture
Franklin Powers

Let's suppose you want to create a task that loads a TSV file into a PSV file on a daily basis. This task is meant to be part of Java code, but you are unfamiliar with Java and are unsure of how to write the code. Good news, you can use the Sample Data Toolkit UI to figure out this code for you as follows:

1) Go to the app page for the Simple Data Toolkit UI, at the time of this writing it is here: https://www.vis-software.com/#sdtk

2) Click Choose Files.

3) Find the file you want to convert.

4) Click Open.

5) Select the output type you want, for this tutorial we will select PSV.

6) Then for script, select Java.

7) Then click Download Script.

You will now have some Java code that uses SDTK to convert the file you selected to PSV. You can now either run this script or integrate it with another one.

If you need to install SDTK for Java, you can do it by downloading the latest version from SourceForge and placing it in your class path. At the time of this writing, this can be found here: https://sourceforge.net/projects/simple-data-toolkit/files/0.1.3/sdtk.jar/download

The code will look something like this:

com.sdtk.table.Converter.start().readFile("complex.csv").tsv().textOnly().output().writeFile("complex.psv").psv().execute();

Any thoughts on Franklin's post?

To comment or reply, you need an Ortingo account.

Sign in or sign up

Here's what Ortingoers think of Franklin's post.

There are no comments on this post.