INTERACT FORUM

Windows => Third Party Plug-ins, Programs, and Skins => Topic started by: jmone on September 26, 2015, 07:29:05 pm

Title: MCUtils
Post by: jmone on September 26, 2015, 07:29:05 pm
MCUtils

MCUtils is a powerful suite of scripts for acquiring and manipulating Media Center metadata, and for performing various actions.  These scripts are written in PERL and will run on Windows, OSX, and Unix

Previously, the scripts were available as individual scripts, and were located here:
- amg.pl: an A M G helper and dummy file creator (http://yabb.jriver.com/interact/index.php?topic=84268.0)
- discogs.pl: a Discogs metadata scraper and dummy file creator (http://yabb.jriver.com/interact/index.php?topic=87032.0)
- pscriptor.pl: a general purpose scriptable MC field manipulator + utility (http://yabb.jriver.com/interact/index.php?topic=85990.0)

The scripts have since been repackaged and updated.  While the original threads have been locked, they still contain some useful additional and historic information. The scripts have been updated and are now merged and packaged as a single MCUtils suite.

The MCUtils suite is available for download; see the attached Instructions.pdf.  Contact the author for additional information or help.

Title: Re: MCUtils
Post by: theoctavist on September 27, 2015, 07:37:57 pm
Works great!
Title: Re: MCUtils
Post by: jmone on September 29, 2015, 06:29:19 am
MCUtils AddOn for Windows: GUI Installer/Connector
Last Updated: 15 Aug 2016

This is no longer required.  See MCUtils Install Instructions in the first post


Title: Re: MCUtils
Post by: unfrostedpoptart on October 06, 2015, 08:52:49 pm
MCUtils

MCUtils is a powerful suite of scripts for acquiring and manipulating Media Center metadata, and for performing various actions.


Hi.  

I'm happy to see people helping develop stuff like this but it seems this particular case is confused and backwards.  I wanted this for some BD Audio disks to split tracks but the links point to Windows executables and I'm running MC21 on a Mac (and possibly Linux in the future).  What seems even stranger is that mcutils isn't a Windows program.  As the source site <link removed - see OP for Instructions.pdf>   shows, it's a bunch of PERL scripts that will run on any OS.  So, what does MCUtils_Installer.exe do that downloading the raw MCUtils doesn't do?  Why take scripts that running on any OS and make it only work on Windows?

Thanks for clearing this up.

 David
Title: Re: MCUtils
Post by: jmone on October 06, 2015, 09:20:42 pm
Hi David,
Your right, MCUtils is based on Perl Scripts and hence has cross platform compatibility.  If you are comfortable following the  Instructions.pdf in the OP you are all good to go!  

For these that are not so computer literate I created a small AHK script (Windows Based) that does the initial setup for a first timer.  I'll try to make the OP clearer.

Thanks
Nathan

Edit - Moved my script from the OP to make it more clear.
Title: Re: MCUtils
Post by: theoctavist on October 08, 2015, 04:17:45 am
"windows can not find c/users/natha etc " error message when trying to use the gui/connector

so why is it looking in your PC for the executable? :P
Title: Re: MCUtils
Post by: jmone on October 08, 2015, 04:38:32 am
That's funny!  Let me look (must have hard coded something!)
Title: Re: MCUtils
Post by: jmone on October 08, 2015, 04:57:11 am
Yup!  I've updated the installer in my Post 2.  You will need to Run "Step 4" again and with some luck it should now point to your MCUtils directory not mine!

Thanks for testing (still works for me  ;D )
Nathan
Title: Re: MCUtils
Post by: theoctavist on October 08, 2015, 05:23:43 am
thanks man!
Title: Re: MCUtils
Post by: theoctavist on October 08, 2015, 06:43:48 am
ok... say ive got an album that I want to update via discogs.  do I go to the album, select all the tracks and then via MCUtils (custom command)

type, for example perl discogs.pl --rid 692390 -v   ?

before when i did this (without the connector, just using MrCs package outside of MC ) I could see the terminal displaying all the album data , and then the tags would update right after.  here when I do that, i get a log saying "finished" with the perl version or whatever. 

catch me up?
Title: Re: MCUtils
Post by: theoctavist on October 08, 2015, 07:12:23 am
I think it is a environment variable issue

what do I need to add to the path?   I uninstalled the previous version of strawberry that I had (when i used the connector-less MCUtils).. so are these the same?  just curioous because I didnt know if perl was installed differently or not.   

C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin
Title: Re: MCUtils
Post by: jmone on October 08, 2015, 09:33:35 pm
What my script does is download all the bits into your selected folder.  One of which is the Portable Version of Perl (no install required).  You should see a PERL subdirectory and within that there is a "portableshell.bat" file.  This sets the environment vars when it runs (eg If you run this it will tell you if perl works or display any errors).

Now what I do with the Commands in MC is to run a version of the "portableshell.bat" file but with the MCUtil Cmd tagged to the end.  It also pipes any of the output that you would see to a TXT file and then displays that for you.

So it "should" be the same process as if you ran "potableshell", "cd.." (to move up one dir to the MCUtils root directy), entered "perl discogs.pl --rid 692390 -v"  .  To test can you try this and see if it works as I was having some issues with hung processes if stuff did not cleanly execute.

Thanks
Nathan
Title: Re: MCUtils
Post by: theoctavist on October 09, 2015, 01:16:57 am
----------------------------------------------
 Welcome to Strawberry Perl PDL Edition!
 * URL - http://strawberryperl.com + http://pdl.perl.org
 * to launch perl script run:      perl c:\my\scripts\pdl-test.pl
 * to start PDL console run:       pdl2
 * to update PDL run:              cpanm PDL
 * to install extra module run:    cpanm PDL::Any::Module
          or if previous fails:    ppm PDL::Any::Module
 * or you can use dev tools like:  gcc, g++, gfortran, gmake
 * see README.TXT for more info
----------------------------------------------
Perl executable: C:\Users\trb\Desktop\MCutils\perl\perl\bin\perl.exe
Perl version   : 5.20.3 / MSWin32-x86-multi-thread-64int
PDL version    : 2.013

C:\Users\trb\Desktop\MCutils>perl discogs.pl --rid 387579 -v
Can't locate Date/Calc.pm in @INC (you may need to install the Date::Calc module) (@INC contains: C:/Users/trb/Desktop/MCutils/perl/perl/site/lib C:/Users/trb/Desktop/MCutils/perl/perl/vendor/lib C:/Users/trb/Desktop/MCutils/perl/perl/lib .) at discogs.pl line 17.
BEGIN failed--compilation aborted at discogs.pl line 17 (#1)
    (F) You said to do (or require, or use) a file that couldn't be found.
    Perl looks for the file in all the locations mentioned in @INC, unless
    the file name included the full path to the file.  Perhaps you need
    to set the PERL5LIB or PERL5OPT environment variable to say where the
    extra library is, or maybe the script needs to add the library name
    to @INC.  Or maybe you just misspelled the name of the file.  See
    "require" in perlfunc and lib.

Uncaught exception from user code:
        Can't locate Date/Calc.pm in @INC (you may need to install the Date::Calc module) (@INC contains: C:/Users/trb/Desktop/MCutils/perl/perl/site/lib C:/Users/trb/Desktop/MCutils/perl/perl/vendor/lib C:/Users/trb/Desktop/MCutils/perl/perl/lib .) at discogs.pl line 17.
        BEGIN failed--compilation aborted at discogs.pl line 17.

C:\Users\trb\Desktop\MCutils>
Title: Re: MCUtils
Post by: theoctavist on October 09, 2015, 01:18:50 am
also...when I send to>>mcutils  I get several CMD windows opening in tandem.   weird
Title: Re: MCUtils
Post by: theoctavist on October 09, 2015, 01:27:52 am
got it working, but had to manually install the modules via cpanm PDL install XXX

Title: Re: MCUtils
Post by: jmone on October 09, 2015, 01:41:30 am
Woops - while you were posting I made you one that shows the CMD box of all that is going on (just replace the MCUtils_Plugin.exe with that attached).
Title: Re: MCUtils
Post by: jmone on October 09, 2015, 01:43:12 am
got it working, but had to manually install the modules via cpanm PDL install XXX

I wonder if it was because you already had perl install so when my portable install happened the moduls were installed in the wrong place?  No idea really.

Is it now working however?
Title: Re: MCUtils
Post by: theoctavist on October 09, 2015, 01:43:51 am
thank you! ok, so it worked for a bit, but now when I send to command shell mcutils, nothing happens.  nor with the perl shell.

Title: Re: MCUtils
Post by: jmone on October 09, 2015, 01:45:50 am
Can you try the one I just posted (so you can see if what the processes is doing, in case it is hanging).  You may need to reboot.
Title: Re: MCUtils
Post by: theoctavist on October 09, 2015, 01:46:25 am
I wonder if it was because you already had perl install so when my portable install happened the moduls were installed in the wrong place?  No idea really.

Is it now working however?

working so far! (with the new plugin)
Title: Re: MCUtils
Post by: jmone on October 09, 2015, 01:51:23 am
Mmmm I'm going to have to rethink how the Process get launched.  I can see in Task Mgr I have a few hung "Console Window Hosts"

Thanks for testing!
Title: Re: MCUtils
Post by: theoctavist on October 10, 2015, 02:09:30 am
no problem! it is wonderful. saves so much time.  ill let you know as issues arise

Title: Re: MCUtils
Post by: theoctavist on October 14, 2015, 01:01:27 am
still goin strong baby!
Title: Re: MCUtils
Post by: jmone on October 14, 2015, 01:54:36 am
XLNT!  Do you mind that you see the CMD window (as the issues were me "hidding" it then trying to get all the details to present in a log later)
Title: Re: MCUtils
Post by: theoctavist on October 15, 2015, 06:44:44 pm
not a bit!  it is great as is!
Title: Re: MCUtils
Post by: theoctavist on October 29, 2015, 02:42:10 am
gah. having problems installing mcutils on a different PC

i see this log file open up, but no command window. //


Finished! See the Log below for more info
 
----------------------------------------------
Perl executable: C:\Users\Nancy\Desktop\perl\perl\bin\perl.exe
Perl version   : 5.20.3 / MSWin32-x86-multi-thread-64int
PDL version    : 2.013

 
Title: Re: MCUtils
Post by: jmone on October 29, 2015, 03:33:57 am
Try running it manually from the command prompt:
1) In explorer go to the ....\MCUtils\perl directory and run "portableshell.bat" and see if you get any errors
2) Type "CD.." (to go backup one level to the MCUtils directory)
3) Run a MCUtils command (eg "perl pscriptor.pl -E MakeBDChapters -v -a check" without the quotes) and see what happens
Title: Re: MCUtils
Post by: theoctavist on October 29, 2015, 03:41:08 am
well i figured it out. for some reason the modules werent installed. had to manually install Roman etc via command line

(I thought the installer did it for some reason?)  at any rate, all seems well now
Title: Re: MCUtils
Post by: theoctavist on October 29, 2015, 03:44:37 am
aw cuss! ok it doesnt run from the connector.  i can only run from command line
Title: Re: MCUtils
Post by: theoctavist on October 29, 2015, 03:54:00 am
ok! got it back. I failed to install the *updated* plugin , had to scroll down the page (on this thread) to find it.  (maybe put all the good ones in the OP? for dumb*@ses like me> :) )
Title: Re: MCUtils
Post by: jmone on October 29, 2015, 03:56:08 am
ACK - will update my OP with the updated ver (sorry!)
Title: Re: MCUtils
Post by: theoctavist on November 01, 2015, 01:10:36 am
Got her rolling on 4 different PCs now.  Great, great stuff that.   Has reduced tagging/maintenance time drastically. 
Title: Re: MCUtils
Post by: jmone on November 01, 2015, 01:17:43 am
:)
Title: Re: MCUtils
Post by: Neis on November 16, 2015, 06:39:03 pm
Am i blind or just stupid, where can i download the installer? I only see the mcutil plugin attachment?
Title: Re: MCUtils
Post by: gkenfield on November 16, 2015, 06:42:15 pm
I too scoured the forum, web and dropbox folders and wasn't able to find it.

