ASolchen’s gists

ASolchen / py_print_test.py

Created April 23, 2024 16:12

Print PDF Report

	from subprocess import Popen, PIPE
	import os, time, datetime
	cwd = os.getcwd()
	ACROBAT = "C:\Program Files\Adobe\Acrobat DC\Acrobat\Acrobat.exe"
	PDF = os.path.join(cwd, 'sample.pdf')
	TEMP_FILE = os.path.join(cwd, 'Temp.html')
	from pyhtml2pdf import converter


	HTML = """

ASolchen / py_mod_sim.py

Created April 12, 2024 01:57

Kivy UI for testing modbus TCP clients

	#!/usr/bin/env python3
	#pip install kivy and pyModbusTCP

	__version__ = '1.0'

	import kivy
	kivy.require('2.2.0')

	from kivy.app import App
	from kivy.clock import Clock

ASolchen / traffic.py

Created March 17, 2023 16:11

Get SNMP 5 min average switchport traffic on a 48-port Cisco 2960

	"""
	!add this to the switch config:
	snmp-server community public RO
	snmp-server location in some closet
	snmp-server contact [email protected]
	"""


	from pysnmp.hlapi import *

ASolchen / cip_server.py

Last active January 14, 2022 05:06

cip_server basic example

	#!/usr/bin/env python3
	import socket, struct, time
	from pycomm3.packets.base import ResponsePacket, RequestPacket
	from pycomm3.packets.ethernetip import RegisterSessionResponsePacket, DataItem
	from pycomm3.cip.services import Services, EncapsulationCommands

	class CIPServer(object):

	def __init__(self) -> None:
	super().__init__()

ASolchen / raC_Dvc_E300_Rung.L5X

Created December 14, 2021 20:17

e300 Rung import

	<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
	<RSLogix5000Content SchemaRevision="1.0" SoftwareRevision="31.02" TargetType="Rung" TargetCount="1" ContainsContext="true" ExportDate="Thu May 20 03:25:02 2021" ExportOptions="References NoRawData L5KData DecoratedData Context RoutineLabels AliasExtras IOTags NoStringData ForceProtectedEncoding AllProjDocTrans">
	<Controller Use="Context" Name="PowerDiscreteDeviceObjects">
	<DataTypes Use="Context">
	<DataType Name="raC_UDT_Event" Family="NoFamily" Class="User">
	<CustomProperties>
	<Provider ID="ACM" Ext="0">
	<Header xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Maj="1" Min="0" OExt="-1" UExt="1">
	<Libs>
	<LibHdr CatalogNumber="raC_Dvc_AS281E" Guid="0D88D226-393F-4D0F-8F3F-B04A585A2698" />

ASolchen / alarm_duration.py

Created August 31, 2021 16:31

python script to compute alarm duration in FactoryTalk View SE database and update the Tag1Value column of the "out of alarm" row

	import pyodbc

	TICKS_PER_SEC = 10000000.0 # Factorytalk Alarm and Event ticks / sec

	server = 'localhost\SQLEXPRESS'
	database = 'FTVSE_AE'
	username = 'python' # using SQL credentials
	password = 'python_pw'
	cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password+';Trusted_Connection=no;')
	cursor = cnxn.cursor()

ASolchen / ftvse_db_backup.py

Last active October 13, 2020 15:51

FactoryTalk Veiw Site Edition Alarm and Event SQL Server backup to SQLite

	import sqlite3
	import pyodbc

	TABLES = {
	"FTAEInstance": """
	CREATE TABLE IF NOT EXISTS [FTAEInstance](
	[lFTAEInstanceId] [int] NOT NULL,
	[sProduct] [varchar](255) NOT NULL,
	[sCatalogNumber] [varchar](255) NULL,
	[lMajorVersion] [int] NOT NULL,

ASolchen / node ethernet IP read and write strings

Created March 3, 2020 18:51

	const { Controller, Tag, EthernetIP } = require("ethernet-ip");
	const { SINT, DINT } = EthernetIP.CIP.DataTypes.Types;

	const PLC = new Controller();


	const readString = (name)=>{
	return new Promise(async (res, rej)=>{
	try{
	str = ''

ASolchen / timestamp interval rdd

Created September 16, 2019 17:14

ASolchen / logo.html

Created August 4, 2019 14:02

Testtech Logo SVG

	<!DOCTYPE html>
	<meta charset="utf-8">
	<html>
	<head>
	<title>widget</title>
	</head>
	<body>
	<svg width="400" height="400">
	<path fill="#AAA" d="M0,0 V400 H400 V0 H0" stroke="#000" stroke-width="4" />
	<circle stroke="#000" stroke-width="10" fill="#FFF" cx="200" cy="200" r="100">

Adam Solchenberger ASolchen