Skip to main content
MediaBeacon University

Text View

User

The Text View allows users to view assets in a compressed format with less emphasis on asset previews.

Text_View_1.png

Main Features

Common Configuration

Please see the View widgets section for a description of interface elements common to all View widgets.

Sorting

In addition to standard sorting options, Text View can set text wrapping for columns and align content vertically and horizontally.

Metadata Entry & Editing

In the Text view, a user can edit non-database metadata shown in columns. Double-click on a field to edit. Once editing has been completed, a small red flag will show in the upper left hand corner of the field, indicating changes have been made. Metadata edits in the Text view are not finalized until "Save" is clicked in the control area. Clicking "Reset" will remove all pending metadata edits.

Shortcut Keys:

  • Open Asset View of selected items: Spacebar.
  • When Editing Metadata, move to next field to the right: Tab Key, Shift-Tab to move to the left.
  • When Editing Metadata, move to next field below: Return or Enter.

Import and Export (AKA The Import / Export Wizard)

Import/Export allows users to manipulate the metadata of large groups of assets using CSV, XML, or other delimited filetypes. Bulk Select can use these same files to select a large group of assets based on matching metadata. These functions can only be enabled in Text View or Calendar View.

Import-Export-Bulk_Select_1.png

Export

Export allows users to export all the metadata in Text View as a CSV or other delimited filetype. This metadata can then be edited in a spreadsheet and written back into the assets using the "Import" function.

To begin an export, click the "Export" button. This brings up the Export dialog, which has several options.

Import-Export-Bulk_Select_2.png

  • File Type: This is the kind of file that will be exported. Comma-separated values (CSV) is the default, but XML and Tab Delimited are also available. To use a custom delimiter, choose "Custom" and enter the desired character into the "Custom Delimiter" field.
  • Encoding: This is the encoding used in the exported text document. UTF-8 is the default, as it's the dominant international encoding of the web, but others are available. 
  • Filename: Enter the name of the exported text document here.
  • Export From: This option exports either the current selection, or else all the assets available in the current view.
  • Remove Quotes: Quotation marks are sometimes problematic when importing and exporting metadata, so they can be removed with this option.
  • Use Namemapped Column Headings: This uses the namemappings in the exported file, instead of the actual field names.
  • Save Export Preset: This option will save the current export settings. They will then be available whenever the "Export" button is clicked.

Import-Export-Bulk_Select_3.pngImport-Export-Bulk_Select_3.1.png

Click "Export" to complete the export. The metadata has now been saved as a delimited text file, which can be edited in a spreadsheet or other program.

Import-Export-Bulk_Select_4.png

Import

After a user has exported metadata and edited the resulting file, Import lets the user upload the file and write the new data into the appropriate assets.

Import-Export-Bulk_Select_7.png

Import Options

MediaBeacon supports import files with the following UTF-8 encoding options: "UTF-8  with BOM", "UTF-16 LE with BOM", "UTF-16 BE", "UTF-16 BE with BOM". "UTF-16 LE" is not supported.

  • File Type: This option identifies the file type for the uploaded file so it can be properly imported. If the file uses a custom delimiter, choose "Custom" and enter the appropriate character into the "Custom Delimiter" field.
  • Encoding: This is the encoding used in the uploaded file. UTF-8 is typical.
  • Generate Import Logs: This generates a log files indicating if there were any errors during import, and which entries matches single assets, multiple assets, or no assets. These logs are created in a time-stamped folder at the root level of the ACL. See Step 8 for details.
  • Create Placeholder Files for unmateched records: This option adds an Data Only asset for each unmatched record.

Matching Assets With Metadata (Key Field)

To match a CSV row with a specific asset, a Key Field is designated, usually the leftmost field. Typically a field like File Name, Record ID, or Serial Number,is used for this purpose. There are several ways of making a match, which can be chosen in the dropdown menu to the right of each column.

To use the full set of matching options, a field must be SQL Indexed. The following are only available in this state: "Equals", "Starts With", "Is the Start Of", "Ends With", "Is the End Of", "Contains", "Is Contained By".

 

Equals

The most straightforward option. Values in the uploaded file will be matched with identical values in MediaBeacon.
Example: "1234" (CSV) will be matched with "1234" (MediaBeacon).
SQL indexed fields only.

Starts With

Values in the uploaded file will be matched with longer values in MediaBeacon that begin the same way.
Example: "1234" (CSV) will be matched with "12345678" (MediaBeacon).
SQL indexed fields only.

Is the Start Of

Values in the uploaded file will be matched with shorter values in MediaBeacon that begin the same way.
Example: "12345678" (CSV) will be matched with "1234" (MediaBeacon).
SQL indexed fields only.

Ends With

Values in the uploaded file will be matched with longer values in MediaBeacon that end the same way.
Example: "789" (CSV) will be matched with "456789" (MediaBeacon).
SQL indexed fields only.

Is the End Of

Values in the uploaded file will be matched with shorter values in MediaBeacon that end the same way.
Example: "456789" (CSV) will be matched with "789" (MediaBeacon).
SQL indexed fields only.

Contains

