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
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
Hi Katrin, I join an example. I don't really understand because in the opac, i found my data (not in the order because i don't succeed to put all data in one line). What it gives on the opac (it's my test server http://koha.ecp.fr/cgi-bin/koha/opac-MARCdetail.pl?biblionumber=23822) I have the impression it reads the field 710$c. Samuel Le 14/12/2012 09:18, Fischer, Katrin a écrit :
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
participants (2)
-
Fischer, Katrin -
Samuel Desseaux