User would like to create a new street group from a list of NE_ID’s which have been queried outside of the TMA forms.
Please first test the script on your test system before applying it to live, just in case something unexpected happens. Run all scripts in SQLPlus as the highways table owner.
1 – Create a new temporary table using the script below:create table temp_streets_tab (NE_ID number(9) not null);2 – Populate the above temporary table with the NE ID’s of the streets you want to add to a new street group.3 – Create a new street group using the Street Groups form in the Atlas application, but don’t add any streets.4 – Edit the following script by replacing the value <ENTER STREET GROUP NAME HERE> with the name of the new street group created above and then run it:select tsg_id from TMA_STREET_GROUPS where TSG_NAME = '<ENTER STREET GROUP NAME HERE>';5 - Edit the following script by replacing the value <ID NUMBER> to be the id of the new street group found above, then run it in SQLPlus as the highways table owner:declare cursor new_group_membs is select ne_id from temp_streets_tab; l_tab_streets nm3type.tab_number; l_group_id number := <ID NUMBER>;begin open new_group_membs; fetch new_group_membs bulk collect into l_tab_streets; close new_group_membs; tma_street_group_utils.bulk_add_members_to_group(pi_delete_existing => false, pi_tsg_id => l_group_id, pi_ne_id_tab => l_tab_streets); commit;end;6 – Your new street group should now be populated with the data. Clear the data from the temporary table using the script below:Truncate table temp_streets_tab;
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!