Was all excited to NOT have to perform the complicated installed replaced by the connector.
Title: Re: MCUtils
Post by: jmone on November 17, 2015, 02:47:16 pm
Sorry - that was my fault.  I put the "plugin" in my second post instead of the "installer" that will download and install all the components (including the plugin).  Should be the right download now.
Thanks
Nathan
Title: Re: MCUtils
Post by: gkenfield on November 17, 2015, 09:15:40 pm
Excellent! That's really slick... thank you for your contribution and I can't wait to test the scripts.
Title: Re: MCUtils
Post by: Al ex on January 04, 2016, 05:30:15 am
MCUtils AddOn for Windows: GUI Installer/Connector
Last Updated: 30 Sep 2015

To simplify the installation and usage within MC, I’ve created a Simple GUI that will:
- Download all the required components
- Configure MCUtils
- Provides a Connector so you can run MCUtil commands from within Media Center
- Note: as this AddOn is a AutoHotKey script it will only run under Windows
...
One thing I've seen if is you enter a dodgy MCUtils (Perl) command you can get a loop that does not end.  If so, in the System Tray right click on the AHK icon and close the app.  It odd things are still happening it is due to hidden cmd processes and it is just easier to reboot.

Hi Jmone,
great work, seems exactly what is needed for users like me.
Unfortunately I cannot finish the installation with the installer, I get stuck with step 2, as I am receiving several error messages (see attached).
Screenshot 1 --> Timelimit reached
Screenshot 2 --> Status of the handle is not according to the requested procedure
Screenshot 3 --> Hanging up while installing PERL - I can only abort...
Title: Re: MCUtils
Post by: jmone on January 04, 2016, 01:29:52 pm
Did it hang on the Download or the Install of the Perl module?
Title: Re: MCUtils
Post by: Al ex on January 04, 2016, 02:17:54 pm
Did it hang on the Download or the Install of the Perl module?

It is during the install of the PERL module.
Title: Re: MCUtils
Post by: jmone on January 04, 2016, 02:31:29 pm
Go to the folder you created for MCUtils and see of you can do the following manually for Step 2 (these are the cmds I send from my script):
1) Install Perl = run portableshell.bat
2) Install the Perl Moduls from a CMD Box by trying in order each of the following
   cpan install Date::Calc
   cpan install Win32::Clipboard
   cpan install XML::LibXML
   cpan install XML::XPath
   cpan install Roman
 
Then from my script you need to Do Step 3 onward

Lets see where the error appears.
Thanks
Nathan
Title: Re: MCUtils
Post by: Al ex on January 04, 2016, 02:48:18 pm
I was trying to download PERL from strawberryperl.com but it seems the URL is not working? Maybe this is the reason as the website is currently down?
Title: Re: MCUtils
Post by: jmone on January 04, 2016, 02:57:28 pm
Could be that.  But you should be able to go through the steps I posted and it will give you a more verbose list of errors.  It sounds like Portable Perl was downloaded, unziped, and probably installed correctly and it is one (or all) of the Perl Moduls that is not being able to be downloaded as part of the cpan install.
Title: Re: MCUtils
Post by: 8139david on February 14, 2016, 03:18:48 am
Thanks for the package! It worked fine for me.

