Welcome Guest

Pages: 1
Import tags from excel or csv
chrisGnPostJuly 16, 2022, 03:29
Newbie
Posts: 17
Registered:
July 16, 2022, 07:20
Normal topicImport tags from excel or csv

Hello,

is it possible to import tags from a excel file or csv file? And if it is possible, what is the best practice for doing it.

Additional question:
The excel/csv file contains several information. I only want to update one tag field with the value from the excel/csv file. Is this possible?

Thank you in advance.

2MR2PostJuly 16, 2022, 08:26
Avatar photo
Administrator
Posts: 2079
Registered:
August 23, 2012, 19:27
Normal topicImport tags from excel or csv

Yate databases are CSV files with a plist sidecar file. It can open and process CSV files which do not have the sidecar. As long as you can export your Excel file as a CSV (UTF8 preferred), Yate can read and process it.

The most important question is how is each row associated with an audio file? Is there a column which contains a full path to the file? A filename? ... or what?

If you send us a copy of the CSV file to support@2manyrobots.com we can have a look at it and put something together so that you can extract a single column. Let us know which column your interested in.

chrisGnPostJuly 17, 2022, 10:56
Newbie
Posts: 17
Registered:
July 16, 2022, 07:20
Normal topicImport tags from excel or csv

Thank you for the answer. Yes, the file path is given and I can produce an csv file.
I also have a track db and album db in place.

What is the best way to import the changes from the csv file?
I could modify the csv file, so only the field with the changes and the field with the file path is contained.

Thank you for further assistance.

2MR2PostJuly 17, 2022, 11:18
Avatar photo
Administrator
Posts: 2079
Registered:
August 23, 2012, 19:27
Normal topicImport tags from excel or csv

There is a built in variant of the Batch Processor which is passed a CSV file of a track database and imports everything. If you modify the CSV file to contain only those fields that you want updated it will do what you want. The database must be a Track database (ie. the File Path must be present).

Simply run Actions>Apply Track Database Metadata Changes

When the wizard starts, drag the CSV file to the target. On the second panel make sure Auto Save Files is enabled.

chrisGnPostJuly 17, 2022, 12:26
Newbie
Posts: 17
Registered:
July 16, 2022, 07:20
Normal topicImport tags from excel or csv

ok, but how will transform this csv to a track database. It is simply another csv generated from another program. The columns are File Path and Grouping.
Question: Is the separator for the columns comma or semicolon.

Thanks!

2MR2PostJuly 17, 2022, 13:09
Avatar photo
Administrator
Posts: 2079
Registered:
August 23, 2012, 19:27
Normal topicImport tags from excel or csv

If you want to make a CSV file produced by a different program into a Track database you have to create the Export set for the database manually.

Yate Track databases always have column headers. If your CSV file does not contain column headers, manually enter a header line at the start of the CSV file. For example: Grouping,"File Path"

Go to Preferences - Export Sets.
In the panel on the left click on the + button to create a new set.
On the displayed menu select Import from Database
Select your CSV file.
Enter a name for the set.
The headers will be imported for each column and the field will be set to OOB (Yate's term for unassigned fields - Out of Bounds)
Click on the grouping row and use the F button to assign a field type. Standard Fields>Grouping
Click on the file path row and use the F button to assign a field type. Special Export Fields>File Path

When done, click on => in the left panel and select Export Sidecar File. Give the file exactly the same filename as the CSV file. Place the file in the same folder as the CSV file. It will have a filename extension of plist.

If you open the CSV file in Yate and right click in the window you will see that the file is now a Track database. (Towards the bottom of the menu).

Note in order for this to work the File Path column must contain complete paths to the file. ie. starts with a /

Yate databases use a comma to separate the fields not semi-colons.

If any required constraints cannot be met we can write you an action to do what you want.

chrisGnPostAugust 23, 2022, 02:05
Newbie
Posts: 17
Registered:
July 16, 2022, 07:20
Normal topicImport tags from excel or csv

I tried your suggested solution and it works well. Thank you!

chrisGnPostAugust 23, 2022, 02:07
Newbie
Posts: 17
Registered:
July 16, 2022, 07:20
Normal topicImport tags from excel or csv

I tried your suggested solution and it works well. Thank you!

Pages: 1
Mingle Forum by Cartpauj | Version: 1.1.0beta | Page loaded in: 0.032 seconds.