Bulk Upload Facility

Bulk upload facility is given for the user to manually update the data in system.

Import point IDs from communication operators

1. Select option to import point IDs
2. Upload excel. The excel file should consist of two columns with ‘Fiber number’ and the relevant ‘point ID’ from communication operators
3. For the first drop down, Select  the relevant column that consist the ‘Fiber number’ in the excel. For the second drop down, select the relevant column  that consist the ‘Point ID’ in excel file.

Click on the update button to update point ids.

Upload delivery and membership dates

It is allowed the user to update the connection delivery date and membership date on each connection.

1. Select option to import delivery and member dates.
2. Upload excel. The excel file should consist of three columns with ‘Fiber number’ and the relevant ‘delivery’ and ‘membership’ dates of the connection.
3. Select  the relevant column that consist the ‘Fiber number’ in the excel.
4. Select column consist of ‘Delivery date’.
5. Select column consist of ‘Member date’.

Click on the update button to update delivery and member dates.

Upload communication methods of the contact person

It is allowed the user to upload communication methods of the contact person of properties. This is useful when the properties are created but the contact details are changed later.

1. Select option to import communication methods.
2. Upload excel. The excel file should consist of seven columns with ‘SSN’,  the above mentioned communication preferences for invoice and other communications.
3. Select  the relevant column that consist the ‘SSN’ in the excel.
4. Select  the relevant column that consist ‘Invoice by email’ communication method.
5. Select  the relevant column that consist ‘Invoice by post’ communication method.
6. Select  the relevant column that consist ‘Invoice by SMS’ communication method.
7. Select  the relevant column that consist ‘Other by email’ communication method.
8. Select  the relevant column that consist ‘Other by post’ communication method.
9. Select  the relevant column that consist ‘Other by SMS’ communication method.

Click on the update button to update communication preferences.