Difference between revisions of "Data Import/Service Qualification Addresses"
(→GNAF Address data in the Emersion Format) |
(→GNAF Address data in the Emersion Format for the SQ Tool) |
||
| Line 17: | Line 17: | ||
You will need to prepare your address data in the required format ready to import. Data provided in a different format will be returned to you as incomplete. The import sheet is a generic template that caters for all different types of addresses, with both long and short forms supported. Not all fields will be used for each address, and as such, no address field is mandatory. Please pay very close attention to filling in this import sheet. Your data will be imported without change. Emersion staff will sight your data for technical compliance but '''we will not comprehensively check the data to ensure you have completed it correctly'''. Emersion will not be held liable for correcting mistakes made due to data being provided to us that was incorrect. You will be invoiced for any corrections needed on a time & materials basis. See the '''GNAF Address Data Definition table''' table at the end of this article for a description of the data fields | You will need to prepare your address data in the required format ready to import. Data provided in a different format will be returned to you as incomplete. The import sheet is a generic template that caters for all different types of addresses, with both long and short forms supported. Not all fields will be used for each address, and as such, no address field is mandatory. Please pay very close attention to filling in this import sheet. Your data will be imported without change. Emersion staff will sight your data for technical compliance but '''we will not comprehensively check the data to ensure you have completed it correctly'''. Emersion will not be held liable for correcting mistakes made due to data being provided to us that was incorrect. You will be invoiced for any corrections needed on a time & materials basis. See the '''GNAF Address Data Definition table''' table at the end of this article for a description of the data fields | ||
| − | Download the GNAF addresses import sheet [[file:gnaf_addresses-importsheet. | + | Download the GNAF addresses import sheet [[file:gnaf_addresses-importsheet.txt]]<br /> |
Code definitions needed to complete the GNAF addresses import sheet can be found in Cumulus. '''Navigate: Reports > Reference > Physical Address Reference Data''' | Code definitions needed to complete the GNAF addresses import sheet can be found in Cumulus. '''Navigate: Reports > Reference > Physical Address Reference Data''' | ||
Revision as of 17:42, 2 October 2014
Contents
Address-based Service Qualification Tool - Importing and Configuring Addresses
Emersion provide an address based SQ (designed around GNAF) and service/location tracking management for providers who run NBN like services, including site device and port management.
This article is for customer who want to populate the address-based service qualification ('SQ') tool with an available list of addresses and their service availability status. Please note that Emersion does not have a database of every address in Australia or elsewhere that is ready to use for this purpose. For any given address, the availability status may vary between Service Providers. In order to use the SQ tool the Service Provider must provide all addresses and their servicability status. Once this is loaded into Emersion, these will be available to be used by the address-based SQ.
Pre-requisites
Service Availability Descriptions
You will need to have a list of service availability descriptions ready for each ****LINK****Service Type that will use the address-based SQ. Below is a CSV file you will be required to complete. Please remove the examples we have provided in the file before submitting. If you do not do this, the file cannot be used to import and the file will be returned to you. See the SQ Servicability Descriptions Data Definition table at the end of this article for a description of the data fields.
Download the service availability descriptions File:Service availability-descriptions.csv
GNAF Address data in the Emersion Format for the SQ Tool
You will need to prepare your address data in the required format ready to import. Data provided in a different format will be returned to you as incomplete. The import sheet is a generic template that caters for all different types of addresses, with both long and short forms supported. Not all fields will be used for each address, and as such, no address field is mandatory. Please pay very close attention to filling in this import sheet. Your data will be imported without change. Emersion staff will sight your data for technical compliance but we will not comprehensively check the data to ensure you have completed it correctly. Emersion will not be held liable for correcting mistakes made due to data being provided to us that was incorrect. You will be invoiced for any corrections needed on a time & materials basis. See the GNAF Address Data Definition table table at the end of this article for a description of the data fields
Download the GNAF addresses import sheet File:Gnaf addresses-importsheet.txt
Code definitions needed to complete the GNAF addresses import sheet can be found in Cumulus. Navigate: Reports > Reference > Physical Address Reference Data
Submitting your Request for Import Services with Emersion
Presently, there is no support for Service Providers to load addresses into Emersion's database via Cumulus. Raise a work request ticket via the Emersion Support Portal or via email to workorders@emersion.com.au and include your import sheet and service availability descriptions. Please be aware that all work requests attract a fee. We provide a rough estimated quote of 1 hour's T&M labour time which accounts for a single pass through the data import process as described below. If we need to help you with your data, or we have to proceed through the import process more than once, you will incur further charges.
Please allow up to 14 days for your request to be processed once we have all the requirements. Estimated delivery dates can be subject to vary during busy times.
The Data Import Process
- Emersion will review the data you have provided to ensure it is technically compliant and is in a state ready for import. If the data is not ready to import, it will be returned back to you to correct and resubmit.
- Once the file passes, Emersion will import your data into a test environment and perform a sanity check.
- Emersion will then export this data from the database and return it back to you for validation.
- If the data needs correcting, please make a new version of the import sheet and submit it to Emersion via the ticket.
- If the data does not need correcting, provide written sign off. Emersion will not import data into Production without written sign off.
- Emersion will then load the data into the Production (Live) database and notify you accordingly.
SQ Servicability Descriptions Data Definition table
| Data field | Description | Mandatory |
| CLASS_NUMBER | A numerical value that can be used to test for a pass or fail SQ result. E.g. Fails are descriptions of class number 1, 2 and 3. the SQ will produce a pass if the address is class 4 or greater | No |
| DESCRIPTION | The service availability description | Yes |
| SERVICE_TYPE_ID | Service type ID applies if the description applies only to a single service type. You can request the ID of any service type from Emersion if you do not know it. In many cases, service types are used by multiple Service Providers. Service availability descriptions is reference data used globally. They will be able to be seen and used by other Service Providers if they are also using the address-based SQ when placing orders for the same service type. Emersion reserves the right to refuse service availability descriptions that are too customer-specific or are unsuitable for use globally. | No |
GNAF Address Data Definition table
| Data field | Description |
| EMERSION_ID | A unique key assigned by the Emersion database automatically. Leave this field empty |
| GNAF_PID | A unique key assigned by the Emersion database automatically. Leave this field empty |
| UNIT_NUMBER | Enter a numerical value in this field if the address has a unit number |
| UNIT_NUMBER | Enter a numerical value in this field if the address has a unit number |
| UNIT_TYPE_CODE | Refer to the Physical Address Reference Data report |
| LEVEL_NUMBER | Enter a numerical value in this field if the address has a level number |
| LEVEL_TYPE_CODE | Refer to the Physical Address Reference Data report |
| ADDRESS_SITE_NAME | Enter a text value in this field if the address has an address site name |
| ROAD_NUMBER_1 | Enter a numerical value in this field if the address has a street number (e.g. 285-289 Hope Road) |
| ROAD_NUMBER_2 | Enter a numerical value in this field if the address has a 2nd road number (e.g. 285-289Hope Road) |
| LOT_NUMBER | Enter a numerical value in this field if the address has a lot number |
| PLAN_NUMBER | Enter a numerical value in this field if the address has a plan number |
| ROAD_NAME | Enter a text value in this field if the address has a road name |
| ROAD_SUFFIX_CODE | Refer to the Physical Address Reference Data report |
| ROAD_TYPE_CODE | Refer to the Physical Address Reference Data report |
| LOCALITY_NAME | Enter a text value in this field if the address has a locality name |
| STATE_TERRITORY_CODE | Refer to the Physical Address Reference Data report |
| HISTORICAL_FOOTPRINT | Leave this field empty |
| LAST_UPDATED | Leave this field empty |
| SERVICE_CLASS | Leave this field empty |
| QAS fields | Only complete these fields if Emersion integrates with your external invoice printing and distribution company. |
| CARRIER_LOCATION_AVAIL_ID | Leave this field empty |
| GNAF_CARRIER_LOCN_PROFILE_ID | Leave this field empty |
| CARRIER_LOCATION_IDENT | Leave this field empty |
| SERVICE_AVAILABILITY_DESC_ID | The Id of the service availability description |
