yashsingh1/xdaforums huggingface dataset:
[Windows Mobile Apps and Games] snark_be:
They have a WebService (XML-RPC): http://www.upcdatabase.com/xmlrpc.asp

They even give sample code for C#.
[Windows Mobile Apps and Games] w3t:
I'll try to prepare a build that doesn't require OpenNetCF because i'm not sure but maybe OpenNetCF is requiring .NET CF 2.0 to be installed too.

snark do you also have .net cf 2.0 and 3.5 installed just like me ?
[Windows Mobile Apps and Games] snark_be:
3.5 yes, it's part of the ROMeOS I'm using. I think 3.5 contains 2.0, no?
[Windows Mobile Apps and Games] w3t:
Normally and at least for Windows version yes 3.5 does fully contains the 2.0 components however on Windows Mobile you can have 2.0 installed manually and 3.5 in Rom (that's what i had).

By checking the dependencies i found that OpenNetCF was refering to 2.0 so i've now uploaded a 0.7.2 version which doesn't use it anymore. I hope it will solve the issue for the other users...

The package is much smaller now and it wasn't really required.

We'll see :D
[Windows Mobile Apps and Games] w3t:
I wasn't aware and i'll have a look at it once it works for most users, in this case it shouldn't be too complicated to check on upc if there is nothing on the barcodezilla webservice...
[Windows Mobile Apps and Games] w3t:
Just regarding the UPC Webservice :

This service, and the data provided by it, is licensed for PERSONAL USE ONLY, and may not be used for commercial purposes, NOR REDISTRIBUTED IN ANY FORM without prior written consent. For questions regarding commercial licensing, please contact me at webmaster@upcdatabase.com. I can't guarantee an answer, or even a response, but I do my best...

So i'm not sure we'll be allowed to integrate this in the software.
[Windows Mobile Apps and Games] snark_be:
Unless you start charging for your program, you should be fine. What's the purpose of having a Web-based product DB if it cannot be interrogated? :)

EDIT

: you could also download the dumps of their DB and insert it into yours. So you would not rely on their webservices but still have a nice prepopulated DB. You would of course have to update your DB once in a while (1 dump every month apparently).

PS: you answer fast ... so much for the "myth" of Suiss people being slow ... :D;)
[Windows Mobile Apps and Games] w3t:
That's a good idea as well. I wanted to separate the company and the product because UPC-A and EAN-13 codes do contain 5-6 digits for the company and so if you already have a product from this company locally then 50% are already pre-filled at edition time.

Btw i've downloaded a copy of their db and i'll check how i could script the reimport...
[Windows Mobile Apps and Games] [-Hausmeister-]:
Last edited by w3t; Today at 07:41 AM.. Reason: Updated cab with a version that doesn't required OpenNetCF anymore

... hmm ... same error again.

I Re-Installed NEt CF3.5 but the Files you said in post #20 are not there.
[Windows Mobile Apps and Games] w3t:
Hello,

i've prepared a cab files for you here:

Compact Framework 3.5 (Missing subset + .NET Configuration tool)

It should install the missing system files.

Regards
[Windows Mobile Apps and Games] snark_be:
Actuallly I dont' have the files either in the \Windows directory, but BarcodeZilla works fine for me :confused: . And when I searched for them with TotalCommander on my TP (from \), it did not return any hits. I made sure ROM and System/Hidden files were displayed. Weird ...
[Windows Mobile Apps and Games] [-Hausmeister-]:
i put the files in the BarcordZilla dir and then in the Windows dir ... both times the same error again.
[Windows Mobile Apps and Games] w3t:
Did you install on the storage card or in Program files ?

I can also reproduce the issue actually by not installing in Program Files\BarcodeZilla, it seems the path to database is still hardcoded :eek:
[Windows Mobile Apps and Games] [-Hausmeister-]:
Jackpot ....

now it works ... i have a german WM .. so it goes to "\Programme\BarcodeZilla"

i recreated the path to Program Files ... and tadaaaa it works
[Windows Mobile Apps and Games] w3t:
Ok,

i've uploaded a new package 0.7.2b, now it accepts to run in any folder and will search for the database in same folder :)
[Windows Mobile Apps and Games] [-Hausmeister-]:
great ... now it run from \Programme without any problems. Nice

thanks :)
[Windows Mobile Apps and Games] w3t:
That's good news :)

Btw if you have suggestions regarding the categories of the scanned items they are welcome.

