mariovaldez.net

MV.net forums
It is currently 14 Jul 2016, 00:34

All times are UTC - 7 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 
Author Message
PostPosted: 25 Feb 2006, 18:16 
for example like in oscEditor (http://osceditor.com/index_en.php) - can we hope on fis feature?


Report this post
Top
  
Reply with quote  
PostPosted: 28 Mar 2006, 12:04 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
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. :!:


:arrow: 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.


Report this post
Top
 Profile  
Reply with quote  
PostPosted: 02 Apr 2006, 06:24 
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


Report this post
Top
  
Reply with quote  
PostPosted: 02 Apr 2006, 14:38 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
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.


Report this post
Top
 Profile  
Reply with quote  
PostPosted: 04 Apr 2006, 12:48 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
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.


Report this post
Top
 Profile  
Reply with quote  
 Post subject: Empty product list
PostPosted: 06 Oct 2006, 08:25 
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


Report this post
Top
  
Reply with quote  
PostPosted: 27 Oct 2006, 05:21 
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. :cry:

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

regards

Ben


Report this post
Top
  
Reply with quote  
PostPosted: 15 Dec 2006, 09:26 

Joined: 26 Sep 2006, 16:36
Posts: 1
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


Report this post
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 

All times are UTC - 7 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group