[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: manojmisrasrmgpc at gmail.com


On Sat, Mar 29, 2014 at 4:34 AM, Jerwyn Fernandez [via Koha] <
ml-node+s1045719n5792600h71 at 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.