The columns section of the XML document refer to the columsn that will be offered in the Data Export Manager screens. The text of the column name is arbitrary and can be anything, but the <column column="TABLE.FIELD"> portion must refer to a "core" table of powerschool. When in doubt, use column="STUDENTS.ID" Avoid using DCID of any table in the column parameter as it might render the query disabled in DEM (grayed out). Reason being the DCID of most tables, starting with Students, is a non-editable identifier key even for system admin roles. Having DCID in SQL and in feild access is acceptable.
Aaron Ciuffo txoof
txoof
/ PowerQuery_Notes.md
Last active
January 9, 2026 04:54
Guide for things that can and should not be done when creating power queries.
PyPi no longer allows simple username/password authhentication through twine. 2FA is now required for all publisyhing.
This gist is based on this PyPA guide
setuptoolssetup.py-- see example below and in this project
txoof
/ syncthing setup.md
Last active
August 11, 2023 18:42
Set up Syncthing on Linux host for multiple users
txoof
/ word_clock.py
Created
January 31, 2022 08:26
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env python3 | |
| # coding: utf-8 | |
| # display the time vaugely as a string (The Time is about Ten to Seven); update every 5 minutes | |
| # to adjust the timing use: | |
| # $ word_clock.py -t xx | |
| import os | |
| from datetime import datetime |
In this situation it is not possible to connect to remote hosts (e.g. github.com) for managing repos over ssh. A tunnel through a remote host (tunnel.myhost.com) can remedy this. An ssh configuration file can be added to the ~/.ssh/config directory to specify a specific command for connecting github.com.
See also How to setup SSH Tunneling
Setup
- create a tunnel host that accepts incomming connections:
tunnel.myhost.com
- install nc
txoof
/ pyenv_mac_os.md
Last active
October 6, 2022 09:04
Setup Python pyenv for Jupyter with nbconvert on Mac OS
If nbconvert throws a similar error, it is likely because the jupyter installation is not setup properly within a pyenv
ValueError: No template sub-directory with name 'python' found in the following paths:
/Users/aciuffo/Library/Jupyter
/opt/homebrew/Cellar/[email protected]/3.9.2_1/Frameworks/Python.framework/Versions/3.9/share/jupyter
/usr/local/share/jupyter
/usr/share/jupyter
- Google Cloud SDK
- macOS 64-bit (x86_64) reccommended
- Project ID from Project with running VM
- VPN Instance Name and Zone
- SSH Key for project
- `ssh-keygen -f ~/.ssh/
- ip address of running project
- Install jupyter:
$ pip3 install jupyter
- launch a Jupyter notebook server that is available over the local network:
$ jupyter-notebook --ip=$(hostname -I) --no-browser
$ jupyter-notebook --ip=$(hostname -I) --no-browser
[I 05:51:34.280 NotebookApp] Serving notebooks from local directory: /home/pi
[I 05:51:34.280 NotebookApp] Jupyter Notebook 6.1.5 is running at:
txoof
/ OS X Code Signing Pyinstaller.md
Last active
September 9, 2025 22:13
@bpteague Has an excellent update solution as of February 2025 using modern tools and an updated workflow.
This gist will remain here, but is deprecated. I'll keep it here historical and link-preservation purposes only. I strongly encourage everyone to check out the solution above!
- Create a developer account with Apple
- https://developer.apple.com and shell out $99 for a developer account
- Download and install X-Code from the Apple App Store