mariovaldez.net

for example like in oscEditor (http://osceditor.com/index_en.php) - can we hope on fis feature?

Hi everybody:

A beta test version is available which uses pure HTTP calls so it does not require a direct MySQL connection. This version should work without the need of a SSH account or a direct MySQL connection (in other words, it should work with any hosting service).

THIS IS A TEST VERSION, NOT READY FOR PRODUCTION USE.

You can find it at:
http://www.mariovaldez.net/software/oscpmwin/files/private_versions/oscpmwin_0.4.1.632_setup.exe


Please, do not use it in any production osCommerce store, use it only on a testing install of osCommerce. This version has not been fully tested.

If you use it, please report back the following:
* Integrity of data (if your data is not lost).
* Network connection reliability (if you get network error or timeouts).
* Connection speed and general performance.

Again, please use it only with a test store, not with your production store(s).
THIS IS A TEST VERSION, NOT READY FOR PRODUCTION USE.


If this version works well, the next release of OSCPMWin will use only HTTP calls, not direct MySQL connections. But I need your feedback.


If you have further questions or comments, please post to the forums or email me at mario@mariovaldez.org.

Regards,

Mario A. Valdez-Ramirez.

What do we need to put on the server ?

What solution did you use Mario ? Im realy intrested.

Is it like the Turbocash.php or do you have a better system ?
Please email me at pvalentijn(at)turbocash.nl

Pieter:

> What do we need to put on the server ?

Just update the oscpm1_upload.php script with the one included (which gets stored in the /oscpmwin/serverside/ directory of the Windows install).


> What solution did you use Mario ? Im realy intrested.

I created an ad-hoc protocol, very simple and somehow crude. Queries are sent as POST parameters, Base64 encoded (to preserve special chars). The server-side script pass the SQL string to MySQL, retrieves resulting rows (if it is a SELECT, if it is an INSERT, it returns the ID [id available]), encode each field with Base64, adds field tags, creates a CRC checksum, adds record tags, compress the whole record set with Gzip compression, encode with Base64 and return everything in plain text to the client application.



> Is it like the Turbocash.php or do you
> have a better system ?

I don't know if it is really better, but I think it has the following advantages/disadvantages:


* It won't work with Delphi DB-aware controles.
* It does not require any DB-related VCL code, so it should compile even in Delphi Personal editions.
* It does not require any MIDAS-related code, so it should not have any licensing issues.
* The code is mostly CPU-bound, not bandwidth-bound. The most expensive operations (client-side) are the Gzip decompression and the Base64 decoding. (I need further testing because it may be a memory-related issue).
* Even with the Base64 encoding (which increases the size of the data by 33%) the recordsets are compact, because the Gzip algorithm compresses them pretty well.
* The server-side code is very simple.
* The client-side code is not more complex than what I used before.

I'm sending you this by email, too; because maybe these things are not very interesting for most people.


Regards,

Mario A. Valdez-Ramirez.

To everybody else testing the beta version:

There is a bug in the 0.4.1.632 version which causes it to display an empty product list. It was a bug in the server-side script. Please upgrade to the 0.4.1.636 version available in:

http://www.mariovaldez.net/software/oscpmwin/files/private_versions/oscpmwin_0.4.1.636_setup.exe


Regards,

Mario A. Valdez-Ramirez.

I'm running with the 636 build, but still do not see any products in the tree.

The 636 serversidescript has been uploaded. Any advice on how I should test my set up?

regards

Ben

Hi,
I have tried all versions of the program. I couldn't access the database using earler models because of the password problem so I have tried with the 636 build, but still do not see any products in the tree.

The 636 serversidescript has been uploaded. Any advice on how I should test my set up?

regards

Ben

Mario,

I have been using oscpmwin v.0.4.1.646 for about 2 months now with no problems. It is the only inventory application that seems to work for me (my host is 1&1) are you still working on updates for the application?

Thank you for making a excellent program.

Steve