Re: How to set html mail

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: How to set html mail

ExsonQu
Administrator
Tim and Phil:

Thank you very much for your nice help.

Since I have some problem to set sendmail in my Ubuntu server, I have to use other smtp server to send the mail, such as smtp.126.com.

My weberp version is 3.11.2, and my problem is that I can't send the PO in PO_PDFPurchOrder.php.

So I follow Tim's advice to edit the scripts of htmlMimeMail.php from the line 140 to 145

And the stmp_param setting is as following:

    $this->smtp_params['host'] = 'smtp.126.com';
        $this->smtp_params['port'] = 25;
        $this->smtp_params['helo'] = $helo;
        $this->smtp_params['auth'] = true;
        $this->smtp_params['user'] = 'exsonqu';
        $this->smtp_params['pass'] = '**********';

But I tried many times but it still failed.

I've found another version of the smtp, it's smtp5. and tried it's attached example scripts in the ubuntu WWW directory, it've succeed to send the example mail. The setting is the same with above in my opinion.

Is there any further comment about this?

Thanks and best regards!

Exson

2010/4/7 <[hidden email]>
Send web-ERP-users mailing list submissions to
       [hidden email]

To subscribe or unsubscribe via the World Wide Web, visit
       https://lists.sourceforge.net/lists/listinfo/web-erp-users
or, via email, send a message with subject or body 'help' to
       [hidden email]

You can reach the person managing the list at
       [hidden email]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of web-ERP-users digest..."


Today's Topics:

  1. CURRENCY MAINTENANCE warnings (Arwan)
  2. Re: How to set html mail (Tim Schofield)
  3. Re: How to set html mail (Phil Daintree)
  4. Re: CURRENCY MAINTENANCE warnings (Tim Schofield)
  5. Re: wrong period appears because of an unsuitable date format
     (Kalmer Piiskop)
  6. Re: wrong period appears because of an unsuitable date format
     (Tim Schofield)


----------------------------------------------------------------------

Message: 1
Date: Tue, 6 Apr 2010 22:10:39 -0800 (PST)
From: Arwan <[hidden email]>
Subject: [webERP-users] CURRENCY MAINTENANCE warnings
To: [hidden email]
Message-ID: <[hidden email]>
Content-Type: text/plain; charset=us-ascii


Hi
Am using weberp 3.11.2
Am getting the following 3 warnings each time I click the CURRENCY
MAINTENANCE link in setup
there are 3 identical warnings per currency defined on the currency table

Warning: file_get_contents() [function.file-get-contents]:
php_network_getaddresses: getaddrinfo failed: No such host is known. in
C:\EasyPHP5.2\www\webERP\includes\MiscFunctions.php on line 91

Warning:
file_get_contents(http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml)
[function.file-get-contents]: failed to open stream:
php_network_getaddresses: getaddrinfo failed: No such host is known. in
C:\EasyPHP5.2\www\webERP\includes\MiscFunctions.php on line 91

Warning: Invalid argument supplied for foreach() in
C:\EasyPHP5.2\www\webERP\includes\MiscFunctions.php on line 121


in configuration settings, Auto Update Exchange Rates Daily: is set to
manual

line 91 in include/miscfunctions.php

 $xml =
file_get_contents('http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml');

How can I stop the system from attempting to get exchange rates online ?

when the internet connection is on, there are no warnings and all is OK.

Thanks in advance

Arwan




--
View this message in context: http://n4.nabble.com/CURRENCY-MAINTENANCE-warnings-tp1753902p1753902.html
Sent from the web-erp-users mailing list archive at Nabble.com.



------------------------------

Message: 2
Date: Wed, 7 Apr 2010 09:28:48 +0100
From: Tim Schofield <[hidden email]>
Subject: Re: [webERP-users] How to set html mail
To: For the general discussion of webERP project
       <[hidden email]>
