Melodeon.net Forums

Please login or register.

Login with username, password and session length
Advanced search  

News:

Welcome to the new melodeon.net forum

Pages: [1]   Go Down

Author Topic: ABC Tags to CSV Extractor utility  (Read 1287 times)

0 Members and 1 Guest are viewing this topic.

Michael Eskin

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 547
    • AppCordions
ABC Tags to CSV Extractor utility
« on: February 21, 2025, 08:03:38 PM »

I've written a simple web-based utility that will scan an entire tunebook of ABC tunes, extract all the tags and write them to a CSV file for import into a spreadsheet.

It also includes the ABC filename and a Share URL for the tune in my ABC Transcription Tools as the last two columns.

The columns in the CSV are:

X:,T:,C:,O:,R:,L:,M:,Q:,K:,D:,S:,Z:,N:,r:,Filename,ShareURL

If multiple tags, for example more than one Z: tag, are found in the same tune, their text is concatenated in the tag's CSV column separated by /

The tool is at:

https://michaeleskin.com/tools/abc2csv.html

I hope this is useful to those of you who have been asking about such a utility on the various ABC forums.   

Please spread the word about the utility to anyone who might find this useful.

Demo video:

https://youtu.be/qo_oia9D3yU

« Last Edit: February 25, 2025, 03:17:21 PM by Michael Eskin »
Logged

Michael Eskin

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 547
    • AppCordions
Re: ABC to CSV utility
« Reply #1 on: February 21, 2025, 09:31:47 PM »

I’ve expanded the ABC to CVS tag extraction utility to now support extracting tags from multiple ABC files.

This is a simple web-based utility that will scan one or multiple files of ABC tunes, extract all the common ABC tags and write them to a CSV file for import into a spreadsheet.

You can use this, for example, to extract the tags from all the ABC files in a folder.

It also includes the ABC filename and a Share URL for the tune in my ABC Transcription Tools as the first and last columns.

The columns in the CSV are:

Filename,X:,T:,Subtitles,C:,O:,R:,L:,M:,Q:,K:,D:,S:,Z:,N:,r:,F:,ShareURL

If multiple tags, for example more than one Z: tag, are found in the same tune, their text is concatenated in the tag’s CSV column separated by /

The tool is at:

https://michaeleskin.com/tools/abc2csv.html

I hope this is useful to those of you who have been asking about such a utility on the various ABC forums. 

Please spread the word to those who might be interested.

Demo video:
https://youtu.be/VUcFQOQJo7I
« Last Edit: February 22, 2025, 05:31:06 AM by Michael Eskin »
Logged

Michael Eskin

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 547
    • AppCordions
Re: ABC to CSV utility
« Reply #2 on: February 22, 2025, 01:53:20 PM »

For the ABC Tags to CSV Extractor utility, I've modified the tag order in the CSV, now:

Filename,X:,T:,Subtitles,C:,O:,R:,L:,M:,Q:,K:,D:,S:,Z:,N:,r:,F:,ShareURL

as well as made the Filename and ShareURL columns optional (enabled by default).

The utility is at:

https://michaeleskin.com/tools/abc2csv.html
« Last Edit: February 23, 2025, 12:26:54 AM by Michael Eskin »
Logged

Michael Eskin

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 547
    • AppCordions
Re: ABC to CSV utility
« Reply #3 on: February 22, 2025, 06:29:07 PM »

You can now launch the ABC Tags to CSV File Utility from the

More Tools / Export All Tunes

dialog in the ABC Transcription Tools.

Video shows extracting tags for an entire directory of ABC files, over 113,000 tunes in total.

After launching the utility the first time I suggest saving a bookmark to it in your browser so you don't have always get to it from the ABC Transcription Tools.

Demo video:

https://youtu.be/WJy7c7CZ2wQ

The feature is in version
 
2330_022225_0930
 
or later.
 
The version number is displayed at the bottom left of the “Settings” dialog.
 
If your version starts with a number less than 2330, click the version number to do a manual update of the tool.
Logged

Michael Eskin

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 547
    • AppCordions
Re: ABC to CSV utility
« Reply #4 on: February 24, 2025, 02:59:10 AM »

I've released a new, extremely advanced feature for those who want to work with CSV files created by the ABC Tags to CSV file utility and are  interested in processing the tune collection data using a spreadsheet or other software and want to bring the processed tune collection back into the ABC Transcription Tools.

