michoelchaikin / gist:fc4db078c0f64f6f5d35

Last active November 13, 2022 18:54

Backup a mySQL database to Google Drive

	#! /usr/bin/perl

	# Backups and compresses a SQL database, and uploads to Google Drive
	# Make sure ~/.my.cnf is set with mySQL login credentials
	# Follow instructions at https://developers.google.com/drive/web/auth/web-server to generate a client id and secret
	# Use bash script at https://github.com/soulseekah/bash-utils/blob/master/google-oauth2/google-oauth2.sh to create refresh token

	# Configuration Options

	my $HOST = ''; # mySQL server host

michoelchaikin / swipe_cc.js

Last active May 30, 2018 16:26

Accept credit cards by swiping in NetSuite using USB credit card reader

	/**
	* Accept credit cards by swiping in NetSuite using USB credit card reader
	* (http://www.ebay.com.au/sch/i.html?_nkw=Magnetic+Stripe+Swiper)
	*
	* To deploy:
	*
	* 1) Upload this file to File Cabinet
	* 2) In your custom Sales Order form, add the script file (no need to associate with any events)
	* 3) Add an 'Inline HTML' custom field to the form with default value:
	* <a href="javascript:swipe_cc();">Swipe Credit Card</a>

michoelchaikin / printlabels.js

Created August 18, 2016 23:58

Netsuite Advanced PDF/HTML templates for any record type

	/**
	* Add 'Print Item Labels' button to Item Page
	*
	* Script ID: customscript_mos_itemlabels_ue
	* Script Type: User Event
	* Deployed to: Inventory Item
	*
	*/

	function beforeload(type, form) {

michoelchaikin / mail_to_printer_setup.md

Last active May 28, 2019 02:02

MAIL TO PRINTER GATEWAY

sudo adduser autoprint
sudo apt-get install fetchmail postfix

/etc/default/fetchmail

START_DAEMON=yes

michoelchaikin / gulpfile.js

Last active July 26, 2017 21:19

Gulpfile for Netsuite development

	const gulp = require('gulp');
	const typescript = require('gulp-typescript');
	const del = require('del');
	const keepass = require('keepass-http-client');
	const spawn = require('child-process-promise').spawn;
	const open = require('open');

	const PROJECT_NAME = 'XXXX';
	const PROJECT_URL = 'https://system.sandbox.netsuite.com/app/site/hosting/scriptlet.nl?script=XXX&deploy=XXXX';
	const SDF_CLASSPATH = 'C:\\Users\\michoel\\Desktop\\sdf\\\*';

michoelchaikin / mos_lookup_history_cs.js

Last active December 7, 2018 20:56

Lookup History Netsuite Customization

	/**
	* Client side code for Lookup History customization
	*
	* Script Type: Client Script
	* Deployed to: <not deployed>
	*
	*/

	'use strict';

michoelchaikin / postmanNetSuiteTBA.js

Last active December 23, 2023 19:06

Postman pre-request script to generate TBA variables for NetSuite Web Services

	/*

	Usage:

	1. Define a NetSuite environment in Postman (https://www.getpostman.com/docs/postman/environments_and_globals/manage_environments)
	with the following keys set: account, consumerKey, consumerSecret, tokenId, tokenSecret

	2. Add this script to your "Pre Request Script" in Postman (https://www.getpostman.com/docs/postman/scripts/pre_request_scripts)

	3. Add the Token Passport in your request with variable placeholders

michoelchaikin / mos_product_search.html

Created March 8, 2018 22:11

Product Search Suitelet

	<!DOCTYPE html>
	<html lang="en">

	<head>
	<meta charset="utf-8">

	<link rel="stylesheet" type="text/css"
	href="https://cdn.datatables.net/r/zf-5.5.2/jq-2.1.4,dt-1.10.9/datatables.min.css"/>
	<script type="text/javascript"
	src="https://cdn.datatables.net/r/zf-5.5.2/jq-2.1.4,dt-1.10.9/datatables.min.js"></script>

michoelchaikin / invoiceWithGroups.xml

Created February 9, 2020 09:44

NetSuite Advanced PDF/HTML Invoice Template with the products grouped by class

	<?xml version="1.0"?><!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd">
	<pdf>
	<head>
	<link name="NotoSans" type="font" subtype="truetype" src="${nsfont.NotoSans_Regular}" src-bold="${nsfont.NotoSans_Bold}" src-italic="${nsfont.NotoSans_Italic}" src-bolditalic="${nsfont.NotoSans_BoldItalic}" bytes="2" />
	<#if .locale == "zh_CN">
	<link name="NotoSansCJKsc" type="font" subtype="opentype" src="${nsfont.NotoSansCJKsc_Regular}" src-bold="${nsfont.NotoSansCJKsc_Bold}" bytes="2" />
	<#elseif .locale == "zh_TW">
	<link name="NotoSansCJKtc" type="font" subtype="opentype" src="${nsfont.NotoSansCJKtc_Regular}" src-bold="${nsfont.NotoSansCJKtc_Bold}" bytes="2" />
	<#elseif .locale == "ja_JP">
	<link name="NotoSansCJKjp" type="font" subtype="opentype" src="${nsfont.NotoSansCJKjp_Regular}" src-bold="${nsfont.NotoSansCJKjp_Bold}" bytes="2" />

michoelchaikin / netsuiteSS2Anywhere.js

Created July 24, 2020 02:44

	/**
	* Usually if you want to access the SuiteScript 2 API via the browser console you need to open specific pages
	* that load the required libraries (such as a record in edit mode). This script will load the libraries on any
	* NetSuite page
	*/

	(async () => {

	/* Add a script element to the DOM and wait until it's loading by checking that
	a known variable it creates exists */