Skip to content

A program that converts .ini files to SQL INSERT queries.

Notifications You must be signed in to change notification settings

GtakillerIV/IniToSql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 

Repository files navigation

v1.2

Introduction

Ini->Sql is a program designed to convert .INI files to SQL Insert Queries.

It was designed to help people that wanted to switch to MySQL, however converting their files was the problem.

Features

v1.0

  • Improved file handling to prevent possible application failure.

  • Ability to ignore duplicate errors upon executing your SQL Query.

  • Ability to skip INI files with missing columns.

  • Automatic table column creation (in query) based off of data gathered from INI files.

  • Progress bar that updates you on the program’s status.

v1.1

  • SQL Queries will now be escaped to protect you from possible SQL injection attempts.

  • Improved application startup.

  • Improved progress bar.

v1.2

  • Ability to handle INI file comments.

  • Improved file handling.

  • Ability to change column names.

  • Improved user input error checking; an empty table name can no longer be used.

Usage

  1. Click on the browse button.

  2. Locate the folder where you have your .INI files stored.

  3. Change the "table name" value to the name of your table.

Optional

  • If you don’t want to ignore duplicate errors, uncheck Ignore duplicate errors.

  • If your file doesn’t contain the player’s username, uncheck File contains username and enter in a column name for your usernames in the textbox below.

Example: In my table I’ve got a column named usernames and my .INI files don’t contain the user’s name but each .INI file is named after the player it was created for. I’ll uncheck file contains username and in the textbox below it, I’d write usernames.

  • If you don’t want to skip files that have missing columns in them, uncheck Skip file if it’s missing columns.

Added in v1.2

  • If you want to change your column names, you’ll have to double click on the column you want to rename in the column list to your right.


Important: The first .INI file in your folder must be fully correct and valid because my program uses it as a reference.

Screenshots