November 17, 2009
mackie srm450 service manual
schematic & service manual:
mackie_srm450_active_speaker_[ET].rar
individual files:
Mackie SRM450 Service Manual.pdf
Mackie SRM450 Schematic.pdf
November 12, 2009
quote delimited CSV output for SQL
when you output sql text manually creating CSV file output format, you may need to adjust for quote delimited data if that data contains your delimeter or line feeds.
this code snippet is for 'comma' delimited output.
SELECT
CASE PATINDEX('%[,"\r\n]%', [MyColumnData])
WHEN 0 THEN [MyColumnData] -- not found
WHEN NULL THEN [MyColumnData] -- unknown
ELSE '"' + REPLACE([MyColumnData],'"','""') + '"' -- encode data
END
AS [MyEncodedOutput]
November 11, 2009
sandisk sansa 8Gb usb drive mode
in some cases, windows may register the device as a "media player". in this mode you cannot view random files/folders like a normal storage device. this threw me off since on my laptop it registered as ordinary removable storage mode, whereas on my desktop it registered as a media player.
there is a setting on the unit to auto detect this mode (media player if capable?). however you can force the unit into storage mode and navigate the drive.
Go to Settings -> USB -> Choose MSC
read more...November 03, 2009
esbar using webasto fuel pump?
the stock Webasto air top at-2000 fuel pump (12 volt) does not work in an Eberspacher (espar) D1LC. we measured the volume of fuel output using a procedure detailed on page 23 of the Espar installation troobleshooting & parts manual, by letting the pump expel fuel into a cup (shot glass) for 90 seconds. not having a proper measuring cup, we weighed the output on a suitable, sensitive scale for results.
output was 13.6 grams of diesel. average density of diesel listed at 0.85 kg/l, so that's 16 milliliters of fuel.
the espar manual states the fuel delivered in this startup cycle should be between 3.4ml and 4.65ml. so, much less. it was also clear after operating for a few minutes, that excess fuel was not being burned off and the unit was spewing smoke like mad.
so the pump output is too strong, waaay too much fuel. so i'm still looking for a proper esbar fuel pump (mfg. part: 25 1830 45 00 00), any tips?
on a curious note, the heater contains fairly advanced microprocessor, electronics, and sensors. they are reasonably well built and remarkably intelligent. i had not realized the level of sophistication these 'simple' heaters enjoy, it's pretty amazing. now, only if it worked. sigh.