Bar-code scanner gun to database? [Suse]

Prev: How to save the Firewall Zone setup for wireless Interface setting
Next: Big OpenGL problems

From: Pete Puma on 16 Apr 2008 01:27

Anyone with this experience recommend the right tools?
I have a zillion CDs and DVDs I'd like to zap into a database.

However, I don't know exactly what data to expect from the bar code label on
these things as there are different types of codes.
Any resources or references would help me. Easily over 2000 items and I type
like a chicken eats, so scanning is my only way out.

--
We have met the enemy, and he is us.
-- Walt Kelly

From: houghi on 16 Apr 2008 04:30

Pete Puma wrote:
> Anyone with this experience recommend the right tools?
> I have a zillion CDs and DVDs I'd like to zap into a database.
>
> However, I don't know exactly what data to expect from the bar code label on
> these things as there are different types of codes.
> Any resources or references would help me. Easily over 2000 items and I type
> like a chicken eats, so scanning is my only way out.

Barcodes are basicaly nubers. So you zould need to find a database that
links these numbers to the right records<

Better ask the question in a music group as it is unrelated to anything
softare. I believe that opendb is able to do it.

houghi
--

You are standing at the end of a road before a small brick building.
Around you is a forest. A small stream flows out of the building and
down a gully.

From: TGGA on 16 Apr 2008 15:54

Some being by the name of Pete Puma managed to piece together the following:

> Anyone with this experience recommend the right tools?
> I have a zillion CDs and DVDs I'd like to zap into a database.
>
> However, I don't know exactly what data to expect from the bar code label
> on these things as there are different types of codes.
> Any resources or references would help me. Easily over 2000 items and I
> type like a chicken eats, so scanning is my only way out.
>

You need to find out the barcode encoding type, probably either 3 of 9, 128
or ?UPEAN? (can't remember the name) - 128 is very common now and covers
all ascii characters. You then need to find out exactly what is stored in
the barcode, for instance is there only 1 piece of information, or more?
Then program up a barcode reader to read the info. Depending on what
barcode reader you get, it will either be a "wedge" or a stand alone unit,
you will either be able to scan in real time through software (using a
wedge type) or batch using the stand alone.

The wedge type normally plugs betwen keyboard and computer, when you scan
it's as though you're typing. With stand alone you scan the detail into the
devices memory and then download the information into an ascii file for
import.

I'd guess that you will want the wedge type. It's large subject really, have
a google round.

--
I'm a dyslexic satanist, I worship the drivel... must be why I'm here

From: Uwe Grauer on 16 Apr 2008 17:15

From: Moe Trin on 16 Apr 2008 20:43

On Wed, 16 Apr 2008, in the Usenet newsgroup alt.os.linux.suse, in article
<I6gNj.6371$eg2.1353(a)trndny06>, Pete Puma wrote:

>Anyone with this experience recommend the right tools?
>I have a zillion CDs and DVDs I'd like to zap into a database.
>
>However, I don't know exactly what data to expect from the bar code
>label on these things as there are different types of codes.

Look at the bar-code. Along the top and/or bottom, you'll see a
string of numbers such as

ISBN 1-7907-8176-X
|| l|lIl |I| |l|l||| | I|ll|| ll|| ||
|| l|lIl |I| |l|l||| | I|ll|| ll|| ||
|| l|lIl |I| |l|l||| | l|ll|| ll|| ||
0 85392 79182 8

which is the bar-code off the Looney Tunes Golden Collection Volume 1
DVD that has your nym co-staring in "Rabbit's Kin" on disc 1. If you
scan that bar-code, you'll get the bottom number which is the product
code. If you want the product _description_ from that, you'll have to
find a copy of the manufacturers database, look up the product number,
and there's the description.

>Any resources or references would help me. Easily over 2000 items and
>I type like a chicken eats, so scanning is my only way out.

Someone is going to have to type - or be cutting and pasting a lot.
All the bar-code is is just another way to write (machine readable) the
same numbers - so if '0 85392 79182 8' doesn't mean a thing to you,
the bar-code is going to decode into the same useless numbers.

>We have met the enemy, and he is us.
> -- Walt Kelly

So hit google, and search for 0-671-21260-5 which is the ISBN for the
Simon and Schuster paperback of that book - or you could look up the
LOCUS number which is 70-189742. But neither of those numbers are
going to tell you this is an old Pogo paperback book (that has the ISBN
on the back, but no bar-code) without you consulting the database for
either numbering scheme. (And now you've made me need to read a dozen
Pogo books that I have.)

Old guy

| Next | Last
Pages: 1 2
Prev: How to save the Firewall Zone setup for wireless Interface setting
Next: Big OpenGL problems