Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

POS4OSC (Point of sale for OSC)


rwmech

Recommended Posts

Posted

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.

Posted
Wow, no feedback? Has anyone tried it?

Taking the plunge this weekend.

Posted
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.

Posted
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.

Posted
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.

Posted
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.

Posted
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.

Posted

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

Posted
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.?

Posted
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

Posted
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.

Posted

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

Posted
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

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?

Posted

<?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>

Posted
<?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.

  • 4 weeks later...
Posted
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

Posted
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?

  • 4 weeks later...
Posted
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
Posted

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

  • 6 months later...
Posted
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..

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...