INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: SACD ISO Extraction from Excel Visual Basic for Application  (Read 3581 times)

F Ribeiro

  • Junior Woodchuck
  • **
  • Posts: 76
  • If it isn't broken don't fix it.
SACD ISO Extraction from Excel Visual Basic for Application
« on: January 26, 2018, 04:06:54 pm »

Hi,

Sometimes you don't have java installed or you can´t install it for diferent reasons, but you want a GUI for SACD ISO file extraction.
This means you can´t use ISO2DSD.
I wrote a GUI in Excel running VBA (once Excel is whidely available).
The code is open for your intire safe.
Feel free to use it and (if you whant and you can) turn the code even better.
See instructions first on the Instructions WorkSheet.
You can use it for files on your PC and you have to have sacd_extract.exe (you can easly download it making shure it's a clean file).
It runs flawlessly in my Portuguese Microsoft Excel, but i think it will run in other language versions.
Remember that you have to accept macros when opening the Excel file for Visual Basic to run.
Sorry about my (bad) English. I'm from Portugal.

FRiver
Logged
JRiver Media Center 25 PC and MAC | PC: Dell Latitude E5250 - Windows 10 Pro | MAC: Mac Mini late 2014 - Mojave | Amp: Classe CAP-2100 | CD Player: Meridian G08.2 | DAC: Naim DAC V1 | Turntable: Linn Axis, Akito tonearm, Adikt MM | Loudspeakers: ProAc Response D28 | Cables: Transparent, Nordost | Server: Synology DS216 Play Raid 1 |

Cryptographer

  • Recent member
  • *
  • Posts: 33
Re: SACD ISO Extraction from Excel Visual Basic for Application
« Reply #1 on: January 28, 2018, 08:59:51 am »

FBrook, there is already a java-free alternative to ISO2DSD.

On SourceForge there is a project sacd_ectract-gui, which is based on C#.net and additionally on mono. This should be usable on any Windows and Linux platform.

That GUI is my personal favorite because of its drag 'n drop feature for the ISO file and the destination directory.

The only drawback is the incomplete decoding of the last block in sacd_extract.exe when the destination format is DSF file. This results in a final crack when listening to a DSF file, because the return to zero level before the playback stops is missing. But this is a general bug in sacd_extract.exe, regardless which GUI you use or not.

Though MC does compensate this bug by appending a very short fade-out, the output file is still non standard conform, and other players, like MPC-CE or foobar2000 let you hear that annoying crack.

So I think about to decode all ISOs once again and hopefully error-free with TRAX (unfortunately only Mac) or AUI Converter 48x44.
Logged

F Ribeiro

  • Junior Woodchuck
  • **
  • Posts: 76
  • If it isn't broken don't fix it.
Re: SACD ISO Extraction from Excel Visual Basic for Application
« Reply #2 on: January 29, 2018, 06:30:46 am »

Hi Cryptographer,

Thank you very much for your complete and very useful information.


Logged
JRiver Media Center 25 PC and MAC | PC: Dell Latitude E5250 - Windows 10 Pro | MAC: Mac Mini late 2014 - Mojave | Amp: Classe CAP-2100 | CD Player: Meridian G08.2 | DAC: Naim DAC V1 | Turntable: Linn Axis, Akito tonearm, Adikt MM | Loudspeakers: ProAc Response D28 | Cables: Transparent, Nordost | Server: Synology DS216 Play Raid 1 |

Spike1000

  • Citizen of the Universe
  • *****
  • Posts: 641
Re: SACD ISO Extraction from Excel Visual Basic for Application
« Reply #3 on: January 29, 2018, 07:39:32 am »

The only drawback is the incomplete decoding of the last block in sacd_extract.exe when the destination format is DSF file. This results in a final crack when listening to a DSF file, because the return to zero level before the playback stops is missing. But this is a general bug in sacd_extract.exe, regardless which GUI you use or not.

I believe that 'popping' bug has long since been fixed. If padding was added/needed by sacd_extract at the end of the very last 'frame' it could cause a 'pop'. A new version  of sacd_extract that addressed the issue was released.

If you're still experiencing the issue make sure you're using the latest version.

Spike

Awesome Donkey

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 7371
  • The color of Spring...
Re: SACD ISO Extraction from Excel Visual Basic for Application
« Reply #4 on: January 29, 2018, 07:49:38 am »

Last time I tried sacd_extact to split a SACD ISO to DSF files (which was the latest up-to-date version) in late 2015, it still had the 'pop' issue. Granted, I haven't checked this in a long time as I have my own setup to get perfect DSF files without the 'pops'.

Basically my current workflow consists of a SACD ISO being extracted/split into 2.0 stereo DFF files using the command-line sacd_extract, then booting into my Mac partition and using the dff2dsf app to convert those DFF files to DSF files (the dff2dsf app actually re-packages the files instead of re-encoding them since DFF and DSF are containers) and using those in my library. Works perfectly, no issues with 'pops' which would be painfully apparently with albums that have songs that are gapless into one another (e.g. Pink Floyd albums).

Now if there was a cross-platform (or a Windows) app to re-package DFF files to DSF files without doing any re-encoding, that'd actually be great, IMO.
Logged
I don't work for JRiver... I help keep the forums safe from Viagra and other sources of sketchy pharmaceuticals.

Windows 11 2023 Update (23H2) 64-bit + Ubuntu 24.04 LTS Noble Numbat 64-bit | Windows 11 2023 Update (23H2) 64-bit (Intel N305 Fanless NUC 16GB RAM/256GB NVMe SSD)
JRiver Media Center 32 (Windows + Linux) | Topping D50s DAC | Edifier R2000DB Bookshelf Speakers

lobo85

  • World Citizen
  • ***
  • Posts: 145
Re: SACD ISO Extraction from Excel Visual Basic for Application
« Reply #5 on: January 30, 2018, 12:19:43 am »

I may be wrong but the 0.38 version of sacd extract is supposed to have fixed the truncated data issue. You can compile it and replace the executable in the iso2dsd folder and everything should work without the large click at the end for most devices. The Loki however in my experience
 [I own one] always clicks at the beginning and end of the sacd track, album, or DSD only playlist. It clicks as it locks on to the DSD signal and clicks as it releases the DSD signal as far as I can tell. The files however are click free on other devices I've had such as an ifi micro DSD DAC.
Logged

Awesome Donkey

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 7371
  • The color of Spring...
Re: SACD ISO Extraction from Excel Visual Basic for Application
« Reply #6 on: January 30, 2018, 03:56:50 am »

The Loki however in my experience [I own one] always clicks at the beginning and end of the sacd track, album, or DSD only playlist. It clicks as it locks on to the DSD signal and clicks as it releases the DSD signal as far as I can tell.

Well, in my case, yes, it clicks when you begin to play DSD and after you're done (and switching back to PCM via the button), but this is to be expected as DACs do this. Otherwise changing DSD tracks doesn't click for me.
Logged
I don't work for JRiver... I help keep the forums safe from Viagra and other sources of sketchy pharmaceuticals.

Windows 11 2023 Update (23H2) 64-bit + Ubuntu 24.04 LTS Noble Numbat 64-bit | Windows 11 2023 Update (23H2) 64-bit (Intel N305 Fanless NUC 16GB RAM/256GB NVMe SSD)
JRiver Media Center 32 (Windows + Linux) | Topping D50s DAC | Edifier R2000DB Bookshelf Speakers
Pages: [1]   Go Up