IranthaJ’s gists

IranthaJ / SearchForIP.gs

Last active February 13, 2019 11:40

Google apps script function to fin related city and country of an IP address

	function SearchForIP()
	{
	var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("IP List");
	var resultsheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Related Data");
	var IPs = sheet.getRange(2,1,sheet.getLastRow()-1,1).getValues();
	var IPdata = [];
	var message_text ="";
	for(var i in IPs)
	{
	var url = 'http://api.ipstack.com/'+ IPs[i][0]+ '?access_key=access_key&output=json';

IranthaJ / getFolderID.gs

Created March 4, 2017 06:11

	function getFolderID(folderName)
	{
	var folders = DriveApp.getFolders();
	while (folders.hasNext()) {
	var folder = folders.next();
	if(folder.getName() == folderName)
	{
	return folder.getId();
	}
	}

IranthaJ / csvtospreadsheet.gs

Created March 4, 2017 05:28

	function importCSV()
	{
	var getfile = "singleColumn.csv";
	var getFolder = DriveApp.getFolderById('this is my folder id');
	var fi = getFolder.getFilesByName(getfile);
	if (fi.hasNext())
	{
	var ssNew = SpreadsheetApp.getActiveSpreadsheet();
	var newSheet = ssNew.getSheetByName("Data from CSV");// select data from CSV tab
	var file = fi.next();

IranthaJ / jiraconnector.gs

Created September 15, 2016 18:10

google apps script to JIRA connector

	function testJiraConnection()
	{
	var baseURL = "https://yourserver/rest/api/2/search";
	var username = "username";
	var password = "pass";
	var encCred = Utilities.base64Encode(username+":"+password);

	var fetchArgs = {
	contentType: "application/json",
	headers: {"Authorization":"Basic "+encCred},

IranthaJ / code.gs

Created January 18, 2016 17:57

	function onOpen(e) {
	//method 1
	SpreadsheetApp.getUi()
	.createMenu('My Menu')
	.addItem('My menu item', 'myFunction')
	.addSeparator()
	.addSubMenu(SpreadsheetApp.getUi().createMenu('My sub-menu')
	.addItem('One sub-menu item', 'mySecondFunction')
	.addItem('Another sub-menu item', 'myThirdFunction'))
	.addToUi();

IranthaJ / MainWindowListViewBasedOnComboBox.xaml.cs

Created April 7, 2015 07:57

	public partial class MainWindow : Window
	{
	public MainWindow()
	{
	InitializeComponent();
	DataContext = new DataContext();
	}

	private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
	{

IranthaJ / MainWindowListViewBasedOnComboBox.xaml

Created April 7, 2015 07:56

	<StackPanel>
	<ComboBox SelectedItem="{Binding Item}" ItemsSource="{Binding itemList}"
	Margin="105,56,52,0" Height="27" SelectionChanged="ComboBox_SelectionChanged">
	<ComboBox.ItemTemplate>
	<DataTemplate>
	<TextBlock Text="{Binding Name}"/>
	</DataTemplate>
	</ComboBox.ItemTemplate>
	</ComboBox>
	<ListView Name="VitaminsListView" SelectedItem="{Binding SubItem}"

IranthaJ / WPFListViewComboBoxClasses.cs

Created April 7, 2015 07:52

	public class Item
	{
	public int itemID { get; set; }
	public string Name { get; set; }

	public Item(int ID, string name)
	{
	this.itemID = ID;
	this.Name = name;
	}

IranthaJ / ClientIdleHandler.cs

Created March 31, 2015 05:52

	public class ClientIdleHandler : IDisposable
	{
	public bool IsActive { get; set; }

	int _hHookKbd;
	int _hHookMouse;

	public delegate int HookProc(int nCode, IntPtr wParam, IntPtr lParam);
	public event HookProc MouseHookProcedure;
	public event HookProc KbdHookProcedure;

IranthaJ / dispatcher.cs

Created December 2, 2014 09:06

	==== In the mainWindow.xaml.cs ======
	//constructor
	public MainWindow()
	{
	main = this;
	}

	internal static MainWindow main;
	internal string Status
	{

iJay IranthaJ