Importing Data (tracks, contacts, companies, etc.)

Importing Data (tracks, contacts, companies, etc.)

Magnetracks allows you to import data into the system in bulk using the Import Data feature. Before you get started, there are a few things you need to know:

1. Get Your Data into a CSV File

The data you wish to import must first be in a CSV (comma-separated values) file. This is the most generic and universal standard for getting a lot of text-based information from one system to another.  In CSV, each record occupies one 'row' of a text file, with all the distinct values in that record separated by a comma (or sometimes a tab character). Pretty much any system you use will allow you to export your data as a CSV, including Microsoft Excel.


2. Not ALL Data is Importable

Unfortunately not all data will be importable into Magnetracks from your CSV file. Every system stores data differently, and it's one of those things you'll need to accept. For instance, if you're importing metadata info from SourceAudio, that application may store musical genres as a two digit code rather than as text ("happy"). That data will have no meaning - and may not be mappable - to Magnetracks. 


3. Garbage In, Garbage Out.

You'll save yourself a lot of time and aggravation if you make sure the file you are working with is as "clean" as possible, prior to importing. That means any empty rows should be deleted, any empty values that can be filled in have been, and the formatting of the information all looks consistent. It's much easier to do this cleanup in a spreadsheet program like Excel, than trying to do it one record at a time in Magnetracks.


4. Create Albums and Catalogs First (for metadata import)

When importing tracks, make sure any albums and the catalogs they belong to are created prior to importing. That way, when you begin mapping the fields in Step 2 of the import process, Magnetracks will be able to properly connect each track to the album and catalog they belong to.

Note: If a track's album doesn't yet exist, Magnetracks will create a new albums for that track, but it will set default values that you may not like or want. It's much better to set them up beforehand.

 


    • Related Articles

    • Audio file naming conventions

      Q: Can I set my own file name format for my tracks? A: Magnetracks has a default standard for how audio files are named when you create a track. This is to ensure file names are always unique and to help Magnetracks identify "which is which" when ...
    • How to Set Up Your SearchPortal Site

      When your catalog is ready, enable your SearchPortal app to offer search and self-serve licensing to the public, clients, content creators. Just follow these steps: Visit the SETTINGS area and click on Connected Apps. Enable the SearchPortal app, and ...
    • How does MusicTrend calculate how "on-trend" my catalog is?

      On MusicTrend's Catalog Insights dashboard, you've probably seen the chart that indicates how "on-trend" your catalog is in certain hot or trending genres/categories. It looks like this: This chart gives you a rating of 0-100% in each musical ...
    • How to bulk import your music catalog into Magnetracks

      Magnetracks gives you a straightforward way to get all your audio files and metadata into Magnetracks. This is a three step process that involves first uploading the metadata for your tracks, and secondly uploading all the associated audio files to ...
    • Track Statuses explained

      Here's what is meant by each possible track 'status':      Active/Complete Your track is complete, and it is now available for selection by our clients. The definition of 'complete' is up to you, but typically it indicates that master files have been ...