Koozali.org: home of the SME Server

Inventory Barcode

Offline tviles

  • *****
  • 197
  • +0/-0
Inventory Barcode
« on: February 07, 2009, 11:26:01 PM »
Is there a contrib that works with SME 7.4 for barcode inventory? Thanks Tracy


Offline tviles

  • *****
  • 197
  • +0/-0
Re: Inventory Barcode
« Reply #1 on: February 08, 2009, 02:17:39 AM »
Has anybody tried this? Does it work with a barcode scanner? Says it is for Centos.

license:
this software (inventory-management.org) is 100% free and may be used free of charge. you may not redistribute for commercial profit.
installation:
-copy all files to your web host
-use phpmyadmin or your mysql interface to run site.sql to setup your database.
-open site.xml and edit the database section with your database details.
-go to index.php and login with username of admin with a password of test.
-be sure to change the passwords for the admin and regular user.

To change the title of the system edit line 8 of
templates\admin\layout.htm between the <title> tags.
Setup the site.xml file with your database settings as follows.
<database type="mysql">
   <server>database server address</server>
   <login>database login</login>
   <password>database password</password>
   <default>mysql database name</default>
</database>

Add this to your ".htaccess" file to prevent viewing of the xml config file.
</Files ~ ".xml">
Order allow,deny
Deny from all
Satisfy All
</Files>

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Inventory Barcode
« Reply #2 on: February 08, 2009, 12:05:46 PM »
Has anybody tried this? Does it work with a barcode scanner? Says it is for Centos.
Then it might run, provided that is compatible with SME Server 7.x, which in fact means compatible with CentOS 4.x (as SME Server is based on this).

license:
this software (inventory-management.org) is 100% free and may be used free of charge. you may not redistribute for commercial profit.
I see no objection here, do you?

installation:
-copy all files to your web host
-use phpmyadmin or your mysql interface to run site.sql to setup your database.
I beleive PHPMyAdmin is in the wiki under the contribs section, but you can also use the basic MySQL commands to install this. For more information on MySQL I suggest the MySQL manual on their site as well as this in relation to MySQL and SME Server: http://wiki.contribs.org/MySQL

<database type="mysql">
   <server>database server address</server>
   <login>database login</login>
   <password>database password</password>
   <default>mysql database name</default>
</database>
Create a new user with the proepr security privileges as instructed in http://wiki.contribs.org/MySQL, do not use the MySQL root user for your application please as this might has serious security issues as this account has to many privileges.

Add this to your ".htaccess" file to prevent viewing of the xml config file.
</Files ~ ".xml">
Order allow,deny
Deny from all
Satisfy All
</Files>
To allow for .htaccess files in ibays on SME Server this might get you started: http://wiki.contribs.org/Htaccess but this post might be even easier: http://forums.contribs.org/index.php/topic,43003.msg203989.html#msg203989
« Last Edit: February 08, 2009, 12:07:54 PM by cactus »
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline tviles

  • *****
  • 197
  • +0/-0
Re: Inventory Barcode
« Reply #3 on: February 08, 2009, 06:43:09 PM »
Thanks again Cactus. You got me thinking. I am going to purchase a cheap USB barcode scanner off Ebay, hook it up to a laptop and start with that. It might be as simple as creating an Excel doc and putting in the shared Ibay folder. Boss wants entire water dept. on inventory with barcodes.