Scalar 2 User's Guide Main Menu Getting Started Explains account and book creation, and some interface basics. QuickStarts A path of all QuickStart content in this user's guide. Working with Media How to get the most out of your use of media in Scalar. Working with Content Creating and editing content in Scalar. Working with Widgets Working with Structure How to use Scalar's many options for structuring publications. Editorial Workflow How to use features for performing editorial review of content. Visualizations Exploring the contents of a book visually. Lenses An introduction to lenses, a tool for searching and visualizing Scalar content. Advanced Topics Describing Scalar's more advanced features. Third Party Plugins and Platforms

Bulk importing CSV data from spreadsheets using the Transfer tool

3296

Page

resourcerdf:resourcehttps://scalar.usc.edu/works/guide2/bulk-importing-spreadsheets-using-the-transfer-tool
typerdf:typehttp://scalar.usc.edu/2012/01/scalar-ns#Composite
is livescalar:isLive1
custom stylescalar:customStyleol {padding-left:20px;}
was attributed toprov:wasAttributedTohttps://scalar.usc.edu/works/guide2/users/378
createddcterms:created2017-01-10T11:07:35-08:00

Version 9

resourcerdf:resourcehttps://scalar.usc.edu/works/guide2/bulk-importing-spreadsheets-using-the-transfer-tool.9
versionnumberov:versionnumber9
titledcterms:titleBulk importing CSV data from spreadsheets using the Transfer tool
descriptiondcterms:descriptionList of steps for importing spreadsheets into Scalar
contentsioc:contentThe 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:
  1. Create a spreadsheet
  2. The first row should hold the metadata field names. For example: "dcterms:title" "dcterms:description" "art:url" "sioc:content" (see more below)
  3. 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).
  4. Export the spreadsheet as a Comma Separated Values (CSV) text file
  5. 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
  6. Choose your CSV file, the click Continue
  7. 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".
default viewscalar:defaultViewplain
was attributed toprov:wasAttributedTohttps://scalar.usc.edu/works/guide2/users/379
createddcterms:created2024-05-20T13:37:55-07:00
typerdf:typehttp://scalar.usc.edu/2012/01/scalar-ns#Version

Version 8

resourcerdf:resourcehttps://scalar.usc.edu/works/guide2/bulk-importing-spreadsheets-using-the-transfer-tool.8
versionnumberov:versionnumber8
titledcterms:titleBulk importing CSV data from spreadsheets using the Transfer tool
descriptiondcterms:descriptionList of steps for importing spreadsheets into Scalar
contentsioc:contentThe 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:
  1. Create a spreadsheet
  2. The first row should hold the metadata field names. For example: "dcterms:title" "dcterms:description" "art:url" "sioc:content" (see more below)
  3. 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).
  4. Export the spreadsheet as a Comma Separated Values (CSV) text file
  5. 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
  6. Choose your CSV file, the click Continue
  7. 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)".
default viewscalar:defaultViewplain
was attributed toprov:wasAttributedTohttps://scalar.usc.edu/works/guide2/users/379
createddcterms:created2019-07-24T08:57:44-07:00
typerdf:typehttp://scalar.usc.edu/2012/01/scalar-ns#Version

Version 7

resourcerdf:resourcehttps://scalar.usc.edu/works/guide2/bulk-importing-spreadsheets-using-the-transfer-tool.7
versionnumberov:versionnumber7
titledcterms:titleBulk importing spreadsheets using the Transfer tool
descriptiondcterms:descriptionList of steps for importing spreadsheets into Scalar
contentsioc:contentThe 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:
  1. Create a spreadsheet
  2. The first row should hold the metadata field names. For example: "dcterms:title" "dcterms:description" "art:url" "sioc:content" (see more below)
  3. 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).
  4. Export the spreadsheet as a Comma Separated Values (CSV) text file
  5. 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
  6. Choose your CSV file, the click Continue
  7. 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)".
default viewscalar:defaultViewplain
was attributed toprov:wasAttributedTohttps://scalar.usc.edu/works/guide2/users/913
createddcterms:created2017-06-07T14:10:31-07:00
typerdf:typehttp://scalar.usc.edu/2012/01/scalar-ns#Version

Version 6

resourcerdf:resourcehttps://scalar.usc.edu/works/guide2/bulk-importing-spreadsheets-using-the-transfer-tool.6
versionnumberov:versionnumber6
titledcterms:titleBulk importing spreadsheets using the Transfer tool
descriptiondcterms:descriptionList of steps for importing spreadsheets into Scalar
contentsioc:contentThe 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:
  1. Create a spreadsheet
  2. The first row should hold the metadata field names. For example: "dcterms:title" "dcterms:description" "art:url" "sioc:content" (see more below)
  3. 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).
  4. Export the spreadsheet as a Comma Seperated Values (CSV) text file
  5. 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
  6. Choose your CSV file, the click Continue
  7. 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)".
default viewscalar:defaultViewplain
was attributed toprov:wasAttributedTohttps://scalar.usc.edu/works/guide2/users/913
createddcterms:created2017-05-23T16:37:09-07:00
typerdf:typehttp://scalar.usc.edu/2012/01/scalar-ns#Version

Version 5

resourcerdf:resourcehttps://scalar.usc.edu/works/guide2/bulk-importing-spreadsheets-using-the-transfer-tool.5
versionnumberov:versionnumber5
titledcterms:titleBulk importing spreadsheets using the Transfer tool
descriptiondcterms:descriptionList of steps for importing spreadsheets into Scalar
contentsioc:contentThe 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:
  1. Create a spreadsheet
  2. The first row should hold the metadata field names. For example: "dcterms:title" "dcterms:description" "art:url" "sioc:content" (see more below)
  3. 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).
  4. Export the spreadsheet as a Comma Seperated Values (CSV) text file
  5. 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
  6. Choose your CSV file, the click Continue
  7. 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)".
default viewscalar:defaultViewplain
was attributed toprov:wasAttributedTohttps://scalar.usc.edu/works/guide2/users/913
createddcterms:created2017-05-23T16:36:02-07:00
typerdf:typehttp://scalar.usc.edu/2012/01/scalar-ns#Version

Version 4

resourcerdf:resourcehttps://scalar.usc.edu/works/guide2/bulk-importing-spreadsheets-using-the-transfer-tool.4
versionnumberov:versionnumber4
titledcterms:titleBulk importing spreadsheets using the Transfer tool
descriptiondcterms:descriptionList of steps for importing spreadsheets into Scalar
contentsioc:contentThe 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:
  1. Create a spreadsheet
  2. The first row should hold the metadata field names. For example: "dcterms:title" "dcterms:description" "art:url" "sioc:content" (see more below)
  3. 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).
  4. Export the spreadsheet as a Comma Seperated Values (CSV) text file
  5. 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
  6. Choose your CSV file, the click Continue
  7. 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)".
default viewscalar:defaultViewplain
was attributed toprov:wasAttributedTohttps://scalar.usc.edu/works/guide2/users/913
createddcterms:created2017-02-21T13:44:11-08:00
typerdf:typehttp://scalar.usc.edu/2012/01/scalar-ns#Version

Version 3

resourcerdf:resourcehttps://scalar.usc.edu/works/guide2/bulk-importing-spreadsheets-using-the-transfer-tool.3
versionnumberov:versionnumber3
titledcterms:titleBulk importing spreadsheets using the Transfer tool
descriptiondcterms:descriptionList of steps for importing spreadsheets into Scalar
contentsioc:contentThe 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:
  1. Create a spreadsheet
  2. The first row should hold the metadata field names. For example: "dcterms:title" "dcterms:description" "art:url" "sioc:content" (see more below)
  3. 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
  4. Export the spreadsheet as a Comma Seperated Values (CSV) text file
  5. 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
  6. Choose your CSV file, the click Continue
  7. 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)".
default viewscalar:defaultViewplain
was attributed toprov:wasAttributedTohttps://scalar.usc.edu/works/guide2/users/913
createddcterms:created2017-02-21T13:41:02-08:00
typerdf:typehttp://scalar.usc.edu/2012/01/scalar-ns#Version

Version 2

resourcerdf:resourcehttps://scalar.usc.edu/works/guide2/bulk-importing-spreadsheets-using-the-transfer-tool.2
versionnumberov:versionnumber2
titledcterms:titleBulk importing spreadsheets using the Transfer tool
descriptiondcterms:descriptionList of steps for importing spreadsheets into Scalar
contentsioc:contentThe 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:
  1. Create a spreadsheet
  2. The first row should hold the metadata field names. For example: "dcterms:title" "dcterms:description" "art:url" "sioc:content" (see more below)
  3. 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. For media make sure the "art:url" field has a value representing the URL to the media file
  4. Export the spreadsheet as a Comma Seperated Values (CSV) text file
  5. 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
  6. Choose your CSV file, the click Continue
  7. 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)".
default viewscalar:defaultViewplain
was attributed toprov:wasAttributedTohttps://scalar.usc.edu/works/guide2/users/378
createddcterms:created2017-02-02T18:01:15-08:00
typerdf:typehttp://scalar.usc.edu/2012/01/scalar-ns#Version

Version 1

resourcerdf:resourcehttps://scalar.usc.edu/works/guide2/bulk-importing-spreadsheets-using-the-transfer-tool.1
versionnumberov:versionnumber1
titledcterms:titleBulk importing spreadsheets using the Transfer tool
contentsioc:contentThe 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 spreadsheet (e.g., in Google Spreadsheets or Excel), add rows that constitute pages, make each column heading match Scalar's brand of metadata fields, the export a Comma Separated Values (CSV) document for use importing.  Here are the steps in detail:
  1. Create a spreadsheet
  2. The first row should hold the metadata field names. For example: "dcterms:title" "dcterms:description" "art:url" "sioc:content" (see more below)
  3. 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. For media make sure the "art:url" field has a value representing the URL to the media file
  4. Export the spreadsheet as a Comma Seperated Values (CSV) text file
  5. 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
  6. Choose your CSV file, the click Continue
  7. 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" (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)" and "iptc:(field name)".
default viewscalar:defaultViewplain
was attributed toprov:wasAttributedTohttps://scalar.usc.edu/works/guide2/users/378
createddcterms:created2017-01-10T11:17:35-08:00
typerdf:typehttp://scalar.usc.edu/2012/01/scalar-ns#Version
Show all versions View as RDF-XML View as RDF-JSON