[Koha-devel] problem with migration

[Hitorijime Aomori]

Hi.

Anyone can help me, because I have a little problem with the migration of the data bases into koha.

I'd already migrating to xml format, but really I don't know how can upload into koha( win version 2.0.0).

I hope anybody can help me.

bye

Andrea Díaz V.

Universidad de Viña del Mar

Chile



On Tue Jun 7 21:07 , address@hidden sent:

Send Koha-devel mailing list submissions to
address@hidden

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
address@hidden

You can reach the person managing the list at
address@hidden

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."


Today's Topics:

1. Re: Summary 2005-06-06 (Paul POULAIN)
2. question on aqorders table (Paul POULAIN)
3. Re: question on aqorders table (MJ Ray)
4. Bugsquash Session Next Week (Joshua Ferraro)
5. Koha 2.2.3 translation & roadmap & release notes (Paul POULAIN)
6. Re: question on aqorders table (Chris Cormack)

--__--__--

Message: 1
Date: Tue, 07 Jun 2005 09:49:49 +0200
From: Paul POULAIN <address@hidden>
CC: address@hidden
Subject: Re: [Koha-devel] Summary 2005-06-06

address@hidden a =E9crit :
> What have the koha developers been doing this week?

> joshferraro fixed bug 981 in opac-userdetails (missing comma - so did t=
ipaul?).

Really great summary.
Just one improvement and it will be perfect : separating what is done on=20
rel_2_2 (for 2.2.x) and what is done on HEAD.

--=20
Paul POULAIN
Consultant ind=E9pendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)


--__--__--

Message: 2
Date: Tue, 07 Jun 2005 12:55:32 +0200
From: Paul POULAIN <address@hidden>
To: address@hidden
Subject: [Koha-devel] question on aqorders table

Hi,

Could someone from katipo explain what is the meaning of the various=20
columns in aqorders table that are related to an amount.
I see :
* listprice (the price entered when placing the order ?)
* totalamount (seems always empty)
* freight (empty or=3D0 for me ? Maybe should be attached to the aqbasket=
=20
table if it's freight fees, as they should be counted only once)
* unitprice (the price really paid ?)
* rrp (?)
* ecost (?)
* gst (?)

Many thanks.

--=20
Paul POULAIN
Consultant ind=E9pendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)


--__--__--

Message: 3
Subject: Re: [Koha-devel] question on aqorders table
To: <address@hidden>,<address@hidden>
From: MJ Ray <address@hidden>
Date: Tue, 07 Jun 2005 13:04:25 +0100

Paul POULAIN wrote:
> Could someone from katipo explain what is the meaning of the various=20
> columns in aqorders table that are related to an amount.

I'm not katipo, but here's my impression.

> I see :
> * listprice (the price entered when placing the order ?)

The full catalgue price of the item (not including discounts)

> * totalamount (seems always empty)

I'd expect this to be unitprice*number ordered
after discounts and surcharges.

