[78-L] Abrams files in EXCEL form

[ron at fial.com.invalid]

Wow, lots of work.  Thanks Iñigo!

I did similar about 20 years ago, purtting the Abrams files in a mysql database.  He sent them 
on a bunch of floppys.   I was building a web site to load pictures of labels and tied them to 
the Abrams database using PHP or Perl code.   But it did not work out, I had a hard disk 
crash and a lot of the work I had done was lost.  It was not getting backed up.

It is a good idea to actually restore from your backups to a new machine to verify that your 
backups are really working.   I bet most of us have been been in this trouble at least once.

Regards,   Ron Fial
_________________________________

On 20 Mar 2022 at 21:49, iñigo wrote:

> 
> Some weeks ago someone (pardon my bad memory) marveled about including all Abrams files in a single practical database in EXCEL spreadsheet. I mentioned I had done it, and here it is, together with all Abrams original TXT files, as per October 2003; in this link you'll get my files, shared for anyone's interest.
> 
> - LABELS & SONGS files: LABELS has the introduction and explanations on the format of the txt files; SONGS is a list of all tune titles with composers.
> - 72 LABEL files total 52.4Mb (each file has the sides sorted by issue number)
> 50 MATRIX files total 39.7 Mb (same information as above ---allegedly--- but sorted by catalog number instead)
> 1 XLS file with 339414 registers (made using all files, I don'r remember if it was the LABEL or the MATRIX series) total 26.5 Mb
> The XLS file has the dates as given by Abrams (mm/dd/yy), but also arranged in an additional field as yyyy.mmdd for ease of sorting by date correctly.
> 
> https://app.box.com/s/0oecnoawed26kz3eafckmyz98u3zlgqs
> 
> The real goal now would be to repeat that using the tables in The Online Discographical Project https://www.78discography.com/, which started from these Abrams files, and those of Settlemier, but may be more updated. Maybe these are directly copiable into EXCEL... 
> 
> Inigo @ Madrid, SPAIN
> _______________________________________________
> 78-L mailing list
> 78-L at klickitat.78online.com
> http://klickitat.78online.com/mailman/listinfo/78-l
>