OZmap

To import data in OZmap, it is necessary to have attention to the obligatory elements for each spreadsheet. You can visualize below the particularities in the importation of each category of equipment.

Poles

A table for importation of poles has the following format: 

• Name: optional. Defines the name of the pole. The names must be unique or left in blank, if it is left in blank, the system will atribute automatically a name;

• Latitude/longitude: mandatory. Coordinates of the element's position;

• Type: optional. Specifies the type of pole. If the field is empty, the poles will be defined as "common";

• Tags: optional. Here you can insert some tags that are already registered in your system;

• Address: optional. Allows the attribution of an address to the pole. It does not dismiss the filling of the coordinates;

• Licensing status: optional. It can be licensed, in analysis or unknown;

• Files: optional. Allows the creation of a post. To add images and other files, you can insert your URLs separated by commas in the right column of the table.

In the moment of the importation you will be asked for what distance the poles must be considered duplicated by the system. For example, if you choose 1 meter, the system will look for poles 1 meter away from the pole being imported; if it is found, the pole will not be imported, because it will be considered as duplicated.

Boxes

The table for box import has the following format:

• Name: optional. Defines the name of the box. If it is left in blank, the system will atribute a name. The name needs to be exclusive inside the project;

• Latitude/longitude: mandatory. Coordinates of the element's position;

• Level: mandatory. Level of the box according to the settings of the project;

• Type: optional. Chooses a type of box. If the column is empty, the default type will be chosen;

• Template: optional. You can choose a template for every type of box. If its not filled, the system wil pick the empty template of the default type;

• Deployment status: optional. Can be defined as in project, implanted, not implanted and certified. If not filled, the standard is not implanted;

• Tags: optional. Here you can insert some tags that are already registered in your system;

• Files: optional. Allows the creation of a post. To add images and other files, you can insert your URLs separated by commas in the right column of the table.

• Comments: optional. It is possible to add one column of notes that will be imported together with the boxes.

When you import the boxes, you will be asked the maximum distance in meters that the system must look for a pole. If there is a pole within the distance, it will be used to set the box.

Then the system will import the boxes indeed. The boxes imported properly will have the lines painted in green. The boxes with problems will have the lines painted in red and will not be imported. This way, a message will indicate the error in the column "status".

You can edit the fields in the own OZmap's table.

Cables

• Name: optional. Defines the name of the cable (that can not be repeated inside the project). If it is left in blank, the system will atribute a unique name based on the boxes of the beginning and end of the cable;

• Type: mandatory. Set a type of cable. If not filled the system will choose the default type;

• Level: mandatory. Level of the cable according to the Settings of Project;

• Points: mandatory. This field must contain the latitude and longitude of the poles or point where the cables pass. Latitude_1; Longitude_1, Latitude_2; Longitude_2... 

• First/second point: optional. You can choose one box to be in the beginning and end of the cable;

• Deployment status: optional. Can be defined as implanted or not implanted. If not filled, the standard is not implanted;

• Tags: optional.  Here you can insert some tag that is already registered in your system;

• Files: optional. Allows the creation of a post. To add images and other files, you can insert your URLs separated by commas in the right column of the table.

• Comments: optional. It is possible to add one column of notes that will be imported together with the boxes. 

Clients

• Code: optional. If informed, uses the value as the code. If not, the system will create one;

• Name: mandatory if there is not a code. Name of the client;

• Box: optional. Name of the box that the client is going to be added. If not informed, it will create the client connected to a pole;

• Pole: optional. If informed, connects the client to this pole. If not, uses the same pole as the box;

• Latitude/Longitude: optional. If it is not specified, the client will be created in a random position near to the pole or the box;

• Address: If only the address in informed, without the latitude and longitude, the system will ask for a Google API key. Therefore the system will search for the address in the map and will set the client in the position advised by Google. To know how to generate an API, send a message to our support.

• Power read: optional. Allows to add information of the power read in the client.

• Deployment status: optional. Can be defined as implanted, not implanted or certified. If not filled, the standard is not implanted;

• Client comments: optional. Imports the client with the observation informed in this field;

• Client tags: optional. Here you can insert some tag registered in your system;

• Files: optional. Allows the creation of a post. To add images and other files, you can insert your URLs separated by commas in the right column of the table;

• Property comments: optional. Imports the client and add the written observations of the realty;

• Property tags: optional. Here you can insert some tag registered in your system;

• Connector: equipment to which the client is connected inside the box;

• Port: optional. Number of the port in the equipment;

• Automatic connection: if not informed which splitter and port, it connects automatically in some splitter/port available in the box.

Prospects

• Name: optional. Name of the prospect;
• Code: optional. Add a code for your prospect;
• Latitude/longitude: mandatory. Coordinates of the Prospect;
• Address: optional. Allows the attribution of an address to the Prospect. Does not dismiss the filling of coordinates.
• Tags: optional. Tags informed in the system. It is an additional information; 
• Comments: optional, to add an observation.

Vertical Buildings

• Name: optional. Defines the name of the building. The names must be unique and if it is left in blank, the system will atribute automatically a name;

• Latitude/longitude: you will need to inform the coordinates in case you do not inform the address;

• Deployment status: optional. Can be defined as implanted or not implanted. If not filled, the standard is not implanted;

• Address: optional. Allows the attribution of an address to the building. Does not dismiss the filling of coordinates. 

• Files: optional. Allows the creation of a post. To add images and other files, you can insert your URLs separated by commas in the right column of the table;

• Comments: additional information about the building.

Horizontal Condominiums

• Name: optional. It must be an unique name and if this field is empty, a name will be given automatically by the system;

• Polygon: mandatory. As the table above, it must have semicolons followed by commas between the latitude and longitude;

• Address: optional. Allows the atribution of an adress to the condominium. It does not dismiss the filling of coordinates;

• Color: optional. You can import a color with your condominium or it will be imported with the standard color;

• Comments: optional.  Additional information about the condominium;

• Tags: optional.  Here you can insert some tag that is already registered in your system.

COs

• Name: optional. If not informed, the system will create an unique name for the CO. 

• Latitude/longitude: mandatory. Coordinates of the CO.

• Deployment status: optional. Can be set as in project, not implanted, implanted or certified. If not filled, it will be imported as not implanted.

• Tags: Tags informed in the system. It is an additional information;

• Files: optional. Allows the creation of a post. To add images and other files, you can insert your URLs separated by commas in the right column of the table.

• Comments: additional information about the CO.

Technical Reserve

• Pole: mandatory. Pole which the technical reserve is going to be added. You can fill with the name or the coordinates;

• Reserve: mandatory. Quantity in meters of technical reserve to be imported;

• Cable: optional. Name of the cable, in case there is more than one cable on the pole. If you do not fill this field, the system will choose a random cable that passes by the pole.

Regions

• Name: optional. The name can not be repeated and if it is empty, it will be generated automatically; 

• Polygon: mandatory. As the table above, it must have semicolons followed by commas between the latitude and longitude;

• Type: optional. Choose a type for the region;

• Color: optional. You can import a color with your region or let it be imported according to the color of its type;

• Comments: optional. Additional information about the region.

• Tags: optional. Here you can insert some tag that is already registered in your system.

Below we have example files for the importation.