IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
SQL Tree: Custom Tagging Question(s)
JohnBuckWLD
post Feb 6 2014, 00:13
Post #1





Group: Members
Posts: 2
Joined: 5-February 14
Member No.: 114348



Trial and error is a fine principle for creative endeavors, but I figure if someone’s already gone through the motions of mastering a certain skill, why not limit the number face-palms and use the benefit of their experience…
Details:
Foobar2000 v1.3.1
+/- 75,000 ripped flac files

User experience: Trying to learn, presently in the gray area between very limited & totally ignorant. I've googled a lot of questions that have since been answered in this forum, and figured the questions here are probably a lot longer than the correct answers.

Issue: There are about 75 custom Vorbis comments [tag fields] I need to add to my audio files. Several questions have surfaced.

1. With the "Default preset" option in Display -> Columns UI, do those 75 custom tags have to be added 7 different times, over and over again, in the following (Preference) places?
  • Display -> Default User Interface -> Playlist View: Custom Columns
  • SQL Tree -> MediaLibrary table (to enable custom views)
  • SQL Tree -> Playlist table (to enable custom groups & columns)
  • Properties -> Tools -> Add New Field -> FIELDNAME [OK] (to enable entry of tag data in the properties dialog window)
  • Tools -> Tagging -> Quick tagger (to enable entry of tag metadata via properties/tagging)
  • Tools -> Text Tools -> Quick Copy Commands (to enable tag field export to csv files)
  • Display -> Columns UI -> Playlist view / [Columns] tab
[*] I’ve entered the 75 desired %tags% manually into those first 2 places, noticing whatever custom tags were established did not carry over to the other places listed above. Is there a less time intensive way of copying the fields from one place to the other?

2. What is the difference between a TFExpression (text) and Tag (text) in the SQL Tree's MediaLibrary and Playlist table? Should custom tags be set up as a TFExpression with the expression set up as [%tag field name%] – or set up as a tag? (Assumed the former).

3. Once those tags fields are established, is there a way to sort the Metadata field names into a more logical order - or should careful consideration be made into which order I "add new fields..."

4. Why are custom tag field names written in UPPERCASE? I assumed it was to make them stand out from Foobar2000's pre-configured fields, but "Comments" is in normal case and that tag that is not listed in their Metadata fields list was I assume was created/established by freedb.



Thanks in advance


This post has been edited by JohnBuckWLD: Feb 6 2014, 00:14
Go to the top of the page
+Quote Post
fbuser
post Feb 6 2014, 21:57
Post #2





Group: Developer
Posts: 673
Joined: 26-September 07
Member No.: 47369



First of all, these questions are posted in the wrong forum as there are related to SQL Tree, which is a 3rd party component.

QUOTE
Trial and error is a fine principle for creative endeavors
There is a help file available for SQL Tree via the context menu.

1. You don't need to add any custom tag manually as TFExpression. They should be added as Tag and this can be done in one run by clicking on "Add defaults". Besides this there is no relation between the columns you define for the ColumnsUI playlist view and the fields you define for SQL Tree.
2. The MediaLibrary table queries the media library, while the Playlist table queries all playlists. The content of the playlist is not necessarily completely included in the media library.
3. No, but I don't see any need to sort them in a logical order.
4. The fields you define for SQL Tree are case insensitive and they are only used for building queries. Choosing reasonable column labels for the queries will result in not exposing them to the UI.
Go to the top of the page
+Quote Post
JohnBuckWLD
post Feb 7 2014, 02:46
Post #3





Group: Members
Posts: 2
Joined: 5-February 14
Member No.: 114348



QUOTE (fbuser @ Feb 6 2014, 21:57) *
First of all, these questions are posted in the wrong forum as there are related to SQL Tree, which is a 3rd party component.
Sorry, I didn't realize SQLite tree is an independent component.
QUOTE (fbuser @ Feb 6 2014, 21:57) *
1. You don't need to add any custom tag manually as TFExpression. They should be added as Tag and this can be done in one run by clicking on "Add defaults". Besides this there is no relation between the columns you define for the ColumnsUI playlist view and the fields you define for SQL Tree.
That's quite a relief, thanks!
QUOTE (fbuser @ Feb 6 2014, 21:57) *
2. The MediaLibrary table queries the media library, while the Playlist table queries all playlists. The content of the playlist is not necessarily completely included in the media library.
That too makes sense, thanks.
QUOTE (fbuser @ Feb 6 2014, 21:57) *
3. No, but I don't see any need to sort them in a logical order.
4. The fields you define for SQL Tree are case insensitive and they are only used for building queries. Choosing reasonable column labels for the queries will result in not exposing them to the UI.
Thanks. I belatedly found & used BenB's instructions in a similar General Forum thread

Thanks for your considerate and clear reply.
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 25th April 2014 - 04:13