Greets:
I am just resuming a long-time radio show I’ve done, but in podcast form.
My request is for better handling and/or more options for playlist generation. For the “better handling” side of things, when I used the option to save the playlist as a CSV file, when I opened up the file in Excel, it looked terrible. Songs and artists looked jumbled and ended up being where the artist list took up five additional role on the sheet, but the titles were shifted upward. And that’s just one example. It’s a mess.
So here comes the other option, the need for more options such as saving it as a text file (with and/or without a tab delimited option) and an html file. For those of us who need to make playlists and post them on our web sites and/or include them on social media, in playlist metadata for the audio file, etc., this would all be a really significant time saver.
As it is now, I have to type the playlists manually, quick may be quicker and neater than the current options in DJay Pro, but a bit of a hamper from a time management perspective.
As more people are doing mixes and livestreams, I can’t be the only one who’d find these desired options extremely useful.
I do not see the CSV options in the Data tab area. There is an “Import”
option in the File menu, which gives me CSV as one of hte choices. I
followed through the wizard, but in the end it’s still a mess. I exported
from DJay Pro iOS as a CSV, AirDrop to my Mac, opened Excel for Mac, and
tried the Import steps.
I will have to spend time later to sort that out. Again, much appreciated.
Putting the info the two of you shared, I realized that I did miss a few steps. Yes, I did use the “File-•Import” option to choose the CSV, but I somehow missed that it was a wizard with a “Next” button (I have low vision, so I zoom my screen very close). I was given the option to choose to separate by commas, and that’s when the data columns fell into place.
It’s not perfect; for some reason, after 6 songs, there were about a dozen blank rows before the next row with data, but it was overall much improved. I could then delete the columns I do not need, ditch the blank rows, and then I’ll have most of what I need.
Yes, it’s a bit taxing at times that in making a function improved, it becomes a workflow interruptions until one has to relearn the new way.
Okay, so I stumbled on an even better method, if you are using Excel on iOS.
Not sure if Excel already has to be opened, but I saved the original test
CSV file on my iPad. Usig the Files app, opening up the CSV file, it was
able to import the data into Excel properly. Now when I mean “properly,” I
mean that it’s sorted the data into their proper column. No wizard or
import tool needed!
Keep in mind, this is all from Excel on iOS, the latest 2022.
Now, there are some caveats to be aware of:
Excel complains that some characters such as / are not allowed, so you
may need to change the file name before importing.
Those blank rows I mentioned in the previous email are still there.
But otherwise, this is great…a few less steps and much less to think
about. If only it worked this way, in the MacOS version!
