IRC logs of #tryton for Friday, 2015-05-08

chat.freenode.net #tryton log beginning Fri May 8 00:00:01 CEST 2015
2015-05-08 00:08 <cedk> jade_: what repo?
2015-05-08 00:22 <jade_> sorry afk
2015-05-08 00:22 <jade_> im checking
2015-05-08 00:24 <jade_> i dont think you can help ced its openlabs
2015-05-08 00:24 <jade_> i might have to talk to sharoon
2015-05-08 00:24 <jade_> github.com:openlabs/nereid
2015-05-08 00:24 <jade_> but really id like to learn how to deploy a site similar to the one use as a demo on tryton.org
2015-05-08 00:26 <jade_> im building my personal landing page in django and i'd like to be able to connect tryton to it
2015-05-08 00:26 <jade_> im also buidling a django app that will be my ecommerce store for my mineral collection
2015-05-08 00:27 <jade_> but so far i can only get django installed locally from synaptic or apt
2015-05-08 00:27 <jade_> its giving me errors when i try to install into a virtual env
2015-05-08 00:29 <cedk> jade_: django and Tryton doesn't seem to be the good mix
2015-05-08 00:29 <cedk> jade_: you should probably use a lighter web framework like flaks, bootle or piramid
2015-05-08 00:30 <cedk> jade_: if you choose flask: https://pypi.python.org/pypi/flask_tryton
2015-05-08 00:31 <jade_> is django just too complex/unnecessary?
2015-05-08 00:31 <jade_> i was looking into flask at very first
2015-05-08 00:33 <jade_> i was also very curious about SAO but i couldnt get that to work either
2015-05-08 00:34 <jade_> also thank you for the advice
2015-05-08 00:36 <jade_> i also see this https://code.google.com/p/tryton/wiki/TrytonDjango
2015-05-08 00:37 <jade_> so its interesting you say they are not a good mix
2015-05-08 00:41 <jade_> i'm also very confused about how to use tryton on a vps, does trytond serve accessible web interface or do i have to build one?
2015-05-08 00:45 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2015-05-08 02:47 -!- smarro(~sebastian@190.105.93.196) has joined #tryton
2015-05-08 04:33 -!- digitalsatori(~Thunderbi@116.234.198.255) has joined #tryton
2015-05-08 04:45 -!- digitalsatori1(~Thunderbi@116.234.198.255) has joined #tryton
2015-05-08 04:55 -!- smarro(~sebastian@190.105.93.196) has joined #tryton
2015-05-08 05:23 <Jitesh_Nair> hey can any one tell me why we have inventories...if keeping track of products can be done by locations they y inventories...which are un-editable?
2015-05-08 06:04 -!- sunny_dealmeida(~quassel@203.115.76.28) has joined #tryton
2015-05-08 06:04 -!- digitalsatori(~Thunderbi@116.234.198.255) has joined #tryton
2015-05-08 06:41 -!- frispete_(~frispete@p54A90355.dip0.t-ipconnect.de) has joined #tryton
2015-05-08 07:00 <Jitesh_Nair> and how to open up product by location through proteus...i want to check the stock level in my warehouse
2015-05-08 07:00 <Jitesh_Nair> product by location is on wizard
2015-05-08 07:01 -!- yangoon(~mathiasb@p549F1739.dip0.t-ipconnect.de) has joined #tryton
2015-05-08 07:54 -!- Telesight(~anthony@4dafef36.ftth.telfortglasvezel.nl) has joined #tryton
2015-05-08 08:24 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton
2015-05-08 08:35 -!- digitalsatori(~Thunderbi@116.234.198.255) has joined #tryton
2015-05-08 09:03 -!- rpit(~ralf@2a02:908:e679:5340:3906:c3d8:bcea:d823) has joined #tryton
2015-05-08 09:08 -!- sunny_dealmeida(~quassel@203.115.76.28) has joined #tryton
2015-05-08 09:12 -!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton
2015-05-08 09:23 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2015-05-08 09:32 -!- michael-kohlhaas(~michael-k@unaffiliated/michael-kohlhaas) has joined #tryton
2015-05-08 09:32 -!- udono(~udono@ip-37-201-196-116.hsi13.unitymediagroup.de) has joined #tryton
2015-05-08 09:41 -!- digitalsatori(~Thunderbi@116.234.198.255) has joined #tryton
2015-05-08 10:09 -!- digitalsatori(~Thunderbi@116.234.198.255) has joined #tryton
2015-05-08 10:11 -!- digitalsatori(~Thunderbi@180.157.147.101) has joined #tryton
2015-05-08 10:11 <Jitesh_Nair> whcih is the module that pops up when we try to pay the invoice and it asks for journal type? it says "Pay invoice"
2015-05-08 10:12 <Jitesh_Nair> but may i know which module is that?
2015-05-08 10:14 <pokoli> Jitesh_Nair: it's the PayWizard in the account_invoice module
2015-05-08 10:16 <Jitesh_Nair> pokoli, PayInvoice(Wizard) <-- this class?
2015-05-08 10:16 <pokoli> Jitesh_Nair: yes
2015-05-08 10:16 <Jitesh_Nair> pokoli, how to work with a wizard in code?
2015-05-08 10:17 <Jitesh_Nair> pokoli, i successfully did it in UI
2015-05-08 10:17 <Jitesh_Nair> any snippets or examples in tests would do fine.
2015-05-08 10:17 <pokoli> Jitesh_Nair: proteus has a Wizard class to execute wizards
2015-05-08 10:17 <pokoli> Jitesh_Nair: but you have to understand how a wizard works
2015-05-08 10:18 <Jitesh_Nair> oh and where can i start with?
2015-05-08 10:18 <pokoli> Jitesh_Nair: http://doc.tryton.org/3.6/trytond/doc/topics/wizard.html?highlight=wizard
2015-05-08 10:18 <Jitesh_Nair> pokoli, i will look into it
2015-05-08 10:18 <pokoli> Jitesh_Nair: and every test scenario calls the install wizard on the first steps
2015-05-08 10:19 <Jitesh_Nair> yea i went through them
2015-05-08 10:30 -!- munron(~AndChat68@197.211.216.214) has joined #tryton
2015-05-08 10:39 -!- nicoe(~nicoe@balisto.wifi.b2ck.com) has joined #tryton
2015-05-08 10:48 <Jitesh_Nair> is there any way i can access the wizard 'account.invoice.pay' through proteus
2015-05-08 10:49 <Jitesh_Nair> i guess we can get only the base module account_invoice with wizard
2015-05-08 10:49 <Jitesh_Nair> are we suppose to use the pool of config and access it?
2015-05-08 10:50 <pokoli> Jitesh_Nair: http://hg.tryton.org/modules/sale/file/15a4426811f2/tests/scenario_sale.rst#l366
2015-05-08 10:51 <pokoli> Jitesh_Nair: grep is your friend :)
2015-05-08 10:52 <Jitesh_Nair> oh my bad!!!
2015-05-08 10:52 <Jitesh_Nair> pokoli, thanks mate
2015-05-08 11:03 <Jitesh_Nair> pokoli, thanks again man \m/
2015-05-08 11:29 -!- hiaselhans(~Thunderbi@212.186.50.97) has joined #tryton
2015-05-08 11:41 -!- sunny_dealmeida(~quassel@203.115.76.28) has joined #tryton
2015-05-08 12:41 -!- munron(~AndChat68@197.211.216.214) has joined #tryton
2015-05-08 13:04 -!- mariomop(~quassel@host247.181-14-156.telecom.net.ar) has joined #tryton
2015-05-08 13:06 -!- sunny_dealmeida(~quassel@203.115.76.28) has joined #tryton
2015-05-08 13:34 <rpit> Is there any module to do mass mailings?
2015-05-08 13:43 -!- kstenger(~karla@200.124.209.158) has joined #tryton
2015-05-08 13:44 <pokoli> rpit: there is some module to create mail from templates, but its a third party
2015-05-08 13:45 <cedk> rpit: correct mass mailing requires some technics
2015-05-08 13:45 <pokoli> rpit: https://bitbucket.org/nantic/profile/repositories?search=trytond-electronic
2015-05-08 13:45 <cedk> rpit: probably better to re-use existing solution and feed it with Tryton information
2015-05-08 13:49 <rpit> pokoli, cedk: thanks, I'll have a look at it
2015-05-08 14:15 <Jitesh_Nair> how to cancel an invoice
2015-05-08 14:15 <Jitesh_Nair> ?
2015-05-08 14:17 <Jitesh_Nair> which is not paid but in the posted state
2015-05-08 14:20 <pokoli> Jitesh_Nair: you have to create a refund
2015-05-08 14:20 <Jitesh_Nair> pokoli, but we dint make it paid right?
2015-05-08 14:20 <pokoli> Jitesh_Nair: customer invoice can not be canceled once posted
2015-05-08 14:20 <Jitesh_Nair> it is still unpaid
2015-05-08 14:21 <Jitesh_Nair> okk
2015-05-08 14:21 <Jitesh_Nair> pokoli, i will liik at it thanks
2015-05-08 14:23 <pokoli> Jitesh_Nair: there is a wizard for creating refunds, and it can reconcile invoice with refund automatically
2015-05-08 14:25 <Jitesh_Nair> sorry for typo its not likk its look at it :(
2015-05-08 14:26 <Jitesh_Nair> yup i will chek that wizard
2015-05-08 14:29 -!- Telesight(~anthony@4dafef36.ftth.telfortglasvezel.nl) has joined #tryton
2015-05-08 14:34 <Jitesh_Nair> pokoli, thanks CreditInvoice did it
2015-05-08 15:11 -!- pablovannini(~pablo@110-189-235-201.fibertel.com.ar) has joined #tryton
2015-05-08 15:27 -!- lukio(~lukio@110-189-235-201.fibertel.com.ar) has joined #tryton
2015-05-08 15:35 -!- prakashpandey(~prakashpa@103.245.118.154) has joined #tryton
2015-05-08 15:38 <prakashpandey> :pokoli hi
2015-05-08 15:40 <prakashpandey> pokoli: I was thinking if tryton could print what are the sql queries it is running while upgrading database
2015-05-08 15:41 <prakashpandey> pokoli: just like django-admin sql command
2015-05-08 15:43 <prakashpandey> :pokoli I patched psycopg2 cursor.execute to print the queries
2015-05-08 15:47 <prakashpandey> :cedk :nicoe ^
2015-05-08 15:49 <pokoli> prakashpandey: I usually patch trytond.backend.postgresql.cursor to do the same
2015-05-08 15:49 <pokoli> prakashpandey: whas you that last week asked about some accounts in account_es?
2015-05-08 15:50 <pokoli> prakashpandey: why you need such verbose sql output?
2015-05-08 15:50 <prakashpandey> pokoli: yes I did, no spanish so
2015-05-08 15:51 <pokoli> prakashpandey: i was not here, but i saw some question (that i don't remember), if you repeat it, i will answer it
2015-05-08 15:52 <prakashpandey> pokoli: solved that
2015-05-08 15:53 <prakashpandey> pokoli: upgrading running tryton instance leads to deadlock most of the time
2015-05-08 15:53 <pokoli> prakashpandey: deadlock on which table?
2015-05-08 15:54 <pokoli> prakashpandey: are you sure that anybody else is accessing the database?
2015-05-08 15:54 <prakashpandey> pokoli: table which is accessed by other users, deadlock will be wrong term
2015-05-08 15:56 <prakashpandey> pokoli: say any running tryton instance, on which users are still working
2015-05-08 15:56 -!- woakas(~woakas@static.13.240.46.78.clients.your-server.de) has joined #tryton
2015-05-08 15:57 <pokoli> prakashpandey: sorry don't understand
2015-05-08 15:58 <prakashpandey> pokoli: postgres will not allow you to make chnages to schema if it is already accessed by some user right?
2015-05-08 15:58 <pokoli> prakashpandey: AFAIK it will block and it may cause your deadlock
2015-05-08 15:58 <pokoli> s/your/a
2015-05-08 15:58 <prakashpandey> pokoli: yes or maybe a rollback
2015-05-08 16:00 <pokoli> prakashpandey: but you don't have any error message?
2015-05-08 16:00 <prakashpandey> pokoli: not right now, but most of them rollback
2015-05-08 16:01 <pokoli> prakashpandey: i will be interesed in the rollback message :)
2015-05-08 16:01 <pokoli> prakashpandey: from which version to which version are you migrating?
2015-05-08 16:01 <pokoli> prakashpandey: do you have custom modules?
2015-05-08 16:03 <prakashpandey> pokoli: its not module specific, it happens sometimes when you deploy new code to servers
2015-05-08 16:04 <prakashpandey> pokoli: On different note: what if i know queries what tryton gonna excute during upgrade and apply them directly?
2015-05-08 16:04 <prakashpandey> pokoli: it would be called an upgrade right?
2015-05-08 16:07 <pokoli> prakashpandey: whats your deploy procedure? deploy code and then update the database?
2015-05-08 16:08 <pokoli> prakashpandey: that's not possible because tryton database schema is dinamic depending on installed modules, so every time you a database update it's run it test if the required schema exist, and creates it if not exists
2015-05-08 16:09 <prakashpandey> pokoli: what If I run a dummy upgrade
2015-05-08 16:09 <prakashpandey> pokoli: which records sql
2015-05-08 16:09 <prakashpandey> pokoli: sql which is updating/creating/deleting
2015-05-08 16:10 <pokoli> prakashpandey: that can be possible, but in a copy database
2015-05-08 16:11 <prakashpandey> pokoli: hmm I realized, you cant do the sandbox upgrade
2015-05-08 16:12 -!- digitalsatori(~Thunderbi@114.92.196.106) has joined #tryton
2015-05-08 16:13 <prakashpandey> pokoli: copy database is not possible if db has active connection right?
2015-05-08 16:13 <pokoli> prakashpandey: yes and then you can come back with the error message
2015-05-08 16:13 <prakashpandey> pokoli: come back to you :p
2015-05-08 16:14 <prakashpandey> pokoli: anyway many thanks
2015-05-08 16:14 <pokoli> prakashpandey: you're welcome :)
2015-05-08 16:14 <prakashpandey> pokoli: you are always a saviour :)
2015-05-08 16:30 -!- prakashpandey(~prakashpa@103.245.118.154) has left #tryton
2015-05-08 17:08 -!- Telesight(~anthony@4dafef36.ftth.telfortglasvezel.nl) has joined #tryton
2015-05-08 17:30 -!- bvillasanti(~bvillasan@181.16.21.34) has joined #tryton
2015-05-08 19:05 -!- digitalsatori(~Thunderbi@114.92.196.106) has joined #tryton
2015-05-08 19:33 -!- Pilou(~Pilou@181.204.19.93.rev.sfr.net) has joined #tryton
2015-05-08 19:33 -!- Pilou(~Pilou@pdpc/supporter/active/pilou) has joined #tryton
2015-05-08 20:22 -!- bvillasanti1(~bvillasan@181.16.21.34) has joined #tryton
2015-05-08 20:43 -!- smarro(~sebastian@190.105.93.196) has joined #tryton
2015-05-08 22:34 -!- hiaselhans(~Thunderbi@212.186.50.97) has joined #tryton
2015-05-08 23:46 -!- hiaselhans1(~Thunderbi@212.186.50.97) has joined #tryton

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!