But when trying to use pscriptor.pl, I had error messages.
So I had to do this in succession:
cpan install Win32::Clipboard
cpan install XML::LibXML (or cpan install XML::XPath, I don't remember which was required)
Maybe you could explain something to that effect in your first post or in the installation instructions?
Edit: In fact, one should do ALL this in succession:
Code: [Select]
   cpan Date::Calc
   cpan Win32::Clipboard
   cpan XML::LibXML
   cpan XML::XPath
   cpan Roman
Title: Re: MCUtils
Post by: 8139david on February 14, 2016, 03:50:00 am
Otherwise, I'm trying to use.
I get this error message, I can't figure out why:
Code: [Select]
C:\Scripts>perl pscriptor.pl -E CSVLookup -v -f composer -a "C:\Users\David\Documents\Composers.csv"
Uncaught exception from user code:
        The view is missing the column 'composer', which defines the file grouping
        Stopped at Scriptlets/CSVLookup.pm line 87.
        CSVLookup::do_preprocessing("C:\\Users\\David\\Documents\\Composers.csv", ARRAY(0x2f67d04), ARRAY(0x3094ad4)) called at pscriptor.pl line 197
My csv is as follows:
Code: [Select]
composer compositeur
Bach Bach_xxx

Edit: I just understood why: I need to use a view where selected files are organized by composer. Done, and it works!

NB: Previously, I also had a problem because I hadn't used the proper delimiters when saving the csv file.
This works for me: the comma , as delimiter. And all text surrounded by quotes ".
Title: Re: MCUtils
Post by: 8139david on February 20, 2016, 01:52:08 am
I was tired of having to navigate to the folder where MC Utils and Perl are installed (in my case C:\Scripts) and launching perl through portableperl.bat (which is in C:\Scripts\perl).
So I first created a bat file ScriptsPerl.bat in C:\Scripts, which opens an explorer and launches portableshell.bat:
Code: [Select]
explorer .
C:\Scripts\perl\portableshell.bat
Then I created a shortcut for ScriptsPerl.bat.
This shortcut can be put in any handy place. In my case, I'm using Classic Shell, so with a right click, I just asked to attach the shortcut to Classic Shell.
I'm also using ConEmu to run commands and scripts, instead of the normal Windows shell.
So when clicking on the shortcut, it opens ConEmu in C:\Scripts and launches portableshell.bat in that same place.
I can then do any operation I want with MC Utilities, for instance:
Code: [Select]
perl amg.pl -i composer,styles,featuringThis updates the files selected in JRiver for the fields composer, styles, and featuring.
Title: Re: MCUtils
Post by: stevem87 on February 28, 2016, 01:09:40 pm
Anyone else missing lyrics? They used to work, but they no longer come in. I imagine it has something to do with a change on AllMusic's site. If anyone can fix, please let me know.

Thanks,
Steve
Title: Re: MCUtils
Post by: theoctavist on March 15, 2016, 11:43:21 pm
hey buddy, forgive me if I have asked this, but each time I use the perl command(from within jriver) multiple command windows open instead of just one.  it is annoying! how to fix this?
Title: Re: MCUtils
Post by: SkGe on March 16, 2016, 03:03:53 pm
@stevem87
It seems those lyrics are not anymore in the song. I think they remove lyrics because i checked some old songs who had lyrics in it and now are not anymore there, so i don't think any change can be made on the part of MCutils.
Title: Re: MCUtils
Post by: theoctavist on March 17, 2016, 08:55:08 am
I was tired of having to navigate to the folder where MC Utils and Perl are installed (in my case C:\Scripts) and launching perl through portableperl.bat (which is in C:\Scripts\perl).
So I first created a bat file ScriptsPerl.bat in C:\Scripts, which opens an explorer and launches portableshell.bat:
Code: [Select]
explorer .
C:\Scripts\perl\portableshell.bat
Then I created a shortcut for ScriptsPerl.bat.
This shortcut can be put in any handy place. In my case, I'm using Classic Shell, so with a right click, I just asked to attach the shortcut to Classic Shell.
I'm also using ConEmu to run commands and scripts, instead of the normal Windows shell.
So when clicking on the shortcut, it opens ConEmu in C:\Scripts and launches portableshell.bat in that same place.
I can then do any operation I want with MC Utilities, for instance:
Code: [Select]
perl amg.pl -i composer,styles,featuringThis updates the files selected in JRiver for the fields composer, styles, and featuring.

can you share the script(s)?
Title: Re: MCUtils
Post by: theoctavist on April 01, 2016, 12:15:44 am
hey buddy, forgive me if I have asked this, but each time I use the perl command(from within jriver) multiple command windows open instead of just one.  it is annoying! how to fix this?

jmon e you out there?
Title: Re: MCUtils
Post by: jmone on April 01, 2016, 03:09:22 am
Sorry - I've been away with work.  I'll have a look this weekend.  Can you give me an example of what you are doing so I can replicate?
Thanks
Nathan
Title: Re: MCUtils
Post by: theoctavist on April 06, 2016, 09:24:29 pm
hey buddy, when i highlight/clipboard the tracks and launch a perl shell , instead of one window opening(cmd window), dozens of them open...almost as if a seperate window were opening for each track
Title: Re: MCUtils
Post by: jmone on April 09, 2016, 05:04:40 am
I think I've found the issue.  I had my script suppress multiple windows but it only works while my script is running.  If you had more than a few tracks selected my script was finishing before MC had sent the cmds for each track selected so you would get multiple windows.  I've added a 3 seconds delay in my script that should prevent additional windows opening (unless you have such a long list that 3 seconds is not enough). 

Can you try this version?  In your MCUtils folder replace the MCUtils_Plugin.exe and .ahk with the version attached. 

If it works I'll update the installer to pull down this version.

Thanks
Nathan
Title: Re: MCUtils
Post by: theoctavist on April 12, 2016, 10:24:50 pm
thank you buddy! one thing I did notice as soon as i called the script is that two command windows opened .

the other thing is i got some plebe error i cant figure out but have to fix before i can test the latest version

Uncaught exception from user code:
        get_selected_files_info: MCWS request failed:
        http://127.0.0.1:52199/MCWS/v1/Files/Current?Action=MPL&Activefile=-1&Zone=-1&ZoneType=ID
        401 Authorization Required
        MCUtils::MCWS::get_selected_files_info(MCUtils::MCWS=HASH(0x3493db4)) called at discogs.pl line 233

that is curious. when i try to open the url above I cannot do so, it behaves as if I keep inputting the wrong user/pw (when I am certain of its accuracy as ive just put it in) the only thing I can think of is that i have adblock running on my router(running shibby tomato firmware) (with pixelserv) , that calls a HOSTS file in the adblock.ini .so maybe I need to whitelist the MCWS pop up? if so what is the URL? I guess it might be being blocked. http://prntscr.com/arljm5
Title: Re: MCUtils
Post by: theoctavist on April 26, 2016, 11:56:28 pm
yo @jmone

Title: Re: MCUtils
Post by: jmone on April 28, 2016, 05:44:27 am
I'll have a look on the weekend.... Real Life has been in the way!
Title: Re: MCUtils
Post by: jmone on May 01, 2016, 01:16:16 am
Ok - Have a look in your "....\MCUtils" folder for "config-custom.txt" and open it up.  You should see three lines for MCWS_server, MCWS_username, and MCWS_password.  Do they all contain the "correct" login details?  If not change them and save the file.  See how you then go.

Thanks
Nathan
Title: Re: MCUtils
Post by: astromo on May 01, 2016, 05:02:04 pm
Having a look at this and am absorbing the various advice and guidance. Made it to MrC's dropbox account and found 3 separate READMEs in the MCUtils_stable.zip file.

Using some pdf editing software, I've put the 3 files together and added bookmarks to the various headings in the document, so that the reader can now navigate the compiled document by hot link. Plus, a blank page has been taken out and the headings numbered to some kind of numerical order. I've left the base content alone. For example, 3.10 reads:
Quote
3.10 Usage Instructions for the pscriptor.pl script
The pscriptor script will
XXX
which is what you'll find in the original document (apart from the heading number).
Also, the table of contents in section 3 has been renumbered to be consistent with a compiled, single document.

Don't know if this is so old that it's of no current value but if not, refer the attached for reference / info.
Title: Re: MCUtils
Post by: theoctavist on May 03, 2016, 10:33:28 pm
I'll have a look on the weekend.... Real Life has been in the way!


gah, still happening. and now this error too.   ncaught exception from user code:
        get_selected_files_info: MCWS request failed:
        http://127.0.0.1:52199/MCWS/v1/Files/Current?Action=MPL&Activefile=-1&Zone=-1&ZoneType=ID
        401 Authorization Required
        MCUtils::MCWS::get_selected_files_info(MCUtils::MCWS=HASH(0x339f2ec)) called at discogs.pl line 233
Title: Re: MCUtils
Post by: jmone on May 03, 2016, 10:49:40 pm
Did you see this?
Thanks
Nathan

Ok - Have a look in your "....\MCUtils" folder for "config-custom.txt" and open it up.  You should see three lines for MCWS_server, MCWS_username, and MCWS_password.  Do they all contain the "correct" login details?  If not change them and save the file.  See how you then go.

Thanks
Nathan
Title: Re: MCUtils
Post by: theoctavist on May 13, 2016, 02:39:48 am
yessir, still having issues. is there a log I can post for you or something?>
Title: Re: MCUtils
Post by: jmone on May 13, 2016, 03:29:00 pm
I'm travling for a few weeks so will not be able to look at much till I'm back
Title: Re: MCUtils
Post by: 8139david on June 17, 2016, 03:18:23 pm
MrC has rewritten his utilities and enriched them!

Thus, the new scriptlet MakeCatalog allows one to create an html catalog like the one attached (see also the pic) :)
I created it with this simple command:
perl pscriptor.pl -S MakeCatalog  --caption "[artist] • [album] • [date] • [album artist]" --size medium -V
( And before that, I had selected 18 composers in a view of my classical music in MC: ~limit=18,1,[Composer] )
Title: Re: MCUtils
Post by: HiFiTubes on June 18, 2016, 02:21:43 pm
Why doesn't JRiver offer any interesting Track Info plugins that pull data. The ones included with MC21 were around at MC10 and are frankly, incredibly dated. MCUtils seems overly complex for the basic user.

Too bad there PM Flow Track Info went defunct.
Title: Re: MCUtils
Post by: kanagowa on June 24, 2016, 02:54:51 pm
I am really interessted in implementing my metadata tags of my library semi automaticly.
Therfeore I would like to know where and how I can download your script please ?
Best regards,
Title: Re: MCUtils
Post by: 8139david on June 25, 2016, 02:26:32 pm
MrC is working on a script to get information from TMDB in a very flexible manner.
It works great for movies, but the part for TV series is not yet developed.
As soon as everything is handled fine, an update of the utils will be available.
The attached pic gives an idea of the kind of information that can retrieved.
Title: Re: MCUtils
Post by: 8139david on June 25, 2016, 02:27:55 pm
See also this pic:
Title: Re: MCUtils
Post by: 8139david on June 25, 2016, 02:32:38 pm
I am really interessted in implementing my metadata tags of my library semi automaticly.
Therfeore I would like to know where and how I can download your script please ?
Best regards,
Download the instructions that are given in the first post: http://yabb.jriver.com/interact/index.php?topic=100449.msg696433#msg696433
Title: Re: MCUtils
Post by: 8139david on June 26, 2016, 06:57:23 am
MrC is working on a script to get information from TMDB in a very flexible manner.
It works great for movies, but the part for TV series is not yet developed.
As soon as everything is handled fine, an update of the utils will be available.
The attached pics give an idea of the kind of information that can retrieved.

