Information on the Text Delimited Data Format
We offer the ability to upload files in comma-delimited text file format. Each line of text file represents a channel transmitted in a specified azimuth. Repeat all applicable data on each line. For example, if a station has three transmit antennas, repeat the information about the station on each line to indicate that the antennas are in the same station and for each antenna please identify all transmit and received channels in a specific azimuth that are potentially in operation.
Supporting Files for Delimited Text Upload Submissions
The documents listed below provide detailed supporting documents for the submission in delimited text format.
|Delimited Text Format for the upload of Technical Data for Stations Authorized under Spectrum Licences||Detailed description of technical data required for data uploads including format, units and allowable values.|
|Spectrum_Licence_data_Spreadsheet_format_En.XLSX (23kB)||Microsoft Excel Spreadsheet file format ready to use for data entry of technical data.|
|Spectrum_Licence_Data_Text_Sample_Data_En.Txt (2kB)||Example of a text file format for a simple system.|
Use of commas
Commas must be used as a field separator only. If a comma is submitted for example in the location field (ex: 300, Slater St), then the field must be double quoted (ex: "300, Slater St") because the line format will not be accepted otherwise.
Station records ordering
Identical station records (same location name and coordinates) must all be grouped together and cannot be mixed with other stations. An error will be issued if the ordering is not met.
Non mandatory fields
If a field is not mandatory according to the data format, a null space must be submitted with comma delimiters.
Use of spaces
Use only the space required. Do not pad text with extra spaces at the start or end of text or numbers.
Use of quotes
Within delimited text files, text can optionally be enclosed in double quotes. When a series of characters begins with a double quote, it is assumed that the text is enclosed in double quotes.
Number Data Formats
Within delimited text files, do not use a comma in numbers, because it must be used as the delimiter. Numbers must not contain units or thousands separators. The period must be used as the decimal character.
Many spreadsheets and databases take their settings for number format from the software or operating system’s language settings. You may have to change the language setting to produce files in the correct format.
Within delimited text files, if text contains a comma, it must be enclosed in double quotes.
Example: "Jones, Kelsey & Leduc" contains a comma and must be enclosed in double quotes.
Date Data Formats
All dates are in the ISO standard numeric year-month-day format with a four digit year (YYYY-MM-DD).
Example: "March 6, 2015" is represented as 2015-03-06
Use of XLSX File Format
You cannot upload a file in this format. Data must be exported in a comma delimited text format (CSV) with the exact sequence specified by Innovation, Science and Economic Development Canada.
We provide a sample file in XLSX format ( Spectrum_Licence_data_Spreadsheet_format_En.XLSX) which can be very useful for data entry and allowing the export of data in comma delimited text format for data uploads.
- Date modified: