[Koha] Koha Item Number File Creation

[Charles Kelley]

Hello, all!

    Earlier today, 19 April 2021 at 7:52 AM, I wrote:

    I have been watching a video on batch item modifications <
> https://www.youtube.com/watch?v=USp2ucBh7gY>. According to the video
> there are three ways to identify the target items: (1) scan or type each
> barcode number into the textbox; (2) identify the compiled file of compiled
> barcodes of the targeted items; and (3) use the file of compiled item
> numbers.
>
>     I have sought information for compiling item record files, but I have
> been unsuccessful. How are such files compiled?
>

    In one exchange, on 19 April 2021 at 12:02 PM, Indranil Das Gupta wrote:

Most often - using a saved sql report from Koha's report module.
>
> Hope this helps,
>

    Yes, it does.

    I'm an idiot! I run enough reports. All I have to do is to SELECT the
proper field, items.itemnumber.

    In another exchange, 19 April 2021 at 12:24 PM, vikram zadgaonkar wrote:

You mean you want a report from koha to confirm item number update?


    No, I just wanted to know how to extract (SELECT in SQL jargon) the
item record number. I know the batch item modification propagates the
changes on the next CRON cycle. But the question helps clarify the issue.

    Thanks. These responses are most helpful.

-- 

    気を付けて。 /ki wo tukete/ = Take care.

    -- Charles.

    Charles Kelley, MLS
    PSC 704 Box 1029
    APO AP 96338

    Charles Kelley
    Tsukimino 1-Chome 5-2
    Tsukimino Gaadenia #210
    Yamato-shi, Kanagawa-ken
    〒242-0002 JAPAN

    +1-301-741-7122 [US cell]
    +81-80-4356-2178 [JPN cell]

    mnogojazyk at aol.com [h]
    cmkelleymls at gmail.com [p]

    linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
    Meeting Your Information Needs. Virtually.