Exporting to Excel spreadsheets

The line
$loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file_mod_date%;%_folderpath%;%_filename_ext%; $loopend()
determines which fields are sent to the resulting csv file.
Which of the fields do you want to keep and which other fields from the file list are you missing.

The field variable %_length_seconds% may be the one that puzzles you as it writes the length in seconds and not in minutes:seconds.
If you want to get the formatted output, replace %_length_seconds% with %_length%.

I'm going to leave everything as is. I can edit it afterwards
what would be the next step?

You edit the script so that the list of fields contains all the fields that you want to see in the export.
If you are not sure how they are represented in a script then list the names as you think they are called. It would then probably be easy to find the corresponding variable name.
You then save the script and call it from the list of export scripts and open the output as you described in the first post.


this what I have?

And what have you done in the meantime?
The last dump shows 1 entry more in the list of export scripts.
Aren't we talking about an unaltered script called "csv"?

this is a cvs file export without the modifications. As you can see I'm missing genre comment bpm bitrate

Apparently, you do not have any data in TRACK
If you want to see

then add
%genre%;%comment%;%bpm%;%_bitrate%
to the line

so that it becomes
$loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file_mod_date%;%_folderpath%;%_filename_ext%;%genre%;%comment%;%bpm%;%_bitrate% $loopend()

I'm not concerned about the missing data, my only requirements are title artist year length bit rate genre comment bpm

That may be as it is.
Did you adapt the script accordingly so that in now meets your

this is what I get when entering the new sequence

Please show me the actual export script.
The name of the script does not say a lot.
Also, it would help if you told us what you did so far.
The text from the screenshot does not look like it has been generated by a modified sample script with the name "csv" in which only the existing list has been appended by some field variables.

the script is what you sent me

$loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file_mod_date%;%_folderpath%;%_filename_ext%;%genre%;%comment%;%bpm%;%_bitrate% $loopend()

this is all i have from you today. Nothing further

It is a partial script as I said

So, what does the whole script look like?

i sent it to you already. It's #30 of the thread

I do not see the contents of an export script in any of the posts following

What I see is a list of names of export scripts.
You would have to select the script name in the list of export scripts and then click the edit button.
Then you see the contents.
And that contents would be of interest for your problem and would also have to be adapted.
As you do not describe what you do (step by step) it is hard if not impossible from the distance to tell what might have gone wrong.
I cannot look over your shoulder.

would you you be willing to do remote access? to get me where I need to me? I'll be donating to this cause and your time?

As others do not see what would happen during the remote access, yet they could benefit from a decent description of the problem plus eventually a possible solution, I would rather deal with the problem in the public forum.

So, the following questions should preferably be answered with "yes" or need a description what happened instead:

  1. Have you selected the files for which you want to get the export?
  2. Have you pressed Ctrl+E?
  3. Did the list of export scripts open?
  4. Did you select the script with the name "csv"?
  5. Did you click on the "edit" button?
  6. Did a text editor window open that shows a text starting with $filename(csv,utf-16)?
  7. Did you replace the string
    $loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file_mod_date%;%_folderpath%;%_filename_ext%;
    with $loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length%;%_file_size%;%_file_mod_date%;%_folderpath%;%_filename_ext%;%genre%;%comment%;%bpm%;%_bitrate%?
  8. Did you save the modfied export script?
  9. Did you close the text editor?
  10. Did you click OK to execute the script?
  11. Did you check the output in Excel?
  12. Was it OK?