Create a selection of assets by uploading a CSV file into the Selection uploader. If a selection is already active, the uploaded CSV file will add assets to your existing selection. This feature is available to consumers and above.
Formatting a CSV file
- Every column header of your CSV file must correspond to the exact name of a supported attribute, including case.
- Each subsequent row must correspond to an exact attribute value which matches an asset stored in NetX; if your site is configured to support wildcard matches, your results may include near-matching values.
- Every field including every column header and row value must be bracketed by double quotes.
- If the attribute is not the last column of your data file, a comma must follow the second quotation mark before the next attribute column throughout the entire column regardless of whether or not the space between commas contains empty double quotes.
- CSV files should not have any spaces between double quotes or the comma separators between attributes or values.
assetID: The unique identification number assigned to each asset in NetX.
file: The name of the asset's file.
name: The label NetX uses as the asset's name.
fileType: An asset's file extension, e.g. .jpg, .pdf, or .mp3.
fileFormatFamily: An asset's format family, e.g. image, document, or audio. Format families represent multiple types of file extensions. For example, .mp3 and .wav are in the audio family.
- Any custom attributes. Note that only one value for multi-select or tag attributes may be searched per row.
Matching all values
If a CSV file has multiple columns, NetX will search for assets that contain all of the attribute values specified. For example:
- fileFormatFamily corresponds to the exact system attribute of the same name, with a value of image in this case in the subsequent row field. This will limit any selection results to specifically image-type assets regardless of their file extension (e.g. jpg, png, etc).
- Dog name is the name of a custom attribute that exists in NetX. The subsequent row corresponds to an attribute value. This file will hunt for any assets that have the value of Boof for the attribute Dog name.
- When this file is uploaded via the selection uploader, a selection will be created consisting of all attributes that are images with a Dog name value of Boof.
Matching any value
When there are multiple rows of values, NetX will search for assets that contain any of those attribute values specified. For example:
- fileFormatFamily corresponds to the exact system attribute of the same name, with a value of image followed by document in the subsequent row fields.
- This file will create a selection consisting of any image or document-type file regardless of file extension – e.g. jpg, png, pdf, etc.
Uploading a CSV file
- Use the Tools button along the lefthand navigational sidebar to open the tools menu.
- Click Upload selection.
- Add your file to the selection uploader window either by using the Select file button to open a file picker to your local storage, or dragging a local file to the window.
- Create your selection by clicking the Upload button.
If you are experiencing issues trying to upload your data file or seeing unexpected search results, here are a few things to check:
- All header attributes are cased and spelled correctly.
- All pulldown, multi-select, and tag values match any preset value options exactly, or the upload will fail.
- Any multi-select or tag values only contain one value per row. Note that you can search for multiple values for a single attribute, but each value must be in its own row.
- Number-type attributes contain only numbers, and conform to any decimal restrictions your site's administrator may have imposed.
- All columns and rows align with their respective attributes and assets, accounting for any empty fields when aligning rows to attribute columns.
- All fields are properly escaped with double-quotes and delimited by commas with no spaces between quotation marks or commas.
- If all attribute fields are accurate and you're sure your file adheres to proper CSV formatting guides — but your file is returning zero results — compare your searched attribute values against the system's advanced search by attribute value.
- If you have issues uploading a CSV file into NetX, check that the CSV file is saved with the current encoding (UTF-8). This is especially important for non-English characters. MS-Excel is known to save CSV files in different encoding standards, depending on the OS of the machine where it is installed. For this reason it is recommended to save Excel files as .xlsx for upload into NetX, or create a CSV using other programs that will ensure the file is set to the correct encoding. Open Office and Google Sheets are good alternatives. See Excel and CSV Encoding for more information.
|True/False||If this property is true, the selection uploader feature will be available in the application. To disable this feature, toggle this value to false.||No|
|True/False||If this property is true and a row of values returns zero results in the application, a second search will be performed which will look for near-matching values, i.e. a wildcard match search. For example, if a primary search value is attend, this second search will look for matches such as attended, attending, or attends. If this value is false, the selection uploader will only create a selection of exact matches for any attribute value.||No|
|True/False||If this property's value is true, a report of any row values which produced zero results will be emailed to the user who uploaded the selection. This report will be a second CSV containing only the non-matching rows. If this property's value is false, no report will be sent regardless of any failed results.||No|