Benetl, a free ETL tool for files working with postgreSQL and MySQL
Benetl is a free ETL tool
an ETL to easily manage csv/txt/xls/json files
Benetl, a free ETL tool for files working with postgreSQL and MySQL, is forteen years old! 84803
downloads

Home page > Documentation > 1. First line to be read

1. First line to be read


First line to be read:

First of all, in order to use Benetl you need two things:

  • A Java Runtime 17 (JRE)
  • A postgreSQL or a MySQL database
  • In order to launch Benetl, you have to use "etltool_gui.bat" from "C:\Benetl".
    You can learn more about "etltool_gui.bat" at: 9. EtlTool running and 11. Files of an EtlTool.

    Then you have to choose a folder and a datasource file (.txt or .csv extensions).

    Since Benetl 1.8 .xls file format is supported.

    Since Benetl 5.0 .json file format is supported.

    Important: Benetl reads first sheet of .xls or .json files and creates .txt files, in order to parse them.

    The separators for fields must be ’;’ or ’|’ or tab.

    opening_datasource_file

    In this screen you enter the line number from which you want to start reading a file.
    The first line is: 0.

    first_line_to_be_read


    Site Map -  Contact: benoit@benetl.net
    Benoît Carpentier - Benetl a free ETL tool - Copyright (c) 2007 - 2024


    Search Engine Optimization and SEO Tools