The script is called tmdb.pl.

Here are the fields that can queried, independently or together, provided the IMDb ID or the TMDB ID is already stored in MC:
# TMDB Fields ----------------  MC Fields
TMDB::   Field: actors          = Actors   (or ActorAsCharacter, depending on the choice)   # list, MC stock field
TMDB::   Field: alttitles        = Alternate Titles      # list
TMDB::   Field: budget         = Budget                # string, MC stock field
TMDB::   Field: credits         = Credits                # list, MC stock field
TMDB::   Field: countries      = Country         # list, MC stock field
TMDB::   Field: daterel         = Date (release)      # date, MC stock field
TMDB::   Field: director        = Director         # list, MC stock field
TMDB::   Field: genre           = Genre            # list, MC stock field
TMDB::   Field: imdbid          = IMDb ID         # string, MC stock field
TMDB::   Field: name           = Name            # string, MC stock field
TMDB::   Field: origlang        = Original Language   # string
TMDB::   Field: origtitle        = Original Title      # string, MC stock field
TMDB::   Field: overview      = Description         # large, MC stock field
TMDB::   Field: popularity    = Popularity         # string, MC stock field
TMDB::   Field: revenue       = Gross Revenue      # string, MC stock field
TMDB::   Field: rid               = TMDB ID                     # string
TMDB::   Field: runtime       = Runtime         # string
TMDB::   Field: spokenlang  = Spoken Languages      # list
TMDB::   Field: tagline         = Tag Line         # string, MC stock field
TMDB::   Field: tmdburl       = TMDB URL                     # string

Covers can be retrieved as well.

TMDB can be queried in any language.
This allows one to get covers and descriptions in any specific language (when they are present in the database).
Title: Re: MCUtils
Post by: 8139david on June 26, 2016, 04:26:58 pm
Moreover, an additional script (RunCommand.pm) allows one to run the tmdb.pl script with Original Language as parameter.
Automatically, then, all films selected in the view in MC get the chosen TMDB/MC fields updated in their original language.
This is very nice for covers and descriptions!
Title: Re: MCUtils
Post by: 8139david on July 06, 2016, 04:33:25 pm
A new version of MCUtils just came out, version 1.04.
It works both for movies and for series  :)
Title: Re: MCUtils
Post by: 8139david on July 06, 2016, 10:40:15 pm
Here are the TMDB fields that can now be queried:
TMDB::   Field: actors          = Actors   (or ActorAsCharacter)    # list, MC stock field
TMDB::   Field: airdate         = Air Date         # string
TMDB::   Field: alttitles       = Alternate Titles      # list
TMDB::   Field: budget          = Budget         # string, MC stock field
TMDB::   Field: countries       = Country         # list, MC stock field
TMDB::   Field: createdby       = Creator         # list
TMDB::   Field: credits         = Credits         # list, MC stock field
TMDB::   Field: daterel         = Date (release)      # date, MC stock field
TMDB::   Field: director        = Director         # list, MC stock field
TMDB::   Field: firstaired      = First Aired         # date
TMDB::   Field: genre           = Genre            # list, MC stock field
TMDB::   Field: gueststars      = Guest Stars         # list
TMDB::   Field: imagefile       = Image File                     # string, MC stock field
TMDB::   Field: imdbid          = IMDb ID         # string, MC stock field
TMDB::   Field: inproduction    = In Production         # integer
TMDB::   Field: keywords        = Keywords         # list, MC stock field
TMDB::   Field: languages       = Language         # list, MC stock field
TMDB::   Field: lastaired       = Last Aired         # date
TMDB::   Field: name            = Name            # string, MC stock field
TMDB::   Field: nepisodes       = nEpisodes         # integer
TMDB::   Field: nseasons        = nSeasons         # integer
TMDB::   Field: networks        = Networks         # list
TMDB::   Field: origincountry   = Origin Country      # string
TMDB::   Field: origlang        = Original Language      # string
TMDB::   Field: origname        = Original Name         # string
TMDB::   Field: origtitle       = Original Title      # string, MC stock field
TMDB::   Field: overview        = Description         # large, MC stock field
TMDB::   Field: popularity      = Popularity         # string, MC stock field
TMDB::   Field: prodcompanies   = Production Companies      # list
TMDB::   Field: revenue         = Gross Revenue         # string, MC stock field
TMDB::   Field: rid             = TMDB ID                     # string
TMDB::   Field: runtime         = Runtime         # string
TMDB::   Field: season_airdate  = Season Air Date      # date
TMDB::   Field: season_name     = Season Name         # string
TMDB::   Field: season_descrip  = Season Description      # large
TMDB::   Field: seasons         = Seasons          # list
TMDB::   Field: series          = Series          # string, MC stock field
TMDB::   Field: series_credits  = Series Credits       # list
TMDB::   Field: series_descrip  = Series Description       # large, MC stock field
TMDB::   Field: series_type     = Series Type         # string
TMDB::   Field: spokenlangs     = Spoken Languages      # list
TMDB::   Field: status          = Status         # string
TMDB::   Field: tagline         = Tag Line         # string, MC stock field
TMDB::   Field: tmdburl         = TMDB URL                     # string
Title: Re: MCUtils
Post by: kanagowa on July 12, 2016, 09:52:29 am
Waouw, cool stuff.
Thanks for your help.
But, my main purpose is to organize my music tag.
Discogs would be a great source to track metadata and tags for music
IMDB/TMDB is a great source for video. I'm not too much in video right nw, I just go to my independant video club and watch DVD/BR on his recommendation :)

I heard that Discogs could be reatched via Foobar. Maybe a half-way solution :
Tag via Foobar, then paly through JIVER, but a bit painfull as process.

Any idea to solve my problem ?
Title: Re: MCUtils
Post by: 8139david on July 12, 2016, 12:05:02 pm
You can use MCUtils to access Discogs
Title: Re: MCUtils
Post by: mjf14 on February 10, 2017, 03:05:48 pm
Hello all,

I was just wondering if others are using this still? I am not able to get the tags written with the discogs data. The debug and verbose output all looks fine but the tags just do not change. I am not running any excludes, etc. Is there anything else I can troubleshoot?

Thanks!
Title: Re: MCUtils
Post by: lepa on February 14, 2017, 10:52:58 am
I'm using these always when importing new albums. Just tried Discogs script and it still works
Title: Re: MCUtils
Post by: pjchappy on February 14, 2017, 05:45:07 pm
I can't get the Win32::Clipboard to install.  Thoughts?

C:\Users\****\Desktop\Strawberry>cpan install Date::Calc
Loading internal null logger. Install Log::Log4perl for logging messages
CPAN: CPAN::SQLite loaded ok (v0.211)
Database was generated on Tue, 14 Feb 2017 20:31:45 GMT

CPAN: Module::CoreList loaded ok (v5.20170114_24)
Date::Calc is up to date (6.4).

C:\Users\****\Desktop\Strawberry>cpan install Win32::Clipboard
Loading internal null logger. Install Log::Log4perl for logging messages
CPAN: CPAN::SQLite loaded ok (v0.211)
Database was generated on Tue, 14 Feb 2017 20:31:45 GMT

Running install for module 'Win32::Clipboard'
CPAN: Digest::SHA loaded ok (v5.96)
CPAN: Compress::Zlib loaded ok (v2.07)
Checksum for C:\Users\****\Desktop\Strawberry\cpan\sources\authors\id\J\JD\JDB\Win32-Clipboard-0.58.tar.gz ok
CPAN: Archive::Tar loaded ok (v2.24)
CPAN: YAML::XS loaded ok (v0.63)
CPAN: CPAN::Meta::Requirements loaded ok (v2.140)
CPAN: Parse::CPAN::Meta loaded ok (v2.150010)
CPAN: CPAN::Meta loaded ok (v2.150010)
Configuring J/JD/JDB/Win32-Clipboard-0.58.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for Win32::Clipboard
Writing MYMETA.yml and MYMETA.json
  JDB/Win32-Clipboard-0.58.tar.gz
  C:\Users\****\Desktop\Strawberry\perl\bin\perl.exe Makefile.PL -- OK
