|
|
|
|
| Welcome, Guest | Home | Search | Login | Register | |
| Author | Alternative to Suftmusic.de (Read 43251 times) | ||||||||||||||||||||||||||||||||||||||||||||||
|
ovalking
128 MB  Posts: 199 
|
Reply #15 on: June 20, 2024, 22:34
>Go to this site: http://rb2rs.freemyip.com/ Nice find MTT. I can confirm Excel 98 will import all 47180 lines just fine. Excel 4 & 5 are limited to 16384 rows. If that's not enough, then you've got more spare time than me! |
||||||||||||||||||||||||||||||||||||||||||||||
|
cballero
|
1024 MB Posts: 1176 System 7, today and forever
Reply #16 on: June 21, 2024, 07:47
|
I'm a tiny bit curious whether other spreadsheet programs have more processing capabilities than Excel? Most of them were all pretty basic and older, but even ClarisWorks has a spreadsheet, and among the older programs I recall Biplane and one from the Mariner product family were part of the initial, older spreadsheet programs I tried out ages ago. Still, Excel was a hard act to follow as far as crunching power; I really wish I was at home to run some quick tests with these large files 
|
MTT
|
256 MB Posts: 394 SSW7 Oldtimer
Reply #17 on: June 24, 2024, 02:04
|
@ovalking: Thanks for the limitation report on Excel 4&5 and yes, Excel from Office 98 is fine and opens the latest radio list from freemyip fully. This limits opening the entire radio list as a spreadsheet, to PPC Macs running Mac OS 7.5.3 and above and using Excel 98. @cballero: I think all spreadsheet program developers were playing catch-up to Excel by the time Excel 4 existed. The one's I've tried don't surpass those Excel versions capabilities. However, I haven't tried that many either. Those I've tried with this radio list; ClarisWorks 4 (choked and crashed), Lotus 1-2-3 (ditto), StarOffice 3.1's "StarCalc". - I earlier thought StarCalc opened this list OK, but I hadn't counted the rows. - It imported only 8000, half that of Excel 5, so I don't recommend this one now, either. With the radio list downloaded from freemyip; On 68k Macs it's best to use BBEdit version 4 or higher. -I just use BBEdit Lite, it's fine for this, and search on a country of interest to locate stations. BBEdit is very fast at opening this entire file as plain text, compared to rendering it as a spreadsheet, and it's easy to track down suitable stations by using its search functions. On PPC Macs and Mac OS 7.5.3+, Excel 98 is the best option for importing this radio list into a spreadsheet, but BBEdit/BBEdit Lite is also fine here, if installing Office/Excel 98 doesn't appeal.
|
cballero
|
1024 MB Posts: 1176 System 7, today and forever
Reply #18 on: June 24, 2024, 03:31
|
Mentally, I was drawing those same conclusions myself  I wonder if Word 5 would also choke on it as well, so I tried it and, success! I searched for 'http:' and easily found several links in different languages and used Word to quickly make a .m3u file of some to play with MPEGDec, so that's another program to add to the list I think, although I'm not sure if the file gets truncated or not.
|
wove
|
1024 MB Posts: 1363
Reply #19 on: June 24, 2024, 14:23
|
Now for a beginning sort of programming project, one could write a HyperTalk script to parse this file, creating cards for country or genre? Then perhaps the resulting stack could launch the player. With the script it then might be doable to download the file from time to time and update the stack.
|
cballero
|
1024 MB Posts: 1176 System 7, today and forever
Reply #20 on: June 25, 2024, 00:03
|
Programming, now that sounds like a really neat idea!  I wonder if FMP 3 or 4 could potentially convert these files into a database as well, to then query and possibly output similar files? 
|
wove
|
1024 MB Posts: 1363
Reply #21 on: June 25, 2024, 04:28
|
This is done working in OS X 10.7. I downloaded the file with Safari, opened the file in Numbers. From Numbers I exported the file to csv. I then opened Bento and selected import from file; selected the csv. I did make a couple minor changes to the "suggested" field labels and it did the import creating a new "RadioStations" database. (This created 47000+ new records, wow!) It is kind of messy looking because I did not design any fancy form to the import. Although I have not used FileMaker, I imagine the process would be very similar. I do not know the limits of Claris/AppleWorks, but I imagine a similar process would work there as well. It would probably be most efficient to just select a subset of the full file to export to csv, then you would be able to "prettify" the fields for the records before you pull in all the records. There are a couple messy areas that could use work. The Genres all show up in one long text field and while it might be nicer to set that up as a different field type with limited choices. The station url field is hot clickable, and depended on the codec, they will just open a Safari browser window and start playing. There is an OpenDoc spreadsheet and it might be interesting to see if that could pull in hot url data, then supported codec station would open right in QuickTime Player.
|
cballero
|
1024 MB Posts: 1176 System 7, today and forever
Reply #22 on: June 25, 2024, 07:06
|
Oh nice! That's right, OS X does indeed work like a charm for things like that! I know FMP 5 works on both PPC Macs running OS 7.6.1 and higher, while FMP 5.5 needs Mac OS 8.1 and 6.0's minimum OS is Mac OS 8.6. All versions should run fine under Mac OS 9, for example, if using SheepShaver.
|
Bolkonskij
|
Administrator 1024 MB  Posts: 2023
Reply #23 on: June 25, 2024, 10:42
|
Excellent discovery! I need to add this to our S7T page and think about how to make this more retro accessible as a database ...
|
MTT
|
256 MB Posts: 394 SSW7 Oldtimer
Reply #24 on: June 25, 2024, 14:20
|
I've looked at different approaches in dealing with this large database list of stations from freemyip.com - In a purely System 7 environment. I got rid of the description column - this was overly large and a waste of time. I changed the order of the columns, so the Country became the first column and the streaming links the second column. This made it very easy to sort and find suitable http links, for System 7 and MpegDec. Excel 98 became my tool of choice for manipulating the list into shape. From Excel 98 I exported a copy of the list back into tab delimited TEXT (for using in 68k Mac and BBEdit Lite and FileMaker Pro 3+). @cballero: your suggestion of using FileMaker Pro is really great! It works fine even with FileMaker Pro version 3.0 in 68k Macintosh - but it did need tweaking with Excel 98 first. With the description column removed and saved back to tab delimited TEXT, FM Pro could then import all 47K records! The absolute genius winner here for me though, remains BBEdit Lite 4 in its unsurpassed speed and the elegance of it's sorting ability. @Bolkonskij: You had asked earlier for a copy of my output. Here's a copy of the latest - it includes the Excel 98 spreadsheet, the tab delimited TEXT file, and my basic FileMaker Pro 3 conversion as a database, for anyone interested.
|
xc68000
|
4 MB Posts: 5 System 7 Newcomer!
Reply #25 on: August 02, 2025, 21:33
|
I've been streaming from somafm.com since the late 90s. If you like electronic mustic, they still have streams for non-ssl traffic 128k and 256k mp3 and aac. Listening to them now on imac g3 with os9 and itunes 2.
|
snes1423
|
256 MB Posts: 458 A Man born of Mechina
Reply #26 on: August 02, 2025, 22:55
|
ProtoWeb has a revival of Shoutcast circa 2000 as part of its proxy ive used it with AMP Radio and WinAMP also http://FinalFantasyStation.com:8000/stream£
|
|
Pages: 1 [2]
|
| ||||||||||||
|
© 2021 System7Today.com. |
