User Manual E2R WEIGHING RECORDS Software Manual number: ITKU-56-01-01-11-A MANUFACTURER OF ELECTRONIC WEIGHING INSTRUMENTS RADWAG Wagi Elektroniczne, 26–600 Radom 28 Bracka Street - POLAND Tel. +48 48 38 48 800, tel/fax. +48 48 385 00 10 Sales Department +48 48 366 80 06 www.radwag.
TABLE OF CONTENTS 1. GENERAL INFORMATION .................................................................................. 4 1.1. Intended use ................................................................................................. 4 1.2. Database....................................................................................................... 5 1.3. System requirements .................................................................................... 5 1.4.
6. DATABASES...................................................................................................... 37 6.1. Assortment.................................................................................................. 37 6.1.1. Adding / editing assortments ............................................................... 38 6.1.2. Deleting product .................................................................................. 39 6.1.3. Searching and filtering assortments .....................
1. GENERAL INFORMATION 1.1. Intended use E2R System is a modular system for complex management of production processes that are associated in some points with weighing. Owning to the modular structure the system is versatile and can be easily tailored to the profile, characteristics and needs of a firm as well as individual customer requirements.
The network of scales can be combined with one or more types of scales. E2R SYSTEM based on Ethernet The program allows for full supervision and reporting from measurements collected from scales WPW, TMC, TMX, WLY, WPY. Notice: 1. Due to continual updates, there is a possibility of minor discrepancies between the contents of this manual and the program. 2. RADWAG takes no responsibility for the unexpected effects of program operation, and possible consequences resulting from wrong use of the program. 1.2.
• • • • processor 2 GHz or faster, minimum 1 GB RAM (recomended 2 GB), minimum 5 GB of free space on HD, monitor and graphic card allowing for resolution at least 1024x768 pixels, • DVD drive, • Default system font size (96 dpi)! Notice: 1. It is advisable not to install other applications on the computer with E2R system. 2.
Before starting cooperation with the program, each scale requires setting adequate user parameters for assuring the expected measurement accuracy and appropriate cooperation with the program. Setting parameters for each scale is described in user manuals. 2. SOFTWARE INSTRUCTION 2.1. Databases As a database engine can be used any distribution of MS SQL Server (MS SQL 2000/2005/2008). The database of E2R System is created during installation of E2R Weighing Records. 2.2.
In further steps follow the instructions displayed in subsequent windows. Welcome window: In order to continue press „Next”.
Choose a folder for program (it is advisable to keep the default path),then press „Next”. Window for selecting components to be installed: Choose components you want to install (all elements needed for appropriate operation are ticked), and then press „Next”.
In order to start the installation process press button „Install”. Completing installation window: After the installation is completed the computer restart is required and the option is selected by default. Press button „Finish” in order to complete the installation. Together with the program are installed: database of E2R System (SQL base), „E2R Synchronizer” and „E2R Manager”. 3.
3.1. RADWAG Synchronizer – Windows Service In the main window of E2R SYNCHRONIZER (SynchAdmin.exe), a button for changing the language and configuring the Radwag Synchronizer sercice is accessible. Main program window: In the title bar of the window there is information about of programs that are parts of „RADWAG Synchronizer”. Description: Install Service Before running RADWAG Synchronizer the service needs to be installed in MS Windows operating system.
Stop Server Stopping the server responsible for communication with scales. Language Language selection window. Accessible languages Polish, English, German and Spanish. After the language change program restart is required. Save Saving language change. Caution! The language change will be applied after program restart. Notice: In case of any problems with the service it should be stopped and uninstalled.
3.2. Adding new scales to the Synchronizer After connecting to the database adding new scales to the Synchronizer on overlap „Scales” is possible. Press button „Add” to add a new scale. Then a scale window appears which needs to be filled in according to the example below. Adding an new scale is shown on the scale WPW. Identically can be added other scales that can cooperate with „E2R System”.
Scale settings: Name Type Config Edit Ident. Name Type Serial No. Adress Platform Quantity Any interface name Field to display interface type (serial, Ethernet) Field to display interface configuration Button for interface edition Scale identification number (numerical field) Any scale name Types of conection with scales: • Radwag.Devices.PUE41.PUE41Encoder – connection with indicator PUEC41H • Radwag.Devices.WeightDryer.WeightDryer Encoder – connection with moisture analyser MAX • Radwag.Devices.PUE7.
Interface settings: MediumType ConnectionString Host Port BaudRate DataBits Handshake Parity PortName StopBits Connection type (None – no connection, Serial – scale connected via RS232, Ethernet – scale connected via Ethernet) String of characters with encoded configuration parameters Name or IP of remote host (for Ethernet connections) – scale IP on which the Synchronizer server runs.
3.3. Deleting and editing of existing scale If the scale no longer works in the system it can be removed from the Synchronizer in order to avoid searching for the scale during synchronisation. Choose the scale to be deleted and press button „Delete”. Then the following window appears: This question appears in order to avoid the risk of accidental removing of a scale. Press „Yes” if you want to remove the scale from the synchronizer.
NOTICE: Some parameters are only for service purposes and is described in the service manual. Below you can find settings of functions that are crucial for proper operation of the synchroniser and parameters that extending the functionality.
Synch_Towar MasaEnabled 0 Setting parameter to „1” causes enabling the update of mass standard in the scale Synch_Towar MinMaxEnabled 0 Setting parameter to „1” causes enabling the update of thresholds in the scale Synch_Towar TaraEnabled 0 Setting parameter to „1” causes enabling the update of tare in the scale Synch_Towar UpdateEnabled 0 Setting parameter to „1” causes enabling the update of tare in the scale ReconnectTimeout OnNoRespond 0 A parameter for setting the maximum timeout in secon
After saving go to overlap „Windows Sevice” and check if „RADWAG Synchronizer Server” operates. If the server runs you can see a visualization of operating scales connected to the system using program E2R Manager. 4. E2R MANAGER Program „E2R Manager” is designed for displaying the state of communication with scales and current weighings. Additionally, there are displayed information about: operator, production order, weitghted product, batch number, contractor, product tare and working mode.
Main window of E2R Manager: Notice: In case of lack of communication between „E2R Manager” and service Radwag Synchronizer or when the service is off no scale window is displayed. 4.1. Setting connection to Radwag Synchronizer In window „Radwag Synch Manager” set address IP and a communication port for a computer with running the service of connecting with scales.
4.2. Show / hide the panel of connection with server In the menu Program settings of „E2R Manager” users can access the panel of connection sith service „Radwag Synchronizer”. If the program runs and no scale is displayed in the window it means the lack of connection with the service „Radwag Synchronizer”. In such a case make sure if the service is running in system MS Windows and press „Connect” in the connection panel.
5.2. Main program window After an operator has logged in the main window appears: There are 4 areas in the main window: • • • • Top Bar – System, Side Bar – Work, Pasek Dolny – Information, Workspace. In the top bar there are program settings, appearance options (colours), a LOGOUT and EXIT buttons. In the side bare, there are modules and operating functions of the program.
The bottom bar displayes information about the program version and logged in user their authorization. In the workspace, there are displayed all windows related to the Side Bar, holding all data and information. 5.3. Program settings Press button in the top bar to display settings.
5.3.1. Database In order to display database settings, press button . in module Functions of database settings: • • • Update Database, Check Connection, Configure Connection. In the top part of the window there is displayed the status of connection with the database. In the lower part of the window there are displayed parameters of connection with the database. In order to cancel introduced changes press button 24 .
5.3.2. Updating the database After pressing button updated. the database version will be Notice: 1. Updating the database overwrites the existing database. For that the current database needs to be archived before updating; 2. Users can update the current database after consulting with RADWAG. 5.3.3. Connection configuration After pressing button a window with parameters of connection with the database is displayed.
Then the window with information given earlier is displayed: After pressing OK in the window above a message box is displayed with information about the connection status. 5.3.4. Connection checking After pressing button database is checked. the connection with the 5.3.5. Authorization and groups of users In order to enable the access of users and groups to different functionalities press button in module . In overlap groups of users are defined.
Buttons’ description: Add Delete Save Adding the new group of users Erasing a group of users Recording changes In overlap all codes with names ascribed to them ,which are used for defining group rights, are accessible. In overlap each group of users can have set accessibility to different program modules.
After choosing a group from menu add or take off authorization according to the predetermined pattern. 5.3.6. Service settings In order to get access to the service settings press button in module Settings. Notice: All service settings are accessible only for RADWAG authorized services.
5.4. Other settings 5.4.1. Changing the active window Only one window is to be displayed after choosing it from the list (setting a . tick next to it) displayed after pressing button 5.4.2. Language change Choose the language from the listbox below. Fields: PL EN DE ES Polish English German Spanish 5.4.3. Program appearance The program outlook can be changed by pressing button choosing one item from the list.
Accessible colour schemes: Caramel Money Twins Lilian The Asphalt World iMaginary Black Blue Brown Light-blue Light-blue Light-gray Dark gray Black Dark blue 5.4.4. Logging out After pressing button , the user is logged out. Then another operator can be logged in by enaring a Login and the to log in. Password. Then press button 5.4.5. Closing program Press button and the program will be closed.
5.5. Working window of the program 5.5.1. Sorting information In the working window of all accessible modules all information displayed can be freely sorted. In order to group displayed data choose a column header and drag it to the place indicated in the image below. The selected header will be displayed as a button with the same caption. Pressing the button causes sorting the list in an ascending or descending way. 5.5.2.
Fields: Sort Ascending Sort Descending Clear Sorting Group By This Column Hide Group By Box Remove This Column Column Chooser Best Fit Best Fit (all columns) Filter Editor… Sorting from A to Z Sorting from Z to A Disable sorting filter Group data according the selected column Hides the field of quick grouping Deletes a selected column from the window Starts columns configurator in the window Change the column width to get the best view Change the width of all columns to get the best view Advanced filter I
5.5.3. Filter creator After choosing button „Filter editor…” you start the window of filter creator where you can freely filter data from the database. Using the creator you can set one or many filtering conditions, which allows for detailes filtering and generating reports from the filtered data.
Definitions: And Or Not And Not Or Add Condition Add Group Clear All The condition that endorces fulfilment of all filtering criteria The condition that endorces fulfilment of any filtering criterium The condition that endorces fulfilment of the opposites to all the set filtering criteria The condition that endorces fulfilment of any opposite to set filtering criteria Allows for adding another condition of filtering Allows for adding another group of filtering (each group can include many conditions of fi
Designations: Equals Does not equal Is greater than Is greater than or equal to Is less than Is less than or equal to Is between Is not between Contains Does not contain Displaying only records from the selected column which are ecactly the same as the entered value Displaying all records from the selected column which are different from the entered value (opposite to filter „Equal”) Displaying only records from the selected column which values are greaterer than the entered value, Displaying only recor
Begins with Ends with Is like Is not like Is blank Is not blank Is any of Is none of Displaying only records from the selected column which start form the given string of characters Displaying only records from the selected column which end with the given string of characters Displaying only records from the selected column which has the same beginning and end, the filtering criterion has the following format „begin%end” Displaying only records from the selected column which has not the given beginning a
6. DATABASES E2R Weighing Records includes following databases: • • • • • Assortment, Contractors, Stocks, Packagings, Operators. All databases are editable also from the software of terminals PUE 5 (Terminal E2R Weighing Records). 6.1. Assortment On database a list of articles or materials. In order to start the module choose option Assortment in the back side window.
6.1.1. Adding / editing assortments After pressing button database. a new assortment can be added to the After pressing button an existing assortment can be edited.
After editing all required data save settings by pressing button and then . 6.1.2. Deleting product After pressing button the assortment can be deleted from the database. Records are protected from accidental erasing and a confirmation is required for such action. If the database holds weighings related to the product it cannot be erased, but is attributed as an archive record. 6.1.3.
Notice: In the working window of displayed information can be sorted and use additional options of filtering. See details in section 5.5.2 and 5.5.3 of this manual. 6.1.4. Reports from Products In order to print a report from the list of products press button in the main window. Then a window called with the generated report appears. Press in this window to send the report to the printer. 6.2.
In this window you can add, erase or modify contractors that are attributed to products to be weighed. 6.2.1. Adding / editing contractors After pressing button database. you can add a new contractor to the After pressing button choosen contractor.
6.2.2. Deleting contractors After pressing button you can delete the selected contractor from the database. Records are protected from accidental erasing and a confirmation is required for such action. If the database holds weighings that are attributed to the selected contractor it will not be deleted. 6.2.3. Filtering and searching contractors Each contractor introduced to the system can be found by inscribing an appropriate string of characters in the column.
6.2.4. Reports from Contractors In order to print a report from the list of contractors press button in the main window. Then a window called with the generated report appears. Press in this window to send the report to the printer. 6.3. Stocks In database the included list of different storage areas can be supervised. To run the module choose Stocks in the side menu. Window of stocks: In this window you can add, erase or modify stocks that have been added to the database.
6.3.1. Adding / changing stocks After pressing button database. you can add a new stock to the After pressing button stock. you can change any data in the selected A window for adding or editing a stock: Fields: Code Name Long name Data Name Stock code for a scale Stock name Full stock name Database name to which a stock is attributed All changes in the stock’s data can be recorded by pressing and then the window can be closed by pressing . 6.3.2.
If the database holds weighings that are attributed to the selected stock it will not be deleted. 6.3.3. Filtering and searching stocks Each warehouse introduced to the system can be found by inscribing an appropriate string of characters in the column. After typing the characters in the column a list of warehouses with the same string of characters is displayed. In order to delete a displaying filter from the window of products press .
Window of packagings: In this window you can add, erase or modify warehouses that have been added to the database. 6.4.1. Adding / changing packagings After pressing button database. you can add a new package to the After pressing button package.
Fields: Code Name Mass Barcode Package code for scales Package name Nominal package weight – tare Package Barcode All changes in the package’s data can be recorded by pressing and then the window can be closed by pressing . 6.5. Operators In database the included list of different storage areas can be supervised. To run the module choose Operators in the side menu.
6.5.1. Adding / changing operators After pressing button database. you can add a new operator to the After pressing button operator. you can change any data in the selected A window for adding or editing an operator: Fields: Code Name Password Group Card number Archive Operator code for scales Operator name Operator’s password Ascribing to an authorization level group. There are four groups with different access levels: administrator, advanced, standard and basic.
6.5.2. Deleting operators After pressing button you can delete the selected operator from the database. Records are protected from accidental erasing and a confirmation is required for such action: 6.5.3. Filtering and searching operators Notice: In the working window of displayed information can be sorted and use additional options of filtering. See details in section 5.5.2 and 5.5.3 of this manual. 6.5.4.
It allows to display all weighings collected in the SQL database. Generation of simple reports from weighings is also possible. In the main window of Measurements you can freely set columns in any report using the tool „Choose column”.
The tool can be started by choosing it from the pop-up menu called by right-clicking on the bar with column names. Two additional windows are displayed: ¾ ¾ Edit Kolumn Properties Customization. Window „Edit Column Properties” allows for modification of appearance of the selected column as well as window and printing properties. Window „Customization” allows to add or remove of the selected column from the view of the selected report. Columns are added or removed by the „drag and drop” method.
7.2. Raport for the Materials Overlap „Material Report” allows for sorting weighings according to the product name. Different sorting criteria can be applied e.g: weighing date, product name. Grouping sorting conditions depends on the sequence of adding them. The time interval for the report is set in the upper part of the window. After outlining all required conditions of grouping and pressing button , a report in PDF file will be generated.
Grouping sorting conditions depends on the sequence of adding them. The time interval for the report is set in the upper part of the window. After outlining all required conditions of grouping and pressing button , a report in PDF file will be generated. It can be saved or printed on a local printer connected to the computer with application „E2R Weighing Records”. 7.4.
Grouping sorting conditions depends on the sequence of adding them. The time interval for the report is set in the upper part of the window. After outlining all required conditions of grouping and pressing button , a report in PDF file will be generated. It can be saved or printed on a local printer connected to the computer with application „E2R Weighing Records”. 7.5. Report for Batch Number Overlap „Report for batch number” allows for sorting weighings according to the one batch number they belong to.
Grouping sorting conditions depends on the sequence of adding them. The time interval for the report is set in the upper part of the window. After outlining all required conditions of grouping and pressing button , a report in PDF file will be generated. It can be saved or printed on a local printer connected to the computer with application „E2R Weighing Records”. 7.6.
Grouping sorting conditions depends on the sequence of adding them. The time interval for the report is set in the upper part of the window. After outlining all required conditions of grouping and pressing button , a report in PDF file will be generated. It can be saved or printed on a local printer connected to the computer with application „E2R Weighing Records”. Additionally, in each report window an advanced sorting can be applied with the use of filter editor (described in details in section 5.5.
7.8. Archive Weighings Overlap „Archive Weighings” allows for archiving selected weigings. Accessible functions: • Move selected to Archive • Restore selected from Archive • Delete selected Archival weighings Weighings can be archived one by one by highlighting a weighing and pressing „Move selected to Archive”. It is also possible to archive groups of weighings. The group can be selected in different ways: • Using data filtering for choosing weighings that are the subject of our interest (see sections 5.5.
Restoring the archival weighings is performed similarly using button „Restore selected from the Archives”. Deleting weighings is possible ONLY after removing them to the archive. 8. TOOLS 8.1. Scale Restart is identical to function „Re-Connect scales” in Tool Synchronizer accessible from the PC application. It causes reconnection to scales based on indicators PUE7 and PUEC41 conncected to the system.
MANUFACTURER OF ELECTRONIC WEIGHING INSTRUMENTS RADWAG WAGI ELEKTRONICZNE 26 – 600 Radom, 28 Bracka Street POLAND Tel. +48 48 38 48 800, tel./fax. + 48 48 385 00 10 Sales department + 48 48 366 80 06 www.radwag.