Actually i have those categories but i suppose than many other things can be scanned and the earlier this is define is the best :

public enum ItemTypes

{

Unknown = 0,

Book = 1,

CD = 2,

DVD = 3,

Software = 10,

Hardware = 20,

Accessory = 30,

Consumables = 40,

Food = 50,

Other = 99

}
[Windows Mobile Apps and Games] basboy7:
I will try it too, ill post if it works :D

Wheres the download link to barcodezilla.cab?
[Windows Mobile Apps and Games] snark_be:
Looks like it's gone... :confused:

A nice feature would be support for AppToDate, making easier to update to the latest version (1 every 10 minutes ;)).
[Windows Mobile Apps and Games] w3t:
I was just uploading a new release it's why it disappeared during the thread update...

The webservice seems to work and is filling up the database slowly :)

have you encountered any issue while uploading items and is everything listed here ?
[Windows Mobile Apps and Games] snark_be:
No problem for me. The item I scanned and submitted is in the list. Another one has just been sent (scanning stuff I have next to my desk ;)).
[Windows Mobile Apps and Games] snark_be:
What's the purpose of the BarcodeZilla username and password?
[Windows Mobile Apps and Games] w3t:
Actually there is no purpose for this but the items do have an ownerID field in the database which could match an id provided by the online server.

Everybody has full access to the product and everybody can modify any item at this time.

I'm still thinking of a structure which will allow users to login and to modify their own products but not the products uploaded by others (excepted for sort of admins or powerusers able to clean up the database).

It's still unclear even for me how i'll handle that so there is still full anonymous access for everybody to the data but i'm not sure it's that safe to keep it this way however the users can only modify product informations (not delete) and modify / delete prices informations (country based, you can only see / modify prices for your own country)...
[Windows Mobile Apps and Games] basboy7:
Nicenice its working for me, ive added some items..
[Windows Mobile Apps and Games] snark_be:
Will there be a Web UI so we can browse the products ?
[Windows Mobile Apps and Games] basboy7:
Im a web-developer so u can call me when u need my help with the website :D
[Windows Mobile Apps and Games] MiKA7:
on every thing i scan i only get "unable to decode" :S
[Windows Mobile Apps and Games] basboy7:
I thougt it didnt work for me too, but you have to make very good pictures and no movements in it:P

My english is bad :x
[Windows Mobile Apps and Games] snark_be:
Works fine for me too. Make sure the autofocus is focusing correctly the picture (the square in the middle of the screen should turn green). You should not be too close to the barcode, otherwise it will not be able to do the focus.
[Windows Mobile Apps and Games] w3t:
Good light is important for optimal scanning and also try to center the barcode near to the middle of the image.

ZXing algorythm are starting to scan from the center so if you're well centered and the image isn't blurry it should even decode very fast.
[Windows Mobile Apps and Games] [-Hausmeister-]:
Hey,

i got a new problem...

when i took 3 or 4 Photos sometimes if i want to take a new photo i get a White Screen and nothing happens.

-> http://hausi.mine.nu/20090412230319.png

Only with the "Home" key i can get out. Then my Device is realy slow for a while and BarcodeZilla is closed.

bye Hausi
[Windows Mobile Apps and Games] w3t:
Hello,

which scanning mode are you using and which resolution ?

it happened to me a few times too when scanning in too high resolution (2,3 or 5M pixels).

normally scanning at 640x480 or 1024x768 is well enough to recognize barcodes.
[Windows Mobile Apps and Games] snark_be:
For books (with an ISBN barcode), another nice source of information would be the ISBNdb. It can be accessed with a Web Service too ;) . And the use of their data is free:
[Windows Mobile Apps and Games] [-Hausmeister-]:
i'm scanning in Photo mode, Resolution @ 640 and Quality @ Medium
[Windows Mobile Apps and Games] w3t:
Done in 0.7.4 :)

It doesn't retrieve price information only product actually but was quite easily implemented even if it doesn't contain most of my books (mainly in french) i was able to find a few which were recognized...

For the white image issue, i don't have many clues actually. After scanning 15-20 products i had an issue with the autofocus not working anymore, i had to soft reset the device and everything was back to normal...
[Windows Mobile Apps and Games] w3t:
Checking on UPCDatabase webservice is now also possible in 0.7.5
[Windows Mobile Apps and Games] w3t:
Added support for amazon webservice in 0.7.6
[Windows Mobile Apps and Games] snark_be:
Great! You're improving it a lot.

