MyOOS Community Support Forum | Shopsoftware | Webshop und E-Commerce Lösungen |

PHP Source code

  /**
   * Field Separator
   * change this if you can't use the default of tabs
   * Tab is the default, comma and semicolon are commonly supported by various progs
   * Remember, if your descriptions contain this character, you will confuse EP!
   */
   $separator = "\t"; // tab is default
   //$separator = ","; // comma
   //$separator = ";"; // semi-colon
   //$separator = "~"; // tilde
   //$separator = "-"; // dash
   //$separator = "*"; // splat


        $stampit_file = 'db_export_stampit-' . date('YmdHis') . '.cvs';
        $fp = fopen(OOS_EXPORT_PATH . $stampit_file, 'w');

        oos_set_time_limit(0);

        $schema = '';
        $schema .= 'Company' . $separator . 'Name' . $separator . 'Street' . $separator . 'Postcode' . $separator . 'City' . $separator . 'Country' .  "\n";


        $customerstable = $oostable['customers'];
        $address_booktable = $oostable['address_book'];
        $countriestable =  $oostable['countries'];

MySQL queries

        $sql = "SELECT c.customers_gender, c.customers_firstname, c.customers_lastname,
                       a.entry_company, a.entry_owner, a.entry_street_address, a.entry_suburb,
                       a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id,
                       a.entry_country_id,
                       c.customers_default_address_id, c.customers_status,
                       z.countries_id, z.countries_name
                 FROM  $customerstable c LEFT JOIN
                       $address_booktable a
                    ON c.customers_default_address_id = a.address_book_id,
                       $countriestable z
                 WHERE c.customers_login = '1'
                   AND a.customers_id = c.customers_id
                   AND z.countries_id = a.entry_country_id";

PHP Source code

        $customers_result = $dbconn->Execute($sql);

        $rows = 0;
        while ($customers = $customers_result->fields) {
          $rows++;

          $name = $customers['customers_firstname'] . ' ' .$customers['customers_lastname'];
          $name = str_replace($separator,' ',$name);
          $name = strip_tags($name);

          if (STORE_COUNTRY == $customers['entry_country_id']) {
            $country = '';
          } else {
            $country = $customers['countries_name'];
          }


          $schema .= $customers['entry_company']. $separator . $name . $separator . $customers['entry_street_address'] . $separator . $customers['entry_postcode'] . $separator . $customers['entry_city'] . $separator . $country . "\n";

          // Move that ADOdb pointer!
          $customers_result->MoveNext();
        }
          // Close result set
        $customers_result->Close();

        fputs($fp, $schema);
        fclose($fp);