IRC logs of #tryton for Sunday, 2021-01-03 #tryton log beginning Sun Jan 3 12:00:01 AM CET 2021
-!- sisalp( has joined #tryton01:09
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton01:11
-!- McFloss_( has joined #tryton02:38
-!- Out`Of`Control( has joined #tryton02:43
-!- sisalp( has joined #tryton02:50
-!- lucascastro( has joined #tryton03:51
-!- semarie(~semarie@unaffiliated/semarie) has joined #tryton05:42
-!- LordVan(~lordvan@gentoo/developer/LordVan) has joined #tryton09:32
LordVanjust wondering09:38
LordVanhow does everyone deal with names .. in regards to sorting / .. and generating reports ..09:39
LordVanmeaining I want to sort by the main company name (or surname if ti is a private customer)09:39
LordVanbut of course on the invoice /.. i want to address as <tilte> <first name> <last name>09:39
LordVanbut when I make internal reports (production documents I would want <last name>, <first name>09:40
LordVan(in case of private .. similar for some companies09:40
LordVanI was thinking it is probably best to have a seperate field like sort_name/internal_name or whatever I call it09:40
LordVanso internal docs and lists are sorted like that and use the normal name field for the "proper" salutation,..09:41
LordVan[on 2nd thought while typing .. I might do it the other way around but never mind either]09:41
LordVanis this a "good" way to solve this or are there better ways to do this in trton?09:41
-!- alidipatrick(~alidipatr@ has joined #tryton09:42
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:50
LordVanhow difficult is it to change the default search (for parties) to not just serach name, but other fields too? like I want it to include a "nickname" field too (we got customers with long names that have shortcuts that everyone uses,..)10:05
cedkLordVan: it is just about extending the search_rec_name method10:09
cedkLordVan: but you can already use the identifier to store nickname10:09
LordVanah hadn't thought about that one10:09
LordVanbtw (duno if you did see what I wrote before you (re-) joined. but just curious .. how do you usually handle things like first name, last name and using them in different orders (like internal use is sorted - and printed- by last name, but for invoices,.. you address differently)10:10
LordVando people usually just add another field for internal use and/or external reports?10:11
LordVanor does it make more sense to store first/last name seperate and have methods that generate the form needed?10:11
LordVancedk, actually what do you mean identifier? (as in wich property/db field) .. identifiers is tax code and stuff?10:16
LordVannm i think you mean code don'T you?10:20
LordVanactually never mind that last line .. code is something else10:22
cedkLordVan: firstname, lastname is a bad design because not everybody has such10:25
LordVanyes i know10:25
cedkLordVan: I suggest you to embrasse the single Name10:25
LordVanjust is very common in a lot of software10:25
cedkLordVan: a lot of software are wrong10:26
cedkor just European centric10:26
LordVaneurope/usa ;)10:26
LordVancedk, to be honest before we had that discussion last year or so i did some reading .. and realized just how bad a design it10:26
LordVanso I think what i will do is I will add a second name field for internal docs10:27
LordVanwhich will contain the name how we use it internally instead of the (legal) full name of the person or company10:27
LordVan[I personally wouldn't mind using the proper one allt he time, but I have to go with user/employee acceptance on that .. and people do not like changes usually .. especially not big ones or lots at once]10:28
cedkLordVan: you can still use an identifier for that10:28
LordVancedk, you mean make my own identifier type/class for that?10:29
LordVanlike eu_vat,.. but like internal_name ?10:30
LordVani think .. that might be .. weird from a workflow/understanding point of view for people to be honest10:30
LordVanis there any benefit in doing that as opposed to just making a new field?10:30
cedkLordVan: that's the goal of identifiers provide alternative ID10:34
LordVanhmm yeah I see what you mean10:34
LordVanI worry though .. having to go to identifiers, there add a new one and then find "Internal Name" int he dropdown to add it is not a very .. straightfoward workflow10:35
LordVanI could add that somehow in the main party "screen" to just show one specific identifier there with a box to enter the internal/alternative name .. but I think that would be more difficult than adding a field for little/no added benefit?10:37
LordVanalso any queries would add another join with identifiers since i want that to be included in the main search on the UI10:38
-!- irclog( has joined #tryton10:38
LordVan[i doubt i will have any issues with performance because there are not a lot of users and only like 2k parties or so but still]10:39
LordVanI think I will add my own field for it .. since that is needed for nearly every single customer/party .. and going to have to add an identifier for everything is just going to be tedious on the end-user part10:41
LordVanthanks for the feedback though .. the idea with identifiers is interesting though might use that for something else10:41
LordVanimporting from dolibarr is not straightforward though ..there is a difference between parties and contacts ..(different way to handle contacts )10:52
LordVancedk, is there a way to link a parties contact_mechanism with specific addresses?10:53
LordVancedk, so that e.g. I do not import the employees of a company seperately as parties, but add them as a seperate address instead but link phone number/email?10:53
LordVan(i know i can put them there and add it as "name" for the contact_mechanism .. but I need to be able to match them for reports)10:54
LordVan[if that is not possible as-is I will probably just import all the company employees as parties too and use party_relationship to mark them as employees of that company10:54
LordVanunsure as to what is better10:54
LordVanusing addresses for employees would have the benefit of not having so many parties and also the UI is well suited for this. on the other hand having to create parties for each employee is extra (administrative) work ..10:55
LordVanI was thinking I could maybe implement something similar to user_role does (from a data Model point of view)11:02
LordVanand UI wise have a column added with a dropdown either below in the contact_mechanism section or at the top with the address where one can pick11:04
LordVan(importing it would be a bit of a pain though11:04
cedkLordVan: I can not answer, I do not know why you are storing the address of employees of customer companies11:48
LordVancedk, i do not need to store the address just names of the employiees12:27
LordVanbut i could "abuse" the address one to do that12:27
LordVanI need to somehow add the individual employees that we might need to contact about projects12:28
LordVanit would be making more sense (likely anyway) to add them as parties and use party_relationship12:28
LordVancedk, i was wondeirng .. would it be possible to maybe do some sort of voice call for a bit to clear up some of my questions on how to best do things? (of course i don't expect it for free)12:30
LordVan(should I have more questions that warrant it i mean)12:32
cedkLordVan: so for me it is a contact mechanism12:51
LordVancedk, I suppose you could put it like that ..12:55
LordVanin very rare cases I have various addresses for seperate customers (ie. sites for the company)12:55
LordVanbut those number so few it doesn't matter i guess12:55
cedkLordVan: so create multiple addresses12:56
LordVani just thought about it again too12:58
LordVanthe best way is to just add the employees as contact_mechanisms and in the few cases multiple addresses12:58
LordVanthat can then be matched manually12:58
cedkI still do not understand why you are mixing addresses and contact13:00
LordVanwell thinking about it .. in tryton i do not have to13:09
LordVanin dolibarr each contact had address, phone number,..13:09
LordVani was thinking in those ways still13:09
LordVanbut you are righ13:09
LordVanin 99% of the cases I have .. adding the employees to contact as contact_mechanism will be enough13:10
LordVanthe only (slight) pain is that an employee will have email, phone number maybe fax .. and i want all that is available printed on the report13:10
LordVanor is there a way to "group" contact_mechanisms ?13:11
cedkexcept by using a full party13:11
LordVanthat is what I thought13:11
LordVanso I have to decide if I use full party for all the contacts or if i create some way to group my contact_mechanisms13:12
LordVanbecause having the people who use it have to pick out all the relevant contact_mechanism when generating the (internal) report for production is not really an option13:12
cedkbut why would you need to group the contact mechanism, each is just one mechanism13:12
LordVanI need to print the phone number, email, fax,.. for each person on the reports13:13
LordVanin case there are qeustions about the order so that whoever has the qeustion has the details13:13
LordVan(I know in an ideal situation people would look it up in tryton .. but .. that is not going to happen)13:13
LordVan[to make it worse some people have multiple phone numbers too so .. I guess the only feasible way for me is to use a full party and party_relationship after all]13:14
LordVanand printing all contact_mechanisms for a party is not going to be feasible either for customers with more employees that order/are point of contact13:16
LordVanI will just have to use a full party for every contact. but thanks for the ideas .. but using contact_mechanisms would require me to do something to match stuff to a person,.. that is just way more (Development) effort than just creating full parties for everyone13:18
LordVanACTION goes to look for examples on how to attach notes to parties (for import purposes)13:20
LordVanhmm why can I not get the ir.note model?13:26
LordVanis that not possible in proteus?13:26
cedkLordVan: looks like the module user_role is not installed but it is registered in the database14:20
LordVanok i had installed that on a whim to test something14:25
cedkmainly the problem is that the model is still register in ir.model14:26
LordVanyes i reset my db to my "minimal testing state" anyway so the problem si gnoe14:31
LordVansince I haven't found it yet .. is there some XML dtd -- or exampel for the UI (for the XPATH expressions for views) .. ? - or a way to get it from the running instance?15:12
LordVan(considering themodular nature i do not really expect a DTD though ^^15:14
LordVanhmm how do I get/attach a note from/to a party?15:21
LordVanI can see how I get the party object when I have the note.. but the other way around .. eludes me15:21
LordVan(that is more of a curiousity thing since I only need to create notes for now - in case of import errors I dump the invalid data [possibly invalid formated phone numbers,..] in  notes ;)15:24
LordVanwhoever in dolibarr decided to export country names in french is a moron16:04
LordVangood that they export country codes too16:04
LordVanI have to say .. I love the automatic verification of contact mechanism and identifiers16:28
-!- lucascastro( has joined #tryton18:29
-!- lucascastro( has joined #tryton19:05
-!- mrichez(~Maxime@2a02:a03f:c2e8:f900:ed77:85ea:af2b:ba6e) has joined #tryton19:55
-!- alidipatrick(~alidipatr@ has joined #tryton20:39
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton22:34

Generated by 2.17.3 by Marius Gedminas - find it at!