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.9-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4a937ab2e2b2a7d10b8339e7e801059f3de0272f2a47b811bd538e36fff207cd |
|
MD5 | 6f03cb6dfc3eef1ffde7505db8d9bfa4 |
|
BLAKE2b-256 | 1f79544de9cdeed7ff430e7be164f8370b6900fa9c7e27c26ae697c8804740f5 |