Re: [Koha] invalid holding branch

2012-12-14 Thread Fischer, Katrin
Hi Samuel,

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

Katrin


 -Original Message-
 From: koha-boun...@lists.katipo.co.nz [mailto:koha-
 boun...@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=branchcodeECAM/column
   column name=branchnameECP/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=issuingNULL/column
   column name=branchip/column
   column name=branchprinterNULL/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

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] invalid holding branch

2012-12-14 Thread Samuel Desseaux

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-boun...@lists.katipo.co.nz [mailto:koha-
boun...@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=branchcodeECAM/column
   column name=branchnameECP/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=issuingNULL/column
   column name=branchip/column
   column name=branchprinterNULL/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


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] invalid holding branch

2012-12-13 Thread Samuel Desseaux

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=branchcodeECAM/column
column name=branchnameECP/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=issuingNULL/column
column name=branchip/column
column name=branchprinterNULL/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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] invalid holding branch

2012-12-13 Thread Samuel Desseaux

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=branchcodeECAM/column
 column name=branchnameECP/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=issuingNULL/column
 column name=branchip/column
 column name=branchprinterNULL/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

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha