Roles needed: Site admin 

Go to the Import & Export page

Setting & Admin > Import & Export

or

Search the menu for "import" or "export"

Select what kind of information you would like to import

In this case, we'll be importing music, so we'll click the import link in the Music row.

Keep in mind, importing music only imports the music library information, and does not include any learning tracks or sheet music. That can be mass uploaded and associated separately using the file attach method.

Review the available field names and upload your csv

Required fields include: Title.  You do not have to worry about the column titles matching exactly. You can manually link up columns in the next step (called mapping fields)

To upload your csv, click "choose file", select a file on your computer, and then click the "proceed to file test" button.

Not sure what a csv is? Click here to read about them.

File test and manage field mapping

You should see at least a few fields mapped on the next page, showing the first ten entires of your csv so that you can verify the site is reading the csv correctly. You MUST have theTitle heading in the mapped fields, or none of your entries will import.

Need to map more fields? Or check fields that were already mapped?

Expand the "Manage mappings from csv to import" heading. You will see a list of the available column titles, with a drop down that lists all of the headings in your csv that have not already been mapped. You can now mix and match the data as appropriate.  When you're finished, click "adjust mappings".  If you wish to reset it to its defaults (what was automatically mapped), then click "reset mappings".

Click the heading "fields that are already mapped" at the bottom of the list to view the fields that have alreayd been mapped.

Continue checking the file test at the bottom of the page until you are satisfied with your import, and then click the "proceed with import button".

Importing rows

Once you click "proceed with import" your file will be imported in batches. If you have a lot of events (upwards of 1000) this may take a few minutes.

Once the upload has completed, you will see a report noting how many rows there were in total, the number of records created, how many were updated, and if there were any errors.

If your import had zero errors, congratulations! You can now navigate back to the music pages to see your new pieces of music!

Did you end up with some errors?

No worries, there should be a file you can download that will let you see the error for each row. The most common errors are missing required fields (noted above in the section "Review the available field names and upload your csv").

You can edit the error file directly, save it, and re-upload only the entries that had errors.

If you choose to upload the entire file again, entries that already exist in the system will be duplicated.

Exporting Music

On the Import & Export page, click the "export" link across from music(over on the right hand side).

This will export all music entries in the system and their library data into a csv file. This will not include any sheet music or learning tracks.