[APP] BarcodeZilla / BarcodeZilla Lite 0.9.5 (Updated 22/05/2009)

BarcodeZilla is a Zxing based barcode decoding application (just like barcorama that i've been using for a while) which is enabled for product recognition (mainly intended for EAN-8 / EAN-13 and UPC barcodes) that will display information the origin country of the product and allows to download product information (if available) and to edit and upload product and price information for your country as well using a WCF webservice.

Here's how it looks:


You don't need to be online to use the application because there is also a local database that will store every product you scan and the price information you might enter in the application.

Please do no upload crap informations to the server. if you play with it please enter accurate information regarding the products and prices as everything is pushed to the server when you click "upload".

For performance reasons you can manually enable or disable the formats that you want to decode, in case you have troubles decoding you can try the "enhanced mode" (suggested).

This application is using .NET Compact Framework 3.5 and SQL Compact 3.5 SP1.

Here are the files you might have to install:

Compact Framework 3.5

SQL Compact 3.5 SP1

I have also launched the online search engine which uses exactly the same mechanism, actually it doesn't allow to add / edit data just to search and display the known products:







News:

Published a "Lite" version which doesn't need SQL Compact 3.5

But with this version you have to be online to be able to recognize products (no persistance) and you cannot add / edit and upload new items.





Support this project:

Use barcodezilla.net when you intend to buy something from Amazon.

or

Donate

Thank you !




Versions History:

0.7.2 :
Fixed not working when installed on Storage Card or some non-english OS

0.7.3 :
Some countries not detected properly
Wait icon remains displayed after unsucessful decoding
Detect books with ISBN as country
Some changes on WebService side

0.7.4 :
Books (ISBN) are checked on ISBNDb.com webservice if not found on barcodezilla webservice
Normalized captalization at upload / download

0.7.5 :
Non-Books (ISBN) are checked on UPCDatabase.com if not found on barcodezilla webservice

0.7.6 :
Added link to the amazon product page
Added "Author field" for items in database (books).

0.7.7 :
Remove Live mode (seems to cause issues on some devices)
Moved capture button to the bottom
Improved Web Service on Server, no more external queries are made by the Windows Mobile device anymore, the Barcodezilla webservice handles everything to improve performances...

0.8.5 :
Some modifications to database structure (your data should be on the server)
Upgraded Web Services on server
Support retrieving prices from Ebay
Amazon data / images aren't persistant anymore and removed from cache after 3 hours (in order to fulfill with amazon requirements)
Audio CD are correctly handled
New web based interface (read only actually) : http://www.barcodezilla.net

0.8.9 :
Updated web services definition due to improvements on www.barcodezilla.net

0.9.0 :
Introduction of BarcodeZilla Lite which doesn't require SQL Compact 3.5

0.9.2 :
Re-Introduction of Live Scanning Mode
Re-Introduction of XML Data Export of Scanned codes

0.9.4 :
Using the default browser instead of forcing Internet Explorer
Possibility to use external search and provide a custom url
Export also done in CSV for being imported easily in Excel
Possibility to define the path to export XML / CSV
Re-Introduction of XML Data Export of Scanned codes
Capture function available in the menu for 320x320 devices

0.9.4b :
Fixed price not displayed in Lite version

0.9.5 :
Browse to the url if you scan a QR Code / DataMatrix containing an url
Added AppToDate support


Download History:

0.8.9 / 0.9.0 :
BarcodeZilla.CAB (359.5 KB, 488 views)
BarcodeZilla.Lite.CAB (286.7 KB, 90 views)

0.9.2 :
BarcodeZilla.CAB (372.5 KB, 1393 views)
BarcodeZilla.Lite.CAB (162.7 KB, 766 views)

0.9.4 :
BarcodeZilla.CAB (372.5 KB, 113 views)
BarcodeZilla.Lite.CAB (162.7 KB, 46 views)

Are you getting an error message or something ?

Did you install both Compact Framework 3.5 and SQL 3.5 ?

In program files\barcodezilla do you have the files ?

- barcodezilla.sdf (initial database)
- opennetCF assemblies
- system.data.sqlserverce.dll

Hello,

I'll try to find the reason, i've just tried on a clean WM6.0 image from the emulator to ensure it was really empty of any other assembly.

i've just installed those cabs (provided in this post) in this order:

NETCFv35.wm.armv4i.cab

sqlce.wce5.armv4i.CAB

and

BarcodeZilla.Cab


Those are the version from Microsoft SDK.

Btw are you on Windows Mobile 6.0 or 6.1 with the Diamond / PRO ?

Personally i am using L26's rom on HTC touch with the .NETCF3.5 which is in ROM but it was tested as well on a Symbol MC75 (WM6.0 with .NET 3.5 installed separately).

It's strange because those are the only required external assemblies and it seems i didn't forget something in the cab.

there isn't another windows after the type load exception (such as unable to pinvoke 'sqlceme.dll' ?

Thanks for the feedback...


Are you all on German OS ? I've only tested on english so far...

wishmaster86 said:

is there also a posibility to have the server files as a download?

im thinking of a movie database by barcode for home use. because i have like 5 cabins full of dvd's and im getting sick of where i left the dvd's so i wanted to organize the cabins with cabin, row, plank height numbers. so that i can easily find my dvd's. and also it would be a nice learning curve.

Click to expand...

Click to collapse

Btw there are no server files actually. It's a SQL database which is behind the WCF WebService, i didn't even prepare any web interface actually, i just have a small windows client which can check what's going on on the webservice.

Hello,

I think that i have a clue regarding the issue, i can reproduce it using .NET Configuration Editor.

If i set the default .NET Framework to use for BarcodeZilla to 2.0.7045 instead of 3.5.7283 then i'll get this error as well on my HTC.

If somebody can download this, extract and copy to his device to verify this theory.

I have uploaded a new .Cab to the main thread, now the application is forced to start using .NET 3.5, i suppose the issue happens if you have both .NET 2.0 and 3.5

Thanks

Hello,

Do you have this line in BarcodeZilla.exe.config with the latest version

<configuration>
<appSettings>
<setting name="UPCE" value="false"/>
<setting name="QR" value="false"/>
<setting name="EAN13" value="true"/>
<setting name="TryHard" value="false"/>
<setting name="UPCA" value="false"/>
<setting name="Resolution" value="default"/>
<setting name="Quality" value="l"/>
<setting name="UserCountry" value="CH"/>
<setting name="CODE128" value="true"/>
<setting name="SaveDecodedImages" value="false"/>
<setting name="CODE39" value="false"/>
<setting name="EAN8" value="true"/>
<setting name="DM" value="false"/>
</appSettings>
<startup>
<supportedRuntime version="v3.5.7283"/>
</startup>
</configuration>


If you check with .NET Configuration what is being reported ?

I know that some roms do only have a subset of .NET 3.5 but i don't know how to verify this actually.

snark_be said:

Nice piece of software.
Could you change the program so it uses UPC Database?

Instead of using your own DB, which will take some time to grow, UPC Database has already more than 1 million entries.

Click to expand...

Click to collapse

Hello,

it's what i did for the very first version but i didn't like this for several reasons :

- no EAN-13 / EAN-8 support which are the mainly used formats for europe
- no price information
- not a webservice but only web based

the idea was really to be able to insert prices at different stores so the softwares reports the 3 best prices (per country, during the 3 last months).

also i wanted to avoid having to use Opera or any other browser and to have the possibility to directly create the new products on the device (even when you are disconnected) and to be able to synchronize at any time.

Once again it's really a preliminary release, the advantage is that even if the product isn't known by the server it takes 5-10 seconds to enter just the company name / product name and you can start storing the price of a product at the current moment.

For those having issues, here's a screenshot of my \Windows folder on my HTC Touch HD.



Can you please verify you have those files as well, the following assemblies are being required by BarcodeZilla :

System
System.Data
System.Runtime.Serialization
System.ServiceModel
System.Web.Services
System.Xml

Normally those files are part of CF 3.5 but i remember in the past i have loaded a ROM where the framework was incomplete...