You may now import CSV files exported either from the tool itself using the

More Tools / Export All / Export all Share URLs as CSV

feature or from the

ABC Tags to CSV Extractor tool available at

https://michaeleskin.com/tools/abc2csv.html

and then edited with external tools like a spreadsheet.

This is primarily for those of you doing working with CSV files of large collections of tunes generated by the ABC Tags to CSV Extractor and want to do data analysis, sorting, or filtering of the tune collection data and then bring the tune collection back into the ABC Transcription Tools for PDF tunebook or tunebook website export.

The CSV import feature is available on desktop browsers in both the standard and "Quick Editor" versions of the tool.

The "Quick Editor" may be the better choice to use if working with many thousands of tunes.

I've tested this in the "Quick Editor" with a CSV collection of over 20,000 tunes and it's extremely fast.

The "Quick Editor" version which only draws one tune at a time is available at:

https://michaeleskin.com/abctools/abctools-quick-editor.html

After importing the CSV data into a spreadsheet or other tool, when exporting back to CSV, you need to make sure the first line CSV table names header is included the in the exported CSV.

This feature is in version

2335_022325_1730

or later of the ABC Transcription Tools.

The version number is displayed at the bottom left of the “Settings” dialog.

If your version starts with a number less than 2335, click the version number to do a manual update of the tool.

Demo video:

https://youtu.be/HEsFXVUvb1M
« Last Edit: February 24, 2025, 03:57:50 AM by Michael Eskin »
Logged

Michael Eskin

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 547
    • AppCordions
Re: ABC Tags to CSV Extractor utility
« Reply #5 on: February 25, 2025, 01:53:31 AM »

To answer a question by Bryan Mitchell on editing CSV files exported from the ABC Tags to CSV Extractor tool, here is a demonstration of:

1) Using the ABC Tags to CSV Extractor tool to create a CSV file from an ABC tunebook of 112 tunes.

2) Importing and editing the CSV in Apple Numbers (could be any other spreadsheet) deleting unwanted columns.

3) Exporting the edited file as a new CSV file from Apple Numbers.

4) Importing the edited CSV file back into the ABC Transcription Tools.

As long as you keep the ShareURL column in the CSV and the required first line header with the comma-delimited column names, you can pretty much do whatever you want to the data. The ShareURL column with a share link for each tune is how the CSV importer reconstructs the tunes for import.


Demo video:

https://youtu.be/NnBtglqGFXg
« Last Edit: February 25, 2025, 03:17:57 PM by Michael Eskin »
Logged

Michael Eskin

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 547
    • AppCordions
Re: ABC Tags to CSV Extractor utility
« Reply #6 on: February 25, 2025, 08:52:56 PM »

So much has happened this week with the ABC Tags to CSV Extractor tool, it was time for a new overview video:

I've released a simple web-based utility that will scan one or multiple files of ABC tunes, extract all the common ABC tags and write them to a CSV file for import into a spreadsheet or other software.

You can use this, for example, to extract the ABC tags from all the ABC files in a folder.

It also optionally includes the ABC filename and a Share URL for the tune in my ABC Transcription Tools as the first and last columns.

You can also optionally have any font, spacing, or *: style ABC annotations found in the each file's ABC file header injected into each of the tunes found in that filed under the tune's X: tag and used for the tag analysis.

The complete set of ABC tag columns in the saved CSV are:

Filename,X:,T:,Subtitles,C:,O:,A:,R:,L:,M:,Q:,K:,D:,S:,Z:,N:,H:,B:,G:,r:,F:,ShareURL

If multiple tags, for example more than one Z: tag, are found in the same tune, their text is concatenated in the tag’s CSV column separated by a space or / depending on the tag.

Once you have the CSV file, you can open it in a spreadsheet program like Apple Numbers, Google Sheets, or Microsoft Excel for additional sorting, filtering, and analysis of all the tunes across the multiple files.

Once you've done your processing of the CSV file in the spreadsheet program, you can export the spreadsheet back out in CSV format and import it into my ABC Transcription Tools.

The tool is at:

https://michaeleskin.com/tools/abc2csv.html

The utility can also be launched from a command on the "Hamburger" menu in the standard and "Quick Editor" versions of the ABC Transcription Tools.

