Re: [Koha] invalid holding branch

14 Dec 2012

      Hi Samuel,

I don't see the record you tried to import - could you share it too? 

Katrin
...
-----Original Message-----
From: koha-bounces@lists.katipo.co.nz [mailto:koha-
bounces@lists.katipo.co.nz] On Behalf Of Samuel Desseaux
Sent: Thursday, December 13, 2012 4:54 PM
To: Koha@lists.katipo.co.nz
Subject: [Koha] invalid holding branch
Hi,
I keep this error during import
....Item not added (bib 25481, item tag #6, barcode ): invalid
holdingbranch  France
I don't see holdingbranch France.
I join to this message the notice.
In my database, when i look at the table, it gives that
<?xml version="1.0" encoding="utf-8"?>
<!--
- phpMyAdmin XML Dump
- version 3.3.7deb7
- http://www.phpmyadmin.net
-
- Serveur: localhost
- Généré le : Jeu 13 Décembre 2012 à 16:45
- Version du serveur: 5.1.49
- Version de PHP: 5.3.3-7+squeeze14
-->
<pma_xml_export version="1.0"
xmlns:pma="http://www.phpmyadmin.net/some_doc_url/">
      <!--
      - Structure schemas
      -->
      <pma:structure_schemas>
          <pma:database name="koha2" collation="utf8_unicode_ci"
charset="utf8">
              <pma:table name="branches">
                  CREATE TABLE `branches` (
                    `branchcode` varchar(10) NOT NULL DEFAULT '',
                    `branchname` mediumtext NOT NULL,
                    `branchaddress1` mediumtext,
                    `branchaddress2` mediumtext,
                    `branchaddress3` mediumtext,
                    `branchzip` varchar(25) DEFAULT NULL,
                    `branchcity` mediumtext,
                    `branchstate` mediumtext,
                    `branchcountry` text,
                    `branchphone` mediumtext,
                    `branchfax` mediumtext,
                    `branchemail` mediumtext,
                    `branchurl` mediumtext,
                    `issuing` tinyint(4) DEFAULT NULL,
                    `branchip` varchar(15) DEFAULT NULL,
                    `branchprinter` varchar(100) DEFAULT NULL,
                    `branchnotes` mediumtext,
                    `opac_info` text,
                    PRIMARY KEY (`branchcode`)
                  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
              </pma:table>
          </pma:database>
      </pma:structure_schemas>
<!--
      - Base de données: 'koha2'
      -->
      <database name="koha2">
          <!-- Table branches -->
          <table name="branches">
              <column name="branchcode">ECAM</column>
              <column name="branchname">ECP</column>
              <column name="branchaddress1"></column>
              <column name="branchaddress2"></column>
              <column name="branchaddress3"></column>
              <column name="branchzip"></column>
              <column name="branchcity"></column>
              <column name="branchstate"></column>
              <column name="branchcountry"></column>
              <column name="branchphone"></column>
              <column name="branchfax"></column>
              <column name="branchemail"></column>
              <column name="branchurl"></column>
              <column name="issuing">NULL</column>
              <column name="branchip"></column>
              <column name="branchprinter">NULL</column>
              <column name="branchnotes"></column>
              <column name="opac_info"></column>
          </table>
      </database>
</pma_xml_export>
If someone can light my way to solve it, it would be great. It's the
last step
best,
samuel

Re: [Koha] invalid holding branch

Fischer, Katrin