1406.0.55.005 - TableBuilder, User Guide  
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 15/12/2016   
   Page tools: Print Print Page Print all pages in this productPrint All RSS Feed RSS Bookmark and Share Search this Product

CUSTOM DATA

Use the Custom Data tab to create custom groups of values (also referred to as 'recodes') to use in tables. The custom groups can be saved in the TableBuilder system and can be accessed again in future. Custom Data files can also be downloaded and shared with other users for uploading. Custom Data is useful for users who may want to create their own classification or load more recent electoral boundaries.

This section includes:
Create and save a custom data group within TableBuilder
Download a saved custom data group
Download a classification to edit outside TableBuilder
Edit a downloaded custom data group outside TableBuilder
Upload a custom data group
Upload Commonwealth and state electoral divisions and local government areas

CREATE AND SAVE A CUSTOM DATA GROUP WITHIN TABLEBUILDER

Use the Custom Data tab to create custom groups of values (also referred to as 'recodes'), which can then be used in a table.

  1. This example uses the 2011 Census - Usual Address and Internal Migration dataset. Select the Custom Data tab.
    Image: Custom data tab
    .
  2. In the Step 1 panel, select the variable categories you want to group together, then click »» to add them to the list on the right.

    For example, to create a group of States in the Main Statistical Area Structure (Main ASGS) field, select the States from the list and click  »»
    Image: Select categories to include in a custom group
    .
  3. The selected categories now appear in the Step 2 panel on the right. After adding all the items required, click Save.
    Image: Chosen custom group categories are displayed
    .
  4. A prompt appears to enter a name for the group. Click Save.
    Image: Name and save the custom group
    .
  5. TableBuilder adds the new group to the My Custom Data list.
    Image: Custom geography is available in My Custom Data
    .
  6. Your saved Custom Data group is now available in the left panel of the Table View. Custom Geographies appear in a folder of the same name as in the My Custom Data screen. In this example, the new data item is in the Custom Geography folder in My Custom Data and in the Table view.
    Image: Custom data group can be seen in variables list panel
    .
  7. Custom groups of geographical areas are found in a separate Custom Geography folder below the other folders in the database. Custom groups of other variables appear at the appropriate level in the classifications folders of the database.
    .
  8. The custom group can be added to a table.
    Image: Custom data group can be added to a table
    .
  9. You can edit a group that you have created previously. However, if you have used your custom group in a saved table, the old version of the group will continue to display in the table. To update to the new version, you will need to remove and add it to the table again.

DOWNLOAD A SAVED CUSTOM DATA GROUP

You can download a Custom Data group you have built in TableBuilder to share with other users.
  1. Select the Custom Data tab.
    Image: Custom data tab
    .
  2. In the My Custom Data section, select the tick box next to the group to be downloaded and click the Download button.
    Image: Select the custom data group to Download
    .
  3. Depending on the browser, the file will either be saved to the default downloads folder, or a prompt appear to Save or Open the file. For example:
    Image: Message asking whether to open or save the file
    .
  4. The custom group is downloaded in a Comma Separated Values (CSV) format, and can be edited outside the TableBuilder system, or shared with other users.


DOWNLOAD A CLASSIFICATION TO EDIT OUTSIDE TABLEBUILDER

You can download a whole classification to edit outside TableBuilder. This option is useful for very large classifications, such as geographies, or where you would like to use a TableBuilder classification to build your own classification outside TableBuilder.
  1. This example uses 2016 Census - Counting Persons, Place of Usual Residence (MB). Select the Custom Data tab. Then select the whole classification you are interested in by using the single arrow >. In this example, SA1 is selected. Click on the double arrow »» to move the selected classification to the second panel.
    IMage: Selecting variables to download in Custom Data
    .
  2. Once the classification has loaded, click the Save button.
    Image: Save the loaded classification
    .
  3. Choose a name for your classification. If you choose a custom group name you have previously used, TableBuilder will ask you to choose another name.
    Image: Name the custom group with a unique name
    .
  4. In the My Custom Data section, select the tick box next to the group to be downloaded and click the Download button.
    Image: Download the custom data group
    .
  5. Depending on the browser, the file will either be saved to the default downloads folder, or a prompt appear to Save or Open the file. For example:
    Image: Prompt to open or save the downloaded file
    .
  6. The custom group is downloaded in a Comma Separated Values (CSV) format, and can be edited outside the TableBuilder system or used with your own geographical classification.

EDIT A DOWNLOADED CUSTOM DATA GROUP OUTSIDE TABLEBUILDER

When a custom group is downloaded as a file in Comma Separated Values (CSV) format, the file can be opened and edited in a text editor or application such as Excel. It is important to be careful when editing a saved custom groups file in Excel, as it may make changes to the data that will prevent the file from opening in TableBuilder again. For example, Excel may strip leading zeros from codes in the file, such as ValueCode, which will not be able to be loaded back into TableBuilder. It is best to use a text editor instead, such as UltraEdit, to upload the new group.

A downloaded custom group opened in a text editor.
Image: Downloaded custom group in UltraEdit
.
A downloaded custom group opened in a spreadsheet.
Image: Downloaded custom group in Excel
.
The first row contains the headings, and each subsequent row represents a single item in the custom group. The heading row must not be edited to allow the file to be uploaded to TableBuilder.

