Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Layouts and Reports Page: 1 2  Previous   Next
Barcode in a report
Author Message
DVD Profiler Unlimited Registrantmicolsendk
Registered: November 3, 2009
Denmark Posts: 6
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Is it possible to make a report where you have a place with the barcode that matche the UPS number on the movie?
This could be useful if you make a sheet with information that you frequently use. From here you can scan the barcode without having to get hold of the movie.

Best regards
Michael Olsen
DVD Profiler Unlimited RegistrantMrVideo
Unix works!
Registered: July 22, 2007
Posts: 332
Posted:
PM this userDirect link to this postReply with quote
micolsendk:

I do not believe that DVDP has the ability to make a UPC (not UPS  ) barcode image on the fly.  That would be a neat feature, but I do not expect it to appear any time soon.
Mr Video Productions
If it isn't Unix, it isn't an OS :-)
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Great Rating
Germany Posts: 2,147
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting micolsendk:
Quote:
Is it possible to make a report where you have a place with the barcode that matche the UPS number on the movie?


to cite myself from a similar thread:
"Depending on what kind of barcode-reader you have, the simplest solution would be to get a barcode-font and just type away. Put asterisks at the beginning and the end of the number and of you go.
No, that is not a real UPC, but e.g. the CueCat reads those just fine, other scanners might too.
see this picture"

That would 'only' leave the question: Can single fields in a report have a different font? If yes, this might be a way to go.


cya, Mithi
Mithi's little XSLT tinkering - the power of XML
DVD Profiler Desktop and Mobile RegistrantStar ContributorRander
I hate mondays...
Registered: March 13, 2007
Denmark Posts: 593
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Mithi:
Quote:
That would 'only' leave the question: Can single fields in a report have a different font? If yes, this might be a way to go.

I actually tried this myself some time ago - and yes, you can define fonts per field. The reason I gave up was that I couldn't get it to add the asterisks properly...
The future is here. It's just not widely distributed yet. (William Gibson)
DVD Profiler Unlimited RegistrantMrVideo
Unix works!
Registered: July 22, 2007
Posts: 332
Posted:
PM this userDirect link to this postReply with quote
Quoting Rander:
Quote:
I actually tried this myself some time ago - and yes, you can define fonts per field. The reason I gave up was that I couldn't get it to add the asterisks properly...


So where is this font available from?
Mr Video Productions
If it isn't Unix, it isn't an OS :-)
DVD Profiler Desktop and Mobile RegistrantStar ContributorRander
I hate mondays...
Registered: March 13, 2007
Denmark Posts: 593
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting MrVideo:
Quote:
So where is this font available from?


This is where I could be tempted to give you this link, but...

Searching Google for "Barcode font", and I got this as the first hit...
The future is here. It's just not widely distributed yet. (William Gibson)
DVD Profiler Unlimited RegistrantMrVideo
Unix works!
Registered: July 22, 2007
Posts: 332
Posted:
PM this userDirect link to this postReply with quote
Quoting Rander:
Quote:
This is where I could be tempted to give you this link, but...


Funny.  I love it.

Quote:
Searching Google for "Barcode font", and I got this as the first hit...


Thanks, got it.

I asked, so that I could get the particular one that you found/use.  I use google to find other fonts that I've needed for special projects.  Why re-invent the wheel 
Mr Video Productions
If it isn't Unix, it isn't an OS :-)
 Last edited: by MrVideo
DVD Profiler Unlimited RegistrantMrVideo
Unix works!
Registered: July 22, 2007
Posts: 332
Posted:
PM this userDirect link to this postReply with quote
Quoting Mithi:
Quote:
see this picture"


How did ya get the ASCII text to line up neatly underneath the barcode?
Mr Video Productions
If it isn't Unix, it isn't an OS :-)
DVD Profiler Unlimited RegistrantMrVideo
Unix works!
Registered: July 22, 2007
Posts: 332
Posted:
PM this userDirect link to this postReply with quote
Quoting micolsendk:
Quote:
Is it possible to make a report where you have a place with the barcode that matche the UPC number on the movie?


I've been doing some google digging and in order for DVDP to include real UPC codes in reports, it will have to do the work.  UPC codes are not simple "type the number and see the result" using a UPC font.  It turns out there is checksum info in the barcode.  So, DVDP would have to embed some software code in order to create the barcodes.

So, the closest thing for reports is the 3 of 9 font.  A good resource about barcode fonts is available here

I guess the next thing is to figure out how to get the * characters around the UPC value, since Rander was having trouble with it (there might not be a cure).
Mr Video Productions
If it isn't Unix, it isn't an OS :-)
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Great Rating
Germany Posts: 2,147
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting MrVideo:
Quote:
How did ya get the ASCII text to line up neatly underneath the barcode?