Message-ID:
       <[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1

Hi,

You need the variables in includes/htmlMimeMail.php at lines 140 to
145 to be set. Also, obviously whatever machine that you have as
$this->smtp_params['host'] needs to have sendmail or an equivalent
installed on it.

Thanks
Tim


On 6 April 2010 15:36, exson qu <[hidden email]> wrote:
>
> Dear all,
>
> ??????? Since my ubuntu systems has no wget installed. And I checked the
> manual which says that the scripts should be revised to send mail. I check
> the scripts and tried many times but still failed to set it. Is there
> anybody can help me to provide some material about the html mime mail or
> just how to set the scripts?
>
> ????????? Thanks and best regards!
>
> ????????? Exson Qu
>
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> web-ERP-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>



--
WebERP Africa Ltd
+447710427049
+255784602561
www.weberpafrica.com



------------------------------

Message: 3
Date: Wed, 07 Apr 2010 23:12:49 +1200
From: Phil Daintree <[hidden email]>
Subject: Re: [webERP-users] How to set html mail
To: For the general discussion of webERP project
       <[hidden email]>
Message-ID: <[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

I think you might be referring to the script to email sales analysis
reports ... if you open the script

MailSalesReport.php

with an editor you will see:

The intention is that this script is called from cron at intervals
defined with a command like:

/usr/bin/wget http://localhost/web-erp/MailSalesReport.php

The configuration of this script requires the id of the sales analysis
report to send
and an array of the receipients */

/*The following three variables need to be modified for the report - the
company database to use and the receipients */
/*The Sales report to send */
$_GET['ReportID'] = 2;
/*The company database to use */
$DatabaseName = 'weberp';
/*The people to receive the emailed report */
$Recipients = array('"Root" <root@localhost>','"' . _('someone else') .
'" <[hidden email]>');



It is reasonably self explanatory - you just set the $_GET['ReportID']
to the number of the sales report you wish to run, you set the
$Recipients array to the email addresses of the folks you wish to
receive the report and then set the report to run using wget from cron....

That's it .... provided you have PHP set up correctly to send mail using
a valid smtp server.If not you need to look at the mail settings in your
web-server's php.ini


Alan Jones wrote a much more elegant report runner script called

report_runner.php - if you open this script it says:

<?php
//--------------------------------------------------------------------
// report_runner.php
// This program is designed to run reports in batch command mode for
// weberp. Much thanks to Phil Daintree as the major author of WEBERP.
//
// --------------------------------------------------------------------
// Written by Alan B Jones ([hidden email])
// based on code orgiginally from weberp
// (c) alan jones 2006.
// (c) 2006 logic works Ltd and others
// licenced under the terms of the GPL V(2)
// if you want to know the details of the use of this software
// and how you are licenced to use it under the terms of the
// see here http://www.gnu.org/licenses/gpl.txt
//--------------------------------------------------------------------
//you must tell the script where you main installation is located
//Rememeber this is different for each location
//$weberp_home=/srv/www/htdocs/weberp
/* $Id: report_runner.php 3384 2010-03-13 16:22:42Z tim_schofield $*/

$usage="USAGE\n".$argv[0].":\n".
       "     -r reportnumber (the number of the weberp report)\n".
       "     -n reportname   (the name you want to give the report)\n".
       "     -e emailaddress[;emailaddress;emailaddres...] (who you
want to send it to)\n".
       "     -d database name (the mysql db to use for the data for the
report)\n".
       "     [-t reporttext ]  (some words you want to send with the
report-optional)\n".
       "     [ -H weberpHOME]  (the home directory for weberp - or edit
the php file)\n";



So you simply have:

report_runner.php -r $ReportNumberToRun -n $AnyNameForTheReport -e
$ColonSeparatedListOfEmailAddresses -d $MysqlDatabaseName -t $EmailText


Phil

>

> On 6 April 2010 15:36, exson qu <[hidden email]> wrote:
>> Dear all,
>>
>>         Since my ubuntu systems has no wget installed. And I checked the
>> manual which says that the scripts should be revised to send mail. I check
>> the scripts and tried many times but still failed to set it. Is there
>> anybody can help me to provide some material about the html mime mail or
>> just how to set the scripts?
>>
>>           Thanks and best regards!
>>
>>           Exson Qu
>>
>>
>> ------------------------------------------------------------------------------
>> Download Intel&#174; Parallel Studio Eval
>> Try the new software tools for yourself. Speed compiling, find bugs
>> proactively, and fine-tune applications for parallel performance.
>> See why Intel Parallel Studio got high marks during beta.
>> http://p.sf.net/sfu/intel-sw-dev
>> _______________________________________________
>> web-ERP-users mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>>
>>
>
>
>



------------------------------

Message: 4
Date: Wed, 7 Apr 2010 11:07:50 +0100
From: Tim Schofield <[hidden email]>
Subject: Re: [webERP-users] CURRENCY MAINTENANCE warnings
To: For the general discussion of webERP project
       <[hidden email]>
Message-ID:
       <[hidden email]>
Content-Type: text/plain; charset=ISO-8859-1

Hi Arwan,

I have corrected this in svn. The files you need are
SystemParameters.php and Currencies.php.

Thanks
Tim


