This screen offers 2 possibilities. The first possibility is to change the status of addresses in re- connections.
The second possibility is to change the zip code, house number etc. of the addresses.
Re- connections
With this option you can change addresses by status in the bulk data.
Column |
Column description |
Column values |
1 |
Housenumber |
hsnr, housenumber, houseno |
2 |
Suffix |
suffix |
3 |
Room number |
room |
4 |
Zipcode |
zipcode, zipcd |
5 |
Housenumber 2 |
hsnr2, houseno2 |
6 |
Suffix 2 |
suffix2 |
7 |
Room 2 |
room2 |
8 |
Zipcode 2 |
zipcode2, zipcd2 |
9 |
Status (MTK, GV etc) |
afwerkeenheid, afwerkeenheid_nieuw, frame, frame_nieuw, ftu, ftu_nieuw, kast, kast_nieuw |
10 |
X-coordinate |
x-coord, xcoord, x, x_coord, xoord |
11 |
Y-coordinate |
y-coord, ycoord, y, y_coord, yoord |
12 |
Yard drilling |
xcoord2 |
13 |
Yard drilling |
ycoord2 |
14 |
Yard drilling |
xcoord3 |
15 |
Yard drilling |
ycoord3 |
16 |
Yard drilling |
xcoord4 |
17 |
Yard drilling |
ycoord4 |
18 |
Yard drilling |
xcoord5 |
19 |
Yard drilling |
ycoord5 |
20 |
Attenuation fiber 1 |
attenuation1,att1 |
21 |
Demping vezel 2 |
demping2, demp2,attenuation2,att2 |
22 |
Frame type |
ftu_type, ftutype, frame_type, frametype |
23 |
Cable ID |
kabel_naam, kabelnaam, cable_id,cableid |
24 |
Cable type |
kabel_type, kabeltype, cable_type, cabletype |
25 |
Branch socket type |
branchsockettype |
26 |
Repair closure type |
rctype |
27 |
X coordinate of repair closure |
xcoordrc |
28 |
Y coordinate of repair closure |
ycoordrc |
29 |
Customer duct type |
customerducttype |
30 |
Customer duct diameter |
customerdiameter |
31 |
Name installation company |
install company |
Address changes
With this option it's possible to change the zip code, housenumber etc. of the addresses in the bulk data.
It may happen that the municipality create new zip codes and house numbers to existing addresses. With this tool you can change this in the bulk data in Cocon.
Column |
Column description |
Column values |
1 |
Zip code old |
postcode, postcd, pc, zipcode |
2 |
House number old |
huisnr, huisnummer, hsnr, housenumber, houseno |
3 |
Suffix old |
toev, suffix, toevoeging |
4 |
Room number old |
kamer, ruimte, room |
5 |
Zipcode new |
postcode2, postcd2, pc2, zipcode2 |
6 |
House number new |
huisnr2, huisnummer2, hsnr2, housenumber2, houseno2 |
7 |
suffix new |
toev2, suffix2, toevoeging2 |
8 |
Room number new |
kamer2, ruimte2, room2 |
When the adress changes have been made, the section-names will be changed also.
Change termination units and connectors
By using this function you are able to change termination units and its connectors in bulk.
To do so, please insert an excel file (.xlsx) with the column sequence as shown below:
Column |
Column values |
Column description |
1 |
Locatienaam |
Name of the location |
2 |
Afwerkeenheidtype |
Termination unit type |
3 |
Connector oneven |
Values for uneven connector positions |
4 |
Connector even |
Values for even connector positions |
5 |
Results |
Leave this blank, results will be show here |
! There can only be one termination unit per location
! The connector fields can be left blank, this will ensure they aren't updated.
|
|
© Speer IT B.V. 1999-2018 |