Running make for J/JD/JDB/Win32-Clipboard-0.58.tar.gz
CPAN: Module::CoreList loaded ok (v5.20170114_24)
cp Clipboard.pm blib\lib\Win32\Clipboard.pm
Running Mkbootstrap for Clipboard ()
"C:\Users\****\Desktop\Strawberry\perl\bin\perl.exe" -MExtUtils::Command -e chmod -- 644 "Clipboard.bs"
"C:\Users\****\Desktop\Strawberry\perl\bin\perl.exe" -MExtUtils::Command::MM -e cp_nonempty -- Clipboard.bs blib\arch\auto\Win32\Clipboard\Clipboard.bs 644
"C:\Users\****\Desktop\Strawberry\perl\bin\perl.exe" -IC:\Users\****\Desktop\Strawberry\perl\lib -IC:\Users\****\Desktop\Strawberry\perl\lib "C:\Users\****\Desktop\Strawberry\perl\lib\ExtUtils\xsubpp"  -typemap C:\Users\****\Desktop\Strawberry\perl\lib\ExtUtils\typemap Clipboard.xs >xstmp.c && "C:\Users\****\Desktop\Strawberry\perl\bin\perl.exe" -MExtUtils::Command -e mv -- xstmp.c Clipboard.cpp
gcc -c          -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE -DPERL_TEXTMODE_SCRIPTS -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -s -O2      -DVERSION=\"0.58\"    -DXS_VERSION=\"0.58\"  "-IC:\Users\****\Desktop\Strawberry\perl\lib\CORE"   Clipboard.cpp
"C:\Users\****\Desktop\Strawberry\perl\bin\perl.exe" -MExtUtils::Mksymlists \
     -e "Mksymlists('NAME'=>\"Win32::Clipboard\", 'DLBASE' => 'Clipboard', 'DL_FUNCS' => {  }, 'FUNCLIST' => [], 'IMPORTS' => {  }, 'DL_VARS' => []);"
g++.exe Clipboard.def -o blib\arch\auto\Win32\Clipboard\Clipboard.xs.dll -mdll -s -L"C:\Users\****\Desktop\Strawberry\perl\lib\CORE" -L"C:\Users\****\Desktop\Strawberry\c\lib" Clipboard.o   "C:\Users\****\Desktop\Strawberry\perl\lib\CORE\libperl524.a" -lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdlg32 -ladvapi32 -lshell32 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_32 -lmpr -lwinmm -lversion -lodbc32 -lodbccp32 -lcomctl32 -Wl,--enable-auto-image-base
"C:\Users\****\Desktop\Strawberry\perl\bin\perl.exe" -MExtUtils::Command -e chmod -- 755 blib\arch\auto\Win32\Clipboard\Clipboard.xs.dll
  JDB/Win32-Clipboard-0.58.tar.gz
  C:\Users\****\Desktop\Strawberry\c\bin\dmake.exe -- OK
Running make test
"C:\Users\****\Desktop\Strawberry\perl\bin\perl.exe" -MExtUtils::Command::MM -e cp_nonempty -- Clipboard.bs blib\arch\auto\Win32\Clipboard\Clipboard.bs 644
"C:\Users\****\Desktop\Strawberry\perl\bin\perl.exe" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0, 'blib\lib', 'blib\arch')" t/*.t
t/test.t .. Failed 1/9 subtests

Test Summary Report
-------------------
t/test.t (Wstat: 0 Tests: 9 Failed: 1)
  Failed test:  7
Files=1, Tests=9,  0 wallclock secs ( 0.05 usr +  0.02 sys =  0.06 CPU)
Result: FAIL
Failed 1/1 test programs. 1/9 subtests failed.
dmake.exe:  Error code 255, while making 'test_dynamic'
  JDB/Win32-Clipboard-0.58.tar.gz
  C:\Users\****\Desktop\Strawberry\c\bin\dmake.exe test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
  reports JDB/Win32-Clipboard-0.58.tar.gz
Stopping: 'install' failed for 'Win32::Clipboard'.

C:\Users\****\Desktop\Strawberry>
Title: Re: MCUtils
Post by: lepa on February 15, 2017, 11:45:12 am
Did you install portable version of strawberry?
Title: Re: MCUtils
Post by: timwtheov on March 15, 2017, 12:26:07 am
I'm having the exact same problem as pjchappy: can't seem to get the Win32::Clipboard to install. And: I did install the portable version of Strawberry Perl (I actually did it twice, just to be sure). Here are the messages:


C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable>cd %USERPROFILE%\Desktop\MCUtils

C:\Users\Tim McCoy\Desktop\MCUtils>install_win.bat
Installing required perl modules...
----Installing perl module Win32::Unicode::File
Database was generated on Wed, 15 Mar 2017 05:06:17 GMT

Running install for module 'Win32::Unicode::File'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\X\XA\XAICRON\Win32-Unicode-0.38.tar.gz ok
Configuring X/XA/XAICRON/Win32-Unicode-0.38.tar.gz with Makefile.PL
Writing ppport.h
Checking if your kit is complete...
Looks good
Warning: prerequisite Test::Output 1.01 not found.
Generating a dmake-style Makefile
Writing Makefile for Win32::Unicode
Writing MYMETA.yml and MYMETA.json
  XAICRON/Win32-Unicode-0.38.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for X/XA/XAICRON/Win32-Unicode-0.38.tar.gz
---- Unsatisfied dependencies detected during ----
----     XAICRON/Win32-Unicode-0.38.tar.gz    ----
    Test::Output [build_requires]
Running install for module 'Test::Output'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\B\BD\BDFOY\Test-Output-1.03.tar.gz ok
Configuring B/BD/BDFOY/Test-Output-1.03.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for Test::Output
Writing MYMETA.yml and MYMETA.json
  BDFOY/Test-Output-1.03.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for B/BD/BDFOY/Test-Output-1.03.tar.gz
dmake.exe:  Error: -- Configuration file `C:\Users\ McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\startup\startup.mk' not found
  BDFOY/Test-Output-1.03.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\dmake.exe" -- NOT OK
Stopping: 'install' failed for 'Test::Output'.
----Done install perl module Win32::Unicode::File

----Installing perl module Win32::Unicode::Dir
Database was generated on Wed, 15 Mar 2017 05:06:17 GMT

Running install for module 'Win32::Unicode::Dir'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\X\XA\XAICRON\Win32-Unicode-0.38.tar.gz ok
Configuring X/XA/XAICRON/Win32-Unicode-0.38.tar.gz with Makefile.PL
Writing ppport.h
Checking if your kit is complete...
Looks good
Warning: prerequisite Test::Output 1.01 not found.
Generating a dmake-style Makefile
Writing Makefile for Win32::Unicode
Writing MYMETA.yml and MYMETA.json
  XAICRON/Win32-Unicode-0.38.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for X/XA/XAICRON/Win32-Unicode-0.38.tar.gz
---- Unsatisfied dependencies detected during ----
----     XAICRON/Win32-Unicode-0.38.tar.gz    ----
    Test::Output [build_requires]
Running install for module 'Test::Output'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\B\BD\BDFOY\Test-Output-1.03.tar.gz ok
Configuring B/BD/BDFOY/Test-Output-1.03.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for Test::Output
Writing MYMETA.yml and MYMETA.json
  BDFOY/Test-Output-1.03.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for B/BD/BDFOY/Test-Output-1.03.tar.gz
dmake.exe:  Error: -- Configuration file `C:\Users\ McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\startup\startup.mk' not found
  BDFOY/Test-Output-1.03.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\dmake.exe" -- NOT OK
Stopping: 'install' failed for 'Test::Output'.
----Done install perl module Win32::Unicode::Dir

----Installing perl module Win32::Clipboard
Database was generated on Wed, 15 Mar 2017 05:06:17 GMT

Running install for module 'Win32::Clipboard'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\J\JD\JDB\Win32-Clipboard-0.58.tar.gz ok
Configuring J/JD/JDB/Win32-Clipboard-0.58.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for Win32::Clipboard
Writing MYMETA.yml and MYMETA.json
  JDB/Win32-Clipboard-0.58.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for J/JD/JDB/Win32-Clipboard-0.58.tar.gz
dmake.exe:  Error: -- Configuration file `C:\Users\ McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\startup\startup.mk' not found
  JDB/Win32-Clipboard-0.58.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\dmake.exe" -- NOT OK
Stopping: 'install' failed for 'Win32::Clipboard'.
----Done install perl module Win32::Clipboard

----Installing perl module Roman
Database was generated on Wed, 15 Mar 2017 05:06:17 GMT

Running install for module 'Roman'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\C\CH\CHORNY\Roman-1.24.tar.gz ok
Configuring C/CH/CHORNY/Roman-1.24.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for Roman
Writing MYMETA.yml and MYMETA.json
  CHORNY/Roman-1.24.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for C/CH/CHORNY/Roman-1.24.tar.gz
dmake.exe:  Error: -- Configuration file `C:\Users\ McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\startup\startup.mk' not found
  CHORNY/Roman-1.24.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\dmake.exe" -- NOT OK
Stopping: 'install' failed for 'Roman'.
----Done install perl module Roman

----Installing perl module Bit::Vector
Database was generated on Wed, 15 Mar 2017 05:06:17 GMT

Running install for module 'Bit::Vector'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\S\ST\STBEY\Bit-Vector-7.4.tar.gz ok
Configuring S/ST/STBEY/Bit-Vector-7.4.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for Bit::Vector
Writing MYMETA.yml and MYMETA.json
Writing patchlevel.h for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe (5.024001)
  STBEY/Bit-Vector-7.4.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for S/ST/STBEY/Bit-Vector-7.4.tar.gz