On 7 April 2010 07:10, Arwan <[hidden email]> wrote:
>
> Hi
> Am using weberp 3.11.2
> Am getting the following 3 warnings each time I click the CURRENCY
> MAINTENANCE link in setup
> there are 3 identical warnings per currency defined on the currency table
>
> Warning: file_get_contents() [function.file-get-contents]:
> php_network_getaddresses: getaddrinfo failed: No such host is known. in
> C:\EasyPHP5.2\www\webERP\includes\MiscFunctions.php on line 91
>
> Warning:
> file_get_contents(http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml)
> [function.file-get-contents]: failed to open stream:
> php_network_getaddresses: getaddrinfo failed: No such host is known. in
> C:\EasyPHP5.2\www\webERP\includes\MiscFunctions.php on line 91
>
> Warning: Invalid argument supplied for foreach() in
> C:\EasyPHP5.2\www\webERP\includes\MiscFunctions.php on line 121
>
>
> in configuration settings, Auto Update Exchange Rates Daily: is set to
> manual
>
> line 91 in include/miscfunctions.php
>
> ?$xml =
> file_get_contents('http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml');
>
> How can I stop the system from attempting to get exchange rates online ?
>
> when the internet connection is on, there are no warnings and all is OK.
>
> Thanks in advance
>
> Arwan
>
>
>
>
> --
> View this message in context: http://n4.nabble.com/CURRENCY-MAINTENANCE-warnings-tp1753902p1753902.html
> Sent from the web-erp-users mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> web-ERP-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>



--
WebERP Africa Ltd
+447710427049
+255784602561
www.weberpafrica.com



------------------------------

Message: 5
Date: Wed, 07 Apr 2010 16:30:52 +0300
From: Kalmer Piiskop <[hidden email]>
Subject: Re: [webERP-users] wrong period appears because of an
       unsuitable      date format
To: [hidden email],
       [hidden email]
Message-ID: <[hidden email]>
Content-Type: text/plain; charset="us-ascii"

An HTML attachment was scrubbed...
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pandeero.vcf
Type: text/x-vcard
Size: 232 bytes
Desc: not available

------------------------------

Message: 6
Date: Wed, 07 Apr 2010 15:38:17 +0100
From: Tim Schofield <[hidden email]>
Subject: Re: [webERP-users] wrong period appears because of an
       unsuitable date format
To: [hidden email], For the general discussion of webERP project
       <[hidden email]>
Cc: [hidden email]
Message-ID: <1270651097.20340.2.camel@aglovale>
Content-Type: text/plain; charset="UTF-8"

Thanks Kalmer,

I had corrected the trunk for this, but not the stable. I have now
applied your fix to the stable branch as well.

Tim


On Wed, 2010-04-07 at 16:30 +0300, Kalmer Piiskop wrote:
> Kalmer Piiskop
--
WebERP Africa Ltd
+447710427049
+255784602561
www.weberpafrica.com




------------------------------

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

------------------------------

_______________________________________________
web-ERP-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-users


End of web-ERP-users Digest, Vol 47, Issue 8
********************************************


------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
web-ERP-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-users
Reply | Threaded
Open this post in threaded view
|

Re: How to set html mail

ExsonQu
Administrator
Dear Tim & Phil:

        Thanks for your nice help. I've solved the problem:

        The steps are as followed:

        1. set the default smtp param in htmlMimeMail.php as I mentioned last time.
            $this->smtp_params['host'] = 'smtp.126.com';
       $this->smtp_params['port'] = 25;
       $this->smtp_params['helo'] = $helo;
       $this->smtp_params['auth'] = true;
       $this->smtp_params['user'] = 'exsonqu';
       $this->smtp_params['pass'] = '**********';
         2. revise the scripts in PO_PDFPurchOrder.php
       (please refer to the Bold and Italic font)
             $mail = new htmlMimeMail();
             $mail->setCrlf("\r\n");
    $attachment = $mail->getFile($_SESSION['reports_dir'] . '/PurchOrder.pdf');
    $mail->setText( _('Please find herewith our purchase order number').' ' . $OrderNo);
    $mail->setSubject( _('Purchase Order Number').' ' . $OrderNo);
    $mail->addAttachment($attachment, 'PurchOrder.pdf', 'application/pdf');
   /**
$mail->setFrom($_SESSION['CompanyRecord']['coyname'] . "<" . $_SESSION['CompanyRecord']['email'] .">");
*/        
    $mail->setFrom('[hidden email]')
  /** some mail server request to verify the mail address.
   */
   
    $result = $mail->send(array($_POST['EmailTo']),'smtp');
   /** to use smtp instead of mail()
   */

   Thanks and best regards!

   Exson
