nanusdad

Save Excel worksheet as .csv file

might need to change new line characters
if saving on Mac - open in vi and run %s/^M/\r/g ( ctrl+M )

Use the following example to load in CSV file from mysql prompt -

    load data infile '/tmp/tc_t.csv' 
    into table new_test_categories 
 fields terminated by ','

Inserting data into mongo collection from JSON file

var file = cat('./20-new.json');  # file name
use testdb                        # db name
var o = JSON.parse(file);         # convert string to JSON
db.forms.insert(o)                # collection name

Inserting data using 'meteor mongo' into collection from JSON file

From StackOverflow

Watermarking with an image is as simple as

composite -dissolve 30% -gravity south watermark.jpg input-file.jpg output-file.jpg

Using the above command as an example, a Bash command for doing this to all files in folder would be:

Commandline:

make dclean
make clean
./config --openssldir=/home/locallinux/lib/openssl no-zlib no-shared
make depend
make test
make all
make install

How to use GoDaddy SSL certs with Express JS

Node requires each certificate in the CA chain to be passed separately in an array.
GoDaddy provides a cerficate file (gd_bundle.crt) probably looks like this:

-----BEGIN CERTIFICATE-----
MIIE3jCCA...
-----END CERTIFICATE-----
-----BEGIN CERTIFICATE-----

Using Ionic to build Android APK on Mac

Install NodeJS
Install ionic and cordova

npm install -g ionic cordova

Might need to install node-sass
Requires CocoaPods

sudo gem install cocoapods

$stdout = File.new('console.out', 'w')

#You may also need to call this once:

$stdout.sync = true

cd /opt/bitnami/apps/wordpress/
sudo ./bnconfig --userpassword YOUR_NEW_PASSWORD

	<html>

	<head>
	<title>Confirmation Form</title>
	</head>

	<body>

	<p id="demo">
	</p>

	node_modules
	*.swp