Le-tools.com Forum Contact
XL-Tools - Documentation

First start

When you start XL-Tools for the first time, you are asked if you want to set default configuration. If you click Yes, you will be asked to select a directory where:

A XL-Tools.ini configuration file will also be created to keep your preferences in memory. You can also set elements above manually, in case you already have some of these databases.



Settings - General

In Tool section, we have the following functions and options:

  • Export Lang.ini: Use this function to translate XL-Tools GUI. See Translation for help about this functionality.
  • Open user dir: This is the directory where settings are saved. Copy the content of this directory if you want to backup your settings.
  • Check Update: Check on le-tools.com if a tool update is available.
  • Check for update at startup: When XL-Tools starts, check on website for available update of the tool.

In Functions section, you have the following options:

  • Choose to start XL-Tools in Full Screen.
  • Choose to Remember position of the GUI (usefull if you have multiple monitors).
  • Change Maximum size for list value. This value represents the maximum number of characters that can displayed in the GUI for each list. If you try to insert more than this limit, you receive a warning that the list will be truncated. You then have the possibility to use a list in a file or increased this value. By default, the maximum size is set to 5 000 000 characters.
  • Choose font...: The selected font applies to the three list in the main interface. You can also change the font size from the main interface. With the focus on any list, you can use [CTRL+Down or Up arrow] to decrease or increase the size of the font.
  • Local timezone: The local timezone is used to identify your local timezone. On some system, the local timezone couldn't be determined so you will have to set it manually.
  • Default language: Some elements of a datetime are specific to a language like the month or the day name. To get those element parsed from or translated to another language, you should change this setting.
  • Output charset: If you change the language, you may also have to change the charset.
  • Set the NsLookup timeout: Associated to the Utils - Nslookup function. This is the time it will wait for the answer. Default is 10 seconds.
  • Customize the User-Agent of XL-Tools: The User-Agent is used to identify the tool when requesting databases from Website. Default is XL-Tools (http://www.le-tools.com).
  • Set the When no result option. Associated with many functions. This is the default value when function is not able to get a result (no valid input, error, no match, ec.). Default is Leave a blank.

Datetime database Window

Datetime Database Window

The Datetime database is used to store and manage all datetime formats that will be available in the tool. This database is used with sort by date and time function and with all functions in Time category.

In the bottom of the window, you can select the Default output. This is the default output that will be used if you select Default in the main interface. This default output is saved as well as other settings. Same as input can only be used if input type is a Datetime object. It cannot be used with ChromeTime for example.

You can add, edit or delete any datetime object in the database.

Datetime database - Edit

Datetime Database - Edit

When you add or edit a datetime object, you must provide the following details:

If the Add or Edit button are still disabled after you filled all the fileds, you can click on the ? to see what is missing or is incorrect.

Ambiguous timezone abbreviations

Some timezone abbreviations are ambiguous, because there are matching more than one timezone. For example, CST could be Central Standard Time (USA), China Standard Time, or Cuba Standard Time. You can take a look here. So, I decided to set those timezone with the following values:

I have try to set it to the most popular value, but I could be wrong. If the datetime you need to parse have a different offset, you can parse the datetime without the timezone and set the appropriate offset in the input format.

Main window

Main window

The main interface is divided in three parts:

If Not Ready ? Click here is visible, click on it if you want to know which step comes next.


No duplicate

This function simply removes duplicate from a list of strings.

List 1 Results

No duplicate

Copyright (c) 2015-2021 Alain Rioux