rwmech Posted April 10, 2008 Posted April 10, 2008 Ok, I could have swore that I posted this to the other POS topic last night with the details on where to get POS4OSC (the software I wrote) but it went missing. Here it is again, and it's own thread for feedback. http://www.mechsoftware.com/POS4OSC_ALPHA1.zip This is the link to the software. There is a readme file in there, you should absolutely read that. You wont get the software to download anything from your store without modifying it. Note that becuase of the UPC and product_cost custom database additions (if you should want to use it) you'll need to modify the query that pulls down the data. Note that I did include a query that should work around that issue if you arent comefortable patching your database to add 2 new fields. Use this completely at your own risk. It will not POST BACK to osc directly. You'll need to use the .SQL file (generated by the software) if you want to post back to your database. Use this completely at your own risk. On another note, I'd ultimately like to turn this code over to the community under likely LGPL since it doesnt use OSC code. I do not have time to maintain the code full time so developemnt and such would need to be part of the community. *IF* there is enough need for this, I would be interested in licensing this under GPL and dontating it directly to the osCommerce team itself.
Guest Posted April 11, 2008 Posted April 11, 2008 Wow, no feedback? Has anyone tried it? Taking the plunge this weekend.
Guest Posted April 11, 2008 Posted April 11, 2008 Taking the plunge this weekend. Set up a new test store on lcalhosthost (underwamp). Site name test_pos, db name test_pos. The data does not download.
rwmech Posted April 11, 2008 Author Posted April 11, 2008 Set up a new test store on lcalhosthost (underwamp). Site name test_pos, db name test_pos. The data does not download. Did you setup the properties file correctly? Yo should have to configure mysql, login, password, etc. It does download, I do it every day. :) OH! One more thing (and this could be a big thing for some) you need make sure in your MYSQL configuration (usually through CPANEL) that you enabled a remote host access to your MYSQL database. Most setup only for localhost access. You'll need to make sure you set it up so your IP (Static or dynamic) can download through it.
Guest Posted April 11, 2008 Posted April 11, 2008 Did you setup the properties file correctly? Yo should have to configure mysql, login, password, etc. It does download, I do it every day. :) Yes, that is set up ok OH! One more thing (and this could be a big thing for some) you need make sure in your MYSQL configuration (usually through CPANEL) that you enabled a remote host access to your MYSQL database. Most setup only for localhost access. You'll need to make sure you set it up so your IP (Static or dynamic) can download through it. Oh, therein lies the problem. This does not seem to be able to be done under wamp, or on my webhosts control panel.
rwmech Posted April 11, 2008 Author Posted April 11, 2008 Yes, that is set up ok Oh, therein lies the problem. This does not seem to be able to be done under wamp, or on my webhosts control panel. In theory I could build an adapter, but at this time it's not supported unless you can get mysql access. I would suggest contacting your webhost on it to see if there is a workaround.
Guest Posted April 11, 2008 Posted April 11, 2008 In theory I could build an adapter, but at this time it's not supported unless you can get mysql access. I would suggest contacting your webhost on it to see if there is a workaround. OK, I have MySQL access on the web, but can't see how it is done. More importnantly (for me) is that I can get it working under localhost. Will have to check it out some more.
koopmanh Posted April 14, 2008 Posted April 14, 2008 Hi, I downloaded this file. Howeve when a start the start.cmd file nothing happens. I'm using an XP machine with java build 1.6
rwmech Posted April 15, 2008 Author Posted April 15, 2008 Hi, I downloaded this file. Howeve when a start the start.cmd file nothing happens. I'm using an XP machine with java build 1.6 That sure is strange, all the files are unzipped completely? The .cmd file should be all that it takes to get it running. DO you get any exceptions or does it just sit there? Has anyone else had this problem.?
koopmanh Posted April 15, 2008 Posted April 15, 2008 That sure is strange, all the files are unzipped completely? The .cmd file should be all that it takes to get it running. DO you get any exceptions or does it just sit there? Has anyone else had this problem.? If I run start.dm nothing happens If I run java -jar pos2osc i get the following result: 15-apr-2008 21:21:44 org.jdesktop.application.Application$1 run SEVERE: Application class pos4osc.POS4OSCApp failed to launch java.lang.NumberFormatException: For input string: "0,00" at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source) at java.lang.Float.parseFloat(Unknown Source) at pos4osc.POS4OSCView.updateAmountTendered(POS4OSCView.java:1189) at pos4osc.POS4OSCView.updateCartAndTotals(POS4OSCView.java:1218) at pos4osc.POS4OSCView.<init>(POS4OSCView.java:65) at pos4osc.POS4OSCApp.startup(POS4OSCApp.java:19) at org.jdesktop.application.Application$1.run(Application.java:171) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Sour at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Sour at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Exception in thread "AWT-EventQueue-0" java.lang.Error: Application class p c.POS4OSCApp failed to launch at org.jdesktop.application.Application$1.run(Application.java:177) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Sour at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Sour at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: java.lang.NumberFormatException: For input string: "0,00" at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source) at java.lang.Float.parseFloat(Unknown Source) at pos4osc.POS4OSCView.updateAmountTendered(POS4OSCView.java:1189) at pos4osc.POS4OSCView.updateCartAndTotals(POS4OSCView.java:1218) at pos4osc.POS4OSCView.<init>(POS4OSCView.java:65) at pos4osc.POS4OSCApp.startup(POS4OSCApp.java:19) at org.jdesktop.application.Application$1.run(Application.java:171) ... 8 more
rwmech Posted April 15, 2008 Author Posted April 15, 2008 java.lang.NumberFormatException: For input string: "0,00" Ahh, the big problem here is that there is no international support. Should that be a 0.00 I believe it would have worked fine.
Luvz2drv Posted April 16, 2008 Posted April 16, 2008 having issues getting this going my server url tssbakery.com database table tss_oscom pass password name name i tried that in the config file but it will not connect.. i have alowed my ip as well .. still it will not connect if someone could maybe rewrite that config it would be great. Jonathon
rwmech Posted April 16, 2008 Author Posted April 16, 2008 having issues getting this goingmy server url tssbakery.com database table tss_oscom pass password name name i tried that in the config file but it will not connect.. i have alowed my ip as well .. still it will not connect if someone could maybe rewrite that config it would be great. Jonathon Can you post the acutal config settings for the URL and SQL query into here so we can take a look. As far as username/password generally that should work with no trouble. Also, is there any exceptions being fired in the command window when you run it?
Luvz2drv Posted April 17, 2008 Posted April 17, 2008 <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"> <properties> <comment>POS4OSC Configuration File</comment> <entry key="URL">jdbc:mysql://tssbakery.com/thayman_catalog</entry> <entry key="password">password</entry> <entry key="userName">username</entry> <entry key="selectStatement">select products.products_id,products_cost,products_price,products_quantity,products_nam e,UPC_CODE,products_model from products join products_description on products.products_id=products_description.products_id order by products_name</entry> </properties>
rwmech Posted April 17, 2008 Author Posted April 17, 2008 <?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"> <properties> <comment>POS4OSC Configuration File</comment> <entry key="URL">jdbc:mysql://tssbakery.com/thayman_catalog</entry> <entry key="password">password</entry> <entry key="userName">username</entry> <entry key="selectStatement">select products.products_id,products_cost,products_price,products_quantity,products_nam e,UPC_CODE,products_model from products join products_description on products.products_id=products_description.products_id order by products_name</entry> </properties> Do you have or have added the UPC_CODE field? If not check the instructions I added a different query in there for those that don't have the extra columns like UPC_CODE and PRODUCTS_COST. Another thing you can try, to rule out a connection issue is to download mysql's administration tools from their website. The "Query Browser" utility will connect to your database. If you can use that and connect succesfully then the problem is either in the connection string, the sql statement or the code.
Kvakky Posted May 15, 2008 Posted May 15, 2008 Hi, I downloaded this file. Howeve when a start the start.cmd file nothing happens. I'm using an XP machine with java build 1.6 Same problem here..The YouTube video looks good, and i'm looking forward to see it live. :) Does somebody have a tip on how to get it to work? Regards, Jan Andrè Oslo, Norway
rwmech Posted May 15, 2008 Author Posted May 15, 2008 Same problem here..The YouTube video looks good, and i'm looking forward to see it live. :) Does somebody have a tip on how to get it to work? Regards, Jan Andrè Oslo, Norway You tube video? Who did a You Tub Video? In any case. POS4OSC really needs somone to take it over. I've had just about 0 luck in getting time to work on this. I'm willing to release the source GPL if somone is willing to help lead the project. I need a Java developer who knows what they are doing. Any takers?
Guest Posted June 11, 2008 Posted June 11, 2008 You tube video? Who did a You Tub Video? In any case. POS4OSC really needs somone to take it over. I've had just about 0 luck in getting time to work on this. I'm willing to release the source GPL if somone is willing to help lead the project. I need a Java developer who knows what they are doing. Any takers? here is the video of for oscommerce
herrlich Posted June 18, 2008 Posted June 18, 2008 I love POS4OSC! I think it's a very powerfull tool with simple use I plan to install it on a version for clients of mine, just wonder if it's planed in a near future to have a barcode support like the original POS? that would be very helpfull for our project thanks anyway herve
andenand Posted January 13, 2009 Posted January 13, 2009 Hi why not upload it as a contribution? (or is it already - and I cant find it? - I assume its not http://www.oscommerce.com/community/contributions,3016 as its too old.)
andenand Posted January 13, 2009 Posted January 13, 2009 You tube video? Who did a You Tub Video? In any case. POS4OSC really needs somone to take it over. I've had just about 0 luck in getting time to work on this. I'm willing to release the source GPL if somone is willing to help lead the project. I need a Java developer who knows what they are doing. Any takers? If you post it as a contribution (+ source) then I´m chances are that someone someday will take it to the next step..
Recommended Posts
Archived
This topic is now archived and is closed to further replies.