I didn't, that was the font itself. It was called "Bar-Code 39 lesbar" (readable) thus every number was represented by the lines and the number itself.

cya, Mithi

PS I still have the XSLT that produced that html-list, unfortunately it seem that I lost the font itself.
Mithi's little XSLT tinkering - the power of XML
DVD Profiler Unlimited RegistrantMrVideo
Unix works!
Registered: July 22, 2007
Posts: 332
Posted:
PM this userDirect link to this postReply with quote
Quoting Mithi:
Quote:
I didn't, that was the font itself. It was called "Bar-Code 39 lesbar" (readable) thus every number was represented by the lines and the number itself.

PS I still have the XSLT that produced that html-list, unfortunately it seem that I lost the font itself.


Found the font and downloaded it.
Mr Video Productions
If it isn't Unix, it isn't an OS :-)
DVD Profiler Unlimited Registrantmicolsendk
Registered: November 3, 2009
Denmark Posts: 6
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Thanks for all the information.
I will try this later today. I have found the fonts and have downloaded them.


Michael
DVD Profiler Desktop and Mobile RegistrantDon'tPanic
Registered: June 4, 2010
United States Posts: 10
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting MrVideo:
Quote:
I've been doing some google digging and in order for DVDP to include real UPC codes in reports, it will have to do the work.  UPC codes are not simple "type the number and see the result" using a UPC font.  It turns out there is checksum info in the barcode.  So, DVDP would have to embed some software code in order to create the barcodes.


The last (12th or 13th) digit of the UPC/EAN number is the check digit, so you don't have to worry about that.

Quoting Rander:
Quote:
Searching Google for "Barcode font", and I got this as the first hit...


You have to careful with that font, as it doesn't scan very well at low font sizes (depending on the scanner, I'm sure).  I couldn't get it to scan with a CueCat (Cat. No. 68-1966) at a font size if 16, but it worked fine at 28 point.  I have another 3of9 barcode font that does scan well at 16 point.

Not that this will help, but I found a free bar code generater here.  It will generate an image in various formats, and you can choose many different forms of barcodes.  Perhaps DVDP can add a field for a barcode image and we can start adding them.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 5,299
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting Don'tPanic:
Quote:
Not that this will help, but I found a free bar code generater here.  It will generate an image in various formats, and you can choose many different forms of barcodes.  Perhaps DVDP can add a field for a barcode image and we can start adding them.
Some ideas:

If you put the generated barcode file in the ScenePhotos folder, under the correct UPC folder, DVD Profiler will nicely keep track of it for you in the database, and you can display it as part of your layout. Not sure if you can then use that image in a report. I guess so.

Is there any interest in me making a change to the PTouch plugin? It would be a relatively minor change, since I already process flagged profiles and already am saving a barcode image preview.

The change I would make, would be to automatically save a barcode image (.bmp) in the ScenePhotos in the correct UPC folder for a set of flagged profiles. The filename would be profileid_barcode.bmp(I'm open to suggestions on the name)

Alternatively, if you can find a standalone barcode image gererator, you can run it under DVDProfileLoop, or from CSV or XML export.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantMrVideo
Unix works!
Registered: July 22, 2007
Posts: 332
Posted:
PM this userDirect link to this postReply with quote
Quoting Don'tPanic:
Quote:
The last (12th or 13th) digit of the UPC/EAN number is the check digit, so you don't have to worry about that.


And why not?  The barcode would be incomplete without it, would it not?
Mr Video Productions
If it isn't Unix, it isn't an OS :-)
DVD Profiler Desktop and Mobile RegistrantDon'tPanic
Registered: June 4, 2010
United States Posts: 10
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting MrVideo:
Quote:
Quoting Don'tPanic:
Quote:
The last (12th or 13th) digit of the UPC/EAN number is the check digit, so you don't have to worry about that.


And why not?  The barcode would be incomplete without it, would it not?


Most of the UPCs are 12 digits, so I'll use one of those as an example.

2001: A Space Odyssey on Blu-ray is 012569-798380.  The twelfth digit is 0 in this case, which is the check digit.  It is already part of the UPC, and, as such, is already part of the barcode.  When the UPC was created, it was created as 11 digits (01256979838), and the checksum was calculated and appended as the 12th digit.

So the answer is, it's already complete.

Here are some links for further exploration:
UPC Explanation on Wikipedia
A UPC/EAN checkdigit calculator
Another UPC/EAN checkdigit calculator
    Invelos Forums->DVD Profiler: Layouts and Reports Page: 1 2  Previous   Next