List Import Wizard

The ImportWizard allows to import data from lists in any regular format. Importing data can be done with the following three easy steps:

Step 1 - Source Data
Enter the source text and verify the correct display of Japanese text. Entering the text is possible in the following ways:

Step 2 - Define Mapping
In this step, the source text is split into consecutive elements (tokens), which are then assigned to the desired Stackz attributes.

Step 3 - Preview
Preview the result. If it is not satisfactory, go back to Step 2 to change the mapping, or even back to Step 1 to correct small formatting errors of the input text.

ListImportWizard Tutorial (HTML table with Japanese text)

Goal: Import this HTML table into Stackz (shortened version of a table found on the net.)


ListImportWizard (1/3) - Enter Source Data

Open the ListImportWizard. On the first page, bring the content of the HTML table into the big edit control by first copying it to the clipboard, and then selecting 'Paste HTML Columns'. This function analyzes the copied HTML formatted table, and places a TAB between the columns.

Once the table is readable in this first wizard step, click the 'Next' button.

ListImportWizard (2/3) - Map Attributes

In this step, the source table must be split into tokens (left side of the dialog), and the tokens must be assigned to the Stackz attributes (right side of the dialog).

Split the Text into tokens Map the tokens to Stackz attributes

The input table is read line by line and 'cut' into words (the 'tokens') by applying the cutting pattern repeatedly.

In the example below, the incoming text is repeatedly cut into tokens 1, 2, 3 and 4 with the specific end-markers until all text is processed.

This example is trivial because the end-marker is always a Tab, except for the last column which is a linefeed. The generic structure of the tool allows handling of much more complicated lists.

The 4 lines on the right side of the dialog represent the 4 Stackz attributes, not all of which must be used. The settings of the dialog below means the following:

  • Text token #3 is used for the first Stackz attribute, it is called 'Entry' and the language is Japanese.
  • Text token #4 is used for the 2nd Stackz attribute ('Reading', Japanese).
  • Text token #2 is used for the 3rd Stackz attribute ('Translation', English).
  • Text token #1 is used for the 4th Stackz attribute ('Chapter', English).

With this system, virtually any existing formatted wordlist can be imported - the token end-markers can be freely defined, and the assignment to Stackz attributes can be arbitrarily chosen.

If you agree with this mapping, click 'Next' for the third and last Wizard page.

ListImportWizard (3/3) - Preview Result

This is the preview page of the import process. If you want to change the order of the columns or the name of a column, press the 'Back' button to change your mapping there.

You might also detect lines that are not mapped correctly due to errors in the original source table. Here this could happen for example if one of the column-entries do contain a TAB character, which would lead to an erroneous 'Split into Tokens'. In this case, you can go back to the first step of the Wizard, manually correct the issue (change the tab to something else) and verify the result again by clicking 'Next' twice.

If you are satisfied with the preview page, the prepared data can be imported to Stackz.

Note: With a Stackz evaluation license, you can evaluate the functionality of the ImportWizard. The generated file has the same state as a list from the online archive: it can not be saved to disk without a full Stackz license.