Display
The tools tab is intended for qualified people only, it includes
functions that can lead to data loss.
Its use is more delicate than in the case of the previous tabs, intended for all users.
This tab is subdivided into sub-tabs, so that it can be easily upgraded to suit your needs.
Its use is more delicate than in the case of the previous tabs, intended for all users.
This tab is subdivided into sub-tabs, so that it can be easily upgraded to suit your needs.
Administration
Software administration refers to operations that allow each user to
access only those parts of the software that are relevant to them.
This is a SIM function that requires the ADMIN option.
If you have this option, you can use the comboBox (scroll down list)
to scroll through the list of users.
With the checkboxes on the right, you define the authorizations for each one.
Your changes are saved with the "Validate" button.
The "New" button allows you to enter a name of your choice in the combo and then assign a password.
Each user will then be able to change their password without informing the administrator.
User management allows you to have, at each launch of the application, a window that then identifies the users in the logbook.
Please note that entering the user name is not case-sensitive, but
the password is.
If the verification is not good, SIM launches in view mode, without the possibility to modify the data.
If you would like to know more about how passwords work, contact us because this information cannot be published in this document!
In order for user control to be effective, SIM will shut down on its own after a certain period of inactivity.
This timeframe is configured in the parameters:
[DIVERS]
LOGOUT = 120
Or, since the 4.0 version:
[OPTIONS]
LOGOUT = 120
Allows you to set the inactivity time of a session to 120 seconds.
At the end of this period, the password is required again.
This is a SIM function that requires the ADMIN option.
With the checkboxes on the right, you define the authorizations for each one.
Your changes are saved with the "Validate" button.
The "New" button allows you to enter a name of your choice in the combo and then assign a password.
Each user will then be able to change their password without informing the administrator.
User management allows you to have, at each launch of the application, a window that then identifies the users in the logbook.
If the verification is not good, SIM launches in view mode, without the possibility to modify the data.
If you would like to know more about how passwords work, contact us because this information cannot be published in this document!
In order for user control to be effective, SIM will shut down on its own after a certain period of inactivity.
This timeframe is configured in the parameters:
[DIVERS]
LOGOUT = 120
Or, since the 4.0 version:
[OPTIONS]
LOGOUT = 120
Allows you to set the inactivity time of a session to 120 seconds.
At the end of this period, the password is required again.
Configuration
The configuration tab allows you to access all SIM settings.
Those that are essential and frequently used, but also those that may be specific to your software version.
Those that are essential and frequently used, but also those that may be specific to your software version.
Settings window
The Edit button displays a settings window with
four columns:
Each cell in the table can be modified, a complete line can be
deleted, and a new parameter can be added at the bottom, in the last
blank line.
The order of the parameters is not important.
When closing, you have the option of saving or not saving the edits.
For specific updates, it is necessary to restart the software, the Restart button is for that purpose.
CAUTION : If a parameter adjustment affects the format of the database, the data must be exported and then the databases cleaned, as described in the next chapter.
- Section : the settings are organized by
functionality.
The most important section is DIVERS or since the 4.00 version, OPTIONS which includes the general options. - Parameter : This column displays the name of the setting, which must be assigned to a section.
- Value : the value of the parameter, a decimal or text
- Comment : an optional text to help you with maintenance
The order of the parameters is not important.
When closing, you have the option of saving or not saving the edits.
For specific updates, it is necessary to restart the software, the Restart button is for that purpose.
CAUTION : If a parameter adjustment affects the format of the database, the data must be exported and then the databases cleaned, as described in the next chapter.
GSM.ini file
For those who are comfortable with the Notepad text editor, press
the CTRL key on the keyboard at the same time as you click the Edit
button.
The parameter file uses a Microsoft syntax.
Each line has a parameter.
The parameters are organized in sections of the shape of [Section].
The order of the parameters in a section does not matter.
To have a parameter ignored, simply change its name, for example XXXUSER1=2333 will disable the USER1 parameter (which contains the license number).
If you want to restore the factory settings, simply delete, or better still, rename this file.
The parameter file uses a Microsoft syntax.
Each line has a parameter.
The parameters are organized in sections of the shape of [Section].
The order of the parameters in a section does not matter.
To have a parameter ignored, simply change its name, for example XXXUSER1=2333 will disable the USER1 parameter (which contains the license number).
If you want to restore the factory settings, simply delete, or better still, rename this file.
Alarms
The Alarms tab is optional, you must have the option "Alarm mails".
With this feature, the software sends each time it is launched an email with the list of products below the minimum.
The alarm screen allows you to configure the recipients.
To activate the activation, the Alarms button displays the content
of the email, the Send button executes a forced sending.
There is only one automatic email per day.
Contact your administrator or Internet service provider to find out which settings to use for sending the email.
You can put several recipients separated by a semicolon in the "To" line.
With this feature, the software sends each time it is launched an email with the list of products below the minimum.
The alarm screen allows you to configure the recipients.
There is only one automatic email per day.
Contact your administrator or Internet service provider to find out which settings to use for sending the email.
You can put several recipients separated by a semicolon in the "To" line.
Data
The data tab allows "massive" operations on the data, such as
importing CSV files or cleaning databases.
Depending on your options, you may have other buttons that match the
additional tables in your database.
In the example below we have:
The Products button enables you to import products from a file in SIM CSV format, generated by the EXPORT button on the product tab.
As for exports where you have the choice between CSV, XLS or XLSX formats, the imports allow all three alternatives.
CAUTION :
For compatibility reasons, often an empty "property" column should be maintained.
The heading line is not useful, but if SIM detects it and ignores it.
If this heading contains in the first column the word "Id" it means that it is a SIM export, and this column will be ignored.
The CSV format depends on the "Windows location" of your PC and the configuration of the numbers, depending on whether you use British decimals with dots or French with commas.
An option exists in SIM SEPARATOR_CSV to adapt in case of issues.
The Specific Products button enables you to import products from any CSV file, the columns of which do not correspond to the SIM CSV format.
The example below shows how to proceed:
To remove a line from the format, double-click it.
CAUTION : Importing prices does not work if your column contains € or other currency.
The original cells must have a "number" format.
Deleting erases the entire relevant database table, and enables the identification numbering to be restarted from the beginning.
Deleting tables is necessary if you have changed options in your configuration.
We then proceed to an export, a clearing of the tables, a modification of the exported file before reintegration.
CAUTION : always make a complete copy of your SIM file before such operations.
In the example below we have:
- Import : Inputs products, suppliers, customers (option) or version-specific data from a CSV file.
- Delete Data : Completely empties the relevant
table: products, suppliers, customers or newspaper.
The log can't be imported, it doesn't really matter. - View Duplicates : Enables to ensure the authenticity of each reference, a necessary requirement for the efficient performance of SIM.
- CAUTION : If a parameter adjustment affects the
format of the database, the data must be exported and then the
databases cleaned.
You can then reinsert your data, after completing or modifying the CSV file as required (adding or deleting columns).
SIM import
The Products button enables you to import products from a file in SIM CSV format, generated by the EXPORT button on the product tab.
As for exports where you have the choice between CSV, XLS or XLSX formats, the imports allow all three alternatives.
For compatibility reasons, often an empty "property" column should be maintained.
The heading line is not useful, but if SIM detects it and ignores it.
If this heading contains in the first column the word "Id" it means that it is a SIM export, and this column will be ignored.
The CSV format depends on the "Windows location" of your PC and the configuration of the numbers, depending on whether you use British decimals with dots or French with commas.
An option exists in SIM SEPARATOR_CSV to adapt in case of issues.
Specific imports
The Specific Products button enables you to import products from any CSV file, the columns of which do not correspond to the SIM CSV format.
The example below shows how to proceed:
- Choose the type of separator of your file: Semicolon, Comma or Tab
- Open your file with the File button
- The columns of your file are displayed next to the SIM
columns.
By clicking once on the column name on the left, twice on the right, you define how the data will be copied: Here, the SIM family column will take the values of the Group column from your file.
Do this for all the columns requested by SIM, regardless if there are too many columns in your source file. - Click on the Import button
To remove a line from the format, double-click it.
CAUTION : Importing prices does not work if your column contains € or other currency.
The original cells must have a "number" format.
Removals
Deleting erases the entire relevant database table, and enables the identification numbering to be restarted from the beginning.
Deleting tables is necessary if you have changed options in your configuration.
We then proceed to an export, a clearing of the tables, a modification of the exported file before reintegration.
CAUTION : always make a complete copy of your SIM file before such operations.
Queries Options
Introduction
The Queries tab is optional, you must have the "requêtes SQL" option.With this feature, everything is possible! Indeed, SIM is built on a SQL database, which accepts all data processing formulated in this universal language that is the Standard Query Language.
It is due to this language that SIM can work on ACCESS, MySQL or WindowsSQL databases and perform complex processing on huge amounts of data.
- The query editor at the top left
- The results section at the bottom left
- The controls on the right
Query editor
The text entry area enables you to manually enter queries such as :
SELECT * FROM t_produits to display all products.
SELECT * FROM t_journal to display the entire log.
It is necessary to know that the SIM database tables are t_produits, t_journal, t_clients, t_fournisseurs, t_clients, t_lots, t_places according to the options... and use the column names to do the processing:
SELECT * FROM t_produits WHERE famille = 'VIS'
For simple requests, it is possible to enter a start and end date and selection criteria.
The request will be generated automatically. Caution! All this is at your own risk!
Result field
The result area is a classic grid, which you can sort and export with the "Export" button.
The "View" button allows you to enlarge it, to the detriment of the input area.
The "Configure" button does the opposite.
The "Total" checkbox accumulates the items displayed.
Control buttons
- Execute : This button initiates the request.
Some requests will cause data to be displayed, others will have no visible effect.
Errors are not listed.
Enables you to use the input field. - Visualize : Expands the viewing area, useful for small screens.
- Erase query : Clears the query text.
- Open query : Searches on your hard disk for a SIM request file with the .req extension
- Save query : Saves your request in a.req extension file
- Export : Exports the result of your query