Homepage: http://www.climahom.eu

EULA

• General characteristics
  • Downloads data from any database that accepts SQL commands
  • Easy and flexible usage

• Brief technical description
  • Connection to the database is carried out by means of ODBC
  • Select, Update, Insert, Delete SQL commands generator
  • "Quick buttons" for the most often used database tables
  • Various profiles for individual database tables
  • Data are downloaded into DBF files (no limits for number of rows, ...)
  • The files can be displayed using build-in Viewer of edited in MS-Excel
  • Data downloaded by means of LoadData can be directly used in the ProClimDB software
  • It is possible to run this application directly from the AnClim software, there you can launch "Download Wizard" which will accomplish all the needed steps (cross tables, TXT export) automatically, you just specify, what to download
  • Batch mode for processing sequence of commands

• Functionality description
  • Creating connection to central database by means of ODBC
  • Loading data from database
    • User specifies what to download in Info_file (stations, elements, periods, etc.)
    • Select - SQL command is created automatically according to a structure of the Info_file (from active rows). The Info_file can be easily created by means of available buttons (this is needed only on the very beginning - to adapt it to given user conditions)
    • it is also possible to input Select - SQL commands directly (or in a TXT file)
  • Creating Cross-Tables from downloaded data (e.g. redistributing monthly data into individual columns), or, on the contrary, creating One data column from a given cross table.
  • Output to TXT files and other formats, various options e.g. delimiters, ...
  • Functions for Inserting, Updating, Deleting data in database

• Examples
  • User Interface
    
    
  • Viewing and editing Info_file (specification what to download)
    

• Documentation
  • Documentation for the LoadData software.
    (Actual documentation can be found under Help menu of each software)

Download Area       Get the Latest Version of the LoadData software: Installation files     Users of the LoadData: Click to Download Updated AnClim.exe file

The downloaded version of the software expires after some time. One of the reasons is that I improve the software all the time and I want the users to work with the latest versions.

Reference: Stepanek, P. (2006): LoadData - Application for loading data from central database. CHMI, regional office Brno.