2010/4/14 <[hidden email]>
Send web-ERP-users mailing list submissions to
       [hidden email]

To subscribe or unsubscribe via the World Wide Web, visit
       https://lists.sourceforge.net/lists/listinfo/web-erp-users
or, via email, send a message with subject or body 'help' to
       [hidden email]

You can reach the person managing the list at
       [hidden email]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of web-ERP-users digest..."


Today's Topics:

  1. Re: How to set html mail (exson qu)


----------------------------------------------------------------------

Message: 1
Date: Wed, 14 Apr 2010 22:19:49 +0800
From: exson qu <[hidden email]>
Subject: Re: [webERP-users] How to set html mail
To: [hidden email]
Message-ID:
       <[hidden email]>
Content-Type: text/plain; charset="iso-8859-1"

*Tim and Phil: *

Thank you very much for your nice help.

Since I have some problem to set sendmail in my Ubuntu server, I have to use
other smtp server to send the mail, such as smtp.126.com.

My weberp version is 3.11.2, and my problem is that I can't send the PO in
PO_PDFPurchOrder.php.

So I follow Tim's advice to edit the scripts of htmlMimeMail.php from the
line 140 to 145

And the stmp_param setting is as following:

   $this->smtp_params['host'] = 'smtp.126.com';
       $this->smtp_params['port'] = 25;
       $this->smtp_params['helo'] = $helo;
       $this->smtp_params['auth'] = true;
       $this->smtp_params['user'] = 'exsonqu';
       $this->smtp_params['pass'] = '**********';

But I tried many times but it still failed.

I've found another version of the smtp, it's smtp5. and tried it's attached
example scripts in the ubuntu WWW directory, it've succeed to send the
example mail. The setting is the same with above in my opinion.

Is there any further comment about this?

Thanks and best regards!

Exson



------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
web-ERP-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-users
Reply | Threaded
Open this post in threaded view
|

Re: How to set html mail

phildaintree
Thanks for posting the solution for others .... of course setting the
company email address to the same email address would have the same
effect. I am surprised you need to change the defaults in
htmlMimeEmail.php - I have never messed with this class and always been
able to get mail working by playing with the PHP configuration in php.ini

exson qu wrote:

