Wednesday, March 21, 2012

Inventory Costing

http://publib.boulder.ibm.com/infocenter/sfsf/v9r1/index.jsp?topic=%2Fcom.ibm.help.prod.concepts.doc%2Fc_AverageCostingMethodInventoryCostingForDrop-ShipProducts.html

Sunday, March 4, 2012

Bulk import csv insert command

BULK INSERT productprices FROM 'E:\RnD Projects\SmartGIngram\MSSQL Sample Package\MSSQL\PRICE.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) GO

Sunday, January 15, 2012

How do I download code using SVN/Tortoise from Google Code?

EXP:
# Non-members may check out a read-only working copy anonymously over HTTP.

svn checkout http://extnet-mvc.googlecode.com/svn/trunk/ extnet-mvc-read-only



Install Tortoise (separate SVN client not required), create a new empty folder for the project somewhere and right click it in Windows. Click "SVN Checkout". Choosing that option will open a dialog box. Paste the URL "http://extnet-mvc.googlecode.com/svn/trunk/" in the first textbox of that dialog box and click "OK".

Thursday, November 10, 2011

SAAS in PHP

Developing a SaaS is quite different from traditional desktop-based software development. Security is a great concern especially when it comes to SaaS business applications. A leak of accounting data would be devastating and truly embarrassing. You need to have proper backups in place as you will be blamed for any server crash and loss of data (after all you are now also the provider of servers, storage and bandwidth). The performance of the application is also something that needs to be closely monitored as you are paying for the processing power instead of the end-user.

Using PHP as programming language and MySQL as database is a good choice when developing your SaaS solution. It is open source and a large number of software developers have jointly tweaked it to excel in terms of performance and security. Both PHP and MySQL have also been around for a long time making it stable but also presenting you with a large pool of available talent such as programmers, database administrators, system administrators and web hosting providers.

Example:
https://github.com/stuartloxton/php-saas

Tuesday, October 18, 2011