cashimportcfg.php

<?php

/*
 * LMS version 1.11-git
 *
 *  (C) Copyright 2001-2013 LMS Developers
 *
 *  Please, see the doc/AUTHORS for more information about authors!
 *
 *  This program is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License Version 2 as
 *  published by the Free Software Foundation.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,
 *  USA.
 *
 *  $Id$
 */

$patterns[] = array(
    'id' => null,   // import source identifier (from 'cashsources' table)
    'pattern' => "/^([^ ]+)\t([^ ]+)[\s\t]+([^ ]+)\t([^ ]+)\t(.*)/",
    'pid' => 0,     // customer ID position in expression
            // if zero - we try to search ID by regexp,
            // invoice number or customer name and forename in entire line
    'extpid' => false, // if true then we treat pid as customer id from external system

    'pname' => 2,   // name position
    'plastname' => 3,   // forename position
    'pvalue' => 4,  // value position
    'pcomment' => 5,    // operation comment position
    'pdate' => 1,   // date position
    'srcaccount' => null, // sender bank account position
    'dstaccount' => null, // receiver bank account position

    'date_regexp' => '/([0-9]{2})\.([0-9]{2})\.([0-9]{4})/', // date format (dd.mm.yyyy)
    'pday' => 1,
    'pmonth' => 2,
    'pyear' => 3,

    'pid_regexp' => '/.*ID[:\-\/]([0-9]{0,4}).*/i',     // if 'pid' is not specified
                                // try to find it by regexp

    'invoice_regexp' => '/.*(\d+)\/LMS\/([0-9]{4}).*/',// format of invoice number
                            // default %N/LMS/%Y
    'pinvoice_number' => 1, // position of invoice number in $invoice_regexp
    'pinvoice_year' => 2,   // year position in $invoice_regexp
    'pinvoice_month' => 0,  // month position in $invoice_regexp

    'comment_replace' => array(
        'from' => array('/^(.+)$/'),
        'to' => array('$1 (z rachunku: %srcaccount%, na rachunek: %dstaccount%, od klienta: %customername%)'),
    ),

    'encoding' => 'UTF-8',  // imported data encoding (for conversion)

    'modvalue' => 0,        // if not zero do value = value * modvalue
    'use_line_hash' => false,   // create md5 hash for whole import line instead of
                // time, value, customer name and comment
    'line_idx_hash' => false,   // include line number into hash data
    'filename_hash' => false,   // include source file name into hash data
);