Badstraße 10a Fon +49 (0) 6341- 14 19 9-0 Email info@drafz-consulting.
de
76829 Landau i.d. Pfalz Fax +49 (0) 6341- 14 19 9-12 www.drafz-consulting.de
User Manual
Release 115
October 2012
Start Manager
Software for Material Planning and
Assembly Management of Piping Projects
Startmanager
Contents
1 Start Template Page 3
2 Activating System Settings Page 4
3 Adjusting System Settings Page 5
4 Setting up a New Database Page 7
4.1 Setting up a New Database with ACCESS Page 9
4.2 Setting up a New Database with SQL-Server 2008 Page 10
4.3 Setting up a New Database with ORACLE Page 11
5 Carrying out Release Change ISM Page 12
5.1 ISM Data Export Page 12
5.2 ISM Data Import Page 13
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 2
October 2012
Startmanager
The start manager allows an easier management of any database. Changing into another database will be a
lot simpler for the user.
The start manager is an ACCESS.mde file, which on one hand saves the data entered and which on the
other hand has to be provided locally on each user’s computer.
When changing the release, you first have to export the data from the current ISM release and then import
the new release.
1. Start Template
In the start template you see the 3 database formats ‘Oracle’, ‘SQL Server 2008’ and
‘Access 2003/2007’,
which are supported by the MaterialManager.
To start the MaterialManager or ISOTRANS. with the desired database click once on the selected
database and then the regarding program button.
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 3
October 2012
Startmanager
2. Activating System Settings
To do the MaterialManager system setup or to integrate a new database, click on ‘file’ in the upper
menu bar.
Select the option ‘Password’
The administrator password is ‘ism’
(* depending on the Microsoft Office system language)
Enter „ism“ into the input box and click the ‘OK’ button.
In the start window the two additional buttons „Edit DB“ and „System“ are now displayed.
By clicking ‘System’ you can enter the MaterialManager and ISOTRANS. system settings/ program
call settings.
By clicking ‘Edit DB’ you can add a new database to the selection.
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 4
October 2012
Startmanager
3. Adjusting System Settings
In the system setting you are asked to select the source files in your filing mapping.
To do so click the button in the respective line, navigate to the respective mapping directory and
select the respective start file.
With the program call the INI files will be generated automatically.
An exception can be forced, if you want to call a special INI file in the ISOMAT.ini and ISOTRANS.ini
lines.
The checkmark for the CITRIX use activates the use of the MaterialManager and ISOTRANS. by
means of a terminal server. Either with the standard Windows terminal server or additionally with the
terminal server application ‘CITRIX’.
In this case each user has to have his own ISM start manager in his USER Home directory, which will
be started. Here local writing rights are needed as well, since the temporary MaterialManager and
ISOTRANS. tables will be put there.
Starting from program release ISM 106 an additional INI file ‘ISM.ini’ is supported as well, in which the
individual User Home mapping = CITRIX Home mapping can be set as a default. The ISM.ini must be
saved in the same directory as the local start manager. When starting the ISM start manager the
contents of the ISM.INI file will automatically be set as the ‘CITRIX Home mapping’.
Entry from the ISM.ini file:
You can also enter the two system variables „%HOME%“ (for the Citrix home directory) or „%TEMP%“
(for the Windows standard terminal server ).
In the line „Online help mapping“ click the button and select the folder, which contains our online
help.
The checkmark ‘Show ISOTRANS key’ activates or deactivates the ISOTRANS. start up button in the
start menu. Some user shouldn’t be able to start ISOTRANS.
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 5
October 2012
Startmanager
To change the editing password click the button .
In the following window enter your new resp. desired password and then click the button .
(* depending on the Microsoft Office system language)
In the next window enter your new resp. desired password again for confirmation and then click the
button .
(* depending on the Microsoft Office system language)
You will then receive the following system message.
Then click the button .
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 6
October 2012
Startmanager
4. Setting up a New Database
To add a new database to the start manager, you have to create it first.
Setting up a New Database with ACCESS
Start the Windows Explorer, copy an existing MaterialManager database (ISODAT*.mdb) into the desired
project directory and change the file name of the MDB file.
Setting up a New Database in the start manager
After having created a new database and clicking the button ‘Edit DB’ in the start menu, the following window
will open.
To set up a new database, you best select an already existing database entry and click the button .
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 7
October 2012
Startmanager
First in the line „Description“ change the data base description
To delete a database profile click the button .
Confirm the following message by clicking the button „Yes“.
The database profile has been deleted.
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 8
October 2012
Startmanager
4.1 Setting up a New Database with ACCESS
To select the desired ISODAT file, ISOLOG and ISOLogbook file, click on the button in the
respective lines, navigate to the respective directory mapping and select the desired file.
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 9
October 2012
Startmanager
4.2 Setting up a New Database with SQL-Server 2008
To select the desired ISOLOG and ISOLogbook file, click on the button in the respective lines,
navigate to the respective directory mapping and select the desired file.
Then click the button in the line ‘Other Supplements’ and edit the SQL Database call.
The three lines have to be edited as follows
Line 1: IsoDatTyp=ODBC_SQL -> stays unchanged
Line 2: IsoDatServer -> enter the name of your SQL Database Server here
Line 3: IsoDatDB -> enter the name of the database, which you have created
on the SQL Database Server here
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 10
October 2012
Startmanager
4.3 Setting up a New Database with ORACLE
To select the desired ISOLOG and ISOLogbook file, click on the button in the respective lines,
navigate to the respective directory mapping and select the desired file.
Then click the button in the line ‘Other Supplements’ and edit the ORACLE Database call.
The three lines have to be edited as follows
Line 1: IsoDatTyp=ODBC_ORACLE -> stays unchanged
Line 2: IsoDatServer -> enter the name of your ORACLE Database Server here
Line 3: IsoDatDB -> enter the name of the database, which you have created
on the ORACLE Database Server here
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 11
October 2012
Startmanager
5. Carrying out Release Change ISM
When changing the release first you have to export the data from the current ISM release and then import
the new release.
Click on ‘File’ in the upper menu bar.
5.1 ISM Data Export
Then select the option ‘Export’
The following window will open.
Click on the button , navigate to the respective directory mapping to which you want to export the
database and system data.
Click the desired option checkmarks ISODAT-Profile and/or System Settings.
Then click the button ‘Export’.
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 12
October 2012
Startmanager
5.2 ISM Data Import
Now start the new Start Manager program release.
Click on ‘File’ in the upper menu bar.
Then select the option ‘Import’.
The following window will open.
Click the button , navigate to the respective directory mapping where you previously exported the
data to.
Click the desired checkmarks ‘Attach new data’ or ‘Replace existing data’. Don’t forget the option
‘System Settings Import’.
Then click the button ‘Import’.
Drafz Consulting GmbH, Badstraße 10a, 76829 Landau i.d. Pfalz Page 13
October 2012