> * freight (empty or=3D0 for me ? Maybe should be attached to the aqbasket=
> table if it's freight fees, as they should be counted only once)
> * unitprice (the price really paid ?)
> * rrp (?)

Recommended retail price (not trade price).

> * ecost (?)
> * gst (?)

General sales tax (our local equivalent, VAT, is not paid on
books in the UK - don't know about TVA).

--
MJ Ray (slef), K. Lynn, England, email see http://mjr.towers.org.uk/
http://www.ttllp.co.uk/koha/


--__--__--

Message: 4
Date: Tue, 7 Jun 2005 05:43:04 -0700
From: Joshua Ferraro <address@hidden>
To: address@hidden
Organization: LibLime Library Solutions
Subject: [Koha-devel] Bugsquash Session Next Week

Hi everyone,

I caught paul, hdl slef and Genji on IRC today and we settled on next
Tuesday, June 14 at 15:00 GMT for the next Bugsquash Session. Here's
the time in your area: http://tinyurl.com/779cy

I count 68 bugs in Koha 2.2 and HEAD: http://tinyurl.com/as66z

We'll be working through the bugs, assigning the tough ones and fixing
the easy ones. If you can attend, please do (even if you can only
attend briefly).

(also, I must appologize to the NZ crowd, would you like to schedule
a different meeting later this week? Let me know)

--
Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE
President, Technology migration, training, maintenance, support
LibLime Koha ILS, Mambo Intranet, DiscrimiNet Filter
address@hidden | Full Demos at http://liblime.com | 1(888)KohaILS


--__--__--

Message: 5
Date: Tue, 07 Jun 2005 16:31:06 +0200
From: Paul POULAIN <address@hidden>
To: Koha-devel <address@hidden>,
Koha-translate <address@hidden>
Subject: [Koha-devel] Koha 2.2.3 translation & roadmap & release notes

Hello all,

TRANSLATION & ROADMAP
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D
Koha 2.2.3 is almost ready. Translators can/must work on their=20
translation files (.po)
You MUST update your translations file & check them. There are at=20
least[*] : 9 new strings and 23 fuzzy in OPAC and 17 untranslated / 29=20
fuzzy in default librarian template.

I plan to release Koha 2.2.3 next monday, so you have almost 1 week do=20
update your translations.

Reminder :
export PERL5LIB=3D/path/to/koha
./tmpl_process3.pl update -r -i ../../koha-tmpl/intranet-tmpl/default/en=20
-s po/default_intranet_your_language.po --exclude=3D.*unimarc.*
./tmpl_process3.pl update -r -i ../../koha-tmpl/intranet-tmpl/default/en=20
-s po/default_intranet_fr_FR.po

Once you have updated, commit the new po file, i'll take care of=20
tmpl_process3.pl install before releasing.

Note : for ppl that don't have cvs access, i can rebuild a .po file and=20
send it by mail.


[*] because i'm not 100% sure that my french translation file comes from=20
2.2.2b, it can be more recent, so there can be more strings to translate.


RELEASE NOTES
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D
The release notes should be the following (maybe more, but not less, all=20
what is written here is done & ready)

BUGFIXES
***** Critical & Minor mixed
=3D=3D=3D ACQUISITION =3D=3D=3D
* adding supplier info to basket.pl (for order printing)
* adding a date filter on acquisition history search

=3D=3D=3D OPAC =3D=3D=3D
* minor fix in subject link (normal view)

=3D=3D=3D CATALOGUE =3D=3D=3D
* it's possible to change a framework type when editing a biblio
* (critical) bugfix in authorities : in biblio repeated fields, when you=20
choosed an authority entries, it was copied in all the fields, not > in one.
* bugfix : when you duplicate a MARC field (for the 2nd time or more),=20
the last field was duplicated too.
* bugfix in subject link, in normal view
* bugfix when duplicate authority suspected, the link to see the other=20
authority was wrong.
* bugfix in items : the Edit biblio button was wrong.
* bugfix when MARC=3DOFF, subject modifs were not stored in MARC database=
.
* bugfix in z3950 client, for BNF (problem probably due to upgrading of=20
some sofwtare in UNIMARC)

=3D=3D=3D AUTHORITIES =3D=3D=3D
* bugfix in "next page" in authority search (was buggy under certain=20
circumstances only)

=3D=3D=3D CIRCULATION =3D=3D=3D
* bugfix : checking issuing rules under certain circumstances was buggy=20
(reported issuing OK where it should not)
* bugfix : renewal by issuing a book again did not work correctly.


=3D=3D=3D BORROWERS =3D=3D=3D
* better management of joining & expiry dates :
- dates can be manually typed when adding a borrower.
- Empty fields are automatically calculated (joining =3D today & expiry=20
date calculated from borrower category)
- Expiry date can be modified
* checking expiry date when trying to issue a book & forbidding issuing=20
when expiry date reached. ** IMPORTANT ** This check was not done=20
before. Thus, you may be unable to issue books where you could before.=20
You can update your database borrower by borrower or with the following=20
SQL command on the server : "update borrowers set expiry=3D'2005-31-12'".=
=20
You can limit the update to a borrower category with "update borrowers=20
set expiry=3D'2005-31-12' where categorycode=3D'A'" (all SQL commands mus=
t=20
be typed without any ")
* template improvements & some bugfixes in fines management.

=3D=3D=3D PARAMETERS =3D=3D=3D
* in marctagstructure, next & previous button no more loose=20
frameworkcode & link to default framework
=09
IMPROVEMENTS
=3D=3D=3D ACQUISITION =3D=3D=3D
* in history search, a filter has been added on order date.
* there are now 2 differents totals : one for rrp column & one for est=20
column

=3D=3D=3D CATALOGUE =3D=3D=3D
* There is also a FindDuplicate feature for MARC Authorities
* Dictionnary search : for titles, author & subject, there is now a=20
"dictionnary search". when the user clic on ..., a popup appear, that=20
enable search in biblios as well as in authorities. For example, if user=20
clic on author, and enter "Hugo", he will fing all authors & authority=20
having "Hugo". He then can choose the Hugo he want and run the search=20
with what he has found (& other criteria as well if he want)
* it's now possible to change the framework of a biblio
* the overduenotice.pl script (that sends a mail to borrowers with late=20
issues) contains the list of late items (title, author)

=3D=3D=3D PARAMETERS =3D=3D=3D
* a new button in marctagstructure.pl has been added : if selected, > actived fields/subfields are shown. Subfields used are in a summary just=20
under the tag. Strongly limits the number of lines shown & more user=20
friendly.
* Adding 2 checks in marc parameter checking : only 1 MARC tag must be=20
mapped to item tab and warning if there is NULL in a frameworkcode'

=3D=3D=3D REPORTS =3D=3D=3D
* in "borrowers with no issues" wizard, adding "without issues since"

=3D=3D=3D OPAC =3D=3D=3D
* basket / bookbag sending now has item list and an iso2709 file attached
* links to reach suggestions & virtual shelves from any OPAC page
* improvements in style sheet for better standard compliance. OPAC works=20
perfectly under opera & konqueror.
* added a systempref to define an alternate image as logo (for main page=20
& top-left image on each page)
* added a systempref to choose either to show or hide "lost" items. Note=20
that "lost items" can be related to an authorised value list, so does=20
not necessary mean "item definetly lost". Even here, some libraries want=20
to see lost items, and some don't want. This parameter will make=20
everybody happy !
* adding a "complete historyview" for subscription. Show year by year=20
all issues, whatever the status (arrived, missing...)

--=20
Paul POULAIN
Consultant ind=E9pendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)


--__--__--

Message: 6
Date: Wed, 08 Jun 2005 09:44:05 +1200
From: Chris Cormack <address@hidden>
Reply-To: address@hidden
Organization: Katipo Communications
To: MJ Ray <address@hidden>
Cc: address@hidden, address@hidden
Subject: Re: [Koha-devel] question on aqorders table

Hi all

MJ Ray has covered some of these, ill grab the ones not.

Freight, is post and packaging, its entered when the order is received.
unitprice = list price + tax + freight .. so yes the price really paid

ecost = estimated cost

Chris
--
Chris Cormack Katipo Communications
Programmer www.katipo.co.nz
027 4500 789



--__--__--

_______________________________________________
Koha-devel mailing list
address@hidden
https://lists.sourceforge.net/lists/listinfo/koha-devel


End of Koha-devel Digest