Collection of scripts to upload Replicon expenses
Project description
Synopsis
This is a simple code to extract data information from an excel (with a predefined format) and send it to a new Replicon expense sheet using webservices.
Motivation
Simplify my expenses reports
Installation
-
Install Python - https://www.python.org/downloads/ (I am using python 3.7)
-
Check if python is in the path environment variable
a) Command+r > type "rundll32 sysdm.cpl,EditEnvironmentVariables"
b) Check if there is somenthing like "C:\Program Files (x86)\Python37-32\scripts;C:\Program Files (x86)\Python37-32" in the PATH variable
c) Add it if necessary
-
Open a command window and install the required python modules using the following command:
pip install repl_uploader
- Install de xlwings addon on excel typing the following command on a command window:
xlwings addin install
-
Garantee that the Project Name Format in your replicon is set to "Name - Code"
a) Login on your Replicon account
b) Go to settings (engine wheel - upper right corner)
c) Change "Project Name Format" to "Name - Code"
-
When a new release is available, upgrade with the following command:
pip install --upgrade repl_uploader
API Reference
xlwings - http://docs.xlwings.org/en/stable/quickstart.html
Author
- Thiago Weidman
Contributors
- Danilo Passos - The guy who made the worksheet template (Yeap, I stole the idea).
- Rodrigo Tomazeli - The Beta tester and "implementer"
- Manuel Cardoso - The new features specifier :)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for repl_uploader-2.0.10-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 858d535b1efe7d65f467ad9364a4b8a02c766f6c1974ff69c4c12bb259131e1a |
|
MD5 | 0e5e5e1b7a0877d9e5c802510c5a0c9a |
|
BLAKE2b-256 | 27b4083b562698a9e4f44ae9981293f754e00bd710cfb15f1e64bc415e12635c |