Database projects

Warehouse layouts/configurations are called projects and are stored in a SQLite Database. FTSim comes with a few configurations, but for new projects the database has to be accessed.

A very convenient grafical tool to do this is the DB-Browser für SQLite, which can be used with and without SQL knowlege.

Beside the DB-Browser I use the command-line-tool sqlite3 which is part of the SQLite Software. It is nice for scripting and administrative tasks. An example for a script which re/builds a complete project is given in ftsim105.sql.

The SQLite Database itself is just a single file. If FTSim is installed with pip in the usual way, the database and the scripts are hidden or difficult to find.

Other ways of installing

If you want to change or check something, it might be easier to choose the directory for the installation yourself. This can be done by downloading a tarball.

Looking into the details of ftsim on PYPI you will find a Button “Download Files” and there you choose the file ending with tar.gz.

This tarball can be used in different ways. It can be unpacked with Tools like 7-Zip or you could use pip to unpack it into a directory of your choice:

C:\SOME\DIRECTORY> pip install --target myftsim ftsim-0.9.3.tar.gz

Somewhere below the created directory myftsim exists a directory with the name ftsim, which contains everything needed to run the program, which is the SQLite database (ft.db) and 3 python - modules. Change to that directory and launch the main module ftmain9:

C:\SOME\OTHER\DIRECTORY\FTSIM> python ftmain9.py

Examples

Version 0.9.3 comes with 6 projects/configurations. They start with the very, very basic example 101, just to show, what needs to be configured. 102 shows a loop and 103 introduces a simple picking place (=Workstation). 104 has an additional loop and 105 has a small storage area. Project``106`` is an example with two orders. The order of the Taskorders is accidental, and as there is only one Workstation the taskorders are processed one by one.