dmake.exe:  Error: -- Configuration file `C:\Users\ McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\startup\startup.mk' not found
  STBEY/Bit-Vector-7.4.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\dmake.exe" -- NOT OK
Stopping: 'install' failed for 'Bit::Vector'.
----Done install perl module Bit::Vector

----Installing perl module Date::Calc
Database was generated on Wed, 15 Mar 2017 05:06:17 GMT

Running install for module 'Date::Calc'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\S\ST\STBEY\Date-Calc-6.4.tar.gz ok
Configuring S/ST/STBEY/Date-Calc-6.4.tar.gz with Makefile.PL

*************************************************************
****** BEWARE: Use "make install UNINST=1" to install! ******
*************************************************************

Checking if your kit is complete...
Looks good
Warning: prerequisite Bit::Vector 7.4 not found.
Generating a dmake-style Makefile
Writing Makefile for Date::Calc
Writing MYMETA.yml and MYMETA.json
  STBEY/Date-Calc-6.4.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for S/ST/STBEY/Date-Calc-6.4.tar.gz
---- Unsatisfied dependencies detected during ----
----        STBEY/Date-Calc-6.4.tar.gz        ----
    Bit::Vector [requires]
    Date::Calc::XS [requires,optional]
Running install for module 'Bit::Vector'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\S\ST\STBEY\Bit-Vector-7.4.tar.gz ok
Configuring S/ST/STBEY/Bit-Vector-7.4.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for Bit::Vector
Writing MYMETA.yml and MYMETA.json
Writing patchlevel.h for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe (5.024001)
  STBEY/Bit-Vector-7.4.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for S/ST/STBEY/Bit-Vector-7.4.tar.gz
dmake.exe:  Error: -- Configuration file `C:\Users\ McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\startup\startup.mk' not found
  STBEY/Bit-Vector-7.4.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\dmake.exe" -- NOT OK
Stopping: 'install' failed for 'Bit::Vector'.
----Done install perl module Date::Calc

Done installing modules.
Title: Re: MCUtils
Post by: timwtheov on March 15, 2017, 10:50:36 am
OK, so just tried reinstalling everything in case I was doing something wrong before: MCUtils (tried all the versions in Dropbox: MCUtils_1_03.zip, the version marked "stable," 1.04), Perl (64 bit portable), redid the Custom-Config file, followed all the directions to the letter, and now I can't even get the "install_Win.bat" file to work properly, as I get a "Stopping: 'install' failed for 'Bit::Vector'" (see below).

Help!

----------------------------------------------
 Welcome to Strawberry Perl Portable Edition!
 * URL - http://www.strawberryperl.com/
 * see README.TXT for more info
----------------------------------------------
Perl executable: C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe
Perl version   : 5.24.1 / MSWin32-x64-multi-thread

C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable>cd %USERPROFILE%\Desktop\MCUtils

C:\Users\Tim McCoy\Desktop\MCUtils>install_win.bat
"installing required perl modules..."
Loading internal null logger. Install Log::Log4perl for logging messages
CPAN: CPAN::SQLite loaded ok (v0.211)
Database was generated on Wed, 15 Mar 2017 15:19:00 GMT

Running install for module 'Win32::Clipboard'
CPAN: Digest::SHA loaded ok (v5.96)
CPAN: Compress::Zlib loaded ok (v2.07)
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\J\JD\JDB\Win32-Clipboard-0.58.tar.gz ok
CPAN: Archive::Tar loaded ok (v2.24)
CPAN: YAML::XS loaded ok (v0.63)
CPAN: CPAN::Meta::Requirements loaded ok (v2.140)
CPAN: Parse::CPAN::Meta loaded ok (v2.150010)
CPAN: CPAN::Meta loaded ok (v2.150010)
Configuring J/JD/JDB/Win32-Clipboard-0.58.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for Win32::Clipboard
Writing MYMETA.yml and MYMETA.json
  JDB/Win32-Clipboard-0.58.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for J/JD/JDB/Win32-Clipboard-0.58.tar.gz
CPAN: Module::CoreList loaded ok (v5.20170114_24)
dmake.exe:  Error: -- Configuration file `C:\Users\ McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\startup\startup.mk' not found
  JDB/Win32-Clipboard-0.58.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\dmake.exe" -- NOT OK
Stopping: 'install' failed for 'Win32::Clipboard'.
Running install for module 'Roman'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\C\CH\CHORNY\Roman-1.24.tar.gz ok
Configuring C/CH/CHORNY/Roman-1.24.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for Roman
Writing MYMETA.yml and MYMETA.json
  CHORNY/Roman-1.24.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for C/CH/CHORNY/Roman-1.24.tar.gz
dmake.exe:  Error: -- Configuration file `C:\Users\ McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\startup\startup.mk' not found
  CHORNY/Roman-1.24.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\dmake.exe" -- NOT OK
Stopping: 'install' failed for 'Roman'.
Running install for module 'Date::Calc'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\S\ST\STBEY\Date-Calc-6.4.tar.gz ok
Configuring S/ST/STBEY/Date-Calc-6.4.tar.gz with Makefile.PL

*************************************************************
****** BEWARE: Use "make install UNINST=1" to install! ******
*************************************************************

Checking if your kit is complete...
Looks good
Warning: prerequisite Bit::Vector 7.4 not found.
Generating a dmake-style Makefile
Writing Makefile for Date::Calc
Writing MYMETA.yml and MYMETA.json
  STBEY/Date-Calc-6.4.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for S/ST/STBEY/Date-Calc-6.4.tar.gz
---- Unsatisfied dependencies detected during ----
----        STBEY/Date-Calc-6.4.tar.gz        ----
    Bit::Vector [requires]
    Date::Calc::XS [requires,optional]
Running install for module 'Bit::Vector'
Checksum for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\cpan\sources\authors\id\S\ST\STBEY\Bit-Vector-7.4.tar.gz ok
Configuring S/ST/STBEY/Bit-Vector-7.4.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for Bit::Vector
Writing MYMETA.yml and MYMETA.json
Writing patchlevel.h for C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe (5.024001)
  STBEY/Bit-Vector-7.4.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\perl\bin\perl.exe" Makefile.PL -- OK