If importing the CSV back into the ABC Transcription Tools, the "Quick Editor" may be the better choice to use if working with many thousands of tunes.

I've tested this in the "Quick Editor" with a CSV collection of over 20,000 tunes and it's extremely fast.

The "Quick Editor" version which only draws one tune at a time is available at:

https://michaeleskin.com/abctools/abctools-quick-editor.html

After importing the CSV data into a spreadsheet or other tool, when exporting back to CSV, you need to make sure the first line CSV table names header is included in the exported CSV.

I hope this is useful to those of you who have been asking about such a utility on the various ABC forums. 

Please spread the word to those who might be interested.

Demo Video:

https://youtu.be/kpTzrV9ApEA
« Last Edit: February 25, 2025, 09:04:03 PM by Michael Eskin »
Logged

Michael Eskin

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 547
    • AppCordions
Re: ABC Tags to CSV Extractor utility
« Reply #7 on: February 26, 2025, 06:45:22 PM »

Updated 26 Feb 2025: The utility is now able to read back the exported (and optionally modified) CSV files and extract the ABC files without having to use the ABC Transcription Tools

I’ve released a simple web-based utility that will scan one or multiple files of ABC tunes, extract all the common ABC tags and write them to a CSV file for import into a spreadsheet or other software.

Additionally, it can read back a CSV file created with the tool after optional editing with an external tool and get back the ABC files.

You can use this, for example, to extract the ABC tags from all the ABC files in a folder, sort or filter the tunes in an external program like a spreadsheet and then save out a CSV file with the sorted/filtered tunes.

It also optionally includes the ABC filename and a Share URL for the tune in my ABC Transcription Tools as the first and last columns.

You can also optionally have any font, spacing, or *: style ABC annotations found in the each file’s ABC file header injected into each of the tunes found in that file under the tune’s X: tag and used for the tag analysis.

The complete set of ABC tag columns in the saved CSV are:

Filename,X:,T:,Subtitles,C:,O:,A:,R:,L:,M:,Q:,K:,D:,S:,Z:,N:,H:,B:,G:,r:,F:,ShareURL

If multiple tags, for example more than one Z: tag, are found in the same tune, their text is concatenated in the tag’s CSV column separated by a space or / depending on the tag.

Once you have the CSV file, you can open it in a spreadsheet program like Apple Numbers, Google Sheets, or Microsoft Excel for additional sorting, filtering, and analysis of all the tunes across the multiple files.

Once you’ve done your processing of the CSV file in the spreadsheet program, you can export the spreadsheet back out in CSV format and import it into the utility or my ABC Transcription Tools.

The tool is at:

https://michaeleskin.com/tools/abc2csv.html

The utility can also be launched from a command on the “Hamburger” menu in the standard and “Quick Editor” versions of the ABC Transcription Tools.

If importing the CSV back into the ABC Transcription Tools, the “Quick Editor” may be the better choice to use if working with many thousands of tunes.

I’ve tested this in the “Quick Editor” with a CSV collection of over 20,000 tunes and it’s extremely fast.

The “Quick Editor” version which only draws one tune at a time is available at:

https://michaeleskin.com/abctools/abctools-quick-editor.html

After importing the CSV data into a spreadsheet or other tool, when exporting back to CSV, you need to make sure the first line CSV table names header is included in the exported CSV.

I hope this is useful to those of you who have been asking about such a utility on the various ABC forums.

Please spread the word to those who might be interested.


Demo video:

https://youtu.be/6ZRZ9_pT9Ac
Logged

Michael Eskin

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 547
    • AppCordions
Re: ABC Tags to CSV Extractor utility
« Reply #8 on: February 26, 2025, 08:34:48 PM »

Demonstration of how to use the ABC Tags to CSV Extractor utility and Apple Numbers (could be another spreadsheet like Microsoft Excel or Google Sheets) to generate a graph of the distribution of tunes by key in an entire tunebook.

The utility is at:
https://michaeleskin.com/tools/abc2csv.html

Demo video
https://youtu.be/yJ8SrnJlWUo
Logged
Pages: [1]   Go Up
 


Melodeon.net - (c) Theo Gibb; Clive Williams 2010. The access and use of this website and forum featuring these terms and conditions constitutes your acceptance of these terms and conditions.
SimplePortal 2.3.5 © 2008-2012, SimplePortal