Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Noteworthy]

Each of my flac tracks is tagged with the tag RELEASETIME in the ISO date format of yyyy-mm-ddT00:00:00Z where the 00:00:00 of course is redundant .

While RELEASETIME tag data correctly appears in the Tag Dump, is there any way to map this to the JRiver tag "Date(Release)" in the format dd/mm/year?
Alternatively, I understand that perhaps there is a way to go about it by writing an auto-import rule?

I would be very grateful for some help with this. I am prepared to clear my library and re-import my music collection if that's what it'll take to get the Date(Release) tag populated.

Many thanks

Win 11 MC33

[MGD_King]

Have you tried the "Move/Copy Fields" option? Right-click file(s) --> Library Tools --> Move / Copy Fields. You can select any source field to any target field.

[Noteworthy]

Thanks MGD_King
The thing is, RELEASETIME is in the Vorbis Comment Block of the Tag Dump and does not appear in the source selection of fields.

[JimH]

You may have to add it.  Read the wiki on tagging.

[Noteworthy]

Many thanks Jim.
I was able to create the field ReleaseTime with the data type set to Date.

After testing with a single track through trial and error, I've discovered that in order to obtain the date 01/07/1973 the RELEASETIME tag value to be imported should be 26846.

The RELEASETIME tag embedded in all the tracks in my collection contains the date in the ISO format yyyy-dd-mmT00:00:00Z. Short of going through the laborious process of changing those values to a date number and then updating all the tracks in my collection, is there any workaround to have the ISO format be effectively represented in the format dd/mm/yyyy?

I should still be able to create smart lists based on that date field.

[markf2748]

Here is a very old thread that seems to address your issue of converting an ISO date string into MC's internal date format using function ConvertDate().  From there you can then output in any desired format using FormatDate() :

https://yabb.jriver.com/interact/index.php/topic,71000.msg479640.html#msg479640

See the Wiki on Date and Time Functions.

[zybex]

Here's a 2022 thread started by a user called 'Noteworthy' about this exact same issue:
https://yabb.jriver.com/interact/index.php/topic,134438.0.html

Some other guy named 'Zybex' provided a solution, apparently 

You can find all your old posts on your profile page:
https://yabb.jriver.com/interact/index.php?action=profile;area=showposts;u=319878

[Noteworthy]

Touché zybex and markf2748!

The problem at that time persisted given that RELEASETIME was contained in the Vorbis comments and I gave up the attempt as there were other pressing issues requiring my attention.

In revisiting the issue in 2025, I have now found the solution as explained in my posted response to Jim.

I created a user-defined field Release (Date) and tested it with a date number. Worked like a charm.
The only problem now is to painstakingly populate the user-defined date and import it into MC

[JimH]

You can copy and paste tags, in case that helps.  Ctrl-C and Ctrl-Shift V

[markf2748]

Touché zybex and markf2748!

Just trying to be helpful and stir the pot  .  @zybex is the incomparable master, along with MrC of yore (cited in my reference), and a few others.  You may find @zybex's program Zelda helpful in debugging this stuff.

The only problem now is to painstakingly populate the user-defined date and import it into MC

You can mass populate fields by using the equals sign "=" (no quotes) in the tag window field entry, writing out any functions and source fields you need to the right of "=".
First select a few audio files to test.
Once it works, you can do the same for a massively large selection in one fell swoop.

You can also make your new custom field an expression field (uses calculated data) to do things automatically, which may help as well going forward.

[Noteworthy]

I'm attaching a snippet of the Vorbis Comment Block where you can see RELEASETIME on the 5th Line.
So @markf2758, taking this as an example, how would populate the MC tag Date(Release)?

In my earlier post when I was talking about creating the user-defined field Date (Release) I was referring to the app Mp3Tag that I historically used to tag the flac files.

If your solution means that I won't have to revert to the said app, then that would really be very productive.

Looking forward to your kind assistance.

[markf2748]

Not sure I'm following all your twists and turns, but here is the general idea off the top of my head (untested):

1) Create an MC Custom Field of type String called RELEASETIME (name must identically match the Vorbis Comment field name).  Hopefully, importing your files will result in that human-readable string field getting automatically populated to match your Vorbis Comment value.  If that does not happen, then it could be due to a MC bug, which may get fixed in the next release (as I recall recently reading somewhere wrt MC34).

2) Create another MC Custom Field of type Date, called for example RELEASETIME (MC_DATE), to hold the date in MC's numeric format.

3) Try mass populating 2) in its tag window entry field, as described above (Reply #9), with =ConvertDate([RELEASETIME]).

4) Alternatively, define 2) using this same expression in Options > Library & Folders > Manage Library Fields... > Calculated Data > Expression...

5) Once this works, sprinkle with FormatDate([RELEASETIME (MC_DATE)], ...) to taste, getting exactly the display string you want.  If desired, create another Custom Expression Field of type String to hold your formatted result (its name must not conflict with a built-in MC field).

[Noteworthy]

@markf2748 - Many thanks.
Will try what you've proposed and see where that takes me...

Will let you know result(s) if any.

Meanwhile, wish you all a very pleasant weekend.

[Noteworthy]

@markf2748
Your steps worked! see attached!
I had to use the option of pasting the expression in the tag entry field (=ConvertDate([RELEASETIME])

The other option (appears to me) to have an anomaly:

4) Alternatively, define 2) using this same expression in Options > Library & Folders > Manage Library Fields... > Calculated Data > Expression...

When I try to enter the expression in calculated data, the field type changes immediately to string.

To avoid conflict, I resorted to pasting the expression in the tag entry field.

[markf2748]

I had to use the option of pasting the expression in the tag entry field (=ConvertDate([RELEASETIME])

The other option (appears to me) to have an anomaly:When I try to enter the expression in calculated data, the field type changes immediately to string.

To avoid conflict, I resorted to pasting the expression in the tag entry field.

Well, I expect your next challenge is to make this all happen automatically, without any manual pasting at all.  Should be very easy at this point.

I also see that the expression field result gets converted to a String Field, not a Date field.  But the string actually represents MC's numeric date value, which is perfectly usable as an input to FormatDate().

Attached is a Zelda example for some of my analagous fields, where I only type in the first entry:
 
1) I enter [Date Acquired (string)] manually in the tag window after ripping a CD.
2) The expression field [Date Acquired (raw sortable)] uses ConvertDate([Date Acquired (string)]) to automatically obtain a numeric date value string, "45601" in this example.  I think this should be analogous to your unformated REALTIME (MC_DATE).
3) Line 3 shows the string field used as input to FormatDate(), which could be used to define the Custom Expression field for your desired output.

Steps 2) and 3) probably can be combined into a single custom expression field with your desired output, if desired.

BTW, @zybex helped me with this many moons ago. 

[Noteworthy]

I owe much to you and @zybex.

BTW, I could'nt find the Zelda app in my first (albeit cursory) search.
If you can provide me with a link... Many Thanks!

I hope that someday, I will acquire sufficient expertise to help others, just as you have helped me.

[markf2748]

BTW, I could'nt find the Zelda app in my first (albeit cursory) search.
If you can provide me with a link... Many Thanks!

Version 2.0.5.0:
https://yabb.jriver.com/interact/index.php/topic,125975.msg974435.html#msg974435
On windows, just download zelda.exe using the link in that post and run it.  You can create a shortcut for convenience.

If a security warning popup appears for unrecognized app, select "More Info > Run anyway", at your own risk of course, or scan it first.

Win11 64-bit | MC 34.0.23

[Noteworthy]

Many Thanks!