Any chance you work a bit on the UI? I found it difficult to click on the Camera, Live or the other buttons...
[Windows Mobile Apps and Games] shadowmike:
would love to use this on the Xperia1 however. with .net 3.5 and sql installed i still get error.
[Windows Mobile Apps and Games] [-Hausmeister-]:
i had the same error on the first start ... i soft reset my Device and the error was gone
[Windows Mobile Apps and Games] w3t:
How would you like the UI to look like ? can you suggest a layout ?
[Windows Mobile Apps and Games] w3t:
Looks like the live scanning mode is the cause, i'll try to make a release without this mode because even on htc it's not very efficient...
[Windows Mobile Apps and Games] snark_be:
Get rid of the "live" preview...

See above! ;)

I do not have an idea for a layout yet but I'll think about it. I'm not that good at designing UIs :o .
[Windows Mobile Apps and Games] snark_be:
I was playing a bit with the last version to test the Amazon webservice (it detected my DVDs fine). I took several pictures, most of them using the Camera mode.

I tried then the Live mode but it couldn't decode the barcode. When I switched back to Camera mode, I got the following .NET error:

Code d'exception : 0xc0000005
Adresse d'exception : 0x012f15a8
Lecture : 0x00000000
Module défaillant : directshow.dll
Offset : 0x000015a8

à Camera.GetCameraResolutions(IntPtr pResolutions, Int32& iResolutionsSize)
à Camera.GetAvailableResolutions()
à fGrabber.SetCameraResolution(Int32 index)
à fGrabber.tmAutoGrab_Tick(Object sender, EventArgs e)
à Timer._WnProc(WM wm, Int32 wParam, Int32 lParam)
à ApplicationThreadContext._InternalContextMessages(WM wm, Int32 wParam, Int32 lParam)
à EVL.Yield()
à fGrabber.btGrab1_Click(Object sender, EventArgs e)
à Control.OnClick(EventArgs e)
à Control.WnProc(WM wm, Int32 wParam, Int32 lParam)
à Control._InternalWnProc(WM wm, Int32 wParam, Int32 lParam)
à EVL.EnterMainLoop(IntPtr hwnMain)
à Application.Run(Form fm)
à Program.Main()

C'est comique de voir des messages d'erreur en français, alors que l'OS de mon TP est en anglais ;) (translation: funny to see error messages in French when the OS of my TP is in English)
[Windows Mobile Apps and Games] Home Nager:
I dont have problems on my german TouchPro.

Its hard to get a good pic, but with a little bit of practise..

For the UI I suggest that you put two great buttons (live and camera) on the bottom. So a scanning with a tip of a thumb would be possible. Its hard to hit the very small buttons now.

I would like to enter prices from my local store. If I could enter them manuell or just by importing a csv file, it would by faster than by scanning.

Thank you for your hard work on BarcodeZilla!
[Windows Mobile Apps and Games] hypest:
Hello w3t!

I'm hypest, developer of Barcorama...Thank you for working on a barcode scanning app for our PDAs! We really need something useful as that for our normal everyday lives!

Although I keep an eye on BarcodeZilla, I haven't managed to actually try it yet as it throws exception on my Kaiser :( (WM6.1)

I have just recently announced a public site/service for exactly that purpose: to enter your local prices by logging your purchases, view your statistics, find cheapest vendors and more! Check it out: http://costpad.com. Sign up, add your purchase locations (e.g. shops) and submit your purchases. Don't forget to enter the barcodes :). While there, you can also put up some shopping lists to check when in the supermarket for example. The site is under heavy development but I use it daily to cooperate with my girlfriend.

w3t, sorry for the propaganda on this thread... perhaps we can cooperate on some level ;)

Free+useful applications for the community are so satisfying!

have fun,

hypest
[Windows Mobile Apps and Games] w3t:
Hello,

The live mode has been removed as it seems to cause issues and not to work as good as the "camera wizard" mode. hopefully it will solve the encountered issues.

The remaining capture button has been moved to the bottom part it should be easier to reach now :)

All the web external web services are now handled on the server because some were not compatible with Compact Framework and it should also help regarding performances.

hypest you've done great job with barcodezilla and it was very useful for this project, i had this in mind for a long time already but my first attempt was using commercial libraries (dtk i think) which was not possible for something public but now with Zxing it's very nice.

my Zxing version is not 100% 1.3 because the libraries weren't fully up to date. i have updated the parts i've seen as outdated and improved a bit the QR which is still very hard to scan but yes i'm sure that cooperation might bring very interesting things.

