Twelve Dozen

Just another WordPress weblog

FTP / ZIP from the command line

http://www.howtogeek.com/howto/windows/how-to-automate-ftp-uploads-from-the-windows-command-line/
http://www.codejacked.com/zip-up-files-from-the-command-line/

  • 0 Comments
  • Filed under: Uncategorized
  • Convert databases to xml

    http://www.softsilver.com/downloads.asp

  • 0 Comments
  • Filed under: Uncategorized
  • Drupal – Format Comments

    Remove (Not Verified) – http://drupal.org/node/99409
    Remove Submitted By – http://www.kirkdesigns.co.uk/format-submitted-text-drupal-6-nodes-and-comments
    Add Comments Header – http://drupal.org/node/76716

  • 0 Comments
  • Filed under: Uncategorized
  • File Permisions

    Good file permissions tutorial -
    http://www.interspire.com/content/articles/12/1/FTP-and-Understanding-File-Permissions
    FTP overwrite problems using Virtualmin setup –
    http://www.virtualmin.com/node/9885

  • 0 Comments
  • Filed under: Uncategorized
  • Backing up large MySQL database

    Linux to the rescue. This sure beats using Export from PhpMyAdmin, it can be slow and may time out with large databases.
    mysqldump -a -u USER -p DBNAME > /path/to/backupname.sql
    http://www.metatitan.com/mysql/6/how-to-backup-and-restore-large-databases-in-mysql.html

  • 0 Comments
  • Filed under: Uncategorized
  • Setting up SSL on your server

    Check your SSL certificate – http://www.digicert.com/help/
    Setting up SSL on apache:
    http://onlamp.com/pub/a/onlamp/2008/03/04/step-by-step-configuring-ssl-under-apache.html

  • 0 Comments
  • Filed under: Uncategorized
  • Jquery slide show for Drupal

    If you need a slideshow for your Drupal website, I recommend using JCarousel Lite – http://gmarwaha.com/jquery/jcarousellite/
    It has lots of parameters to tweak depending on how you want to set it up. It’s easy to get working.
    One slight issue (well major issue really until I fixed it), that I had using this with Drupal was that [...]

  • 0 Comments
  • Filed under: Uncategorized
  • FILES=”test.xml”
    # for loop read each file
    for f in $FILES
    do
    INF=”$f”
    OUTF=”$f.out.tmp”
    # replace javascript
    sed ‘//d;//d’ $INF > $OUTF
    /bin/cp $OUTF $INF
    /bin/rm -f $OUTF
    done
    http://en.kioskea.net/faq/sujet-1451-sed-delete-one-or-more-lines-from-a-file
    http://www.oracle.com/technology/pub/articles/dulaney_sed.html

  • 0 Comments
  • Filed under: Uncategorized
  • Convert CSV to XML using Perl

    In my quest to convert a CSV file to XML I’ve found the best advice seems to be to use Perl.
    Do I have Perl installed on my linux server?
    http://www.cyberciti.biz/faq/how-do-i-find-out-what-perl-modules-already-installed-on-my-system/
    Enter the following command in shell -
    $ instmodsh
    To find the version of perl -
    http://www.cyberciti.biz/faq/how-can-i-find-out-perl-version/
    $ perl -v
    Here’s my findings:
    I’ve been following a tutorial in a book called XML [...]

  • 0 Comments
  • Filed under: Uncategorized
  • Audio Player for Drupal

    Recently, I’ve changed the way I’ve been creating websites in Drupal. Instead of trying to make everything as easily as possible for clients to add content to their websites I’m actually more inclined to think that this can make creating sites more complicated. I know there are a plethora of Drupal modules available for almost [...]

  • 0 Comments
  • Filed under: Uncategorized