Scalar 2 User's GuideMain MenuGetting StartedExplains account and book creation, and some interface basics.QuickStartsA path of all QuickStart content in this user's guide.Working with MediaHow to get the most out of your use of media in Scalar.Working with ContentCreating and editing content in Scalar.Working with WidgetsWorking with StructureHow to use Scalar's many options for structuring publications.Editorial WorkflowHow to use features for performing editorial review of content.VisualizationsExploring the contents of a book visually.LensesAn introduction to lenses, a tool for searching and visualizing Scalar content.Advanced TopicsDescribing Scalar's more advanced features.Third Party Plugins and Platforms
Transfer Tool File Upload Tab
12017-01-10T11:21:20-08:00Craig Dietrich2d66800a3e5a1eaee3a9ca2f91f391c8a689349032961Screengrab of the Transfer tool's file upload tabplain2017-01-10T11:21:20-08:00Craig Dietrich2d66800a3e5a1eaee3a9ca2f91f391c8a6893490
This page is referenced by:
12017-01-10T11:07:35-08:00Bulk importing CSV data from spreadsheets using the Transfer tool9List of steps for importing spreadsheets into Scalarplain2024-05-20T13:37:55-07:00The Transfer tool is located in the Dashboard's Import/Export tab. (The tool is a Scalar plugin and might not be present if the administrator of your Scalar install hasn't installed it separately from Scalar itself.) Its primary function is to allow for migration of Scalar books from one place to another, for example, migrating a Scalar book from one Scalar install to another. Though, it can also be used to bulk import pages and media from a spreadsheet.
The steps for importing a spreadsheet are straight forward: create a spreadsheet (e.g., in Google Spreadsheets or Excel), add rows that constitute pages, make each column heading match Scalar's brand of metadata fields, then export a Comma Separated Values (CSV) document for use importing. Here are the steps in detail:
Create a spreadsheet
The first row should hold the metadata field names. For example: "dcterms:title" "dcterms:description" "art:url" "sioc:content" (see more below)
Add rows that constitute pages and media. For pages make sure there is content in the "sioc:content" field that constitutes the text of the page (see our example.csv for uploading pages). For media make sure the "art:url" field has a value representing the URL to the media file (see our example.csv for uploading media).
Export the spreadsheet as a Comma Separated Values (CSV) text file
Head over to the Transfer tool, then click on the "Upload File" tab. The "destination book" fields should already be filled in if you came to the tool via your Scalar book
Choose your CSV file, the click Continue
That's it! You should now have pages and/or media present in your Scalar book.
Any Dublin Core fields can be used as column headings. For example: "dcterms:title" "dcterms:description" "dcterms:source" (dcterms:title is required). In addition, you must have one of: "art:url" or "sioc:content". Scalar supports other ontology prefixes such as: "bibo:(field name)" "iptc:(field name)" "id3:(field name)".
Note that if you include a "scalar:slug" column and populate it with the slugs of existing pages or media, then the importer will update those items with the new data, instead of creating new items. The "slug" is a unique identifier that consists of the last segment of a Scalar URL, usually derived from the item's title. For example, the slug for this page is "bulk-importing-spreadsheets-using-the-transfer-tool".