tatarize

Spreadsheet-to-Keystrokes Script

This script is designed to automate the process of inputting data from a spreadsheet into a program that only allows input one field at a time. By reading an exported file and simulating keystrokes, the script inputs each cell value into the corresponding field in the program.

The script is simple and easy to use, with no complicated setup or configuration required. All you need to do is prepare the data in a tab-delimited text file, open the order entry system, and drag and drop the file onto the script, then select the first field in the program. The script will wait three seconds then automatically input the data for you.

Prerequisites

We are assuming you are running Microsoft Windows with VBScript (it comes standard). If this is inaccurate, a python example is also provided.

Assumptions

We are assuming that you can press tab to move to the next field, and that pressing enter will move to the next line.

Spreadsheet to Auto Entry

This script should allow you to enter data in a custom ordering with special keypresses and allow some customization and development on-the-fly. Each line you will be prompted to give the desired ordering for the sendkeys, if you edit it. It will reflect this for the next attempt. When you have a working ordering for the keystrokes, you can rename the script file to that ordering name and it will be used as the default ordering.

The replacement variables $1 - $n are presented for each line.

Instructions

Open the spreadsheet containing the data you want to enter into the program.
Save the spreadsheet data in a Tab Delimited format.

	# Code is derived from the C noise code:
	# Copyright (c) 2008, Casey Duncan (casey dot duncan at gmail dot com)
	# MIT LICENSE.
	# This port is also, MIT LICENSE.


	from numpy import floor, fmod

	M_1_PI = 0.31830988618379067154

	# Code is derived from the C noise code:
	# Copyright (c) 2008, Casey Duncan (casey dot duncan at gmail dot com)
	# MIT LICENSE.
	# This port is also, MIT LICENSE.


	from numpy import floor, fmod

	"""
	"Native-code tileable Perlin "improved" noise functions"

	"""
	// Copyright (c) 2008, Casey Duncan (casey dot duncan at gmail dot com)
	// see LICENSE.txt for details
	// $Id$
	"""

	import sys # Only needed for FLT_MAX, FLT_MAX is semaphore; replace with None

	import numpy as np

	import wx.aui
	import wx
	import wx.ribbon as RB

	ID_CIRCLE = wx.ID_HIGHEST + 1
	ID_CROSS = ID_CIRCLE + 1
	ID_TRIANGLE = ID_CIRCLE + 2
	ID_SQUARE = ID_CIRCLE + 3
	ID_POLYGON = ID_CIRCLE + 4
	ID_SELECTION_EXPAND_H = ID_CIRCLE + 5

	import math
	from copy import deepcopy
	from functools import lru_cache
	from PIL import ImageDraw, Image

	# Color conversion formula borrowed from:
	# http://www.easyrgb.com/index.php?X=MATH&H=02#text2

	ref_X = 95.047 # ref_X = 95.047 Observer= 2°, Illuminant= D65
	ref_Y = 100.000 # ref_Y = 100.000


	def build_edge_list(polygon):
	edge_list = []
	for i in range(0, len(polygon) - 1):
	if (polygon[i].imag, polygon[i].real) < (polygon[i + 1].imag, polygon[i + 1].real):
	edge_list.append((polygon[i], i))
	edge_list.append((polygon[i + 1], ~i))
	else:
	edge_list.append((polygon[i], ~i))
	edge_list.append((polygon[i + 1], i))