Skip to content
Nick Rau edited this page Nov 29, 2019 · 1 revision

How to use

Preperation

Before you start the program you have to prepare a few things.

Step 1 - Your files in a main folder

You need all your files in one folder so the program can pick it up. Next you categorize them using folders within the main folder. The program will pickup the folders as categories and the files within will be connected to those categories.

Step 2 - The SQL Server

You need to have access to a SQL Server in order to create a database and fill it with data. Make sure you have a SQL Server you can connect to and a account that has authority to execute SQL Queries like CREATE database and INSERT. CREATE and INSERT are the only ones the program uses but it has to have the authority to use them.

Start the program

After you have prepared the files and have access to a SQL Server, you can start the program. It will load and a menu will appear. Instructions are written on the menu. Just follow the steps and type the commands accordingly. If you think you made a mistake you can rerun the command but note you have to do these commands in the following order:

  1. Set folderpath (set folderpath)
  2. Prepare files (prepare files)
  3. Upload to Database (upload to db)

If you decide to go back a command you have to follow the commands after again or your change will not be used. (example: set folderpath after preparing files, you have to prepare files AGAIN).

Clone this wiki locally