BIS.Net Data Editor – User Manual
Contents
1. the best performance 3 You cannot enter values into the Red cells You can only enter values into the White cells 4 Youcan only filter by a single date only as if a mistake is made it affects the entire range Clearing the Filter Box To clear the filter box from the drop down list choose Select a Table This will clear the filter box Select Data Add Records to Specifications Table Add Records to Co AIEEE A TADIA Brix _and_Carbonation X select a table Brix and Carbonation o Coly olume Control BISNET Config BISNET Specifications Ei EE E 3 Populate E 10 Page BIS Net Data Editor Administrator Manual Neena ul ANJ N O Bulk Editing Bulk editing is for editing or removing large volumes of data However only the administrators have the permissions to do this If there are large volumes of data which needs updating or removing please contact the administrators BIS Net Champions are not be able to modify or remove data Excluding Including records for reporting purposes in BULK Records can be flagged to be excluded from reporting in bulk Records which have been flagged to be excluded from reporting have not been deleted from the database They are only simply not included in the reports To exclude results for reporting please follow these instructions 1 Select the table and filter the data which needs updating After the data has been extracted and displayed check to see i2. 6 Press the Next gt gt gt button to view the data You will be directed to the Data tab which will display the data which you have just filtered Select Data Add Records to Specifications Table Add Records to Configuration Table Seen Brix_and_Carbonation x Populate Selected Row with Choice Lists Next gt gt gt 9 Page BIS Net Data Editor Administrator Manual ENa ul ANJ NO 7 Depending on how much data is returned you may need to scroll through multiple pages to view all of the data To scroll through the multiple pages click on the appropriate arrows directly underneath the Select TAB but above the grid displaying the data Select Data Add Records to Specifications Table Add Records t Date Tim Location Line CEE E E fT ena os aioure fT EE E tioure aT anor A ST Please Note 1 When displaying choice lists on the filter box if filters have already been assigned for other fields then after pressing the Populate Selected Row with Choice Lists button the values listed in the selected choice list will be based on the filters already assigned For example if you have specified a date and wish to display a choice list for the Flavour field the flavours which will be displayed in the choice list will be based on the date which you have specified earlier 2 Itis highly recommended to filter data rather than extracting the entire data stored in the selected table to obtain
3. BIS Net Data Editor User M swe Fr Pages BIS Net Data Editor Administrator Manual Neen Ao N O Table of Contents MOI OW sean nana aca E a ESG CP E a a nc ns a 3 Login to the BIS Net Data Editor cc eccecceesseceeseeseeseseesseesenseesens 4 Filtering and Viewing data iss ererreser seara ren censen een eaneno 7 Clearing the Filter BOX cccccceccesceseessesseeseuseeseuseeseseeseeeseeseeeensees 10 Bulk Editing ccc cecceccsecceccecceseeseeseeeeeceeseuseuseuseeseeeeeeeeeseuseueeneensss 11 Excluding Including records for reporting purposes in BULK 11 Excluding Including individual records for reporting purposes 12 Adding SPECIFICATIONS cccccceecceccescesceseseeuceuseuceeceseeuseeseuseusenseess 14 Edit existing specifications ccccceccecceeceeccescucceseseeeeeseeuseeseuseesensss 14 REMOVING SPECIFICATIONS ccc ccccescecceececeeccescuceuseseeseeseeeseuseusensensss 14 Adding to the BIS Net Configuration table iss iii 14 2 Page CLA COCA COLA AMATII r e R gt i aye User Manual This user manual has been written for the BIS Net Champions of the BIS Net Data Editor Overview The BIS Net Data Editor is an on line application available to all BIS Net Champions across all sites to view and modify data for their lines As the BIS Net Data Editor is password protected to prevent unauthorized usage a
4. corresponding field Only the Administrators will be able to carry out this function 4 Using the above descriptions as a guide specify your filters into the filter box An example is shown below Select Data Add Records to Specifications Table Add Records to Configuration Table Seen een Erix and Carbonation Populate Selected Row with Choice Lists 22 11 2010 _ ho 4 4 4 Coca Cola we a 5 ALTERNATIVELY instead of entering values directly into the filter box you may select your filtering criteria from choice lists To do this click on the cell where you will be entering a filter and press the Populate Selected Row with Choice Lists button The cell in which you have selected will display a choice list listing all of the values for the selected field as shown over the page 8 Page BIS Net Data Editor Administrator Manual Neena ul ANJ N O Select Data Add Records to Specifications Table Add Records to Configuration Table mea Brix and Carbonation Populate Selected Row with Choice Lists oum e ee 22 11 2010 s Coca Cola se CF Diet Coke Coca Cola Diet Coke Vanilla Diet Lift Fanta Orange Fanta Orange 2 Juice Fanta Orange 5 Juice Kirks Creaming Soda Kirks Lemon Squash Kirks Lemonade Kirks Low Joule Creaming Soda Kirks Low Joule Lemon Kirks Low Joule Lemonade Kirks Old Stoney Ginger Beer Kirks Pasito Lift sprite sprite Zero Vanilla Coke
5. e launch pad and then click on the Add to Favourites link located at the top left hand side of the screen 6 Page BIS Net Data Editor Administrator Manual ENa ul ANJ N o Filtering and Viewing data To filter data for viewing editing purposes please follow these instructions 1 From the Select a Table drop down list select the appropriate table 2 A filter box will be displayed as shown below Select Data Add Records to Specifications Table Add Records to Configuration Table select a table Brix and Carbonation Populate Selected Row with Choice Lists Columm A 3 Aline number applicable to the user login will be displayed If you click on this drop down list all other lines also applicable to the user login will be listed The structure of the filter box is as follows Column Lists all of the fields in the selected table Enables you to filter data that is equal to the value entered under this column for the corresponding field gt Enables you to filter data that is equal to or greater than the value entered under this column for the corresponding field lt Enables you to filter data that is equal to or less than the value entered under this column for the corresponding field 7 Page BIS Net Data Editor Administrator Manual ENa ul ANJ N o Replace If you are updating an existing value with a new value then the new value needs to be entered under this column for the
6. entiz i n 6 Enter your username and password and press the Log in button 7 You will be directed to the Select screen ready to commence your session 5 Page BIS Net Data Editor Administrator Manual Nena ul ANJ N o fe CCA Editor Windows Internet Explorer aX Go v e http www ccabisnet com aufeditor Editor aspx 4 x flivesearch lej amp amp ECCA Edtor gt A th pave rodo CCA Select Data Add Records to Specifications Table Add Records to Configuration Table CO CA co LA A MATI L Select a table Select a table X Populate Selected Row with Choice Lists Tome Renee E aa Y Trusted sites Protected Mode Off 100 The layout of the BIS Net Data Editor is as follows The BIS Net Data Editor is divided into TABS These TABS are Select Data Add Records to Specifications Table and Add Records to Configuration Table e The SELECT TAB displays the main screen which enables you to filter data for viewing e The DATA TAB displays the filtered data e The ADD RECORDS TO SPECIFICATIONS TABLE TAB is used to enter new specifications Administrators ONLY e The ADD RECORDS TO CONFIGURATION TABLE TAB is used to apply Machine Interface line settings Administrators ONLY Please Note The BIS Net launch pad www ccabisnet com au may be set up as a favourite To set up asa favourite load th
7. f correct data set has been returned If it has click back to the Select tab to display the filter box and press the Flag filtered records to be excluded in reports button Pressing the above buttons will permanently commit he change You should first view the data in the Data ab to confirm that the filter selections are correct To include these records back for reporting purposes please follow these instructions 1 Complete Steps 1 amp 2 listed above except this time press the Flag filtered records to be included in reports button 11 Page BIS Net Data Editor Administrator Manual ENa ul ANJ N O Pressing the above buttons will permanently commit he change You should first view the data in the Data ab to confirm that the filter selections are correct Please Note 1 When excluding records from reporting the username is automatically stamped next to all records which have been excluded under the Comments field 2 After you have reverted the changes back to the original the username will be removed from the Comments field 3 When excluding including results it is recommended that you re load data to confirm if the change has been successful To check if the change has been successful after you have re loaded the data and have been automatically directed to the Data TAB scroll across to the Save Flag column If you have excluded results then the value O should be d
8. he reports COCA COLA AMAT Comments Say lag StopFlag 13 Page BIS Net Data Editor Administrator Manual ENa ia yA KO Please Note 1 When excluding records from reporting the username is automatically stamped next to all records which have been excluded under the Comments field 2 After you have reverted the changes back to the original the username will be removed from the Comments field 3 When excluding including results it is recommended that you re load data to confirm if the change has been successful To check if the change has been successful after you have re loaded the data and have been automatically directed to the Data TAB scroll across to the Save Flag column If you have excluded results then the value O should be displayed If you have included the results then the value 1 should be displayed Adding Specifications Please contact the administrators if new specifications are required Edit existing specifications Please contact the administrators if specifications need to be modified Removing specifications Please contact the administrators if specifications need to be removed Adding to the BIS Net Configuration table The BISNet Configuration table is used to configure standard Machine Interface settings across all lines These settings include n Points sample frequency start up time max records save intervals purge days version plus more These settings a
9. isplayed If you have included results then the value 1 should be displayed Excluding Including individual records for reporting purposes There will be many times where you will not want to exclude include ALL records which you have filtered Instead you may only want to exclude ONLY several records in the data which you have filtered To exclude individual records manually please follow these instructions Select the table and filter the data which needs updating After the data has been extracted and displayed check to see if the correct data set has been returned If it has whilst remaining on the Data TAB scroll across to the Save Flag column and change the appropriate values from 1 to 0 12 Page BIS Net Data Editor Administrator Manual ENa ul ANJ N O COCA COLA AMATIL Change 1 to O for all records which are to be excluded from the reports Comments SaveFlag 3 Press the UPDATE button The UPDATE button has a TICK displayed on it and is displayed at the bottom left hand side of the screen 45 17 11 2010 09 47 Melbourne aso o 311 z 311 7 48 19 50 4 amp k To include these individual records back for reporting purposes please follow these instructions 1 Complete steps 1 to 3 listed above Except this time change the appropriate values under the Save Flag from O back to 1 Change 0 to 1 for all records which are to be included in t
10. l ANJ N o e Excluding including data for reporting purposes e Adding new specifications e Editing specifications e Removing specifications e Adding to the BIS Net configuration table Login to the BIS Net Data Editor To login to the BIS Net Data Editor please follow these instructions Load your Internet Explorer Inthe address bar type www ccabisnet com au 3 The following launch pad will be displayed enabling you to launch the different BIS Net web applications and documentation E CCA Launcher Windows Internet Explorer GO e TE E Bcchtante PRs B t pee Gre COCA COLA AMATIL osso ECA ESSE Ro gt n z a eo TT E TT T Tio O eet Protected Mode On 100 gt Estar a RE 8 ECA Launcher windo EvA Sb 4 Click on the Editor_Au button for Australia and Editor NZ for New Zealand 4 Page BIS Net Data Editor Administrator Manual ENa ul ANJ N O ZECCA Launcher Windows Internet Explorer Go e ttp trw ccabisnet com au w a CCA Launcher Add to Favourites Editor Au FE 7 5 The BIS Net Data Editor will load prompting for a username and password OCCA Bisnet Data Editor Windows Internet Explorer ty Y el http www ccabisnet com au editor E x Live Search og w ae CCA Bisnet Data Editor re E dm sb Page Ci Tools 2 COCA COLA AMATIL T f 4 e e Pan pis User Name QANSH P Enter your Cred
11. ll BIS Net champions will be provided a username and password for their site This means that BIS Net champions will only be able to view and modify data for their lines ONLY The BIS Net Data editor has two user levels each with different permissions They are gt Administrators gt Site Users BIS Net Champions Administrators Administrators have full rights to the BIS Net Data Editor The appointed administrators of the BIS Net data editor are responsible for the entire application and are able to view data update delete data exclude include results for reporting purposes enter modify specifications and enter modify the BIS Net configuration table Qtech International has been appointed the administrators of the BIS Net Data Editor Site Users BIS Net Champions The BIS Net champions are the appointed site users The BIS Net Champions have limited rights and are only able to access and modify their sites data ONLY BIS Net champions are able to view data and exclude include data for reporting purposes BIS Net champions are not able to edit delete data enter modify specifications and enter modify the BIS Net configuration table The administrators will need to be contacted for this The remainder of this user manual will now cover the following topics e Login to the BIS Net Data Editor e Filtering amp viewing data e Clearing the filter box e Bulk editing 3 Page BIS Net Data Editor Administrator Manual ENa u
12. re configured nationally Although default settings have been standardized across all sites some sites are unique and thus each line can be configured differently For example 1 production line could require longer start up time or another site may have many more filler stoppages and thus will need to adjust the time for the Machine Interface to start saving again when the filter starts up again If you need any of the above settings changed to suit your line please contact the administrators 14 Page
Download Pdf Manuals
Related Search