#idempiere IRC log for Sunday, 2015-02-01

*** hieplq has quit IRC01:17
*** RecordingBot` has joined #idempiere01:36
*** posde has quit IRC01:43
*** RecordingBot has quit IRC01:43
*** posde has joined #idempiere01:43
*** hieplq has joined #idempiere03:47
*** posde has quit IRC03:55
*** posde has joined #idempiere03:55
*** nmicoud has joined #idempiere06:17
*** a42niem has joined #idempiere07:30
*** fares has joined #idempiere07:34
fareshi07:34
*** fares has quit IRC07:34
*** a42niem has quit IRC07:34
*** fabiocanella has joined #idempiere07:48
*** fabiocanella has left #idempiere07:49
*** nmicoud has quit IRC08:14
*** fares has joined #idempiere09:10
fareshi09:11
faresi will read  adempiere 3.6 cookbook pdf  is it help me in idempiere?09:11
hieplqyes. i still help09:12
hieplqit is still help09:12
faresthanks09:13
*** fabiocanella has joined #idempiere09:20
*** fares has quit IRC09:20
*** fabiocanella has left #idempiere09:25
*** nmicoud has joined #idempiere11:20
*** nmicoud_ has joined #idempiere11:45
*** nmicoud has quit IRC11:48
*** nmicoud_ has quit IRC14:07
*** hieplq has quit IRC17:24
*** CarlosRuiz has joined #idempiere18:08
*** ChanServ sets mode: +o CarlosRuiz18:08
*** norbertbede has joined #idempiere19:02
norbertbedehi CarlosRuiz19:02
norbertbedecan i disturb you for i while19:02
*** tbayen has joined #idempiere19:18
CarlosRuizhi norbertbede19:30
norbertbedeim working on the design for DMS (document managment system) plugin19:32
norbertbedei worked lot with alfresco, and i found interesting re-use attribute set and attribute concept for DMS19:32
norbertbedelooks me not to complicated get first stage (meta data) handling in phase 1. later could be improved various, like indexint, file manipulation etc.19:33
norbertbedemy question where we stopped19:33
norbertbedeis where we made reverse engineering of attachement handling19:34
norbertbedeas result we found 1 e.g. product records = 1 attachement record. then file details are stored in xml in binary column19:34
norbertbedethat looks me problem when we design join each attachement attribute sets.19:35
norbertbedeat the end we have 2 solution19:35
norbertbede1. improve xml handling19:35
norbertbede2. deprecate xml handling and improve attachements where each uploaded attachement will have own record in ad_attachement19:36
norbertbedethen we can easily working with attachements19:36
norbertbedethe question is: what you mean replace attachement XML handling with solution 2 (1 attachement 1 ad_attachement record)19:37
norbertbedeneed your objective opinion here19:37
norbertbedeto continue properly19:37
norbertbedeWDYT ?19:38
tbayenHi19:39
norbertbedehi tbayen19:41
tbayenWhat is the difference between Business Partner field "Open Balance" and the result of the Open Items report?19:41
CarlosRuiznorbertbede, I have not used alfresco - and casually these days I've been thinking in a DMS plugin - so probably I would be heavily interested in working that with you if possible19:41
norbertbedeas i know openbalance is feild could be recalculated in batch. but system handle this value continuously on updates19:42
tbayenMy question is: Why are the values different?19:42
norbertbedeconsistency issue e.g. you merge business parnter19:43
norbertbedeCarlosRuiz. i have 2 A4 sites prepared. not yet finished but will share with you, because its quite important in short term for me19:43
tbayenThere are different values in the demo. There must be a reason for that, mustn't it?19:44
norbertbedetbayen must be same19:44
norbertbedetry to recalculate it19:44
norbertbedewith process19:44
norbertbedemaybe sw issue too19:45
norbertbedebug19:45
tbayenI see differences in the demo. Is this a bug in the demo database or am I missing something?19:46
tbayene.g. "C&W construction"19:46
norbertbedeIMHO could be sw issue or somebode used merge entities19:47
norbertbedemaybe others know more about this19:47
norbertbede:)19:47
norbertbedeworking for us well19:47
tbayenThanks for your confirmation that it should work and must be an issue.19:47
norbertbedein serious approach you must recalculate it to fit then test with transactions19:47
tbayenYes, I will do that now.19:48
norbertbedehope help19:48
norbertbedetbayen. an idea - offtopic19:48
tbayenyes?19:48
norbertbedewe are invited hieplq to slovakia for 1-2 month19:48
norbertbedethinking about make a round trip Slovakia>Italiy>France>Germany19:49
norbertbedeto meet others like Marko, Nmicoud. you etc.19:49
tbayenyes, fine! I would like to invite him! :-)19:49
norbertbedewe have submit all papers and credits to government and they must answer next week. if accept then we send papers to hiep and he should get visa in vietnam. then we sponsor his travel… let you know schedules19:50
norbertbedewe can maybe creates a small european meeting19:51
norbertbedesomewhere19:51
tbayenI think about having a conference this summer. There is only one point to clear before I begin planning it. Perhaps this fits together? If he comes earlier I am afraid he has to travel two times. :-D19:51
norbertbedewe requested 90 days in schengen.19:51
norbertbedeapplicable between february and juny or july dont rememver exactly19:52
norbertbedeso we can schedule travel well19:52
tbayenHmmm... perhaps I planned about june or august. But I would like to meet hieplq. That must be possible somehow.19:52
tbayenUp to now we should use what we have fixed. And that is your schedule. So I would like to invite him here. Tell me when there is a good time.19:53
norbertbedeok. i will let you know when he will have confirmed schengen VISA19:53
norbertbedeand we need buy flyticket. this time is when we need fix schedule definitively19:54
tbayenYou can be sure that I take part! :-)19:54
tbayenI did miss something important. :-( The "Open Balance" Field of "C&W" was 323,02. After running the validating process is was 324,13. The sum of the open items is 228,86.19:59
*** fabiocanella has joined #idempiere20:02
CarlosRuiztbayen, in demo.idempiere.com?20:02
tbayenYes.20:03
CarlosRuiztbayen, making the calculations manually I got very close to see that OpenBalance is correct20:10
tbayenHmm... I mixed something up. Give me some minutes to explain better.20:18
CarlosRuizworthy to check why not exact - the difference in my calcs is 1.1120:19
CarlosRuizinvoices = 1320,9520:19
CarlosRuizpayment = -864,3120:19
CarlosRuizdiscounts = 133.6220:19
tbayenI think this difference was introduced when I used the "business partner validate" process.20:19
CarlosRuiznorbertbede, I think the attachment table was originally designed for 1 attachment - and then maybe JJ (or somebody) improved it to save a zip and make it multi-file20:21
CarlosRuizwhat is the issue with the xml approach you have?20:22
norbertbedeFYI: quickly review my dms vision doc. sent you private for now20:23
norbertbedewhat is my problem with xml ?20:23
norbertbedeimagine i want to display attached documents on orders.20:24
norbertbedeat this moment we can see on first look what docs are attached to an order20:24
norbertbedei can imagine to create a simple tab type view listing all attachements, basic meta data etc.20:25
norbertbedebased on my knowledge something this cant be done20:25
norbertbedeother question is performance20:25
norbertbedebut i dont know its could be a potential issue, just wondering about20:26
norbertbedeplease ready my vision doc, and we can continue about this. is something what you plan too20:26
CarlosRuizI made a Proof of Concept 2 weeks ago for something similar - I created a table to keep "correspondence"20:30
CarlosRuizand the attachment was "in principle" related to this "correspondence" table20:30
CarlosRuizthe attributes idea sounds great - I didn't think about that in my POC20:31
CarlosRuizI made a table for document types - and the doctype have information about an optional sequence and an optional request category to trigger some basic request "workflow" for the item20:32
CarlosRuizI was thinking in a system where a receptionist receive i.e. an invoice vendor - scan it and trigger a workflow to approve and process the invoice in a company20:33
CarlosRuiznot sure if that's something alfresco cope with - or is a different system20:33
norbertbedei have luck, because adempiere is next generation solution founded by people sold out EMC20:39
CarlosRuiznorbertbede, about your question - I see there is a table ad_attachmentnote - it seems unused20:39
norbertbedeso conceptrs are great and i see lot reausable components including Workflow etc. (we implemented workflow across 12 countries and various departments)20:40
norbertbedethis table i think is not required in new concept20:40
norbertbedebecause all info related to a "content" is stored in attribute set20:40
CarlosRuizwe could make ad_attachmentnote work for your needs - one record for each file with the filename and attribute set20:41
norbertbedeyou can see idea where we found to attach in xml to attributes20:41
norbertbedejust doesnt exactly understand ad_attachmentnote20:42
norbertbedeapproach20:42
CarlosRuizI mean - you ask if we can make ad_attachment 1-1 to a record20:42
norbertbedeyep20:42
CarlosRuizand have multiple ad_attachment related to same record when you need multiple?20:42
norbertbedeso note could be 1:1 ?20:42
norbertbedeyou mean when we need multiple ad_attachements relate to a record ?20:43
CarlosRuizat this moment we allow that20:43
norbertbedehow20:44
CarlosRuizwhen in DB - the attachment record contains a zip file with all the attachments20:44
CarlosRuizwhen in filesystem - it's a list of files AFAIR20:44
norbertbedehm. this was review by tomassvikruha. hm20:45
CarlosRuizthat's why I think ad_attachmentnote as an extension of ad_attachment where you can keep information of each file20:45
norbertbedeok. but we can check it20:45
CarlosRuizwe don't touch ad_attachment - which will be hard as it will break many things (attachment store is pluggable)20:46
norbertbedeyes. but stay consistent we can keep data in ASI subsystem20:46
norbertbedeand drop this note concept20:46
CarlosRuizbut we can easily extend using ad_attachmentnote to keep filename+ASI info20:46
norbertbedeok. at the end its "just" technical part, dont need to change end user benefirs and overall concept20:47
norbertbedeif you mean ASI concept could be great then would be nice20:47
norbertbededid you read my doc ?20:47
norbertbedeallready20:47
CarlosRuizyes20:47
norbertbedethere is also a picture illustrate with collage how we could extend attachemtn and ASI window20:48
norbertbedeok20:48
CarlosRuizyep - exactly - you can show the attachmentnote related to the file in screen20:48
CarlosRuizin your picture where you read 4W003358.jpg - is a list of files20:48
norbertbedeyes20:49
norbertbedealthough could be attachement split also by small viewer20:49
norbertbedelisting attachemnt tuhmnails20:49
norbertbedethumbails20:49
CarlosRuizso - you could show the related attachmentnote for that file - attribute set and its corresponding ASI values at the right20:49
norbertbedebut idea is when switch file - make scoped - then user able change/update attraibutes20:50
CarlosRuizyep20:50
norbertbedeso no limitation, just reuse something could save our time20:50
CarlosRuizI think maybe worthy to implement a doctype - and the doctype has the ASI reference20:51
CarlosRuizand the user select the doctype instead of the attribute set20:52
norbertbedethinking too. just if we want to create a good DMS then not all docs are related to docs20:52
CarlosRuizyes - correspondence for example20:52
norbertbedelot docs could be just upluaded like brochures, manuals etc20:53
norbertbedeah yes20:53
*** fabiocanella has quit IRC20:53
norbertbedei prefer more attribute sets then doctypes for now20:53
norbertbedebut could be make pros/contra20:53
norbertbedesure20:53
CarlosRuizI think it will be easier for you to add new required things to the new doctype table - than trying to change the attribute set table20:54
norbertbedeim usually make vision then consult realisation study with develoer :)20:54
CarlosRuizmaybe we better call it contenttype to not confuse it with doctype20:54
norbertbedemy idea was asi subsystem is very complex and would be better reuse all as exists20:55
norbertbedecant imagine technically now how we then could joun together attributes and generate atrributeinstance per content20:55
norbertbedemaybe you have vision20:55
norbertbedecan you share your POC ? if reasonable20:58
CarlosRuizI mean - the contenttype table just have a reference to the attribute set for such content type - is the sae21:01
norbertbedei see look ok21:01
norbertbedeanother big question is folder structure21:01
CarlosRuizis the same as you thought - just adding a table in the middle to allow more parameters that probably you're going to need21:01
norbertbedeat this moment we creates storage provider for amazon S3.21:02
norbertbedefor better asseblility attachemnts for external webstore21:02
norbertbedethis way identify a fact21:02
CarlosRuizabout dropupload    http://books.zkoss.org/index.php?title=ZK_Component_Reference/Essential_Components/Dropupload   - seems at this moment is just available for ZKEE - so would need to develop some components to make it work21:02
norbertbedethis fact is idempiere automatically build his striucture baed on client>table>recordname21:03
norbertbedeif we wants to manage other content and make browsable interface for end users for human readabiulity then we need implement/split a meta level "folder structure"21:03
norbertbedealfresco also storing files in flat way like amazon S3 with uuid filenames.21:04
norbertbedebut user able creates folder structure21:04
CarlosRuizthe folder structure is managed by the plugin21:04
CarlosRuiznot mandatory to have client/org/table/record21:04
CarlosRuizindeed I think is wrong to have the org there  :-)21:05
CarlosRuizbut - you can define your storage plugin with a different structure and it works21:05
norbertbedewhich plugin, new one or exists21:05
CarlosRuiznew21:05
CarlosRuizfor example if you want to change the folder structure for the AttachmentFileSystem plugin - just copy it and change the getAttachmentPathSnippet method21:06
norbertbedethis folder structure also must be used when later an external small software display data for end user.21:08
norbertbedewe are using now sometjing like netdrive app able to map S3 or FTP as windows filesystem21:08
norbertbedeso if we give e.g. S3 proxy then any S3 compliant system could deliver content trough filesystem21:09
norbertbedeanother question is file versiononing. would be important claridy it at beginning. so 1 file could have multiple versions - latest will be preferred in displaying in interface21:10
norbertbedebut simple share various area, could be resolved21:10
CarlosRuizor having multi-attachments21:11
CarlosRuizwith version - this is the case where the contenttype intermediate table helps21:11
CarlosRuizyou define a parameter "versioned" in the contenttype table for these kind of docs21:12
CarlosRuizand your plugin can take care for example of version numbering and saving previous version when a new version is uploaded21:12
norbertbedelot ideas. when we start development ? (A)21:14
CarlosRuiz:D21:14
norbertbedei can assist, really know what a DMS require.21:14
norbertbedethis could be in base or plugin21:14
CarlosRuizI think a plugin will work better21:15
norbertbededo you need from my side additional infos. or updated POC document, where i describe other areas21:16
CarlosRuizmy time these days is very scarce - I can participate if you want - helping with code review, testing, and probably small development time21:18
norbertbedethen first we need create 1 POC doc21:19
norbertbedethen i can lead it and manage other areas21:20
norbertbedegoing to sleep. if you mean you have valueable POC please reply if possible. then i create 1 doc incudin our 2 docs and this chat22:07
norbertbedebye for no22:07
norbertbedew22:08
*** norbertbede has quit IRC22:15
*** jmpiloq_ has joined #idempiere22:17
tbayenCarlosRuiz, when you have some time can you have a look at IDEMPIERE-2435 and tell me what you think is the right way to solve it?23:34

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!