repl-uploader

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 :)

Release files for repl-uploader 2.2.7

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for repl-uploader 2.2.7
File	Size	Uploaded
repl_uploader-2.2.7.tar.gz	30.4 kB	Jun 6, 2022	Details

Built distribution (wheel)

Table of built distributions (wheels) for repl-uploader 2.2.7
File	Interpreter	ABI	Platform	Reset
repl_uploader-2.2.7-py3-none-any.whl 33.5 kB Jun 6, 2022	Python 3	none	any	Details

Total release size: 63.9 kB

Release files / repl_uploader-2.2.7.tar.gz

Download URL	repl_uploader-2.2.7.tar.gz
Size	30.4 kB
Tags	Source
SHA-256 checksum How to use checksums	`ede32756dbeee52876403c6bfec1ca488e4854e1a81f574dad0ccf68e16fa73d`
BLAKE2b-256 checksum How to use checksums	`d3a88a14d91fc63536a926c37e3c08625220ea78f391ecf8a6730f0d454b0bda`
Upload date	Jun 6, 2022
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/4.0.1 CPython/3.9.12`

Release files / repl_uploader-2.2.7-py3-none-any.whl

Download URL	repl_uploader-2.2.7-py3-none-any.whl
Size	33.5 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`fd75e219ff1f561fe4c072e16c75b1738a79651fc46cc0fdc667d12578465919`
BLAKE2b-256 checksum How to use checksums	`f5cd79cd459ba76366149f7e5d8f301477242e967df7c3e9d3dd1419575bdc25`
Upload date	Jun 6, 2022
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/4.0.1 CPython/3.9.12`