Article: KB-11752
How to:
Robert Bosch - Modify section mapping
Skill required to complete this article: Controls and level is No Skill Level Association.

The purpose of the request from Robert Bosch would be to move slots from one section to a different section, so that the section would print labels from a different printer.  Robert Bosch will supply the slots that they wish to move to different sections.  The slot names will not change.

Example ticket - TS-00382767

There are two database tables involved in the change

- loc_slot  (update section number for slots)
- loc_section  (update count of lights per section, based off of loc_slot)

Here are the general steps needed to make this change

Preparation of import file

1)  backup loc_slot and loc_section table
2)  unload section(s) from the loc_slot table that are to be changed

Example:  unload to new_loc_slot_200.unl select * from loc_slot where slot_name like "200-%" and section = 100 order by slot_name;

3)  modify loc_slot unload file with desired section changes

Installation of import file

These steps are for an example of section 100 slots being moved to section 151:

1)  Ensure that sections to be modified are picked clean
2)  go to directory where the import file is located, then log into the database
cd ~support/slai; dbaccess $DB_SQL -
3)  delete rows from loc_slot table:
delete from loc_slot where section = 100 and slot_name like "200-%";
4)  Insert records
load from new_loc_slot_200.unl insert into loc_slot;
5)  Find updated count of devices in sections 100 
select count(*) from loc_slot where section = 100;
(note down value.  This is the number of devices in section 100 after the update)

6) Find updated count of devices in sections 151
select count(*) from loc_slot where section = 151 
(note down value.  This is the number of devices in section 151 after the update)
7)   Display previous count of devices in sections 100 and 151
select pick_lights from loc_section where section in ("100", "151");
(this is the count of lights prior to the update)

8) Update count of devices for section 100  
update loc_section set pick_lights = [step 5 value] where section = 100;

9)  Update count of devices for section 151
update loc_section set pick_lights = [step 6 value] where section = 151;
10)  restart application

 Related Articles
No Related Articles Available.
 Help us improve this article...
What did you think of this article?
poor   excellent
Your Email:
Tell us why you rated the content this way. (optional)
RadEditor - HTML WYSIWYG Editor. MS Word-like content editing experience thanks to a rich set of formatting tools, dropdowns, dialogs, system modules and built-in spell-check.
RadEditor's components - toolbar, content area, modes and modules
   
Toolbar's wrapper 
 
Content area wrapper
RadEditor's bottom area: Design, Html and Preview modes, Statistics module and resize handle.
It contains RadEditor's Modes/views (HTML, Design and Preview), Statistics and Resizer
Editor Mode buttonsStatistics moduleEditor resizer
 
 
RadEditor's Modules - special tools used to provide extra information such as Tag Inspector, Real Time HTML Viewer, Tag Properties and other.
   
 

 Comments...
No user comments available for this article.
Published on 6/24/2023.
Last Modified on 6/24/2023.
Last Modified by Samuel Lai.
Article has been viewed 350 times.
Rated out 0 of 10 based on 0 votes.
Print Article Print Article