Timestamps are in EET.
[0:26] * nebajoth (n=nebajoth@76-10-174-10.dsl.teksavvy.com) Quit ("Leaving")
[0:34] * elopio (n=elopio@200.122.185.199) Quit (Read error: 110 (Connection timed out))
[0:42] * mtaa1 (n=mtaal@ip5650ded8.direct-adsl.nl) Quit (Read error: 110 (Connection timed out))
[0:52] * ruoso (n=ruoso@201009087218.user.veloxzone.com.br) has joined #openbravo
[1:04] * jonw (n=jonw@201.170.238.32) has joined #openbravo
[1:09] * HUMA2000 (n=HUMA2000@62.43.188.78) Quit (Read error: 110 (Connection timed out))
[1:17] <CIA-44> OpenbravoPOS: adrianromero * r531 /trunk/src-pos/com/openbravo/pos/ (4 files in 2 dirs): Fixes issue 0007926: Customer Name field cannot contain '&' symbol.
[1:33] * trifon (n=chatzill@79.124.70.209) Quit (Read error: 110 (Connection timed out))
[1:36] * trifon (n=chatzill@79.124.70.209) has joined #openbravo
[1:40] * jonw (n=jonw@201.170.238.32) Quit (Remote closed the connection)
[4:06] * nebajoth (n=nebajoth@76-10-174-10.dsl.teksavvy.com) has joined #openbravo
[4:34] * nebajoth (n=nebajoth@76-10-174-10.dsl.teksavvy.com) Quit ("Leaving")
[4:34] * nebajoth (n=nebajoth@76-10-174-10.dsl.teksavvy.com) has joined #openbravo
[4:34] * nebajoth (n=nebajoth@76-10-174-10.dsl.teksavvy.com) Quit (Client Quit)
[4:51] * trifon (n=chatzill@79.124.70.209) Quit (Read error: 104 (Connection reset by peer))
[4:52] * trifon (n=chatzill@79.124.70.209) has joined #openbravo
[4:53] * etaylor (n=chatzill@p78-70.acedsl.com) has joined #openbravo
[5:11] * slimshock (n=digital@122.3.179.12) Quit ("Ex-Chat")
[6:00] * mtaal (n=mtaal@ip5650ded8.direct-adsl.nl) has joined #openbravo
[6:43] * Girish (i=3b61c136@gateway/web/ajax/mibbit.com/x-eba259db0eb0c99c) has joined #openbravo
[6:43] <Girish> Hello
[6:46] <Girish> I want to create the Document Number same as in Sales order.
[6:47] <Girish> In Bank Statement and in cash journal
[6:56] <Girish> How to solve this problem?
[8:29] * DMA02 (n=foo@194.126.6.206) has joined #openbravo
[8:49] * Girish (i=3b61c136@gateway/web/ajax/mibbit.com/x-eba259db0eb0c99c) Quit ("http://www.mibbit.com ajax IRC Client")
[9:41] * artem8990 (n=Miranda@194.158.202.123) has joined #openbravo
[12:41] * iciordia (n=ici@37.pool85-54-199.dynamic.orange.es) Quit ()
[13:19] * nebajoth (n=nebajoth@76-10-174-10.dsl.teksavvy.com) has joined #openbravo
[13:22] * Mahi (i=3b61c136@gateway/web/ajax/mibbit.com/x-da6110ba1db0df7a) has joined #openbravo
[13:23] <Mahi> how to calculate freight amount?
[13:27] * trifon (n=chatzill@79.124.70.209) Quit (Read error: 110 (Connection timed out))
[13:29] <Mahi> hi
[13:29] <Mahi> how to calculate freight amount?
[13:34] * artem8990 (n=Miranda@194.158.202.123) Quit ("Miranda IM! Smaller, Faster, Easier. http://miranda-im.org")
[13:43] * trifon (n=chatzill@79.124.70.209) has joined #openbravo
[14:19] * onats (n=onats@unaffiliated/onats) Quit (Remote closed the connection)
[14:21] * onats (n=onats@unaffiliated/onats) has joined #openbravo
[14:56] * Mahi (i=3b61c136@gateway/web/ajax/mibbit.com/x-da6110ba1db0df7a) Quit ("http://www.mibbit.com ajax IRC Client")
[15:08] * HUMA2000 (n=HUMA2000@62.43.188.78) has joined #openbravo
[15:45] * HUMA2000 (n=HUMA2000@62.43.188.78) Quit (Read error: 104 (Connection reset by peer))
[15:45] * [1]HUMA2000 (n=HUMA2000@62.43.188.78) has joined #openbravo
[15:45] * [1]HUMA2000 is now known as HUMA2000
[15:59] * HUMA2000 (n=HUMA2000@62.43.188.78) Quit (Read error: 104 (Connection reset by peer))
[15:59] * [1]HUMA2000 (n=HUMA2000@62.43.188.78) has joined #openbravo
[15:59] * [1]HUMA2000 is now known as HUMA2000
[16:50] * DMA02 (n=foo@194.126.6.206) Quit ("Leaving")
[17:27] <CIA-44> OpenbravoERP: Artem Zakolodkin <artem.zakolodkin <at> opensuite.com> default * 3432:25eb5c735c0e /src-db/database/ (model/functions/M_INOUT_POST.xml sourcedata/AD_MESSAGE.xml): Fixed bug 0007860: Error message while completing Goods receipt should be displayed more clear
[17:43] * elopio (n=elopio@200.122.185.199) has joined #openbravo
[18:08] * HUMA2000 (n=HUMA2000@62.43.188.78) Quit (Read error: 104 (Connection reset by peer))
[18:11] * HUMA2000 (n=HUMA2000@62.43.188.78) has joined #openbravo
[18:35] * [1]HUMA2000 (n=HUMA2000@62.43.188.78) has joined #openbravo
[18:35] * HUMA2000 (n=HUMA2000@62.43.188.78) Quit (Read error: 104 (Connection reset by peer))
[18:35] * [1]HUMA2000 is now known as HUMA2000
[18:52] * HUMA2000 (n=HUMA2000@62.43.188.78) Quit (Read error: 104 (Connection reset by peer))
[18:52] * HUMA2000 (n=HUMA2000@62.43.188.78) has joined #openbravo
[19:41] * HUMA2000 (n=HUMA2000@62.43.188.78) Quit (Read error: 104 (Connection reset by peer))
[19:41] * HUMA2000 (n=HUMA2000@62.43.188.78) has joined #openbravo
[20:22] * dash (n=washort@ampere.divmod.com) Quit (Read error: 110 (Connection timed out))
[20:22] * HUMA2000 (n=HUMA2000@62.43.188.78) Quit (Read error: 104 (Connection reset by peer))
[20:23] * HUMA2000 (n=HUMA2000@62.43.188.78) has joined #openbravo
[20:26] * dash (n=washort@ampere.divmod.com) has joined #openbravo
[21:08] * |ude (n=jerome@modemcable197.215-201-24.mc.videotron.ca) has joined #openbravo
[21:09] <|ude> Hi everyone
[21:12] <|ude> i am currently working on installing openbravo pos on a computer for my student's café. the base system is ubuntu 8.10 on a core 2 duo computer. As i am a Canadian, i must have summary taxes, but, until now i cannot figure how to do it. I do asign parent tax to child tax, but on the Sales screen, i only see the parent one and on the chekout it only calcultes the child one, any help would be welcomed
[21:15] * HUMA2000 (n=HUMA2000@62.43.188.78) Quit (Read error: 104 (Connection reset by peer))
[21:15] * [1]HUMA2000 (n=HUMA2000@62.43.188.78) has joined #openbravo
[21:16] * [1]HUMA2000 (n=HUMA2000@62.43.188.78) Quit (Client Quit)
[21:22] * MarvinTM_ (n=MarvinTM@34.112.218.87.dynamic.jazztel.es) Quit (kubrick.freenode.net irc.freenode.net)
[21:22] * MarvinTM_ (n=MarvinTM@34.112.218.87.dynamic.jazztel.es) has joined #openbravo
[21:46] * |ude (n=jerome@modemcable197.215-201-24.mc.videotron.ca) Quit ("Ex-Chat")
[21:53] * elopio (n=elopio@200.122.185.199) Quit (Read error: 110 (Connection timed out))
[21:56] * elopio (n=elopio@200.122.185.199) has joined #openbravo
[22:13] * Yorix (n=jorge@unaffiliated/yorix) has joined #openbravo
[22:14] <Yorix> i seem to be having some issues while adding a new field referencing a table in the products product tab in v2.4
[22:15] <Yorix> is anybody available for help?
[22:19] <katratxo> Yorix: what is the problem?
[22:20] <Yorix> ok im trying to add a field referencing a "working" window (table) in products tab
[22:21] <Yorix> and keep getting this stupid error in the compilation of the window
[22:21] <Yorix> let me paste it for you
[22:23] <Yorix> http://pastebin.ca/1365536
[22:23] <Yorix> the thing is that the window is working perfectly
[22:25] <Yorix> but i want to create a field in product that creates a combobox (references (tableDir) the primary key field of this table) like other fields with similar functionality in products tab, but buildWad action builds a wrong sql query
[22:26] <Yorix> i can also tell you where exactly is the error in the query theres an empty ELSE() in CUS_MOTOR_ID reference in the query
[22:26] <Yorix> i dont really know what i am doing wrong here
[22:27] <Yorix> im going blind here
[22:27] <katratxo> Yorix: first you don't need to compile the whole application for a change in a window
[22:28] <Yorix> i know
[22:28] <katratxo> use ant compile -Dtab=Window
[22:28] <Yorix> but that was the last compilation i did
[22:28] <katratxo> ok, if you are adding a field to a tab, i assume that you added a column to the table
[22:29] <Yorix> indeed, i was doing that, but i needed to try this complete compilation out of curiosity
[22:29] <Yorix> of course
[22:29] <Yorix> thats is why wad processing is ok
[22:29] <katratxo> ok, which is the colum name
[22:29] <Yorix> cus_motor_id
[22:29] <Yorix> in m_product
[22:31] <katratxo> if you use tabledir reference, you must follow the openbravo naming convention
[22:31] <Yorix> numeric(10)
[22:31] <Yorix> hmmm
[22:31] <katratxo> is there a cus_motor table? with a cus_motor_id field as a pk?
[22:31] <Yorix> indeed
[22:31] <Yorix> that is the new window table
[22:32] <Yorix> it is working
[22:33] <Yorix> i added some data after registering and compiling it
[22:33] <Yorix> just to check
[22:34] <Yorix> then when i go to product table, register the new field, sync terminology , create the new field in the window telling it to reference that field in that new table, this is when it happens
[22:37] <katratxo> ha. ok..
[22:37] <Yorix> the error is the building of the empty ELSE in the xsql file, this tells me either im doing sth wrong in registering the field or there is a bug in adding a field in products tab
[22:38] <katratxo> sorry, but let me try to understand it ...
[22:38] <katratxo> you have a new table cus_motor ... the pk is cus_motor_id
[22:38] <katratxo> then you added a new colum to the m_product table, cus_motor_id ...
[22:39] <katratxo> added the new colum to the table definition
[22:39] <katratxo> and picked, tabledir reference
[22:39] <katratxo> created a new field in the product tab
[22:39] <katratxo> and compiled the window...
[22:40] <katratxo> am i right?
[22:40] <Yorix> not exactly
[22:40] <Yorix> i created table cus_motor pk cus_motor_id
[22:40] <Yorix> registered table in OB
[22:40] <Yorix> created window
[22:41] <Yorix> registered window in table in OB and sync terminology
[22:41] <Yorix> compiled
[22:41] <Yorix> WINDOW WORKS!
[22:41] <Yorix> now
[22:41] <Yorix> added new column in table via sql
[22:41] <Yorix> registered new column in OB
[22:41] <Yorix> added new field in products tab
[22:41] <Yorix> sync terminology
[22:41] <Yorix> compiles
[22:42] <Yorix> its a NO NO!
[22:42] <katratxo> added new colum in table? which table?
[22:42] <Yorix> m_product
[22:42] <Yorix> in sql
[22:43] <Yorix> i need to add a field in the product tab that says what kind a motor it has
[22:44] <Yorix> same functionality as product category and such
[22:44] <Yorix> a combo that tells me what to select
[22:44] <Yorix> http://pastebin.ca/1365553
[22:45] <Yorix> this is the compilation of only the product tab
[22:45] <Yorix> notice that wad is processing window product with its fields correctly
[22:45] <Yorix> but errors jumps while processing xsql file
[22:48] <Yorix> spit those thoughts
[22:49] <katratxo> yeap, this xsql file is also generated by wad.... can you please double check the reference that you picked on the cus_motor_id on the m_product table?
[22:49] <Yorix> didnt undestand your request
[22:51] <Yorix> in tables and columns? in OB? or constraints in sql?
[22:51] <katratxo> check which reference did you choose on the cus_motor_id column, the one you added to the m_product table... in the application dictionary i mean
[22:54] <Yorix> its DB Column Name is CUS_Motor_ID and it references an application element called CUS_Motor_ID - Motor <- this DB columns name is also CUS_Motor_ID
[22:55] <Yorix> so the answer would be yes
[22:57] <katratxo> no, the application element is another thing... i asked for the reference that you picked... tabledir, table?
[22:57] <Yorix> tableDir
[22:57] <Yorix> sorry
[22:59] <katratxo> weird, because if you picked tabledir, wad will expect a cus_motor table... with a cus_motor_id as pk
[22:59] <katratxo> is there any column marked as identifier in the cus_motor table definition?
[22:59] <katratxo> or, do you have a name column in that table?
[23:02] <Yorix> to the first question NO, there is no field marked as identifier
[23:03] <katratxo> if you don't have a 'name' column in your table, you must check at least one column as indentifier
[23:03] <Yorix> ok
[23:03] <Yorix> doing that
[23:03] <katratxo> the data in that column will be displayed in the combo
[23:03] <Yorix> wich shall i mark as ident
[23:03] <Yorix> ??
[23:04] <Yorix> ho
[23:04] <Yorix> ok
[23:04] <Yorix> done
[23:04] <katratxo> recompile the window...
[23:04] <Yorix> doing that
[23:04] * katratxo prays
[23:06] <Yorix> processing windows......still nothing
[23:09] <Yorix> and SCORE!!!
[23:09] <Yorix> it compiled
[23:10] <Yorix> the identifier was the problem
[23:10] <katratxo> hehe.. katratxo 1 - WAD 0
[23:10] <Yorix> it was the only thing i was missing!!!
[23:10] <katratxo> i don't know how i remember that...
[23:11] <katratxo> i not a functional developer, do i don't make windows so often
[23:11] <katratxo> s/i not/i'm not
[23:11] <Yorix> i owe you man!!
[23:11] <katratxo> s/do/so
[23:11] <katratxo> no problem
[23:11] * katratxo is leaving
[23:11] <Yorix> me too
[23:11] <Yorix> thanx a lot ma
[23:12] <Yorix> man
[23:12] <Yorix> bye
[23:12] <katratxo> bye
[23:13] * Yorix (n=jorge@unaffiliated/yorix) Quit ("Saliendo")
These logs were automatically created by LogBot-vl on irc.freenode.net using the Java IRC LogBot.