That is no error message but just the confirmation that the export was successful - as opposed to your script where $loop() and $loopend() do not match
I also included a screenshot fo the subsequent, successful import into Excel ...
So I cannot really see any problems over here.
And: updating MP3tag usually does not modify existing export scripts.
I still suggest that you copy the code (and only the code) from post #2 and paste it into your existing export script.
To check: you need a new line in front of the $loop() statement.
Please check also the documentation on how to setup an export script:
I don't understand.
I showed you with screenshots that the suggested code works for me.
As far as I understood the problem that in Excel the column headers are immediately followed by data from the first record instead of the data starting in the line below the column headers.
Is that correct?
I don't under either. all I've asked is the sequence. $filename(csv,utf-16)Title$char(9)Artist$char(9)Album$char(9)Track$char(9)Year$char(9)Length$char(9)Size$char(9)Modified$char(9)Path$char(9)Filename$char(9)Genre$char(9)Comment$char(9)BPM$char(9)Bitrate
$loop(%_filename_ext%)%title%$char(9)%artist%$char(9)%album%$char(9)%track%$char(9)%year%$char(9)%_length%$char(9)%_file_size%$char(9)%_file_mod_date%$char(9)%_folderpath%$char(9)%_filename_ext%$char(9)%genre%$char(9)%comment%$char(9)%bpm%$char(9)%_bitrate%
$loopend()
this was your response 23 days ago
If you want to keep the same order as the one that you have in the filelist then use $loop(1) instead.
If you want to sort by ARTIST; ALBUM and then by TRACK, use $loop(%artist%%album%$num(%track%,2))
I asked you then where do I insert $loop(%artist%%album%$num(%track%,2)) in the sequence above?
if that leads to a better order in the export.
In general: $loop() is the sorting command - the expression in the brackets sets the sort criteria.
In your original script you sorted by %_FILENAME_EXT% and I read
why I wanted to know what the order should be.
If the (sorted) order of the exported tracks should be the same as you see them in the file list, then use $loop(1)
If you want to sort by artist, then by album, then by the track in that album, then use $loop(%artist%%album%$num(%track%,2))
@Scorpius You do know that @ohrenkino is another user of mp3tag like yourself, and not the developer?
I have been updating to the latest beta versions of the program for years myself. I have several export scripts saved and have never had an update break these. So I don't think this is related to this.
I have been working through your request from this thread, and the suggestions already provided here work as expected under both conditions. So either there is more information required from your side that hasn't been made available, or you are not applying these formats for your exports correctly. Either way more will need to be done on your end to isolate the issue and get this particular export working as you would like.
$filename(csv,utf16)Title$char(9)Artist$char(9)Album$char(9)Track$char(9)Year$char(9)Length$char(9)Size$char(9)Modified$char(9)Path$char(9)Filename$char(9)Genre$char(9)Comment$char(9)BPM$char(9)Bitrate$loop(%_filename_ext%)%title%$char(9)%artist%$char(9)%album%$char(9)%track%$char(9)%year%$char(9)%_length%$char(9)%_file_size%$char(9)%_file_mod_date%$char(9)%_folderpath%$char(9)%_filename_ext%$char(9)%genre%$char(9)%comment%$char(9)%bpm%$char(9)%_bitrate%$loopend((%artist%%album%$num(%track%,2)) This is the error message I get after inserting - $loop(%artist%%album%$num(%track%,2))
(which is still there in your script)
but simply added another $loop(), this time
at the end.
And obviously, you did not have a look at the documentation as otherwise you would know by now the syntax for $loopend() which has already been revealed to you also in this thread:
Thirdly, I think that you still have not inserted the paragraph/lin break in front of the $loop() statement.
And as all these are changes that I cannot do for you as you have to adapt your script locally, I cannot help you any further.
And @MotleyG is right: I am just a plain user and participant in this forum, no MP3tag developer. So I learned to write export scripts just like you would have to.
If you cannot adapt the script, then it would be time to think about an alternative to the Excel export.
In some other thread I asked you:
so perhaps a closer look at the other MP3tag functions could avoid the problem with the export script.
@LyricsLover Actually did look the export to excel document. Also, how i choose to organize stuff is solely up to me. The vast majority of tag editors don't do a good good job sorting remixes & white label music. Music that's 20-30years old,
That may well be true but I think we would all like to see an example of such a deficiency in Mp3tag, specifically. I have never felt limited by Mp3tag's sorting capabilities.
@ Doug_Mackie I never said MP3Tag had deficiencies.
"The vast majority of tag editors don't do a good good job sorting remixes & white label music. Music that's 20-30years old,"
Please tell me where I said anything about MP3 Tags in my statement above?
For your information and the community, I did connect MP3Tags to Discogs. Discogs was about to give me information on a song that was totally incorrect.
All I asked 23days ago was the issue of the one line of song showing up on the #1 line in excel. (example provided). I get these drawn out responses which didn't get answered until today by Lyric_lover with a tad of sarcasm. I actually did read the document on excel and closing the loop and so on. Writing code is not for me period. I like the simplicity of the program the convenience of selecting all files and having the program do what I want it do. Also it's not anyones elses concern how I choose to use the program the way it's features are supposed to work.
I was asked if my environment changed, no it hasn't with the exception to windows updates program updates everything was working fine and again I will say the last update on nov 3 is when I was having this new issue.
I inserted the line I was told to change, created this new error message
I would have to suggest that after 23 days of repeatedly asking the same thing, and then copying and pasting in the same (wrong) strings, you might need to consider that you just aren't reading and applying all of the suggested fixes as provided.
Fair enough, but then it is also unreasonable to ask for support from the community here that are volunteering their time and experience to try to help you resolve your problem. Sharing the purpose behind what you are striving for with this export may help get some clarity on the end target results. Often there are other simpler ways at arriving here without jumping through these hoops. And if it is truly necessary, at least perhaps this can lead to developing a more concrete export tool that can assist others later.
If you want to share some additional information so this conversation can continue productively, please do so. Otherwise copying and pasting your same responses are creating an endless loop, and this thread should just get closed off.
You were replying to this very good suggestion from Ohrenkino:
If you believe that Mp3tag does indeed have the capabilities you need, I suggest that you learn to use them. You may not need Excel at all. In that case this whole discussion is moot.
