oscom/trans.php

   1 <?
   2 /***************************************************************
   3 * $Id: trans.php,v 1.1 2004/06/29 08:50:30 hli Exp $
   4 *Author: Holger Lindemann
   5 *Copyright: (c) 2004 Lx-System
   6 *License: non free
   7 *eMail: info@lx-system.de
   8 *Version: 1.0.0
   9 *Shop: osCommerce 2.2
  10 *ERP: Lx-Office ERP
  11 ***************************************************************/
  12 require_once "DB.php";
  13 require_once "conf.php";
  14 $LAND=array("Germany"=>"D");
  15 $db=DB::connect($SHOPdns);
  16 if (DB::isError($db)||!$db) { $shop="<font color='red'>Fehler</font>"; } else { $shop="ok"; };
  17 $db2=DB::connect($ERPdns);
  18 if (DB::isError($db2)||!$db2) { $erp="<font color='red'>Fehler</font>"; } else { $erp="ok"; };
  19
  20 ?>
  21 <html>
  22         <head>
  23                 <title>Datenaustausch ERP-osCommerce</title>
  24         </head>
  25 <body>
  26 <center>
  27 <table>
  28         <tr>
  29                 <td colspan="2">
  30                         Eine direkte Verbindung beider Datenbanken ist erforderlich!<br>
  31                         Folgende Verbindungsdaten wurden gefunden:
  32                 </td>
  33         </tr>
  34         <tr>
  35                 <td>
  36                         <b>Lx-ERP</b>
  37                 </td>
  38                 <td><?= $erp ?></td>
  39         </tr>
  40         <tr>
  41                 <td>Datenbank-Server</td>
  42                 <td><?= $ERPhost ?></td>
  43         </tr>
  44         <tr>
  45                 <td>Datenbank</td>
  46                 <td><?= $ERPdbname ?></td>
  47         </tr>
  48         <tr>
  49                 <td>
  50                         <b>osCommerce</b>
  51                 </td>
  52                 <td><?= $shop ?></td>
  53         </tr>
  54         <tr>
  55                 <td>Datenbank-Server</td>
  56                 <td><?= $SHOPhost ?></td>
  57         </tr>
  58         <tr>
  59                 <td>Datenbank</td>
  60                 <td><?= $SHOPdbname ?></td>
  61         </tr>
  62         <tr>
  63                 <td colspan="2">
  64                         <hr>
  65                 </td>
  66         </tr>
  67         <tr>
  68                 <td align="center"><a href="shopimport_db.php"><img src="e2s.gif" border="0"></a></td>
  69                 <td align="center"><a href="oscomexport.php"><img src="s2e.gif" border="0"></a></td>
  70         </tr>
  71         <tr>
  72                 <td colspan="2">
  73                         <hr>
  74                 </td>
  75         </tr>
  76         <tr>
  77                 <td colspan="2">
  78                         F&uuml;r den Export der Artikeldaten aus der ERP in eine CSV-Datei<br>
  79                         oder den Import der Artikeldaten in den Shop ist nur die Verbindung<br>
  80                         zur entsprechenden      Datenbank notwendig.<br>
  81                         Die CSV-Dateien werden in den konfigurierten Verzeichnissen erwartet.<br>
  82                         Der Webserver ben&ouml;tigt hier Schreibrechte.
  83                 </td>
  84         </tr>
  85         <tr>
  86                 <td>
  87                         <b>Lx-ERP</b>
  88                 </td>
  89                 <td><a href="<?= $ERPdir ?>"><?= $ERPdir ?></a></td>
  90         </tr>
  91         <tr>
  92                 <td>
  93                         <b>osCommerce</b>
  94                 </td>
  95                 <td><a href="<?= $SHOPdir ?>"><?= $SHOPdir ?></a></td>
  96         </tr>
  97         <tr>
  98                 <td align="center"><a href="erpexport.php"><img src="e2c.gif" border="0"></a></td>
  99                 <td align="center"><a href="shopimport_csv.php"><img src="c2s.gif" border="0"></a></td>
 100         </tr>
 101         <tr>
 102                 <td colspan="2">
 103                         <hr>
 104                 </td>
 105         </tr>
 106         <tr>
 107                 <td colspan="2">
 108                         Copyright (c) 2004 Lx-System - Version: 1.0 - <a href="mailto:info@lx-system.de">info@lx-system.de</a>
 109                 </td>
 110         </tr>
 111 </table>
 112 </center>
 113 </body>
 114 </html>