Welcome, guest | Sign In | My Account | Store | Cart

Notice! PyPM is being replaced with the ActiveState Platform, which enhances PyPM’s build and deploy capabilities. Create your free Platform account to download ActivePython or customize Python with the packages you require and get automatic updates.

Download
ActivePython
INSTALL>
pypm install gocept.collmex

How to install gocept.collmex

  1. Download and install ActivePython
  2. Open Command Prompt
  3. Type pypm install gocept.collmex
 Python 2.7Python 3.2Python 3.3
Windows (32-bit)
1.2.1
1.3Never BuiltWhy not?
1.2.1 Available View build log
1.2 Available View build log
1.1.1 Available View build log
1.0 Available View build log
0.9 Available View build log
0.7 Available View build log
Windows (64-bit)
1.2.1
1.3Never BuiltWhy not?
1.2.1 Available View build log
1.2 Available View build log
1.1.1 Available View build log
1.0 Available View build log
0.9 Available View build log
0.7 Available View build log
Mac OS X (10.5+)
1.2.1
1.3Never BuiltWhy not?
1.2.1 Available View build log
1.2 Available View build log
1.1.1 Available View build log
1.0 Available View build log
0.9 Available View build log
0.7 Available View build log
Linux (32-bit)
1.3 Available View build log
1.2.1 Available View build log
1.2 Available View build log
1.1.1 Available View build log
1.0 Available View build log
0.9 Available View build log
0.7 Available View build log
Linux (64-bit)
1.3 Available View build log
1.2.1 Available View build log
1.2 Available View build log
1.1.1 Available View build log
1.0 Available View build log
0.9 Available View build log
0.7 Available View build log
 
Author
License
ZPL 2.1
Lastest release
version 1.3 on Mar 4th, 2013

Introduction

Collmex is an online ERP system for (small) companies with a focus on simple accounting. <http://www.collmex.de> (Note: Collmex is Germany-based but seems to support English. You're bound to stumble over German strings, though.)

This package aims to provide pythonic bindings to program against Collmex' API. It includes transaction management for integration with the ZODB or other databases that can integrate with the transaction package.

Collmex API

Collmex provides a POST- and CSV-based API, which is encapsulated into a utility that provides methods for the various CSV record types. API documentation is available at http://www.collmex.de/cgi-bin/cgi.exe?1005,1,help,api.

The collmex object

The collmex object is a central place to access collmex. In the Zope 3 jargon it is a global utility:

>>> import os
>>> import gocept.collmex.collmex
>>> collmex = gocept.collmex.collmex.Collmex(
...     os.environ['collmex_customer'], os.environ['collmex_company'],
...     os.environ['collmex_username'], os.environ['collmex_password'])
Pre flight cleanup

First we need to clean up the Collmex environment:

>>> import gocept.collmex.testing
>>> gocept.collmex.testing.cleanup_collmex()
Transaction integration

gocept.collmex has support for transaction integration. All modifying calls are buffered until the transaction is commited. XXX explain more.

>>> import transaction
Customers: create_customer and get_customers
>>> customer = gocept.collmex.model.Customer()
>>> customer['Kundennummer'] = 10000
>>> customer['Firma'] = 'Testkunden'
>>> collmex.create(customer)
>>> transaction.commit()

Customers can be listed using the get_customers method:

>>> customers = collmex.get_customers()
>>> customers
[<gocept.collmex.model.Customer object at 0x...>,
 <gocept.collmex.model.Customer object at 0x...>]
>>> len(customers)
2

The first customer is the generic one:

>>> customer = customers[0]
>>> customer['Satzart']
u'CMXKND'
>>> customer['Kundennummer']
u'9999'
>>> customer['Firma']
u'Allgemeiner Gesch\xe4ftspartner'

The second customer is one created during test setup:

>>> customer = customers[1]
>>> customer['Satzart']
u'CMXKND'
>>> customer['Kundennummer']
u'10000'
>>> customer['Firma']
u'Testkunden'
Products: create_product and get_products

Products are created using the create_product method:

>>> product = gocept.collmex.model.Product()
>>> product['Produktnummer'] = 'TEST'
>>> product['Bezeichnung'] = 'Testprodukt'
>>> product['Produktart'] = 1 # Dienstleistung
>>> product['Basismengeneinheit'] = 'HR'
>>> product['Verkaufs-Preis'] = 5
>>> collmex.create(product)
>>> transaction.commit()
>>> collmex.get_products()[0]['Bezeichnung']
u'Testprodukt'
Invoices: create_invoice and get_invoices

Invoices are created using the create_invoice method:

>>> import datetime
>>> start_date = datetime.datetime.now()
>>> item = gocept.collmex.model.InvoiceItem()
>>> item['Kunden-Nr'] = '10000'
>>> item['Rechnungsnummer'] = 100000
>>> item['Menge'] = 3
>>> item['Produktnummer'] = 'TEST'
>>> item['Rechnungstext'] = u'item text \u2013 with non-ascii characters'
>>> item['Positionstyp'] = 0
>>> collmex.create_invoice([item])

Invoices can be looked up again, using the get_invoices method. However, as discussed above the invoice was only registered for addition. Querying right now does not return the invoice:

>>> collmex.get_invoices(customer_id='10000', start_date=start_date)
[]

After committing, the invoice is found:

>>> transaction.commit()
>>> collmex.get_invoices(customer_id='10000',
...                      start_date=start_date)[0]['Rechnungstext']
u'item text \u2013 with non-ascii characters'
Activities

This section describes the API for activities (Taetigkeiten erfassen)

Create an activity

A project with one set and an employee are required to submit activities:

>>> import datetime
>>> import gocept.collmex.testing
>>> gocept.collmex.testing.create_project(u'Testprojekt')
>>> gocept.collmex.testing.create_employee()
>>> act = gocept.collmex.model.Activity()
>>> act['Projekt Nr'] = '1' # Testprojekt
>>> act['Mitarbeiter Nr'] = '1' # Sebastian Wehrmann
>>> act['Satz Nr'] = '1' # TEST
>>> act['Beschreibung'] = u'allgemeine T\xe4tigkeit'
>>> act['Datum'] = datetime.date(2012, 1, 23)
>>> act['Von'] = datetime.time(8, 7)
>>> act['Bis'] = datetime.time(14, 28)
>>> act['Pausen'] = datetime.timedelta(hours=1, minutes=12)
>>> collmex.create(act)
>>> transaction.commit()
Export using get_activities

get_activities returns Activity objects.

Attention!

In previous versions this method returnd a raw CSV string. This was due to Collmex not having an actual API.

>>> activities = collmex.get_activities()
>>> activities[0]['Beschreibung']
u'allgemeine T\xe4tigkeit'
Projects: get_projects

Projects can be exported with the get_projects API. It returns an entry for every project set (Projektsatz) of each project (Projekt):

>>> proj = collmex.get_projects()
>>> len(proj)
2
>>> proj[0]['Projektnummer'] == proj[1]['Projektnummer']
True
>>> proj[0]['Satz']
u'5,00'
>>> proj[1]['Satz']
u'9,65'
>>> proj[0]['Inaktiv']
u'0'
Caching

Results queried from Collmex are cached for the duration of the transaction.

To demonstrate this, we instrument the _post() method that performs the actual HTTP communication to show when it is called:

>>> original_post = collmex._post
>>> def tracing_post(self, *args, **kw):
...     print 'cache miss'
...     return original_post(*args, **kw)
>>> collmex._post = tracing_post.__get__(collmex, type(collmex))

The first time in an transaction is retrieved from Collmex, of course:

>>> transaction.abort()
>>> collmex.get_products()[0]['Bezeichnung']
cache miss
u'Testprodukt'

But after that, values are cached:

>>> collmex.get_products()[0]['Bezeichnung']
u'Testprodukt'

When the transaction ends, the cache is invalidated:

>>> transaction.commit()
>>> collmex.get_products()[0]['Bezeichnung']
cache miss
u'Testprodukt'
>>> collmex.get_products()[0]['Bezeichnung']
u'Testprodukt'

Remove tracing instrumentation:

>>> collmex._post = original_post

Changes

1.3 (2013-02-22)
  • Implement activities API (#11954).
1.2.1 (2012-03-09)
  • Fix gocept.collmex.collmex.Collmex.browser_login() after collmex website changed wich included a rename of form elements.
1.2 (2012-02-21)

Note: This version was accidentally released without the changes in 1.1.1, however, the release itself contained the changes of 1.1 and thus isn't broken.

  • Add Inaktiv attribute on CMXPRJ (projects)
1.1.1 (2012-02-17)
  • Rectify previous brown-bag release.
1.1 (2012-02-17)
  • Do not honour Collmex' robots.txt as of 2012-02-09. :(
1.0 (2012-01-23)
  • Forced usage of Python 2.7.
  • Added testing helper get_collmex to create a collmex object from environment variables.
  • Made testing helper collmex_login() a method: gocept.collmex.collmex.Collmex.browser_login()
  • Modified signature of testing helper create_activity, so it no longer needs a parameter.
0.9 (2012-01-20)
  • Added testing helper create_activity.
0.8 (2012-01-20)
  • Added API for retrieving activities (get_activities).
  • Updated tests and test infrastructure to recent changes in Collmex.
0.7 (2009-11-05)
  • Added API for retrieving projects and creation of activities.
0.6 (2009-02-16)
  • Make models robust against API changes so they don't immediately break when the record becomes longer.
  • Updated customer model to current API.
0.5.1 (2009-01-08)
  • Fixed multi-threading bug: thread-local data needs to be intialized for each thread.
0.5 (2008-12-19)
  • Values returned from Collmex are converted to unicode.
  • Cache results for the duration of the transaction.
0.4 (2008-12-11)
  • Added get_products and create_product.
  • Added create_customer.
  • gocept.collmex.testing.cleanup_collmex() now only deletes any existing data, it does not add any sample customers or products, use the API for that.
0.3.1 (2008-12-02)
  • Python 2.5 compatibility.
0.3 (2008-12-01)
  • Using Windows-1252 as encoding when uploading data (used to be ISO-8859-1).
  • Fixed transaction integration when upload fails.
0.2 (2008-11-28)
  • Modifications for changed Collmex API.
  • Added get_customers to query customers (API CUSTOMER_GET).
0.1 (2008-10-14)
  • first release. Supports getting and storing invoices.

Subscribe to package updates

Last updated Mar 4th, 2013

Download Stats

Last month:2

What does the lock icon mean?

Builds marked with a lock icon are only available via PyPM to users with a current ActivePython Business Edition subscription.

Need custom builds or support?

ActivePython Enterprise Edition guarantees priority access to technical support, indemnification, expert consulting and quality-assured language builds.

Plan on re-distributing ActivePython?

Get re-distribution rights and eliminate legal risks with ActivePython OEM Edition.