Stefan Stoichev countnazgul

## git clone only specific branch
git clone user@git-server:project_name.git -b branch_name /some/folder

## MS-DOS delete folder silently.bat
rmdir /S /Q c:\temp

## QlikView_Convert_into_Unix_Timestamp.qvs
LET t1 = (num(timestamp#('2013-01-11 18:00:00', 'yyyy-mm-dd hh:mm:ss')) - 25569) * 86400;

LET t2 = (num(Now(1) - 25569) * 86400;

## Loop_through_all_files_in_current_folder.bat
for /r %%i in (*.txt) do echo %%i

## psftp_automate_sftp_server.bat
psftp username@sftp.server.com -pw password -b commands.txt

commands.txt contain all the psft commands that need to be executed like:
 lcd c:\test
 mget *.gz

## Qlikview_mixed_security_access
Section Access;

  LOAD * INLINE [
    ACCESS, USERID, PASSWORD, NTNAME
    ADMIN , admin , admin   , *
    USER  , *     , *       , DOMAIN\USERNAME
  ];

Section Application;

## NULLINTERPRET
SET NULLINTERPRET=NULL;

Orders:
LOAD * INLINE [
    OrderID, OrderDate
    112233, 1/2/2008
    223344, 2/2/2008
    334455, NULL
    445566, NULL
    556677, 3/3/2008

## QlikView_Julian_Date_Conversion.qvs
// to convert from Julian Date to normal Date (Gregorian)
// subtract the offset 2415019 (equivalent to 30.12.1899, which is day 0 in QlikView):

Date(JulianDateField - 2415019)

//You probaly have to adjust the timezone since Julian Date is in UTC.

// to convert from normal Date (Gregorian) to Julian Date
// add the offset 2415019 (equivalent to 30.12.1899, which is day 0 in QlikView):

## Mongoose filter fields.js
User.find({}, 'first last', function (err, usr) {
    //Got the result, saved a few bytes of code
});

## Limit number of MongoDB query.js
Posts
  .find({})
  .sort({})
  .limit(5)
  .exec(function(err, posts) {
     console.log(posts)
});
	LET t1 = (num(timestamp#('2013-01-11 18:00:00', 'yyyy-mm-dd hh:mm:ss')) - 25569) * 86400;

	LET t2 = (num(Now(1) - 25569) * 86400;
	psftp username@sftp.server.com -pw password -b commands.txt

	commands.txt contain all the psft commands that need to be executed like:
	lcd c:\test
	mget *.gz
	Section Access;

	LOAD * INLINE [
	ACCESS, USERID, PASSWORD, NTNAME
	ADMIN , admin , admin , *
	USER , * , * , DOMAIN\USERNAME
	];

	Section Application;
	SET NULLINTERPRET=NULL;

	Orders:
	LOAD * INLINE [
	OrderID, OrderDate
	112233, 1/2/2008
	223344, 2/2/2008
	334455, NULL
	445566, NULL
	556677, 3/3/2008
	// to convert from Julian Date to normal Date (Gregorian)
	// subtract the offset 2415019 (equivalent to 30.12.1899, which is day 0 in QlikView):

	Date(JulianDateField - 2415019)

	//You probaly have to adjust the timezone since Julian Date is in UTC.

	// to convert from normal Date (Gregorian) to Julian Date
	// add the offset 2415019 (equivalent to 30.12.1899, which is day 0 in QlikView):
	User.find({}, 'first last', function (err, usr) {
	//Got the result, saved a few bytes of code
	});
	Posts
	.find({})
	.sort({})
	.limit(5)
	.exec(function(err, posts) {
	console.log(posts)
	});