From: ExsonQu <hex...@gm...> - 2014-01-13 11:40:02
|
*Dear all:* Thank you for your long time nice support! I am wondering if anyone have any good idea to convert PO from one company's webERP to SO of another company's webERP. Currently, webERP has email, PDF, EDI to communicate with outside. Shall we find another solution for webERP communicate with each other? Is EDI the only way? Or we have to use the api to achieve this? Any comments are highly appreciated! Thanks and best regards! Exson -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |
From: Phil D. <ph...@lo...> - 2014-01-15 07:50:22
|
Hi Exson, I am sure I've done something like this before for a customer.... didn't think it would have generic applicability. However, I can't track it down now. It would need mapping of item codes between the businesses - producing a file or if the two systems are on the same server could be done directly between DBs. Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 14/01/14 00:39, ExsonQu wrote: > *Dear all:* > > Thank you for your long time nice support! > > I am wondering if anyone have any good idea to convert PO from one > company's webERP to SO of another company's webERP. > > Currently, webERP has email, PDF, EDI to communicate with outside. > Shall we find another solution for webERP communicate with each other? > > Is EDI the only way? Or we have to use the api to achieve this? > > Any comments are highly appreciated! > > Thanks and best regards! > > Exson > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > CenturyLink Cloud: The Leader in Enterprise Cloud Services. > Learn Why More Businesses Are Choosing CenturyLink Cloud For > Critical Workloads, Development Environments & Everything In Between. > Get a Quote or Start a Free Trial Today. > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
From: ExsonQu <hex...@gm...> - 2014-01-15 22:41:10
|
*Hi, Phil,* Thank you for your reply. I've googled the EDI information and find your article in webERP wiki website. It maybe a unique one in open source ERP? Shall we set up a standard/facility for communication between webERPs used by different company? Thanks and best regards! Exson -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657168.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |
From: Phil D. <ph...@lo...> - 2014-01-16 08:48:40
|
Yes would be good Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 16/01/14 11:40, ExsonQu wrote: > *Hi, Phil,* > > Thank you for your reply. > > I've googled the EDI information and find your article in webERP > wiki website. It maybe a unique one in open source ERP? > > Shall we set up a standard/facility for communication between > webERPs used by different company? > > Thanks and best regards! > > Exson > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657168.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > CenturyLink Cloud: The Leader in Enterprise Cloud Services. > Learn Why More Businesses Are Choosing CenturyLink Cloud For > Critical Workloads, Development Environments & Everything In Between. > Get a Quote or Start a Free Trial Today. > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
From: ExsonQu <hex...@gm...> - 2014-01-24 10:28:26
|
*Dear all:* Thank you very much for your feedback. After discuss with Steven, we bring out a proposal for this: 1. Add a QR code for PO pdf file, which contains all the information of the PO. (The QR code will be configurable of course) 2. Create a script to convert the QR code data to SO. One solution is use a QR reader of mobile device, another one is a QR code decoder(Not investigate yet) to parse QR code in the pdf file. Any comments are highly appreciated for this. Thanks and best regards! Exson -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657190.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |
From: gilberto d. s. a. <gs...@gm...> - 2014-01-24 14:12:17
|
on this link [1] i put some spreadsheet used for migrations and for build rules for source and target environments. Examples: PeopleSoft to SAP; SAP to legacy-Local-Home-system See that we map table,colum,attrib, (left side) (rule-number) on center and (target or to) (rigth side). Based on this all spreadsheet we build all sql need. All commands are ansi sql that could run on any ansi-sql-92 compliant. Data files may be .txt or .xml or .json transmitted by ftp or sftp or any webservice. we use curl / wget for send and receive operations. On windows command (AT) and on linux CRONTAB regards Please if any doubts we should discuss or explain. [1] https://docs.google.com/spreadsheet/ccc?key=0ArRGseydrhtydHRkdFFKcUJkaFVfeVkzU1BqOWI1MWc&usp=sharing 2014/1/24 ExsonQu <hex...@gm...> > *Dear all:* > > Thank you very much for your feedback. > > After discuss with Steven, we bring out a proposal for this: > > 1. Add a QR code for PO pdf file, which contains all the > information of the PO. (The QR code will be configurable of course) > > 2. Create a script to convert the QR code data to SO. One > solution is use a QR reader of mobile device, another one is a QR code > decoder(Not investigate yet) to parse QR code in the pdf file. > > Any comments are highly appreciated for this. > > Thanks and best regards! > > Exson > > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657190.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > CenturyLink Cloud: The Leader in Enterprise Cloud Services. > Learn Why More Businesses Are Choosing CenturyLink Cloud For > Critical Workloads, Development Environments & Everything In Between. > Get a Quote or Start a Free Trial Today. > > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > -- gilberto dos santos alves +55.11.98646-5049 sao paulo - sp - brasil |
From: ExsonQu <hex...@gm...> - 2014-01-25 00:40:58
|
*Hi, gilberto dos santos alves,* Thank you for your reply. My purpose is to provide a daily job solution for weberp users to transfer PO from another company's webERP system to their own SO. It should be as simple as operate another feature in webERP instead of data migration which need other expertise such as sql. I'm not sure your solution is workable for this purpose? Thanks and best regards! Exson gilberto dos santos alves wrote > on this link [1] i put some spreadsheet used for migrations and for build > rules for source and target environments. > > Examples: > > PeopleSoft to SAP; > > SAP to legacy-Local-Home-system > > See that we map table,colum,attrib, (left side) (rule-number) on center > and > (target or to) (rigth side). > > Based on this all spreadsheet we build all sql need. > > All commands are ansi sql that could run on any ansi-sql-92 compliant. > > Data files may be .txt or .xml or .json transmitted by ftp or sftp or any > webservice. we use curl / wget for send and receive operations. > > On windows command (AT) and on linux CRONTAB > > regards > > Please if any doubts we should discuss or explain. > > > > [1] > https://docs.google.com/spreadsheet/ccc?key=0ArRGseydrhtydHRkdFFKcUJkaFVfeVkzU1BqOWI1MWc&usp=sharing > > > 2014/1/24 ExsonQu < > hexinfans@ > > > >> *Dear all:* >> >> Thank you very much for your feedback. >> >> After discuss with Steven, we bring out a proposal for >> this: >> >> 1. Add a QR code for PO pdf file, which contains all the >> information of the PO. (The QR code will be configurable of course) >> >> 2. Create a script to convert the QR code data to SO. One >> solution is use a QR reader of mobile device, another one is a QR code >> decoder(Not investigate yet) to parse QR code in the pdf file. >> >> Any comments are highly appreciated for this. >> >> Thanks and best regards! >> >> Exson >> >> >> >> >> -- >> View this message in context: >> http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657190.html >> Sent from the web-ERP-developers mailing list archive at Nabble.com. >> >> >> ------------------------------------------------------------------------------ >> CenturyLink Cloud: The Leader in Enterprise Cloud Services. >> Learn Why More Businesses Are Choosing CenturyLink Cloud For >> Critical Workloads, Development Environments & Everything In Between. >> Get a Quote or Start a Free Trial Today. >> >> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk >> _______________________________________________ >> Web-erp-developers mailing list >> > Web-erp-developers@.sourceforge >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> > > > > -- > gilberto dos santos alves > +55.11.98646-5049 > sao paulo - sp - brasil > > ------------------------------------------------------------------------------ > CenturyLink Cloud: The Leader in Enterprise Cloud Services. > Learn Why More Businesses Are Choosing CenturyLink Cloud For > Critical Workloads, Development Environments & Everything In Between. > Get a Quote or Start a Free Trial Today. > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web-erp-developers@.sourceforge > https://lists.sourceforge.net/lists/listinfo/web-erp-developers -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657192.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |
From: gilberto d. s. a. <gs...@gm...> - 2014-01-25 07:58:31
|
hi! if you could abstract my suggestion of infraestructure you will see that it is a generic solution to connect anything. First step when you want provide a integration between b2b or b2c or b2w or enything you MUST map source and target information. Second step is map rules or roles that connect every piece of information (rules like transformation, conversion, translation). In old days we used EDI and current days we use JSON [1] or XML [2] more specific SOAP for handle all this. Third is build PL/SQL for this, to avoid someone to have know lots of programming language like C, PHP, PYTHON, RAILS, C#,C++,PASCAL... Unfortunatelly we do not have and ANSI PL/SQL for Databases. MYSQL use one, MSSQL user another, ORACLE another, SQLITE3 another dialects. This is main reason that we believe that CONNECTORS like these with SQL syntax is less expensive maintenance and CO$T for companies. MYSQL has capabilities that automatically start triggers and processing for replicate, insert, delete data on multiples instances of databases. In this url [3] you will find detailed doc schema of weberp database see volume of details for enforce integrity of data for 2 companies. See two phased commit concepts [4]. I understand that are many ways of doing things, but realtime systems like weberp, syncronous or assyncronous transactions [5]. regards! [1] http://en.wikipedia.org/wiki/JSON [2] http://en.wikipedia.org/wiki/XML [3] http://auvix.com.br/weberp-doc/ [4] http://en.wikipedia.org/wiki/Two-phase_commit_protocol [5] http://pic.dhe.ibm.com/infocenter/adiehelp/v5r1m1/index.jsp?topic=%2Fcom.ibm.etools.ctc.bpel.doc%2Fconcepts%2Fcsynch.html 2014/1/24 ExsonQu <hex...@gm...> > *Hi, gilberto dos santos alves,* > > Thank you for your reply. > > My purpose is to provide a daily job solution for weberp users to > transfer PO from another company's webERP system to their own SO. It should > be as simple as operate another feature in webERP instead of data migration > which need other expertise such as sql. I'm not sure your solution is > workable for this purpose? > > Thanks and best regards! > > Exson > > > > > > > > > > > > gilberto dos santos alves wrote > > on this link [1] i put some spreadsheet used for migrations and for build > > rules for source and target environments. > > > > Examples: > > > > PeopleSoft to SAP; > > > > SAP to legacy-Local-Home-system > > > > See that we map table,colum,attrib, (left side) (rule-number) on center > > and > > (target or to) (rigth side). > > > > Based on this all spreadsheet we build all sql need. > > > > All commands are ansi sql that could run on any ansi-sql-92 compliant. > > > > Data files may be .txt or .xml or .json transmitted by ftp or sftp or any > > webservice. we use curl / wget for send and receive operations. > > > > On windows command (AT) and on linux CRONTAB > > > > regards > > > > Please if any doubts we should discuss or explain. > > > > > > > > [1] > > > https://docs.google.com/spreadsheet/ccc?key=0ArRGseydrhtydHRkdFFKcUJkaFVfeVkzU1BqOWI1MWc&usp=sharing > > > > > > 2014/1/24 ExsonQu < > > > hexinfans@ > > > > > > > >> *Dear all:* > >> > >> Thank you very much for your feedback. > >> > >> After discuss with Steven, we bring out a proposal for > >> this: > >> > >> 1. Add a QR code for PO pdf file, which contains all the > >> information of the PO. (The QR code will be configurable of course) > >> > >> 2. Create a script to convert the QR code data to SO. One > >> solution is use a QR reader of mobile device, another one is a QR code > >> decoder(Not investigate yet) to parse QR code in the pdf file. > >> > >> Any comments are highly appreciated for this. > >> > >> Thanks and best regards! > >> > >> Exson > >> > >> > >> > >> > >> -- > >> View this message in context: > >> > http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657190.html > >> Sent from the web-ERP-developers mailing list archive at Nabble.com. > >> > >> > >> > ------------------------------------------------------------------------------ > >> CenturyLink Cloud: The Leader in Enterprise Cloud Services. > >> Learn Why More Businesses Are Choosing CenturyLink Cloud For > >> Critical Workloads, Development Environments & Everything In Between. > >> Get a Quote or Start a Free Trial Today. > >> > >> > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk > >> _______________________________________________ > >> Web-erp-developers mailing list > >> > > > Web-erp-developers@.sourceforge > > >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers > >> > > > > > > > > -- > > gilberto dos santos alves > > +55.11.98646-5049 > > sao paulo - sp - brasil > > > > > ------------------------------------------------------------------------------ > > CenturyLink Cloud: The Leader in Enterprise Cloud Services. > > Learn Why More Businesses Are Choosing CenturyLink Cloud For > > Critical Workloads, Development Environments & Everything In Between. > > Get a Quote or Start a Free Trial Today. > > > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk > > _______________________________________________ > > Web-erp-developers mailing list > > > Web-erp-developers@.sourceforge > > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657192.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > CenturyLink Cloud: The Leader in Enterprise Cloud Services. > Learn Why More Businesses Are Choosing CenturyLink Cloud For > Critical Workloads, Development Environments & Everything In Between. > Get a Quote or Start a Free Trial Today. > > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > -- gilberto dos santos alves +55.11.98646-5049 sao paulo - sp - brasil |
From: ExsonQu <hex...@gm...> - 2014-01-25 10:44:28
|
Hi, Tim and Gilberto dos santos alves, Thank you for your reply. The reason to raise QR code solution is from the SME's practice. Currently, there are not only Electric data exist in these business. There are at least fax, email, pdf, even mail. EDI is big player's practice, but our target users are not big companies. So we must find a pragmatic solution as webERP usually does. Paper documents still dominate most of SME. That's why we provide a QR proposal although there is no instance, but we can create it as a pragmatic solution. Thanks and best regards! Exson Hi, I am a bit out of touch but do any of the big ERP guys offer import/export via GR codes? If they do then what format do they put the data in? Remember however we export these documents there has to be plenty of client applications waiting to import them. It seems to me that even if they do, this is just the transport layer, and we still need to use a standard way of structuring the data. EDI is that international standard for such things http://en.wikipedia.org/wiki/Electronic_data_interchange Also EDI has the great advantage for us in that it has already has about half the implementation done in webERP. QR codes could be the transport mechanism for these documents but they are not the solution of how to structure the documents. Tim gilberto dos santos alves wrote > hi! if you could abstract my suggestion of infraestructure you will see > that it is a generic solution to connect anything. > > First step when you want provide a integration between b2b or b2c or b2w > or > enything you MUST map source and target information. > > Second step is map rules or roles that connect every piece of information > (rules like transformation, conversion, translation). In old days we used > EDI and current days we use JSON [1] or XML [2] more specific SOAP for > handle all this. > > Third is build PL/SQL for this, to avoid someone to have know lots of > programming language like C, PHP, PYTHON, RAILS, C#,C++,PASCAL... > > Unfortunatelly we do not have and ANSI PL/SQL for Databases. MYSQL use > one, > MSSQL user another, ORACLE another, SQLITE3 another dialects. > This is main reason that we believe that CONNECTORS like these with SQL > syntax is less expensive maintenance and CO$T for companies. > > MYSQL has capabilities that automatically start triggers and processing > for > replicate, insert, delete data on multiples instances of databases. > > In this url [3] you will find detailed doc schema of weberp database see > volume of details for enforce integrity of data for 2 companies. See two > phased commit concepts [4]. > > I understand that are many ways of doing things, but realtime systems like > weberp, syncronous or assyncronous transactions [5]. > > regards! > > > [1] http://en.wikipedia.org/wiki/JSON > [2] http://en.wikipedia.org/wiki/XML > [3] http://auvix.com.br/weberp-doc/ > [4] http://en.wikipedia.org/wiki/Two-phase_commit_protocol > [5] > http://pic.dhe.ibm.com/infocenter/adiehelp/v5r1m1/index.jsp?topic=%2Fcom.ibm.etools.ctc.bpel.doc%2Fconcepts%2Fcsynch.html > > > 2014/1/24 ExsonQu < > hexinfans@ > > > >> *Hi, gilberto dos santos alves,* >> >> Thank you for your reply. >> >> My purpose is to provide a daily job solution for weberp users >> to >> transfer PO from another company's webERP system to their own SO. It >> should >> be as simple as operate another feature in webERP instead of data >> migration >> which need other expertise such as sql. I'm not sure your solution is >> workable for this purpose? >> >> Thanks and best regards! >> >> Exson >> >> >> >> >> >> >> >> >> >> >> >> gilberto dos santos alves wrote >> > on this link [1] i put some spreadsheet used for migrations and for >> build >> > rules for source and target environments. >> > >> > Examples: >> > >> > PeopleSoft to SAP; >> > >> > SAP to legacy-Local-Home-system >> > >> > See that we map table,colum,attrib, (left side) (rule-number) on center >> > and >> > (target or to) (rigth side). >> > >> > Based on this all spreadsheet we build all sql need. >> > >> > All commands are ansi sql that could run on any ansi-sql-92 compliant. >> > >> > Data files may be .txt or .xml or .json transmitted by ftp or sftp or >> any >> > webservice. we use curl / wget for send and receive operations. >> > >> > On windows command (AT) and on linux CRONTAB >> > >> > regards >> > >> > Please if any doubts we should discuss or explain. >> > >> > >> > >> > [1] >> > >> https://docs.google.com/spreadsheet/ccc?key=0ArRGseydrhtydHRkdFFKcUJkaFVfeVkzU1BqOWI1MWc&usp=sharing >> > >> > >> > 2014/1/24 ExsonQu < >> >> > hexinfans@ >> >> > > >> > >> >> *Dear all:* >> >> >> >> Thank you very much for your feedback. >> >> >> >> After discuss with Steven, we bring out a proposal for >> >> this: >> >> >> >> 1. Add a QR code for PO pdf file, which contains all the >> >> information of the PO. (The QR code will be configurable of course) >> >> >> >> 2. Create a script to convert the QR code data to SO. >> One >> >> solution is use a QR reader of mobile device, another one is a QR code >> >> decoder(Not investigate yet) to parse QR code in the pdf file. >> >> >> >> Any comments are highly appreciated for this. >> >> >> >> Thanks and best regards! >> >> >> >> Exson >> >> >> >> >> >> >> >> >> >> -- >> >> View this message in context: >> >> >> http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657190.html >> >> Sent from the web-ERP-developers mailing list archive at Nabble.com. >> >> >> >> >> >> >> ------------------------------------------------------------------------------ >> >> CenturyLink Cloud: The Leader in Enterprise Cloud Services. >> >> Learn Why More Businesses Are Choosing CenturyLink Cloud For >> >> Critical Workloads, Development Environments & Everything In Between. >> >> Get a Quote or Start a Free Trial Today. >> >> >> >> >> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk >> >> _______________________________________________ >> >> Web-erp-developers mailing list >> >> >> >> > Web-erp-developers@.sourceforge >> >> >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> >> > >> > >> > >> > -- >> > gilberto dos santos alves >> > +55.11.98646-5049 >> > sao paulo - sp - brasil >> > >> > >> ------------------------------------------------------------------------------ >> > CenturyLink Cloud: The Leader in Enterprise Cloud Services. >> > Learn Why More Businesses Are Choosing CenturyLink Cloud For >> > Critical Workloads, Development Environments & Everything In Between. >> > Get a Quote or Start a Free Trial Today. >> > >> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk >> > _______________________________________________ >> > Web-erp-developers mailing list >> >> > Web-erp-developers@.sourceforge >> >> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> >> >> >> >> -- >> View this message in context: >> http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657192.html >> Sent from the web-ERP-developers mailing list archive at Nabble.com. >> >> >> ------------------------------------------------------------------------------ >> CenturyLink Cloud: The Leader in Enterprise Cloud Services. >> Learn Why More Businesses Are Choosing CenturyLink Cloud For >> Critical Workloads, Development Environments & Everything In Between. >> Get a Quote or Start a Free Trial Today. >> >> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk >> _______________________________________________ >> Web-erp-developers mailing list >> > Web-erp-developers@.sourceforge >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> > > > > -- > gilberto dos santos alves > +55.11.98646-5049 > sao paulo - sp - brasil > > ------------------------------------------------------------------------------ > CenturyLink Cloud: The Leader in Enterprise Cloud Services. > Learn Why More Businesses Are Choosing CenturyLink Cloud For > Critical Workloads, Development Environments & Everything In Between. > Get a Quote or Start a Free Trial Today. > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web-erp-developers@.sourceforge > https://lists.sourceforge.net/lists/listinfo/web-erp-developers -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657195.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |