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.11-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 66c61c517a7a9a01e10f057ce5d18b5b7fcb8358692bdef1e87e8a2caf99b7a5 |
|
MD5 | 3ba5f894130b71fe2194d94f05fb5783 |
|
BLAKE2b-256 | ab986df792cb1a9438fafd6dba7f04ece5d3aaaf7406c3cdf5aa316562c6422d |