Menu
▾
▴
Re: [WebERP-developers] Convert PO to SO?
|
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 |
