A quick how-to if you want to copy or move Magento to another database instance, e.g. to create a test site, or move test to live.
(1) Backup Magento using the built in backup tool. Download and uncompress the resulting SQL script. If changing the server or domain, search and replace “old.mysite.com” with “new.yoursite.com” Execute it [...]
If you are running Skype v3 or later, there is a registry change (provided by Skype for Universities etc.) that reportedly prevents your PC becoming a supernode. I say reportedly, because whilst I have been a guinea pig for the last week I haven’t noticed being a supernode, but of course Skype may not have [...]
Here is some DOS / NT CMD Script code to sleep for n seconds:
@echo off
echo Sleeping for 5 seconds
call :sleep 5
echo Done
goto :EOF
:sleep
:: This subroutine sleeps for n seconds
ping -n %1 127.0.0.1 > NUL 2>&1
goto :EOF
OK, so Epson’s support proved to be useless – “isn’t there a DIP switch on the back” and “we don’t do programming here” seemed to be the best they can offer.
Inspiration led me to lookup the ESC/POS sequences for cursor display – not DC2 & DC4 as previously though, they use the ASCII US (31 [...]
Aparently UTW suffers from an expensive query – this site has a fix:
http://ocaoimh.ie/2006/09/27/simple-utw-performance-boost/
From xlDynamic.com
File path, file and worksheet name:
=CELL(“filename”,A1)
File path only:
=LEFT(CELL(“filename”,A1),FIND(“[",CELL("filename",A1),1)-1)
File name only:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,
FIND("]“,CELL(“filename”,A1),1)-FIND(“[",CELL("filename",A1),1)-1)
The sheet name:
=MID(CELL("Filename",A1),FIND("]“,CELL(“Filename”,A1))+1,255)
Restriction: this technique only works for workbooks that have been saved at least once.
I really must get around to implementing these plug-ins to stop clutter in the WordPress category and page lists.
See also here.
Consider the following JavaScript:
// Toggle Show/Hide
function toggle(name) {
if (document.getElementById(name).style.display == “block”) {
document.getElementById(name).style.display = “none”;
} else {
document.getElementById(name).style.display = “block”;
}
}