blob: 0e27df0c1a3fe981a37b245e1ba56cbb9538183a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
# Maconomy Hours
A simple tool for sending reminder mails based on Deltek Maconomy.
Currently it uses direct database access, and works with either Oracle DB or MSSQL.
Help instructions are available using -h.
You need to supply a configuration file that contains database and mail information.
See `config.cfg.dist` for a skeleton
## Installation
- Install python 2.7 or 3.
- Install pip packages `pip install -r requirements/mssql.txt` or `pip install -r requirements/oracle.txt`
### Oracle
You will need to install the Oracle Client along with the python packages.
You might have some luck with i[this gist](https://gist.github.com/thom-nic/6011715), I did unfortunately not write down how I got `cx_Oracle` to work
### MSSQL
Steps for installing the MSSQL client bindings are taken from [https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-python](https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-python)
- OSX
- Install `msodbcsql` and `mssql-tools` (you might be able to skip `mssql-tool`)
```
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
ACCEPT_EULA=y brew install msodbcsql mssql-tools
```
- Windows
- Install [MSSQL ODBC Driver](https://www.microsoft.com/en-us/download/details.aspx?id=53339)
- Optionally install [SQL Server Command Line Utilities](https://www.microsoft.com/en-us/download/details.aspx?id=53591)
|