Rows can be added, edited or removed (except the header row) to change the composition of the group.


UPLOAD A CUSTOM DATA GROUP

Custom group files that have been created or edited in your own system or shared from other users can be uploaded into TableBuilder.

To upload a custom group:
  • You must have access to the dataset that the custom group was created in.
  • The dataset that relates to the custom group must be open.
  • Upload files must be in CSV format.
  • The structure of the custom group file must be retained using the same column headings.
  • The name of the group in the saved file must not be the same as an existing custom group. TableBuilder displays an error if a custom group with the same name as an existing group is attempted to be loaded. Delete the existing custom group, rename it, or rename the group saved in the file (by changing the value of the GroupName in the final column).
  • Only one saved group can be uploaded at a time.
  1. To load a custom group from a file, open the dataset that was used to create the recode, and select the Custom Data tab.
    Image: Custom data tab
    .
  2. In the My Custom Data section, click Upload in the.
    Image: Upload button
    .
  3. Browse to the location where you saved your custom group file and select the file. When uploaded, TableBuilder adds the new group to the My Custom Data list.
    Image: New group added to the variable list
    .
  4. If there is a problem with the upload, an error message is displayed.
    .
Common errors when uploading a custom data group:

| Upload error. 61 out of 65 lines successfully imported. A values code or name is not found.
The ValueCode column, which is the numeric code for a variable name, may be missing leading zeros. Check if the classification you have edited includes leading zeros.

| Upload error. 0 out of 1,464 lines successfully imported. A group with this name already exists.
The Custom Data group has previously been uploaded or the name has already been used. You will need to change the value of the GroupName in the final column to load the file.

| Upload error. 0 out of 1,464 lines successfully imported. A tables code or name is not found.
The upload file doesn't match the dataset that is open. You will need to open the matching dataset to load the file. If you already have the correct file open, the information in the FactTableCode or FactTableName may be incorrect. You can check what this should be by downloading any custom data from the same dataset.

| Uploaded file has invalid CSV header. Expecting column names FactTableCode, FactTableName, FieldCode, FieldName, ValueSetCode, ValueSetName, ValueCode, ValueName, GroupName but read [, FactTableName, FieldCode, FieldName, ValueSetCode, ValueSetName, ValueCode, ValueName, GroupName]
The header row contains an error. You will need to check the header row in your file to ensure it has the correct names, as listed in the examples pictured above.

The requested URL was rejected. Please consult with your administrator.
This message may be caused by a number of different actions. In this context it may be caused by trying to load an incorrect file type, such as an XLS. Only CSV files can be used when uploading Custom Data Groups.
UPLOAD COMMONWEALTH AND STATE ELECTORAL DIVISIONS AND LOCAL GOVERNMENT AREAS

Commonwealth electoral divisions (CED), state electoral divisions (SED) and local government areas (LGA) boundaries change over time. ABS has prepared upload files to assist users to update the boundaries available within Census TableBuilder.

TableBuilder upload files for CEDs, SEDs and LGAs are available for use with Census 2016 datasets:
Australian Statistical Geography Standard (ASGS): Volume 3 - Non ABS Structures (cat. no. 1270.0.55.003) (see Downloads tab)

Earlier boundaries are also available using SA1s for use with Census 2011 datasets:
2016 Commonwealth Electoral Divisions
2012 Commonwealth Electoral Divisions
  1. Download the CSV file from the Downloads tab in Australian Statistical Geography Standard (ASGS): Volume 3 - Non ABS Structures (cat. no. 1270.0.55.003), and save it to your computer.
    Image: Commonwealth and State electoral divisions and local government areas zip files available to download
    .
  2. Files are available for Australia and for each state and territory. These files are suitable for use with the following 2016 Census of Population and Housing - TableBuilder Pro datasets:
    2016 Census - Counting Persons, Place of Enumeration (MB) - compatible files are annotated with en
    2016 Census - Counting Persons, Place of Usual Residence (MB) - compatible files are annotated with ur
    Image: TableBuilder datasets that can be used with CED files Image: 2017 CED files for Australia and each state for EN and UR
    .
  3. Log into Census TableBuilder and open the dataset you are interested in. This example uses 2016 Census - Counting Persons, Place of Usual Residence (MB). Go to the Custom Data tab and click the upload button at the bottom left of the screen.
    Image: Upload selected file
    .
  4. Find the location where the CED files have been saved and select the region you are interested in (Australia, state or territory). This example uses 2017_ced_nsw_ur.csv.
    Image: Example load file for 2017_ced_nsw_ur.csv
    .
  5. When the upload has completed, a message appears on the right to confirm the number of rows that have been loaded from the CSV file (not including the heading row). The uploaded custom data appears in the My Custom Data window under Custom Geography. If you receive an error when uploading a file, check the errors and causes listed in the Upload a custom data group section above.
    Image: Successful upload message and display of custom groups
    .
  6. In the Table View tab the custom data you uploaded appears under the Custom Geography folder. You can select multiple tick boxes at once by holding down the Shift key to add the NSW CEDs to a table.
    Image: Selecting multiple CEDs using Shift key Image: Using a CED in a table