Exporting to Excel spreadsheets

[Scorpius]

1. Yes
2. Yes
3. Yes
4. Yes
5. Yes
6. Yes, I deleted that part as I wasn't sure if that was to be kept or not ( $filename(csv,utf-16) ?)
7. Yes
8. Yes
9. Yes
10. Yes
11. Yes,
12. No. it did not come out the way previous attempts where made

[ohrenkino]

@Scorpius

No. it did not come out the way previous attempts where made

which leads me to the alternative to "yes":

@ohrenkino

... need a description what happened instead:

[Scorpius]

please advise as to what line of scripting that needs to be eliminated and kept.

I had to reinstall the program

Thank you

[ohrenkino]

If you start from scratch then I would think that you first follow the absolute basic list of tasks as described here:

Exporting to Excel spreadsheets

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: Have you selected the files for which you want to get the export? Have you pressed Ctrl+E? Did the list of export scripts open? Did you select the script with …

Independent from that:
you tend not to answer the feedback.
E.g.
I am missing an answer to

@ohrenkino

As the export to excel seems to be so many problematic - what do you want to do with the exported data in Excel?

And how do you know that the length is not right?

[Scorpius]

Yes, I am at the point of editing

[Scorpius]

I was told that the length is in seconds

[ohrenkino]

... and the idea was then to use a different variable, right?

@ohrenkino

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%.

[Scorpius]

yes, I was given this path to hopefully export everything required

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

[ohrenkino]

That did not replace only the part starting with "$loop()" right?
Please open the export script for editing.
Select all the text in the script
Delete the whole text from the script
Copy the following code

$filename(csv,txt)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()

and paste it to the empty export script window.
Save the export script.
Close the editor
Execute the script
Check the resulting CSV file in Excel.

[Scorpius]

[ohrenkino]

No.

@ohrenkino

Select all the text in the script
Delete the whole text from the script
Copy the following code

and all the other bits in that post.
Please!
I am close to giving up on this.

[Scorpius]

SUCCESS!!!!!!!!!!!!!!!! Thank you!!!!!!!

[ohrenkino]

Great.
So now you have the data in Excel.
And what next?

[Scorpius]

That's it. I can go about how I want to set up my library and DJ list

Thank you for your patience, it's truly appreciated

[ohrenkino]

@Scorpius

set up my library and DJ list

Still, out of interest: in what respect does Excel help you?
Finding particular tracks -> filter in MP3tag
Renumbering tracks to keep a certain order -> track numbering wizard in MP3tag
Playing the track to find out which version should be taken -> double-click in MP3tag
Assigning a new genre -> edit file in MP3tag.
Putting files together for a playlist -> Generate playlist in MP3tag (file menu)

So where does Excel come in handy?

[Scorpius]

I will be doing a master play list for each genre of music for each of the song I play so I have a record if one song is played more than another

[ohrenkino]

If you want to sort that list by GENRE, wouldn't it then be better to have an export script that already sorts the files by genre?

Doesn't you DJ player add a play-counter to the files?
And even if it does not: the field POPULARIMETER has a parameter to add a play-counter. And that could easily be editted in MP3tag and be used as a filter criterion to find the popular files.