Values in the uploaded file will be matched with values in MediaBeacon that contain them anywhere in the string.
Examples:
"456" (CSV) will be matched with "2345678" (MediaBeacon).
"Man" (CSV) will be matched with "Spiderman" (MediaBeacon).
"Sun" (CSV) will be matched with "Sunscreen" (MediaBeacon).
SQL indexed fields only.

Is Contained By

Values in the uploaded file will be matched with values in MediaBeacon that are contained anywhere in the string.
Examples:
"2345678" (CSV) will be matched with "456" (MediaBeacon).
"Spiderman" (CSV) will be matched with "Man" (MediaBeacon).
"Sunscreen" (CSV) will be matched with "Sun" (MediaBeacon).
SQL indexed fields only.

No Action

No matching or replacement will occur.

Updating and Overwriting Metadata:

The last two options should be used for columns whose values are actually being changed. New values will display with a red microbadge in the upper left corner in Text View.

Import-Export-Bulk_Select_7.png

  • Update: This option will write only non-empty values from the uploaded file into the assets. If an entire column is empty in the uploaded file except for one value, "Update" will only write that single value to its corresponding asset. The other assets will remain untouched.
  • Overwrite: This option will write all values from the uploaded file into the assets, both empty and non-empty. Thus, if an entire column is empty in the uploaded file except for one value, "Overwrite" will blank out all the asset values in that column except for one, which will be changed to the new value.
  • Ignoring Columns: "No Action" should be chosen for columns that aren’t being used for matching and aren’t being updated/overwritten during import.

Import Error Indications

Unmatched Records

Records that can’t be matched with assets will be outlined in red and display at the top. Unmatched records can occur if the corresponding assets aren’t in the current import location (chosen in Step 2), or if the data that’s being used for matching in the uploaded file is somehow incorrect. Use the checkbox to create placeholder files for unmatched records.

Import-Export-Bulk_Select_9.png

Unmatched Columns

By default, MediaBeacon will try to match the column headers in the uploaded file with the columns in Text View. If the column names don’t match, the user can use dropdown menus to manually choose columns from the uploaded file to match with the Text View columns.

Import-Export-Bulk_Select_8.png

Saved Import Settings

To save the import settings before proceeding with the import, click "Save Preset." This will make these settings available for future imports.

Import-Export-Bulk_Select_11.pngImport-Export-Bulk_Select_12.png

Import Log Files

After the import is complete, logs files will be created if "Generate Import Logs" was checked. There are 5 logs files:

  • Error: Lists any errors that occurred during import.
  • MatchedMultipleUpdated: Lists any entries that matched multiple assets.
  • MatchedSingleUpdated: Lists any entries that matched single assets.
  • UnmatchedCreated: Lists any entries that matched no assets and had placeholders created instead.
  • UnmatchedNotCreated: Lists any entries that matched no assets for which no placeholders were created.

Import-Export-Bulk_Select_13.3.png

Import Sequence

  1. To begin an import, click the "Import" button.

    Import-Export-Bulk_Select_1.png

  2. This brings up the upload dialog.

    Import-Export-Bulk_Select_6.png

  3. Click "Choose File" to select the text file to be imported. If the import file wasn't originally generated by MediaBeacon, be sure it conforms to the MediaBeacon format by clicking the example files at the bottom of the dialog.
  4. Import Location: This option determines which assets the metadata from the imported file should be written to, either the current selection, or else all the assets available in the current view.
  5. Click "Upload."
  6. The Import dialog now appears, the user chooses options.
  7. To finish the import, click "Write Metadata." The values from the uploaded import file will now be written into the matched assets.

    Import-Export-Bulk_Select_13.png

    Bulk Select

    The function allows the user to select assets based on a list. For example, a list of filenames would select any assets that match any filename on that list, including any identically-named files.

    Preparing the Data Source

    The input file may be a saved file, or a bock of pasted text. The Bulk select will only act upon a single column of values, proceeded by a header row, per the example below:

    file_name
    file4712.ext
    file5607.ext
    file4091.ext
    file8767.ext
    file7888.ext
    file6004.ext
    file6885.ext
    

    The field used for bulk select must be indexed with SQL

     

    To use the function, click "Bulk Select" and choose the source file, or paste the value list into the "Paste" text area, and click "Continue".

    bulkselect.png

    Initially, no assets will be selected.

    bulkselect-columns1.png

    The user will need to choose a search operator from the pulldown to the right of the corresponding metadata column, in this case "File Name".

    bulkselect-columns2.png

    Upon choosing the operator, a preview of the selection will be displayed:

    bulkselect2.png

    Upon choosing "Select" the list of assets will become the current asset selection:

    bulkselect3.png

    Admin

    Text_View_Config_1.png

    Widget Configuration

    • Common Configuration: Please see the View widgets section for a description of interface elements common to all View widgets.
    • Import/Export/Bulk Select Options: Turns on import/export/bulk select functionality in Calendar View. Please see "Import/Export and Bulk Select" for more details.
    • Capture current widget settings and lock: This option locks the current column widths so that they aren't draggable by other users.
    • Rows To Display: This is the number of rows that will display. By default, MediaBeacon will display as many rows as possible in the browser window.
    • Width: This sets a fixed width for the widget in pixels.
    • Preview Size: This controls the height of the rows and asset thumbnails.
  • Was this article helpful?