> *Dear Tim & Phil:*
>
>         Thanks for your nice help. I've solved the problem:
>
>         The steps are as followed:
>
>         1. set the default smtp param in htmlMimeMail.php as I mentioned
> last time.
>             $this->smtp_params['host'] = 'smtp.126.com
> <http://smtp.126.com/>';
>        $this->smtp_params['port'] = 25;
>        $this->smtp_params['helo'] = $helo;
>        $this->smtp_params['auth'] = true;
>        $this->smtp_params['user'] = 'exsonqu';
>        $this->smtp_params['pass'] = '**********';
>          2. revise the scripts in PO_PDFPurchOrder.php
>        (please refer to the Bold and Italic font)
>              $mail = new htmlMimeMail();
>             / *$mail->setCrlf("\r\n");*/
>     $attachment = $mail->getFile($_SESSION['reports_dir'] .
> '/PurchOrder.pdf');
>     $mail->setText( _('Please find herewith our purchase order
> number').' ' . $OrderNo);
>     $mail->setSubject( _('Purchase Order Number').' ' . $OrderNo);
>     $mail->addAttachment($attachment, 'PurchOrder.pdf', 'application/pdf');
>   */ /**/*
> $mail->setFrom($_SESSION['CompanyRecord']['coyname'] . "<" .
> $_SESSION['CompanyRecord']['email'] .">");
> **/*        
>     */$mail->setFrom('[hidden email] <mailto:[hidden email]>')
>   /** some mail server request to verify the mail address.
>    */
> /*  
>     $result = $mail->send(array($_POST['EmailTo']),/*'smtp*'/);
>    /** */to use smtp instead of mail()/*
>    */
>
>    Thanks and best regards!
>
>    Exson
> 2010/4/14 <[hidden email]
> <mailto:[hidden email]>>
>
>     Send web-ERP-users mailing list submissions to
>            [hidden email]
>     <mailto:[hidden email]>
>
>     To subscribe or unsubscribe via the World Wide Web, visit
>            https://lists.sourceforge.net/lists/listinfo/web-erp-users
>     or, via email, send a message with subject or body 'help' to
>            [hidden email]
>     <mailto:[hidden email]>
>
>     You can reach the person managing the list at
>            [hidden email]
>     <mailto:[hidden email]>
>
>     When replying, please edit your Subject line so it is more specific
>     than "Re: Contents of web-ERP-users digest..."
>
>
>     Today's Topics:
>
>       1. Re: How to set html mail (exson qu)
>
>
>     ----------------------------------------------------------------------
>
>     Message: 1
>     Date: Wed, 14 Apr 2010 22:19:49 +0800
>     From: exson qu <[hidden email] <mailto:[hidden email]>>
>     Subject: Re: [webERP-users] How to set html mail
>     To: [hidden email]
>     <mailto:[hidden email]>
>     Message-ID:
>          
>      <[hidden email]
>     <mailto:[hidden email]>>
>     Content-Type: text/plain; charset="iso-8859-1"
>
>     *Tim and Phil: *
>
>     Thank you very much for your nice help.
>
>     Since I have some problem to set sendmail in my Ubuntu server, I
>     have to use
>     other smtp server to send the mail, such as smtp.126.com
>     <http://smtp.126.com>.
>
>     My weberp version is 3.11.2, and my problem is that I can't send the
>     PO in
>     PO_PDFPurchOrder.php.
>
>     So I follow Tim's advice to edit the scripts of htmlMimeMail.php
>     from the
>     line 140 to 145
>
>     And the stmp_param setting is as following:
>
>        $this->smtp_params['host'] = 'smtp.126.com <http://smtp.126.com>';
>            $this->smtp_params['port'] = 25;
>            $this->smtp_params['helo'] = $helo;
>            $this->smtp_params['auth'] = true;
>            $this->smtp_params['user'] = 'exsonqu';
>            $this->smtp_params['pass'] = '**********';
>
>     But I tried many times but it still failed.
>
>     I've found another version of the smtp, it's smtp5. and tried it's
>     attached
>     example scripts in the ubuntu WWW directory, it've succeed to send the
>     example mail. The setting is the same with above in my opinion.
>
>     Is there any further comment about this?
>
>     Thanks and best regards!
>
>     Exson
>
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> web-ERP-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
web-ERP-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-users
If anyone is wondering about the persistently nasty comments made by Tim Schofield and wants the full story please see: http://timschofield.blogspot.com/ Hell hath no fury like a woman (or Tim) scorned
Reply | Threaded
Open this post in threaded view
|

How to import bank statement

Rostislav Hučka
In reply to this post by ExsonQu
Hi guys,
we would really appreciate little help to make a script, which can
import bank statement in csv or fixed length format (GPC format) into
weberp. Is there any sample script, which can do that to help us adopt
it into our environment?
There is present in the statement either customer code or sales invoice
number or special unique per customer code in Address6 field. I would
like to make a table after import, where would be used data above to
match record to a customer, but for unclear or other bank records there
would be a possibility to add customer information or GL information.

Thank you very much

Rostislav Hucka
www.midgard.cz

------------------------------------------------------------------------------

_______________________________________________
web-ERP-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-users
Reply | Threaded
Open this post in threaded view
|

Re: How to import bank statement

phildaintree
This sounds like a really good initiative Rosta. Just thinking off the
top of my head:

I think the script would need to browse for the bank's output file for
reading in then parsing the file into a table showing the date,
narrative, reference, amount etc - which perhaps has three of links per
line

- code to GL
- code to a customer account
- code to a supplier account

The links would need to pull up scripts that allow the postings to be
processed.

The scripts would need to create the banktrans and flag the transactions
as reconciled - since they have cleared the bank! The subscripts would
need to enable selection of:

- a multiple of GL accounts
- a customer - of the same currency as the bank account or allow for
conversion to the customer's currency
- a supplier ... ditto.

respectively.

This would be an excellent addition to webERP. A script that selects a
file for parsing ... Z_ImportStocks.php

A script that allows selection of GL accounts and posts bank trans -
Payments.php


Phil

Rosta wrote:

> Hi guys,
> we would really appreciate little help to make a script, which can
> import bank statement in csv or fixed length format (GPC format) into
> weberp. Is there any sample script, which can do that to help us adopt
> it into our environment?
> There is present in the statement either customer code or sales invoice
> number or special unique per customer code in Address6 field. I would
> like to make a table after import, where would be used data above to
> match record to a customer, but for unclear or other bank records there
> would be a possibility to add customer information or GL information.
>
> Thank you very much
>
> Rostislav Hucka
> www.midgard.cz
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> web-ERP-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

------------------------------------------------------------------------------

_______________________________________________
web-ERP-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-users
If anyone is wondering about the persistently nasty comments made by Tim Schofield and wants the full story please see: http://timschofield.blogspot.com/ Hell hath no fury like a woman (or Tim) scorned