Do you intend to add web service support on your platform ?

for Home Nager:

Actually there is no way to manually push the products however i could setup a web page on the server which allows to do this in order to fill the database easily, i just want to avoid people from typing wrong barcodes etc... it's why actually it's restricted this way.
[Windows Mobile Apps and Games] hypest:
yes, a more formal, web-services-alike access API is a must! In the midtime, using the already implemented http reqs/resps is also doable.

keep it comming ;)

hypest
[Windows Mobile Apps and Games] w3t:
Something providing the WSDL would be the must for being implemented easily in .net and directly from .Net Compact Framework.

You still have exceptions with 0.7.7 ? the directshow.dll library has been removed...
[Windows Mobile Apps and Games] hypest:
I'm developing costpad.com in pure php+javascript. SOAP and the likes are a secondary target but will probably eventually be used. My main effort so far is on the actual usefulness of the entered data... statistics and "cheapest vendor". In any case, if you are interested in integrating costpad into BarcodeZilla, perhaps I could redirect some effort into the webservice.

The exception I encounter is sql related. I'm about to copy/paste the exception details now...

there you go:

ExceptionCode: 0xc0000005

ExceptionAddress: 0x78b2438c

Reading: 0x00000000

Faulting module: sqlceqp35.dll

Offset: 0x0001438c

at NativeMethods.GetKeyInfo(IntPtr pIUnknown, IntPtr pTx, String pwszBaseTable, IntPtr prgDbKeyInfo, Int32 cDbKeyInfo, IntPtr pError)

at SqlCeDataReader.FillMetaData(SqlCeCommand command)

at SqlCeCommand.InitializeDataReader(SqlCeDataReader reader, Int32 resultType)

at SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)

at SqlCeCommand.ExecuteReader(CommandBehavior behavior)

at SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior)

at DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

at DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at DbDataAdapter.Fill(DataTable dataTable)

at DataAccess.ExecuteSelect(SqlCeCommand dbCommand)

at dalCountry.loadCountryList()

at fSettings..ctor()

at fGrabber..cctor()

at Program.Main()
[Windows Mobile Apps and Games] Sean D.:
Same here...

I got the same error. Had to uninstall.
[Windows Mobile Apps and Games] Broman400:
Does not work on Windows Mobile 6.5

Tried to install to both Phone & Memory Card, but still doesn't work.
[Windows Mobile Apps and Games] w3t:
Hello,

Did you install the SQL Compact 3.5 cab i provided in the main thread ?

Does the issue still occur if you install the "official package" located here :

SQL Compact 3.5 SP1 (Official Package)

I found this thread which seems related, i'll have to verify the package in the first thread to ensure it's the SP1 version as well. It's the version which is automatically deployed by Visual Studio when i deploy.

Native exception thread

On my device i have version 3.5.5692.0 for all 3 dll's

the two dll'd in Program Files\Microsoft SQL Server Compact

the System.Data.SqlServerCe.dll in BarcodeZilla folder

Please verify this. Thanks
[Windows Mobile Apps and Games] hypest:
That took the problem away! I installed the ..\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\armv4i\sqlce.ppc.wce5.armv4i.CAB, rebooted and now it runs OK. Thanks!
[Windows Mobile Apps and Games] w3t:
Great. Thank you, i've updated the main post so it links to the complete package.
[Windows Mobile Apps and Games] mahd-leb:
thnx that worked i can launch the application now but i still get an error when i click on the cam icon to launch the camera i get this following error?

microsoft.windowsmobile.forms.cameracapturedialog.launchcameracapturedialog(intrptr ptrstruct)

iam using htc kaiser
[Windows Mobile Apps and Games] sp00kydd:
Nice app, thank you! Can I also scan QR codes with it?
[Windows Mobile Apps and Games] comingloud:
runs at my HD but there unable to check data by my vodafone live connection.. any ideas?

are there possiblities to check other codes like 2/5i or Code39
[Windows Mobile Apps and Games] w3t:
Hello,

QR are supported but are very tricky to scan, quality + horizontal and vertical parralelism of the QR code on the screen is very important to be decoded correctly.

i've tried to improve this from zxing but it only supports 2-3° rotation before it stops working.

