IRC logs of #tryton for Wednesday, 2011-01-05 #tryton log beginning Wed Jan 5 00:00:02 CET 2011
Hydrantis there a changelog or something for Tryton... I haven't found anything obvious on the site00:34
HydrantI can either go with Ubuntu packages... 1.4... or manually install and get 1.8...00:34
-!- heg( has joined #tryton01:14
-!- heg( has left #tryton01:14
dbaHydrant: or install 1.8 from debian experimental (packages are not experimental, but they are there because of the upcoming squeeze release).01:21
-!- pepeu(~manuel@ has joined #tryton01:52
-!- ikks(~ikks@ has joined #tryton02:09
Hydrantdba: yah, I thought about doing that... to keep the scripts and such03:19
HydrantI wasn't sure if there were other deps that would mess things up though03:19
-!- zodman(~zodman@foresight/developer/zodman) has joined #tryton03:46
Hydranthas anyone here setup LDAP with Tryton ?03:56
-!- Hydrant(~aj@unaffiliated/hydrant) has joined #tryton04:10
-!- yangoon( has joined #tryton05:20
-!- pheller( has joined #tryton05:42
phellerHydrant: yes, I've connected Tryton to LDAP05:43
phellerHydrant: specifically, to Windows AD.05:43
HydrantI have it binding now... what I'm not sure is how to get Tryton to use the usernames / groups inside LDAP05:44
phellerHydrant: it's been awhile since I've done it, though as I recall, you must still create the username within Tryton.  LDAP is only used for external authentication.05:47
phellerHydrant: and to allow for a central point where accounts are disabled.  As for groups, I don't believe there is any integration there yet.05:47
phellerHydrant: though again, I've only done a cursory test to ensure that users can login.05:47
Hydranthrrm... I was hoping to be able to share authentication with all the other apps05:47
HydrantI have too many programs that all want usernames/passwords, and was hoping they could all get along :-)05:48
phellerHydrant: no problem sharing authentication -- that works fine.  It is only account provisioning that will still be a manual process.05:48
Hydrantright, but I already have the accounts created and existing...05:49
phellerHydrant: yes, it's a pain to also create them in Tryton -- but at least the user can change their password in one place and it will apply to everything, including tryton....05:49
HydrantI might be misunderstanding what you mean by create them05:50
HydrantTryton wants to write to the LDAP directory ?05:50
Hydrantor I just am creating them for the DBMS in Tryton05:50
phellerHydrant: you must still define the user in Tryton and give him/her some groups.  But, the authentication will be done against LDAP05:50
phellerno, Tryton just wants to read from LDAP05:50
Hydrantokay I'll try it05:51
phellerso, point tryton to LDAP, create user in both LDAP and Tryton.  if user changes password in ldap, then that is the new password for them in tryton as well.05:51
phellerdisable user in ldap, they should not be able to login to tryton anymore.05:51
phellerat least this is how I recall it from my cursory test some months ago :-)05:52
Hydranthrrm, yes that did work!05:52
Hydrantnow... does all the other stuff get populated from LDAP... like email....05:53
phellerI didn't test everything, but I would suspect doubtful.05:53
phellerIf you want more things integrated, open a feature request.....
HydrantI can also just check the code05:54
phellerSure.... if you're comfortable.  You're also welcome to give a shot at adding the features and submit the code for review and possible inclusion.05:54
phellerOk, time for me to sleep.  spent too much time working on the URL handling for the MacOS client tonight.  My eyes hurt!05:55
phellerNot a problem.  Have a nice evening.05:55
-!- jcm( has joined #tryton06:02
Hydrantanyone know how to get rid of all the VAT fields ?06:03
-!- okko(~okko@ has joined #tryton08:05
-!- Vladimirek(~vladimir@ has joined #tryton08:13
-!- Vladimirek(~vladimir@ has joined #tryton08:21
-!- jcm( has joined #tryton08:36
-!- enlightx( has joined #tryton08:36
-!- pjstevns( has joined #tryton08:55
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:01
-!- jcm( has joined #tryton09:46
-!- bechamel( has joined #tryton09:59
-!- paepke( has joined #tryton10:42
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton10:50
-!- Vladimirek(~vladimir@ has joined #tryton11:32
VladimirekWhat IDE do you use for python/xml ?12:35
cedkVladimirek: vim12:41
udonoVladimirek: aso vim12:42
jcmcedk: is it easy to get invoices as pdf instead of read-only odt ? is there a pdf templating system in tryton or would it require an openoffice export into pdf ?12:55
bechameljcm: you can convert odt to pdf sevrer side, by choosing it on the report form13:13
-!- ikks(~ikks@ has joined #tryton13:14
bechameljcm: via Administration> User Interface > actions > Report13:16
jcmbechamel: should I change odt to pdf in invoice report only? Makes a bug when viewing: URL seems to be an unsupported one.14:22
udonojcm: take a look at in the wiki and issue tracker you will find some dependencies you need to take care of.14:49
-!- gremly(~gremly@ has joined #tryton15:11
-!- pepeu(~manuel@ has joined #tryton15:18
-!- hoRn( has joined #tryton15:45
hoRnhappy new year15:45
udonohoRn: thanks, happy New Year, back15:48
-!- sharkcz(~sharkcz@2001:15c0:6747:160:250:43ff:fe3c:3b5d) has joined #tryton15:51
-!- sharkcz(~sharkcz@2001:15c0:6747:160:250:43ff:fe3c:3b5d) has joined #tryton16:01
Hydranthey everyone... I have Tryton setup nicely, and working with LDAP.... I'm not sure if user details like email addresses are populated via LDAP also16:09
cedkHydrant: no only name and login16:11
Hydrantit's too bad16:11
HydrantI was also hoping that Tryton groups might be populated from LDAP16:11
cedkHydrant: it is not possible by default to know where is the email address16:14
Hydrantyou mean from LDAP ?16:15
cedkHydrant: yes16:16
paepkeHydrant its not a big deal to write an additional module to match other fields from ldap to tryton.16:16
HydrantI'm pretty sure it is... lots of email clients are able to use LDAP address books... I don't know the particular object type, but don't you just have to populate your users with the right object type for that to work ?16:17
Hydrantpaepke: that's good to know, I looked a little bit at the source yesterday16:18
paepkeHydrant, i've done that for testing in 1.4. havent migrated it into 1.6 or even 1.816:18
cedkHydrant: email clients ask for which attribute store the email16:19
paepkeHydrant, you have to request the right values from ldap and insert it into the generated user object.16:19
Hydrantcan Tryton currently export also the "Party" data to LDAP for a centralized address book in the company?  Or perhaps read that data from there?16:20
Hydrantwhat I would love to have... is all these tools sharing contact information rather than several islands16:20
paepkeHydrant, tryton can currently only export via carddav, a sort of webdav. iphone and thunderbird understands that.16:21
paepkeHydrant, export in the meaning of directly accessible via a client.16:21
HydrantI had read that LDAP supposedly can show some data as if it is part of the directory, but really it's populated via a DBMS16:22
Hydrantthis is potentially something that can be done16:22
paepkeHydrant, there are several ways to get it working. ldap is designed to be spanned over several servers. like having a central entry-point and directing some parts of the ldap-tree to other servers.16:23
paepkeHydrant, there is already a wiki page where we discussed some ideas
Hydrantpaepke: yes, I've read that last night16:24
Hydrantbut only the parts on authentication... I didn't realize some of these issues were discussed there also16:25
HydrantI think the "solution" here is not to try to have Tryton export it's own LDAP interface16:27
paepkein my eyes its a big point. but unless some of my customers wants this actually i wont implement it.16:27
Hydrantinstead... have something like ou=party,ou=tryton,dc=example,dc=com or something like that16:27
Hydrantbut have that sub-tree populated via the Tryton database16:28
Hydrantthis might hit the database too much, I don't know16:28
paepkeHydrant, you can do some caching somewhere if you have concerns with performance.16:28
paepkeHydrant, even in tryton.16:28
Hydrantright... or have the data updated infrequently16:29
Hydrantmy main concern right now is the amount of data that will be shared between SugarCRM and Tryton16:29
Hydrantcertainly the party information will be shared16:29
Hydrantand users are going to want to be able to just email parties directly via their own mail clients.... not by looking up an email in Tryton or whatever16:30
paepkeHydrant, I'm not a fan of cloning data to other servers. in my eyes tryton (or an service which access the tryton database) have to export a ldap-subtree.16:30
Hydrantthis is likely not such a hard thing to actually implement so long as Tryton is fairly well designed16:30
Hydrantit might actually be so simple as a few database queries written on the LDAP side, I don't know16:31
paepkeHydrant, it is fairly well designed ;-)16:31
paepkeHydrant, its a bad design to access the database directly.16:31
Hydrantit might be better to actually just have Tryton load its party data from LDAP16:32
paepkeHydrant, there is already a python lib which wraps the tryton stuff. Its called proteus. That would be the perfect starting point if you want to write an own small ldap-access script.16:32
paepkeHydrant, its totally specific to the company from where you get your main data.16:33
Hydrantkeep the addresses and contact data in LDAP.... and force all the tools to get the data from there for most party stuff16:33
paepkeHydrant, some guys think the ERP has to be tha master of all data. and everythin has to be federated from there16:33
Hydrantyes, I worked at a company where that was the case... mostly for historical reasons16:34
Hydrantfor myself, I view my company as a collection of services that should integrate16:34
HydrantI'm not going to use Tryton for project management, Redmine does a very good job of that for us... but I do want the two to understand each other for accounting purposes16:34
HydrantSugarCRM is likely better suited to sales leads, but I want to be able to generate an invoice or contract in Tryton with some ease once the sale is closed16:35
Hydrantand so on... there are lots of tools16:35
Hydrantright now I realize I don't have a huge amount of time to spend integrating the tools, and probably never will myself... but if my company grows it is my intention to hire someone full time to work on the various open-source projects that run my company16:36
paepkeHydrant, yes, would be cool to export the project times into tryton.16:37
HydrantI'm not sure how tryton abstracts its data sources16:37
paepkei'm using redmine, too. until i find some better tool...16:37
paepketryton has its own orm.16:38
Hydrantpart of the issue is that the data needs to be able to come from various places... the party data might come from LDAP... project data via SOAP... and so on16:38
paepkeHydrant, there are several ways to access the data. via xmlrpc, json or at a higher python level vial proteus.16:38
Hydrantthat's a good thing16:39
Hydrantand Python also will be pretty nice for this kinda thing16:39
paepkeHydrant, tryton can manage multiple sources. but you know. someone has to be the boss when for example generating a customer number16:39
Hydrantpaepke: is there something you don't like about redmine ?16:41
-!- pheller( has joined #tryton16:42
cedkHydrant: the main issue when you split the data sets, is to maintain the data integrity16:42
Hydrantcedk: right, in some ways there is likely a missing piece that all programs need to interoperate with that will act as the main reservoir and keeper of data16:43
Hydrantlike a DBMS but more flexible, a kinda information router / gateway16:43
HydrantACTION likes to dream of cool ways to integrate data sources16:44
paepkeHydrant, the most annoying thing is the limitation of having only one repository per project. i don't like to have a lot subprojects which only holds the sources.16:45
cedkHydrant: for me it is a DBMS16:47
Hydrantcedk: yes, I worked at a company where it was the DBMS also... but there were issues over time... I forget what they all were16:48
Hydrantis there an ER-diagram for Tryton ?16:49
cedkHydrant: there is a report in Administration>Models>Modes16:51
HydrantI don't see a Models->Modes16:52
cedkHydrant: Administration>Models>Models16:53
Hydrantany way to get it for the whole thing ?16:54
cedkHydrant: no, it depends of the modules installe16:54
phellercedk: did you see my email about the URL handler in Mac OS ?  :-) :-) :-)16:55
-!- heffer(~felix@2a01:4f8:100:6fff:5054:ff:fe98:b9) has joined #tryton16:56
-!- heffer(~felix@fedora/heffer) has joined #tryton16:56
cedkpheller: yes16:57
cedkpheller: looks promizing16:57
-!- heffer_(~felix@2a01:4f8:100:6fff:5054:ff:fe98:b9) has joined #tryton16:57
-!- heffer_(~felix@fedora/heffer) has joined #tryton16:57
Hydranthave any of you seem applications that work entirely with metadata?  In particular, the application data and forms are completely flexible at runtime...16:58
cedkpheller: if you want we can review the patch before you send it to gtk+16:59
Hydrant I worked for a company that uses this at one point16:59
Hydrantthat looks like marketing speak though17:00
phellercedk: sure, that's probably a good idea.  I'll keep working on solving the last few bits over the next days and submit a code review for the gtk-osx piece on the weekend.17:00
cedkHydrant: difficult to know what it is17:06
Hydrantcedk: I know, I'm trying to find some non-marketecture17:07
Hydrantbasically.. as I understand it, the database just maintains tables that describe the data and relationships so that the schema can be changed easily17:07
cedkHydrant: generally this kind of system become slow17:09
-!- hoRn( has joined #tryton17:12
hoRnis there an attribute for sizing a wizard?17:13
cedkhoRn: no but the client can remember the size17:24
cedkhoRn: it is in "Options>Form>Save Width/Height"17:32
hoRncedk: ok - i got it17:33
hoRncedk: now i'm thinking about a solution to add the possibility to add a kind of stop watch to the module timesheet17:35
cedkhoRn: don't understand17:37
hoRncedk: the employee should select a work  and click "Start" - when he finishes the job, he clicks a "Finished"-Button. Easyclicking fpr employees ;)17:40
hoRncedk: assisted by a barcodescanner: click-scan-click-solution17:42
hoRnor better: scan-scan-solution. a click is to much for many people17:42
cedkhoRn: it is more attendance than timesheet17:44
hoRncedk: both - we want to measure the time needed for projects. now i need a small solution to add timesheet.lines to a work17:50
-!- paepke( has left #tryton17:55
-!- heffer_( has joined #tryton18:05
-!- heffer_(~felix@fedora/heffer) has joined #tryton18:05
-!- paepke( has joined #tryton18:51
-!- paepke( has left #tryton18:53
-!- pheller( has joined #tryton19:04
-!- plantian( has joined #tryton19:21
-!- Hydrant_(~aj@unaffiliated/hydrant) has joined #tryton19:22
Hydrant_I'm trying to setup a budget for my company... is there a particular way to do this in Tryton ?  Right now I just have an excel sheet... or is this something that doesnt' belong in the ERP19:23
-!- Vladimirek(~vladimir@ has joined #tryton19:37
Hydrant_how do I expense things to projects?  Do I create an account that is somehow associated with the projecT?20:03
hoRnHydrant: do you mean that a project generates costs?20:07
Hydrant_I need to buy things for a project, and I want to expense it to a project20:07
Hydrant_same with time spent on it and such20:07
Hydrant_ACTION has very little accounting knowledge and is trying to figur eout Tryton and basic accounting20:07
hoRni'm working still on this ;)20:08
Hydrant_as in programming it, or figuring it out ?20:08
-!- okko( has joined #tryton20:09
hoRnfor now you can apply hourly_costs for an employee - so you have a amount of the costs of the project20:09
Hydrant_in my situation, I recently completed a contract and got paid... but had to buy a few things to deliver on it20:10
Hydrant_should I just create a separate account for each project, and charge to it ?20:10
Hydrant_I'm not concerned with the human expense yet, just tracking equipment and other services that are purchased20:11
hoRni think  there isn't a 'balance' per project20:12
hoRni'm more a programmer - but i think you can do something similar with analytic account20:13
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton20:13
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton20:13
Hydrant_talking to a friend, they suggested we use a "memo account" which will let us track costs without affecting financial statements20:20
Hydrant_is there such a thing in Tryton ?20:20
hoRnHydrant: analytic_account?20:25
Hydrant_let me look at that20:26
Hydrant_thanks for bearing with me... I'm a complete n00b at this...20:26
hoRnme too ;)20:26
cedkHydrant_: I really think that you are looking for analytic account20:27
Hydrant_cedk: how do I create one?20:28
Hydrant_okay, chart of analytic accounts20:28
Hydrant_Tryton can use some more tool-tips I think20:29
hoRnif cedk confirms me, i'm right!20:29
Hydrant_like "what is a root account" as soon as I open up creating an analytic account20:29
Hydrant_I have a lot of accounting intimidation to overcome, and I think making Tryton a bit more comforable to work with will go a long way20:30
Hydrant_oh, I guess subaccounts... so project root... subproject and such20:30
cedkHydrant_: yes if you want20:30
cedkHydrant_: there is no rules to create analytic account, you do as you want20:30
Hydrant_okay.. so I have to supply a root and parent... but creating a root/parent requires me to have a root/parent ?20:32
cedkHydrant_: create first a root account20:33
Hydrant_how can I do that ?  It seems creating any analytic account requires one to already exist20:34
Hydrant_oh, type root20:35
Hydrant_there are some mysteries even here... what does the "mandatory" checkbox mean?20:35
-!- trifon( has joined #tryton20:36
cedkHydrant_: it means the this analytic account should be filled in every accounting documenent20:36
plantianHi, when I download a patch on codereview what is the best way to apply it?  Doing patch -i patchset.diff does not seem to be able to find the files in the diff.  Should I use additional options?20:39
cedkplantian: I think you must use -p120:40
plantiancedk: You are right thanks, I tried a -p 4 up to 9 I guess it was just the prefixed slash.20:42
Hydrant_what is the difference between payable/receivable and expense/revenue ?20:49
-!- Vladimirek(~vladimir@ has joined #tryton20:50
cedkHydrant_: payable/receivable it is what you must paid or receive from others20:51
cedkHydrant_: expense/revenue it is what you spent or earn20:51
Hydrant_okay.... so like a banking account20:52
Hydrant_my understanding is that I'd have an account for say: shipping fees20:52
Hydrant_and when I spend money to ship something, I credit (or debit?) from that account to be able to track my shipping expenses20:52
Hydrant_is that right ?20:52
cedkHydrant_: yes and also credit an account payable because you must pay someone20:54
Hydrant_okay... thanks for helping with what are likely very simple questions20:54
Hydrant_I'm building my chart of accounts now20:54
Hydrant_the account payable/receivable will literally just be a bank account right ?20:55
Hydrant_or would I use it for other things too ?20:55
cedkHydrant_: not really, because you should have account that represents the account in bank20:56
cedkHydrant_: because account in bank is like a the bank owe money20:57
cedkACTION bbl20:57
-!- heg( has joined #tryton20:58
hoRncedk: little question in between - my admin account looses always the company - is this a feature or a broken local installation?20:58
-!- pheller( has joined #tryton21:02
Hydrant_where can I download charts of accounts?  I remember there being a list of them online somewhere at one point but can't find it21:05
-!- sisalp( has joined #tryton21:20
cedkhoRn: this is strange21:38
cedkHydrant_: I don't know I guess it depends of your country21:39
sisalpback on a question from jcm this afternoon21:47
sisalpabout pdf reports.21:47
sisalpThis is the traceback I get :21:48
sisalp  File "/trytond/modules/company/", line 289, in parse21:48
sisalp    localcontext=localcontext)21:48
sisalp  File "/trytond/report/", line 242, in parse21:48
sisalp    data = self.convert_pdf(data)21:48
sisalp  File "/trytond/report/", line 277, in convert_pdf21:48
sisalp    doc = desktop.openFile(odt_name, hidden=False)21:48
sisalp  File "/openoffice/", line 150, in openFile21:48
sisalp    return self.openURL(url, **kw)21:48
sisalp  File "/openoffice/", line 144, in openURL21:48
sisalp    return self._desktop.loadComponentFromURL(url, target, 0, properties)21:48 URL seems to be an unsupported one.21:48
sisalpodono suggested about a missing dependency21:49
sisalpsorry udono ;-)21:49
sisalpany idea what to check ?21:49
sisalpI installed dependencies I found in apt-get -s install tryton-server21:53
sisalpthen I 'm running trytond from sources21:53
-!- ebanders( has joined #tryton21:56
-!- bechamel( has joined #tryton22:02
-!- pheller( has joined #tryton22:05
udonosisalp: check the issuetracker of there are some dependencies for debian listed22:08
udonoopenoffice dependencies22:08
sisalpThank you I go and read there22:08
sisalpwhy openoffice dependencies did not installed ?22:09
udonoACTION afk22:09
cedksisalp: it must be in the deps of openoffice-python22:12
sisalpinstalling and ...22:13
sisalpIt's ubuntu lts 10.04 minimal22:13
cedksisalp: how did you install openoffice-python ?22:13
sisalpthis way :22:15
sisalpapt-get install ca-certificates defoma dictionaries-common fontconfig fontconfig-config graphviz hicolor-icon-theme hunspell-en-us iso-codes libatk1.0-0 libatk1.0-data libavahi-client3 libavahi-common-data libavahi-common3 libcairo2 libcups2 libcurl3-gnutls libdatrie1 libdirectfb-1.2-0 libexpat1 libfontconfig1 libfontenc1 libfreetype6 libfribidi0 libgd2-noxpm libgdbm3 libgmp3c2 libgraphite3 libgraphviz4 libgstreamer-plugins-base0.10-0 libgstreamer0.10-22:15
cedksisalp: I don't see openoffice-python22:17
sisalp;-) I guess I messed it with python-openoffice22:18
sisalpE: Couldn't find package openoffice-python22:19
cedksisalp: I don't know the name of the package on Debian22:21
sisalpI'll check this point, nevertheless, installing draw and writer did the job and I got the pdf after restarting trytond22:27
sisalpby the way kill -9 on trytond did not free the net-rpc port22:28
sisalplooks like python-openoffice and openoffice-python are the same22:30
-!- pheller( has joined #tryton22:33
sisalpThank you very much for your help, I'll add draw and writer to my lllloooonnnngggg dependency list ;-)22:37
-!- pepeu(~manuel@ has joined #tryton22:39
-!- pheller( has joined #tryton22:57
cedksisalp: I think it is normal with kill -923:08
sisalphow do you stop it ?23:09
cedksisalp: just kill23:09
cedksisalp: which is kill -223:10
cedksisalp: by the way, kill -9 here allow to reuse the port23:10
sisalpyes it works, I use kill -2 from now23:11
sisalpiirc, kill -9 is mandatory with some versions of openerp, therefore i used to23:12
Hydrant_I spent some time investigating CRM today23:13
Hydrant_initially I wanted to go with SugarCRM... but apparently its licensing is rather deceptive and sleazy23:13
Hydrant_open source, with no features23:14
Hydrant_so... looking at Tryton now to see how suitable a substitute it could be23:14
cedkHydrant_: CRM is a large concept23:18
cedkHydrant_: Tryton doesn't handle every features you could expect23:18
cedkHydrant_: you should first define what you need23:19
Hydrant_for the most part I'm just looking at tracking sales leads, as we visit trade shows, get calls, and so on... and to ensure that everyone is on the same page for prospective sales23:20
cedkHydrant_: so the sale_opportunity module could be a good starting point23:21
Hydrant_yes, I've been exploring it23:22
Hydrant_and thinking on how to put together other services to get what I want... i.e. Alfresco for managing exchanged documents and records23:22
Hydrant_the advantage of having leads in Tryton is to maintain a single source for all party contacts, and also to be able to take a lead to generate a real sale, and manage through the rest of the process23:23
cedkHydrant_: yes of course23:24
cedkyangoon, dba: do you plan to package proteus for Debian?23:25
Hydrant_when I look at sales though... it asks for a warehouse... but I'm not shipping physical goods... at least not yet23:25
Hydrant_wha does that warehouse correspond to for me ?23:25
cedkHydrant_: we should improve the field to be only required when stockable product are sale23:27
cedkHydrant_: so you can just ignore it and let the default warehouse23:27
Hydrant_so the issue is that Tryton doesn't differentiate products yet then23:29
Hydrant_ACTION brain is hurting from a day of this stuff23:29
cedkHydrant_: it does in most part of the software but not for this field23:31
cedkHydrant_: you could fill an issue on roundup23:31
plantianIs it possible to sort a one2many in a model that inherits from ModelView only?  I use it in a wizard but select=1,2 does not seem to do anything.  Is the order of creation the only way to sort the relation ?23:49

Generated by 2.11.0 by Marius Gedminas - find it at!