Running make for S/ST/STBEY/Bit-Vector-7.4.tar.gz
dmake.exe:  Error: -- Configuration file `C:\Users\ McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\startup\startup.mk' not found
  STBEY/Bit-Vector-7.4.tar.gz
  "C:\Users\Tim McCoy\Desktop\strawberry-perl-5.24.1.1-64bit-portable\c\bin\dmake.exe" -- NOT OK
Stopping: 'install' failed for 'Bit::Vector'.

C:\Users\Tim McCoy\Desktop\MCUtils>
Title: Re: MCUtils
Post by: timwtheov on March 16, 2017, 10:16:11 am
Figured out the issue I was having: it has to do with unzipping my Perl folder onto my desktop and then having the folder path quoted. Normally this isn't a problem, but since my desktop's name has a space in it (i.e., Users>Tim McCoy>Desktop), the folder had to be put into my C drive, where it was renamed "myperl." Apparently, Perl Makefiles choke on Windows systems when its destination path contains white space or other shell meta-characters. FYI.
Title: Re: MCUtils
Post by: stevem87 on October 14, 2017, 10:42:54 am
Not sure if anyone is still using this or not, but the Composer field is no longer populating from amg. Any ideas?
Title: Re: MCUtils
Post by: Absinthe on August 25, 2019, 09:23:56 pm
Ive delved through the instructions and commentary regarding MCUtils and have muddled through iterations of mistakes and misunderstandings on my part but in the end have finally succeeded in updating most of my audio tags with data with the exception of the AMG and Discogs album ratings.  With the other special fields used by the two sites, I was able to figure the fields that had to be added to the library by parsing the script files (awg.pl / discogs.pl) but this has not helped me with the ratings.  Anyone who can shed some light on what / how to include this data in my tags would be most appreciated as I want to update my theater view accordingly and like having this info in the audio template!
Title: Re: MCUtils
Post by: Moe on August 26, 2019, 11:02:56 am
If I am understanding you correctly, I think I can help. 

You can see all the fields being used in the config files for the respective script.  As an example, for AMG and Discogs look in the \MCUtils\data\config\ folder and find amg+discogs.txt

You'll see two lines

AMG::       Field: rating         = AMG Rating         # integer, raw AMG rating
Discogs::   Field: rating         = Discogs Rating      # float, raw Discogs rating

This tells you that you need to add two fields "AMG Rating" and "Discogs Rating"
Title: Re: MCUtils
Post by: Absinthe on August 26, 2019, 02:36:41 pm
If I am understanding you correctly, I think I can help. 

You can see all the fields being used in the config files for the respective script.  As an example, for AMG and Discogs look in the \MCUtils\data\config\ folder and find amg+discogs.txt

You'll see two lines

AMG::       Field: rating         = AMG Rating         # integer, raw AMG rating
Discogs::   Field: rating         = Discogs Rating      # float, raw Discogs rating

This tells you that you need to add two fields "AMG Rating" and "Discogs Rating"

Huh, then there must be something else amiss as these are the two new library fields I added and neither one populates.  I tried the script with a debug dump to file and its attached below.  It clearly shows an AMG Rating for the particular title to be 8 but this field never shows up in the MC field AMG Rating ? ? ?


Title: Re: MCUtils
Post by: Absinthe on August 26, 2019, 02:45:55 pm
Huh, then there must be something else amiss as these are the two new library fields I added and neither one populates.  I tried the script with a debug dump to file and its attached below.  It clearly shows an AMG Rating for the particular title to be 8 but this field never shows up in the MC field AMG Rating ? ? ?

scratch that!  After some more scratching and playing around, I changed the field to lower case (i.e. "amg rating") and viola, it appears from the mist.  Thanks Moe, your numerous posts, comments and corrections have helped immensely in my endeavors  ;D
Title: Re: MCUtils
Post by: Absinthe on August 26, 2019, 03:05:18 pm
scratch that!  After some more scratching and playing around, I changed the field to lower case (i.e. "amg rating") and viola, it appears from the mist.  Thanks Moe, your numerous posts, comments and corrections have helped immensely in my endeavors  ;D

Well, almost gold, discogs is still not populating but given that when I submitted the tracks for updating via the discogs.pl script, it came back "skipping file with empty Discogs Release ID:"  I finally had to use the --rid option and this time it populated four tracks with titles and albums from another artist.  Checking the actual web page, these song titles were not listed so methinks Discogs is having some issues.  Anyone else having problems with discogs.pl or Discogs in general?
Title: Re: MCUtils
Post by: Absinthe on August 26, 2019, 06:51:20 pm
Well, almost gold, discogs is still not populating but given that when I submitted the tracks for updating via the discogs.pl script, it came back "skipping file with empty Discogs Release ID:"  I finally had to use the --rid option and this time it populated four tracks with titles and albums from another artist.  Checking the actual web page, these song titles were not listed so methinks Discogs is having some issues.  Anyone else having problems with discogs.pl or Discogs in general?

Ok, this issue has been fixed.  It turns out that the amg+discogs.txt (configuration file) excluded the Discogs ratings.  A simple edit to the text file and all is well.  Since I also typically pull the Artist bio I included this option in the AMG call.  Thanks again Moe for pointing my nose at the right file!
Title: Re: MCUtils
Post by: Moe on August 26, 2019, 09:26:27 pm
Glad to hear you got it all working!
Title: Re: MCUtils
Post by: Absinthe on August 29, 2019, 12:58:04 am
OK, last question for the evening.  I can get the discogs.pl script to pull the artist name but not the artistid.  This is needed to pull the discogs artist bio.  Is the artistid field supported and if so, what magic words are needed to get it to populate MC?
Title: Re: MCUtils
Post by: Moe on August 29, 2019, 01:05:54 pm
Absinthe, I sent you a PM.
Title: Re: MCUtils
Post by: Mans on April 04, 2020, 10:26:10 am
Great day to all of you,

In search of scraping Amg and Discogs data as p.e. review and descriptions on albums.
My goal is to update my Album template and showing this data when selecting the album, as within this very popular other post on the forum :-)

I'm trying to setup MCUtils, but after multiple attempts I'm always stuck at this message,
I did also as suggested within this MCUtils post, to manually install the components which was successful
As also i made a shortcut to make sure the MCUtils directory is opened when launching the portableshell batfile.

Anyone has an idea or clue what to correct, replace or change in order to get the scripts running ?
Thanks in advance for your help:

C:\MCUtils>explorer .

C:\MCUtils>C:\MCUtils\Myperl\portableshell
----------------------------------------------
 Welcome to Strawberry Perl Portable Edition!
 * URL - http://www.strawberryperl.com/
 * see README.TXT for more info
----------------------------------------------
Perl executable: C:\MCUtils\Myperl\perl\bin\perl.exe
Perl version   : 5.30.2 / MSWin32-x64-multi-thread

C:\MCUtils>perl amg.pl -i composer,styles,featuring
Can't locate Win32/Unicode/File.pm in @INC (you may need to install the Win32::Unicode::File module) (@INC contains: C:/MCUtils/. C:/MCUtils/lib C:/MCUtils/Myperl/perl/site/lib C:/MCUtils/Myperl/perl/vendor/lib C:/MCUtils/Myperl/perl/lib) at C:/MCUtils/Myperl/perl/lib/if.pm line 15.
BEGIN failed--compilation aborted at C:/MCUtils/./Utils/File.pm line 19.
Compilation failed in require at C:/MCUtils/./Utils/Options.pm line 19.
BEGIN failed--compilation aborted at C:/MCUtils/./Utils/Options.pm line 19.
Compilation failed in require at amg.pl line 22.
BEGIN failed--compilation aborted at amg.pl line 22 (#1)
    (F) You said to do (or require, or use) a file that couldn't be found.
    Perl looks for the file in all the locations mentioned in @INC, unless
    the file name included the full path to the file.  Perhaps you need
    to set the PERL5LIB or PERL5OPT environment variable to say where the
    extra library is, or maybe the script needs to add the library name
    to @INC.  Or maybe you just misspelled the name of the file.  See
    "require" in perlfunc and lib.

Uncaught exception from user code:
        Can't locate Win32/Unicode/File.pm in @INC (you may need to install the Win32::Unicode::File module) (@INC contains: C:/MCUtils/. C:/MCUtils/lib C:/MCUtils/Myperl/perl/site/lib C:/MCUtils/Myperl/perl/vendor/lib C:/MCUtils/Myperl/perl/lib) at C:/MCUtils/Myperl/perl/lib/if.pm line 15.
        BEGIN failed--compilation aborted at C:/MCUtils/./Utils/File.pm line 19.
        Compilation failed in require at C:/MCUtils/./Utils/Options.pm line 19.
        BEGIN failed--compilation aborted at C:/MCUtils/./Utils/Options.pm line 19.
        Compilation failed in require at amg.pl line 22.
        BEGIN failed--compilation aborted at amg.pl line 22.
Title: Re: MCUtils
Post by: lepa on April 04, 2020, 02:13:20 pm
Did you run install_win.bat which will try to download plugins like file.pm?
Title: Re: MCUtils
Post by: Mans on April 04, 2020, 03:51:57 pm
Thanks Iepa,

MrC give me the exact same feedback :-)

Yes i did but MrC also suggested to install a previous and a msi version of Perl and voila this did the trick :-)

Thanks to both of you for your kind reaction.

Now i can continue my 'mission' in order to get these missing data scraped.

Take care !
Title: Re: MCUtils
Post by: Raistlan on May 02, 2020, 02:14:10 am
I have just downloaded The latest MCUtils (2020-03-29-1354) and I have set up a config file at %USERPROFILE%\.mcutils\config.txt with my username and password for MCWS, but it's still complaining about authentication

EDIT: turns out that I had a several year old MCUtils folder that I unzipped the latest over that caused all sorts of problems. Don't mind me... :o
Title: Re: MCUtils
Post by: Marra on June 08, 2021, 05:08:52 am
Thanks Jmone for MCUtils.  I am successfully tagging using amg.pl.  Is it possible to get the small spiel (about 20-30 words) that appears for editor's choices or new release albums in AMG ? Thanks.
Title: Re: MCUtils
Post by: jmone on June 08, 2021, 07:17:49 pm
Hi Marra,  I'm not the Author of MCUtils.  You can find his contact details in the Drop Box folder linked in the OP Instructions for any requsts.  FYI - The latest version is "MCUtils_2021-05-18-1348.zip"
Title: Re: MCUtils
Post by: MrBiff on June 30, 2021, 04:25:49 am
Thanks Jmone for MCUtils.  I am successfully tagging using amg.pl.  Is it possible to get the small spiel (about 20-30 words) that appears for editor's choices or new release albums in AMG ? Thanks.

Hey Marra!  Are you still out there?  I was wondering if you still wanted help getting the bio blurbs?
Title: Re: MCUtils
Post by: Marra on July 01, 2021, 04:38:42 pm
Yes I'm still interested in getting bio blurbs but I am having trouble getting MCUtils running on new computer.  I surprised myself by getting it functional  the first time.  Do you think I can do it again?  Struggling ggrrrr!  How do you copy error messages from command line?  Away for a few days and will follow up shortly.  Thanks for your support.
Title: Re: MCUtils
Post by: Marra on July 11, 2021, 05:42:58 pm
Back on board, looking for help with MCUtils (2021-05-06-1638) amg.pl using strawberry perl portable. How do I copy error messages I'm getting with this new install.. "can't locate....file.pm in @INC".  Right click with mouse not giving option to copy text from the command line. Thanks in advance.
Title: Re: MCUtils
Post by: MrBiff on July 11, 2021, 07:39:46 pm
Check your messages.
Title: Re: MCUtils
Post by: kliclick on July 27, 2021, 09:58:23 pm
Hi, I'm just beginning with MCUtils, which seems to be a very nice work, but have a problem, maybe my English is too bad reading the manual.
I wanted to store in my database the Discogs ID, Master ID if present, Release ID and Artist ID.
In the Discogs ID I wanted to store the Release ID value since you don't always have a Master ID in Discogs database.
I run  the following command : "perl discogs.pl -VV --id r13123919 -T" which correspond to an album without Master ID. The passed id correspond to the Release ID.
The return was something unexpected (see attached image) :
- the returned discogsid is 13123919 (ok, it's the release id as specified)
- discogsmid is m13123919, but this is wrong since a master id does not exist, Discogs pages show only r13123919
- discogsmurl is https://www.discogs.com/release/13123919. This is the Master URL, pointing to a release address (not a master url)
- discogsrid remains blank
For such a case, I expected the master id and master url to remain blank, and the release id and url to be filled.
Using it with an album with both master and release id, no problem, the Release ID is stored as Discogs ID, and all master and release id are filled as expected (at least for me).
Did I something wrong, or does MCUtils supposed to work like this ? Thank you.
Title: Re: MCUtils
Post by: kliclick on June 20, 2022, 08:19:04 pm
Hi, I'm just trying to install the latest version (MCUtils_2022-05-27-1705) using Strawberry Perl and the "install_win.bat" batch file for the modules.
But when I try to make a new config I get errors (see attached image) and the result is an empty config file. Any ideas?
Thanks
Title: Re: MCUtils
Post by: lepa on June 21, 2022, 09:29:29 am
Maybe some bug in code which sets username/passw. You can run it without username and password and then manually add those to minimal config file. There is also a converter for field overwrites you have possible made in the tools folder. Input is your old config file and it prints out changed fields in new format.

I just manually converted my old config in notepad++ by looking syntax from the default config files. If you are using everything as default then I guess all you need is the username/password in the config
Title: Re: MCUtils
Post by: HansVanEijsden on June 21, 2022, 09:33:04 am
By the way, for those on MacOS using MacPorts: if you receive errors with missing modules, I've fixed those errors by running these extra commands (the install_osx_macports.sh script didn't install those in my case):
sudo port -N install p5-path-tiny
sudo port -N install p5-hash-merge
Title: Re: MCUtils
Post by: lepa on June 22, 2022, 01:20:02 pm
Hi Hans, Could you check your inbox here on the forum. When trying to send you a PM it says that your inbox is full.
Title: Re: MCUtils
Post by: HansVanEijsden on June 22, 2022, 01:23:37 pm
Hi Hans, Could you check your inbox here on the forum. When trying to send you a PM it says that your inbox is full.
Thanks, done! I had 5 messages there, didn't know that was the maximum. Deleted 4 of them.
By the way, the MCUtils developer contacted me, very kind and fast. My "issue" will be solved in the next release.  :)
Title: Re: MCUtils
Post by: Outlaw Audio on June 23, 2022, 10:40:24 am
+1
Thats Mr C.  for ya!

Do read the user manual as well.  Lots of good tidbits in there as well
Title: Re: MCUtils
Post by: jvthree on June 25, 2022, 03:36:51 pm
+1 @kliclick same problem with adding new config
set the unm and pwd manually and moving to next step.

jv3
Title: Re: MCUtils
Post by: BryanC on July 24, 2023, 11:25:21 am
Finally getting around to using discogs.pl on Linux to populate some particularly annoying to tag albums from discogs data. Toolbox makes this (sort of) a breeze for Perl and it had no problems with network or https for MCWS. Bravo! Is there a donation link and have you thought of repository-based hosting on Git* or elsewhere so I can stay up-to-date with your development without having to manually check?

A usage question: what's the fastest method of assigning discogs ids to my existing albums from within MCUtils/MC? If I have to do it externally (Musicbrainz, beets, etc.), I figure I might as well just apply the tags externally too and read them back into MC, but where's the fun in that? It would be cool if there was a semi-intelligent dicogs id assignment strategy as part of MCUtils, with user input as needed for edge cases and tag comparisons for overwrite/updates. Am I overlooking something or overthinking this?
Title: Re: MCUtils
Post by: lepa on July 29, 2023, 02:10:42 pm
There is no AI solution yet in the MCUtils  ;D I use MC links to go release pages (MB/Discogs). I have set link query to also to include catalog # so I can get more accurate hit. There is also --search in mcutils which can help. For me as I need specific pressing page that search isn't what i use though. (For movies and series it is a gem)

My workflow is first try Musicbrainz as it may also contain discogs and AM ids (which MCUtils will then fill for you) so I can save some time there.
Title: Re: MCUtils
Post by: lpas on November 17, 2023, 11:13:23 am
I have tried to install mcutils on macOS Sanoma folliowing instructions in the guide (installing Macports, Xcode and command line tools, placing MCUtils folder on Desktop). When I enter " source tools/install_osx_macports.sh" I get - after entering password -:

Error: Port perl5  p5-net-ssleay p5-lwp-protocol-https p5-lwp-useragent-cached p5-mojolicious p5-term-ansicolor p5-file-which p5-text-csv p5-xml-libxml p5-date-calc p5-uri p5-html-encoding p5-json-maybexs p5-json-xs p5-text-unidecode p5-file-slurp p5-ipc-system-simple p5-clone p5-term-readline p5-term-readline-gnu p5-roman p5-path-tiny p5-hash-merge p5-mac-pasteboard p5-future-asyncawait not found
Installation Done

What am I doing wrong?

Title: Re: MCUtils
Post by: atreides on January 27, 2024, 02:29:06 pm
Is there a suggested upgrade procedure?  I got one folder of many versions ago working, but when I try to download the new version and use that one it doesn't even recognize that I have discogs library fields, for example.  Should I copy a new version over the top of an older one? 
Title: Re: MCUtils
Post by: lepa on January 27, 2024, 03:32:14 pm
i'm overwriting older version with newer as config file is located in the user folder. for newest version you probably need to update strawberry perl and then run updater.pl from the tools folder to update to used perl libraries
Title: Re: MCUtils
Post by: atreides on January 27, 2024, 04:24:55 pm
Thanks for your reply.  I don't have an updater.pl file on my system.  I did run the install_win.pl file that is in the Tools folder.

The issue I am having right now, with the latest version is this:

perl discogs.pl -VVV --include discogsid,discogsrid,discogsmid --sequence --id 7260309 -T

gives this error:

Key 'discogsid' is unknown.  The supported keys are:

    album            artistid         artisturl        country          datescraped      formatdesc       identifiers      locrecord        name             rurl             tcredits_nr
    albumartist      artistmemberof   artistvariations credits          discnum          formatsextra     image_files      mcutils_version  notes            series           totaldiscs
    artist           artistmembers    barcode          credits_nr       filekey          genre            label            mediatype        publisher        seriesnum        totaltracks
    artistaliases    artistrealname   catalog          date             filename         heading          locengineer      mid              rating           styles           tracknum
    artistbiography  artistsites      companies        daterel          format           id               locmix           murl             rid              tcredits

If I returned to my old version, the command executes normally.
Title: Re: MCUtils
Post by: lepa on January 27, 2024, 04:52:06 pm
Quote
  Taggers:
  - [Change] The various id and url keys for amg and discogs taggers are no longer prefixed by the
    tagger's name.
So you can lose the discog prefix from the keys
perl discogs.pl -VVV --include id,rid,mid --sequence --id 7260309 -T
Title: Re: MCUtils
Post by: bspachman on February 24, 2024, 04:43:39 pm
Hi all you helpful perl folks!

I've gotten MCUtils up and running and have been able to use pscriptor to fill a lot of values into about 400 files using CSVLookup but have hit a snag.

One of the values in the CSV file is for the [Date] field. The log output from pscriptor seems to show that the value is being sent to MC, but I'm having trouble getting them to appear in MC.

My first run showed no dates in MC (though the pscriptor output in my terminal window said it was sending the proper data). Actually, that's not entirely true. A few of the dates in the CSV are year-only. THOSE dates did show up in MC, but incorrectly--all in the year 1905. Since I only have the year for those files, I'll just fix them manually.

For run #2, I made sure dates were fully padded, with leading zeros for month and day when appropriate (mm/dd/yyyy). This loaded in about 175 of the dates.

Subsequent runs with all files selected and runs with just the missing date files selected in MC did not improve my situation. There are still over 230 files that seem to be acknowledged by pscriptor, but are not showing the data for [Date] in MC.

Any ideas as to what I should try next?

Thanks!
brad
Title: Re: MCUtils
Post by: zybex on February 24, 2024, 05:02:35 pm
The [date] field in its raw format takes a value that is the number of days since Jan 0 1900 (31.12.1899), with the fractional part being the time portion. This is exactly how Excel handles dates internally too - just enter a date in a cell and have Excel then show it as a number, or vice-versa.

So "2023" is actually 15.07.1905. "1970" is also still 1905, 23.05.1905. The entire century falls in 1905.
It is now 45347.001535764, or just after midnight 25.02.2024 CET.
Title: Re: MCUtils
Post by: bspachman on February 24, 2024, 08:37:24 pm
Perfecto!

A little extra munging in my Excel/CSV file and things filled in as expected! Using those raw integer values for the dates was the key.

It is a little strange (in my book) that nearly half of the files worked with my original data (in human-readable form).

Regardless, all dates are present and accounted for, with only about a dozen to enter manually.

Thanks for the pointer!