Also only EAN / UPC barcode will return results from the webservice.
[Windows Mobile Apps and Games] abumaia:
thought I'd write and confirm that the program runs correctly on my HTC Touch, however I may not be able to use it since my camera does not have an auto focus. Getting a clear image for it to decode is difficult.
[Windows Mobile Apps and Games] w3t:
Updated to version 0.8.5.

Also possible to search online or to use this page and scan the barcode on screen. Normally your contributions should be visible there but it's not very convenient because the only way to search is by barcode :)

http://www.barcodezilla.net
[Windows Mobile Apps and Games] [-Hausmeister-]:
wow cool ... nice update but the Search isn't working for me

-> Server Error in '/' Application.
[Windows Mobile Apps and Games] w3t:
Hello,

what did you type in the box to get the error ? it never happened to me...
[Windows Mobile Apps and Games] [-Hausmeister-]:
4015000410816
[Windows Mobile Apps and Games] w3t:
Thanks, i've fixed the issue...
[Windows Mobile Apps and Games] w3t:
Upgraded to 0.8.9, not many changes on Client but was required to align with updated web services on the server.

Tested on WM6.5 w/ Camera 1.16 without problems it even seems a bit faster...
[Windows Mobile Apps and Games] danielsen:
hello,

i tried the software and i got the error "PInvoke-DLL 'sqlceme35.dll' not found?

Any ideas? I have already installed .net 3.5 and sql

device: sony xperia - wm 6.1

thanks for your help,

bye
[Windows Mobile Apps and Games] w3t:
The SQL Compact 3.5 you have installed really is the version provided in the first post (with SP1) ?

Such errors can happen if it's not the correct SP1 version.

Do you have this file 'sqlceme35.dll' in Program Files\SQL Compact or in Windows folder ?
[Windows Mobile Apps and Games] danielsen:
thanks for the fast reply.

i check the folder Program Files\ - and there is no extry "SQL Compact" - i download the .msi file from the first post #1 (SP1) and i installed it on my xp machine.

There is a folder ...Microsoft SQL Server Compact Edition\v3.5\Devices - I guess i have to copy a cab-file from this directory to my device, right? But wich?

What kind of plattform (wce400 or 500) is wm 6.1 and which prozessor is a Qualcomm MSM7200? (armv4, armv4i, mipsii, mipsii_fp, mipsiv, mipsiv_fp, sh4, x86)

Should I install all cab-files? sql.dev. / sql. / sqlce. / sqlce.repl / sqlce.dev

I am a little bit confused. But i hope you can understand my bad english :)

tanks
[Windows Mobile Apps and Games] derekwilkinson:
Does anyone have a SQL cab? I'm on a Mac and can't install it from Microsoft's website.
[Windows Mobile Apps and Games] w3t:
Normally installing sqlce.wce5.armv4i.CAB should be ok, it's the one i usually deploy, probably the dev version for phone (smaller) is enough for our HTC devices however installing the one which is 1.7 mb should work.

i'm preparing a lite version of BarcodeZilla that doesn't require SQL Compact due to the troubles encountered by many users but it will only work online and not offer to possibility to push new products.
[Windows Mobile Apps and Games] w3t:
Added the cab to the first post
[Windows Mobile Apps and Games] danielsen:
@ w3t, thanks for the solution

after the installation of sqlce.wce5.armv4i.CAB the program starts fine - but if i press the "camera button" the camera tool of my xperia begins to start (take ages). Then i have the possibility to take a picture - then there is a info: "saving" but after this alert nothing happend - i see the start gui form barcodezilla but nothing more? Any ideas?

Is there a "live mode" available?
[Windows Mobile Apps and Games] w3t:
There was a live mode in earlier versions but due to confusion it was creating and the issues on HTC (only low-res supported, not good handling of auto-focus,etc...) it has been removed.
[Windows Mobile Apps and Games] w3t:
Updated main topic with the "Lite" version.

It doesn't require SQL Compact 3.5 and will not persist informations.

Of course you have to be online to retrieve product informations.

Product addition and edition is only available in the full release but as not everybody wants to install SQL Compact and some other do have issues then you can go with this simpler version...
[Windows Mobile Apps and Games] Sean D.:
Settings??

I installed the "Lite" version, and so far it seems to work. Meaning it starts up, the camera will turn on when you press the icon.

But what needs to be done for the app to go online? The first picture I took I was given the unable to decode, error. The second picture (taken with the camera turned so the shot was in landscape) also gave me the same "undable to decode" error, but the picture was saved in the temp folder.

Am I doing something wrong here?

:confused: