[Koha] Sorting of accession numbers

[manoj382093]

Dear Friends,
I have used alphabets in barcode numerbers for different item types, now
when i have generated the accession register sorted by barcode it sort like
A1, A11, A12, A21.. etc instead of A1,A2,A3,A4.

Please help!


Manoj Kumar Misra



--
View this message in context: 
http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Sorting of accession numbers

[vikram zadgaonkar]

Hi
I think you should create different items type in system rather than
barcode for differentiating items.

Vikram Zadgaonkar


On Sat, Mar 29, 2014 at 9:50 AM, manoj382093 wrote:

> Dear Friends,
> I have used alphabets in barcode numerbers for different item types, now
> when i have generated the accession register sorted by barcode it sort like
> A1, A11, A12, A21.. etc instead of A1,A2,A3,A4.
>
> Please help!
>
>
> Manoj Kumar Misra
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> 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

Re: [Koha] Sorting of accession numbers

[Jerwyn Fernandez]

Hi Manoj,

Maybe what you are try to say,  you want to export your generated report
arranged by barcode? Am I right?

In that case you may edit your data through excel.

*Steps*

Step 1

Highlight the whole column of the "barcode"

Step 2

click cnrt+H

Step 3

Find what = A
Replace with = *note leave it blank

click Replace All

(so that you can remove the "A" symbol)

Step 4

Go to *Data* and sort your column to A - Z

Step 5

Make a new column beside the barcode column

then type ="A"&(the column with the number 1) then press enter

and then drag the formula to put A back

Regards,

- Jerwyn









On Sat, Mar 29, 2014 at 12:20 PM, manoj382093 wrote:

> Dear Friends,
> I have used alphabets in barcode numerbers for different item types, now
> when i have generated the accession register sorted by barcode it sort like
> A1, A11, A12, A21.. etc instead of A1,A2,A3,A4.
>
> Please help!
>
>
> Manoj Kumar Misra
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Jerwyn G. Fernadez
Basic Education Librarian
Southville International School and Colleges
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Sorting of accession numbers

[manoj382093]

Dear Friends,
Is there no way we can do it by SQL Command in report writing.

*Regards!*

*Manoj Kumar Misra*
M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.)
Deputy Librarian
SRMGPC
Lucknow
Mob. No.: 09415422579
Alternate E-mail: manojmisrasrm...@gmail.com


On Sat, Mar 29, 2014 at 4:34 AM, Jerwyn Fernandez [via Koha] <
ml-node+s1045719n5792600...@n5.nabble.com> wrote:

> Hi Manoj,
>
> Maybe what you are try to say,  you want to export your generated report
> arranged by barcode? Am I right?
>
> In that case you may edit your data through excel.
>
> *Steps*
>
> Step 1
>
> Highlight the whole column of the "barcode"
>
> Step 2
>
> click cnrt+H
>
> Step 3
>
> Find what = A
> Replace with = *note leave it blank
>
> click Replace All
>
> (so that you can remove the "A" symbol)
>
> Step 4
>
> Go to *Data* and sort your column to A - Z
>
> Step 5
>
> Make a new column beside the barcode column
>
> then type ="A"&(the column with the number 1) then press enter
>
> and then drag the formula to put A back
>
> Regards,
>
> - Jerwyn
>
>
>
>
>
>
>
>
>
> On Sat, Mar 29, 2014 at 12:20 PM, manoj382093 <[hidden 
> email]>wrote:
>
>
> > Dear Friends,
> > I have used alphabets in barcode numerbers for different item types, now
> > when i have generated the accession register sorted by barcode it sort
> like
> > A1, A11, A12, A21.. etc instead of A1,A2,A3,A4.
> >
> > Please help!
> >
> >
> > Manoj Kumar Misra
> >
> >
> >
> > --
> > View this message in context:
> >
> http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591.html
> > Sent from the Koha-general mailing list archive at Nabble.com.
> > ___
> > Koha mailing list  http://koha-community.org
> > [hidden email] 
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
>
> --
> Jerwyn G. Fernadez
> Basic Education Librarian
> Southville International School and Colleges
> ___
> Koha mailing list  http://koha-community.org
> [hidden email] 
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> --
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p5792600.html
>  To unsubscribe from Sorting of accession numbers, click 
> here
> .
> NAML
>




--
View this message in context: 
http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p5792647.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Sorting of accession numbers

[Doug Dearden]

Hi Manoj,

You might be able to parse out the pieces by using MySQL string functions: 
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html 

For instance, you could use the Left function to get the two characters at the 
beginning of the string, and the Mid function to get the rest of the 
characters, then sort on the first two, then on the rest.  

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of manoj382093
Sent: Sunday, March 30, 2014 9:54 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Sorting of accession numbers

Dear Friends,
Is there no way we can do it by SQL Command in report writing.

*Regards!*

*Manoj Kumar Misra*
M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.)
Deputy Librarian
SRMGPC
Lucknow
Mob. No.: 09415422579
Alternate E-mail: manojmisrasrm...@gmail.com


On Sat, Mar 29, 2014 at 4:34 AM, Jerwyn Fernandez [via Koha] <
ml-node+s1045719n5792600...@n5.nabble.com> wrote:

> Hi Manoj,
>
> Maybe what you are try to say,  you want to export your generated report
> arranged by barcode? Am I right?
>
> In that case you may edit your data through excel.
>
> *Steps*
>
> Step 1
>
> Highlight the whole column of the "barcode"
>
> Step 2
>
> click cnrt+H
>
> Step 3
>
> Find what = A
> Replace with = *note leave it blank
>
> click Replace All
>
> (so that you can remove the "A" symbol)
>
> Step 4
>
> Go to *Data* and sort your column to A - Z
>
> Step 5
>
> Make a new column beside the barcode column
>
> then type ="A"&(the column with the number 1) then press enter
>
> and then drag the formula to put A back
>
> Regards,
>
> - Jerwyn
>
>
>
>
>
>
>
>
>
> On Sat, Mar 29, 2014 at 12:20 PM, manoj382093 <[hidden 
> email]<http://user/SendEmail.jtp?type=node&node=5792600&i=0>>wrote:
>
>
> > Dear Friends,
> > I have used alphabets in barcode numerbers for different item types, now
> > when i have generated the accession register sorted by barcode it sort
> like
> > A1, A11, A12, A21.. etc instead of A1,A2,A3,A4.
> >
> > Please help!
> >
> >
> > Manoj Kumar Misra
> >
> >
> >
> > --
> > View this message in context:
> >
> http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591.html
> > Sent from the Koha-general mailing list archive at Nabble.com.
> > ___
> > Koha mailing list  http://koha-community.org
> > [hidden email] <http://user/SendEmail.jtp?type=node&node=5792600&i=1>
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
>
> --
> Jerwyn G. Fernadez
> Basic Education Librarian
> Southville International School and Colleges
> ___
> Koha mailing list  http://koha-community.org
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5792600&i=2>
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> --
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p5792600.html
>  To unsubscribe from Sorting of accession numbers, click 
> here<http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5792591&code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkyNTkxfC0xMDkzNzg1MDg0>
> .
> NAML<http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>




--
View this message in context: 
http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p5792647.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
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