[Web-erp-developers] Fw: PHP Developer

[Daintree <p.d...@pa...>]

> Hi Jeff,
>
> No panic at all - just want to do it right really.
>
> Some more thoughts follow.....
>
> Have done a little more reading there are a number of different formats
> within EANCOM it seems that industry groups get together and decide which
> fields are appropriate and which not. The upshot is that two customers may
> well want EDI messages is slightly different formats - so we will have to
> set up a table(s) to define the message format to be used for a specific
> customer as well as customer specific branch mapping and part mapping
> tables. I think this will be as simple as
>
> EDI_BranchMapping
>
> DebtorNo - Customer Code 8 (or is it 10?) char
> BranchCode - our branch code 8 (or is it 10?)  char
> CustomerBranchCode char 20
>
> and
>
> EDI_PartMapping
>
> DebtorNo
> StockID
> CustomerStockID
>
> The tables to hold the message format particular to each customer is
another
> story - one that is yet to unfold!!
> The system will need to construct the EDI flat file from this table in
> conjunction with the data that makes up the invoice. Similarly the ORDER
> format message will have to be parsed based on the data in the ORDER
format
> definition for the customer. It will be quite tricky - but a great test!!
I
> will email you the pdf with the EANCOM general description of the ORDER
and
> INVOIC transactions tonight.
>
> Additional fields will be required in DebtorsMaster for
>
> EDIInvoices (bool) does the customer wish to receive EDI invoices
> EDIOrders (bool) does the customer wish to send EDI orders
> EDIName varchar(20)  - the EDIReference the customer uses
> EDITransport varchar(10) - email or ftp.
> EDIServer varchar(50) - email address or ftp server address
> EDIServerUserName varchar(50) ftp server username
> EDIServerPwd varchar(50) ftp server password
>
> We should make this customer EDI setup a seperate script to the normal
> customer entry screen - to avoid clutter most customers will probably not
be
> EDI ones - only the really biggies.
>
> I am thinking that the invoice printing script should have some ifs and
> another option to allow:
>
> 1. printing all invoices in the range
> 2. print only non-edi invoices in the range
> 3. print and send edi invoices in the range
> 4. print non-edi invoices and send edi invoices in the range
>
> The flat file produced using the edi invoice script would then be either
> emailed off as an attachment using html-mime-email class already in the
> system or ftp off to the customers edi server - php would have to be
> compiled with enable-ftp.
>
> Orders received as processed by the script running from cron (or some
> windows sheduler) should email the order number created to the customer
> service person - we will need a new config.php directive for the
> EDIOrders_Notify = cus...@co...; or some such. Perhaps
the
> order number should be in the subject with a blank body to save the
customer
> service person having to open the email to figure out the dispatch note to
> print.
>
> Hope this is not too gruesome as always as the extent of the requirements
> become more clear with some analysis the job gets more sizable!
>
> Phil
>
>
>
> ----- Original Message -----
> From: "Jeff Dyke" <jef...@ho...>
> To: <p.d...@pa...>;
> <Web...@li...>; <jd...@us...>
> Sent: Friday, January 30, 2004 4:44 AM
> Subject: Re: PHP Developer
>
>
> > Hey Phil.
> >
> > That sounds like a good task...yes, i'd be interested in the seeing the
> > format. and if you don't mind the table schema(s) that would be being
used
> > to retrieve the data to build the transfer.   i'll try to install your
> code
> > tonight so i can take a look at the db myself and take a look at the
> overall
> > functionality.
> >
> > All in all it sounds like a fun challenge, and i'd definitely be
> interested
> > in helping...what kind of time frame are you thinking about?
> >
> >
> > Thanks
> > Jeff
> >
> >
> > >From: Daintree <p.d...@pa...>
> > >Reply-To: Daintree <p.d...@pa...>
> > >To: Web-ERP Developers <Web...@li...>, Jeff
> > >Dyke <jd...@us...>
> > >Subject: Re: PHP Developer
> > >Date: Thu, 29 Jan 2004 08:31:03 +1300
> > >
> > >Thanks for your interest Jeff,
> > >
> > >There are  a number of areas of work....
> > >
> > >EDI
> > >
> > >I was thinking that a facility to create a flat file from a purchase
> order
> > >in the format described by EANCOM's Electronic Data Interchange would
> > >enable
> > >dispatch of EDI orders. This could be an option on the
> PO_PDFPurchOrder.php
> > >page if the supplier is defined as EDI enabled. The supplier master
would
> > >need some additional information regarding the transport mechanism -
> either
> > >email address or ftp - server address. Additional tables would be
> required
> > >to cross reference the item codes of the system to the item code of the
> > >supplier. I can send you the specification of the EANCOM Orders.
> > >
> > >Similarly, the sending of EDI sales orders from a customer to be
imported
> > >into a sales order. I figure this script will be a scheduled script
> running
> > >in the background to poll an email address and/or an ftp server's
> > >directory,
> > >to take the files in attachments and parse them into a sales order -
> again
> > >a
> > >translation table will probably be required for parts and customer
> > >branches.
> > >If there were orders uploaded, then a customer service person is
> emailed -
> > >perhaps defined in config.php - with the new order numbers created by
the
> > >script.
> > >
> > >This is a tricky area I think and may well be a bit of a mission. Was
> this
> > >the area you were interested in?
> > >
> > >Regards
> > >
> > >Phil
> > >
> > >----- Original Message -----
> > >From: "Jeff Dyke" <jd...@us...>
> > >To: <dai...@us...>
> > >Cc: <jd...@us...>
> > >Sent: Thursday, January 29, 2004 5:13 AM
> > >Subject: RE: PHP Developer
> > >
> > >
> > > >
> > > > Hello. I saw your help-wanted post and am interested. i've
> > > >
> > > > got about 4 years of solid php work(my project is posted at
> > > >
> > > > phpimageview.sourceforge.net).
> > > >
> > > >
> > > >
> > > > I enjoy working on conversion db->file and vise versa type
> > > >
> > > > tasks and have done a few.  i'd be interested in more
> > > >
> > > > information if the spot is still open.
> > > >
> > > >
> > > >
> > > > Thanks
> > > >
> > > > Jeff
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> > _________________________________________________________________
> > Let the new MSN Premium Internet Software make the most of your
high-speed
> > experience. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1
> >
> >
>