Creating Tables
Tables are the foundation of Hunni.
- Tables can contain data or files
- Tables can be shared internally or externally
- Table data can be accessed directly or indirectly through Views
- Tables and table data can be modified using the Hunni API
You can create a new table by either 1. Uploading from an excel file or 2. Using the Table Builder.
Start by making sure your table is setup so Hunni can read your data.
- The table should be in the first sheet of your Excel workbook starting in cell A1
- Your top row should contain names for each column
- No empty columns or rows inside your table
- Your Excel file should be in XLSX or CSV format.
- If you want to add a file column, after uploading you can edit the table in the Table Builder
Next, you'll want to navigate to where you'll want the table to be stored in your folders in the Assets Dashboard. You can always change an asset's location later by selecting the asset and click the Edit -> Location button.
Once you are in your desired Table location, click the Upload button in the top right of the Asset Nav window and select Upload New Table from the dropdown.
Hunni will scan your file to make sure your layout is good and detect the types of data in your columns for the next step. This make take longer for larger tables.
Next you'll pick a table name and choose your column types.
- If you don't see an expected column type, that means we detected data in that column that wouldn't fit that column type. For example, if you have decimal numbers in a column, you won't be able to select an integer column type.
- You cannot upload data to file columns. Uploading a file ID or a file name will not associate it to a row. Files must be uploaded through the expanded grid row editor or through the API .
- Choose column types carefully. Currently, you cannot edit a column type after it's been chosen. If you'd like to change a column type, you will need to Edit the table, create a new column with the new column type, then transfer the data to the new column.
- After uploading, you can adjust display formats for decimal and integer columns in the Table Builder by selecting the table and clicking Edit->Structure Details.
After making your selections, click the "Complete" button, and your table will upload.
If your table is large, you may recieve a pop-up asking if you'd like to recieve an Email, when it's ready to be accessed. Most tables with over a million data values could take a couple minutes to upload.
If you recieved an error, double check your table layout against the instructions in Step 1.
If you continue to have issues, please email [email protected]. Please attach the table you are trying to upload. You can also submit a support request by clicking the question mark icon from the banner menu in the top right and selecting "Contact Support" from the dropdown.
When uploading new rows to an existing table, your upload table needs to match the structure of the Hunni table you are uploading to, including the "Hunni Id" column in Column A.
- First row should match the column names and order of the existing table
- If you are editing rows in the same upload the first column must be a "Hunni Id" column. Leave this column blank for any new rows to be added.
- You can use this same upload process to edit table rows, by including the Hunni ID of rows you wish to replace. See Editing Table Data.
- Make sure your upload table data matches the column types of the table you are uploading to. You can check the column types by selecting the table, then clicking Edit->Structure/Details.
Once your upload table is ready, Navigate to the existing table in the Assets dashboard and select it.
Click the Upload button in the top right of the Asset Nav window and select Upload to Selected Table from the dropdown.
After selecting your file, the new rows will be added to the table. If you recieved an error, double check your table layout to make sure it matches the
Below is an example format of an upload table with new rows and edits in the same table.
Use the Table Builder to:
- Create a new Table, by first defining its structure (column names, column types, description), then adding data/files to it later.
- Edit an existing Table's structure/details
Use the Table Builder to add File Columns to Tables
First, you'll want to navigate to where you'll want the new table to be stored in your folders in the Assets Dashboard. You can always change an asset's location later, by selecting the asset and click the Edit -> Location button.
Click the "New" button in the top right of the Asset Nav window and select Table from the dropdown.
- Choose column Name and Type, then click the "Add Column" button
- Click and drag columns to change column ordering.
- Click the Pencil Button to edit a column
- The "Required" column indicates whether a new row can be added with empty data in that column. (Yes = column cannot be empty, No = column can be empty)
- Use the "Column Display Format" column to adjust display formatting for interger and decimal columns
- Name your Table and give it a description
After you click Save Table, your table will be available in the Assets Dashboard.
You can then upload rows to the table using an excel file, or use the excel add-in to add rows directly from excel. See Using the Excel Add-In for more info.