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.8)
-
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.2.7-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fd75e219ff1f561fe4c072e16c75b1738a79651fc46cc0fdc667d12578465919 |
|
MD5 | 6bfd36af59f7099d1932457bd500d692 |
|
BLAKE2b-256 | f5cd79cd459ba76366149f7e5d8f301477242e967df7c3e9d3dd1419575bdc25 |