Home

Linux CRM

Tuesday 31 January 2012 at 08:17 am

CRM, or Customer Relationship Management is a class of collaberative applications for enterprises that keep track of prospects, leads, customers, customer complaints, orders and shipments. Companies wishing to better serve customers in support situations as well as equip their sales force with tools to manage leads and prospects have turned to CRM tools for some time. Many varied computer applications, from ACT for the PC to the ultra sophisticated Siebel Systems corporate customer service applications for mainframes can be categorized under this banner.

Small companies looking for CRM solutions under a linux or Mac platform environment first need to consider how long they can operate in a lone-wolf mode. Applications like ACT, although as portable as their PC, and with ACT's creation of links to Blackberry, Palm and Windows CE, lacked the integration when a second sales person or customer service person joined the force. For the umteenth time, when it comes to using computers, there are two modes, solo and everything else. With contact management and CRM the Cloud is the ideal environment for contact management.

While there are probably sophisticated contact managers for groups using iPhones, we evaluation programs more along the lines of SugarCRM, an intense cloud based prospect and contact manager that has capabilities to manage every phase of prospecting, closing and selling. While SugarCRM can be downloaded and installed on your Mac or Ubuntu PC, it is an ideal candidate for the cloud. It can be scaled to the growth of your organization for less that $ 1000 per year per user and that is a small price compared to the cost of a years salary. For more information on Atlanta ERP visit MSincs Linux and open source ERP and CRM surveys.

LAMP ERP

Wednesday 28 December 2011 at 12:49 pm

ERP or Enterprise Resource Planning also entails the normal accounting operations required in a small and medium sized business, the integration between the post mortem analysis functions, planning procedures and the basic data collection and organizational functions required for a backbone business information system leave business planners wanting an integrated package of data processing functions to interface with the planning procedures.

Linux based open source software packages offer the richest and most rapidly evolving applications. That Redmond Washington vendor can enter a market and abandon it in a matter of a few years, leaving users with unsupported application software. While the life cycle for a release of a desktop operating system may be less than five years, many ERP implementation last two decades or more. Elements of major million dollar ERP software packages contain business logic with roots in the Fortran and Cobol of the 1960's.

Certain SQL based packages lack much business logic entirely and the relatively new, but robust procedural languauge of the Oracle flavor, Plsql is developing and creating an inventory of business logic. But licensing costs drive infoimration system specialists to continue to use applications based on the Unix operating system and the known source code model. These models rely on vendors like Redhat and Novell to maintain expertise at a lower cost while providing the option to 'go it alone' that indeed major banks and telecoms excercise.

Linux, Apache, MySql and Php combine to provide applications for the business community, and with the use of Perl banking providors like Paypal provide incredibly robust and yet secure micro application environments that employ technology in innovative and profitable ways. But businesses that merely outgrow the Quickbooks model, which lacks the aforementioned integration desires that forward thinking business owners seek leave small manufacturers for example to look at packages of the next tier such as Peachtree, MAS-90 and even the Redmond solutions.

However, businesses might come accross three very innovative vendors that use Linux as a basis, yet provide compatibility with Windows and Macinstosh for the most part. Linux in the previously mentioned telecom operations provides the least downtime, and many times Oracle has used Linux to set world records in the database transaction processing arena. For more information on visit www.mansup.net for more information on open source modeled and Linux based LAMP ERP solutions.

Emacs commands

Saturday 10 December 2011 at 08:03 am

Conventions for this help guide are required, first, a character struck while holding down the control key are preceded by the CTL- and an enter key (or sometimes it used to be a return key or 'carriage return') is designate with <cr>.

First, what have we gotten into here? Emacs is a full screen character editor that allows arrow keys, which may be much more intuitive to the unfortunate folk that started life on Windows or Macintosh. While everybody knows that 'vi' is the ultimate editor, alas, Emacs is a good idea to learn.

I have gotten into emacs on a file, and am afraid of making modifications, exit without saving;

CTL-X CTL-C

Unfortunately, we can get caught in a situation where Emacs believes that there are changes to be saved, so try this;

CTL-X CTL-C n<cr> yes<cr>

At any rate, if you have issued the CTL-X CTL-C from a neutral start, meaning the context is not determined by Emacs to be something other than exit, you should be getting instructions at the bottom of the screen.


Saving the file

CTL-X CTL-S

Emacs vs vi in Linux and Bash

Monday 05 December 2011 at 11:41 am

EMACS keystrokes

EMACS is a Unix/Linux text editor which lots of people like because it can do a lot of stuff. EMACS has many keystroke controls, but the only two which you really need to know in order to use it are as follows: Save document: C-x, C-s Exit EMACS: C-x, C-c (C-x is EMACS shorthand for CTRL-x. It uses so many CTRL-key combinations that it's more practical to shorten it that way. Incidentally, for ALT-key combinations, EMACS uses M instead of A as you might expect; For example, M-x means press ALT-x. This stands for "meta".)

Another neat keystroke to remember is M-x. (Yes, that's ALT-X.) This lets you run commands in EMACS by name; Every command in EMACS has a name, but the most commonly-used ones are bound to specific keystrokes so they can be run quickly. If a command is not bound to a keystroke, you can run it just by pressing M-x and then typing the command name. Press M-x and type doctor at the prompt to run EMACS' "doctor" module, which is the famous ELIZA-like psychiatrist built into it. If this doesn't convert someone from using pico, nothing will.

Also note that EMACS notation uses "RET" to refer to the ENTER key. This derives from the days when the alphanumeric ENTER key was often labeled "RETURN", because it was analogous to a typewriter carriage return. vi commands vi (short for "visual") is the most popular text editor in Unix/Linux. It's not as feature-and-keystroke laden as EMACS, but that's why most people like it.

vi - press ESC and then type a colon to get to the vi command prompt. Once there, the following commands apply: w Save file q Exit vi wq Save file AND exit vi, all in one handy command. Environment variables in bash - The most important are PATH and PS1. PATH is the set of directories the shell will look in for the program to run when you type a command (it works exactly like DOS' PATH variable). PS1 is what your Linux command prompt looks like (it works exactly like DOS' PROMPT variable). Linux hotkeys CTRL-Z forces an exit to most programs and returns you to your shell (where you can then use kill (or kill -9 ;) ) to get rid of the process. CTRL-ALT-F1 through CTRL-ALT-F6 switch between virtual consoles.

Special characters at the command prompt  *nix systems have a number of "special" characters which let you do some fancier tricks at the command line. Here are a few: ` This is a grave accent, NOT an apostrophe. The grave accent is the "backwards apostrophe", located under the tilde key (right next to the key for the number 1 near the top of the keyboard). It lets you execute a command within a command. Use two grave accents to enclose a command, and the result of that command will be used. If that didn't come through too clearly, here's an example: echo `cat /home/foo` Typing this will output the contents of /home/foo.

This is because cat listed the file, and then the results of that (the contents of the file) were used on the command line for echo. This is a simple example, but obviously more complicated (and useful) things can be done with this. & This symbol is used at the end of a command. It executes the command and then returns to the command prompt without waiting for the command to finish. It's useful for Xwindows programs, when the program runs in a window and then prevents you from accessing the console window you used to run it until you close the program. For example, typing this: xeyes& ...would run xeyes and still let you use the console window you were on without having to close xeyes first. ~ This symbol (the tilde) lets you specify a user's home directory. For example, ~foobar specifies the home directory for the user named foobar. And typing cd ~foobar would change to that user's home directory.

Note that you can also use just a tilde without a username to specify your own home directory. ! The exclamation mark is interpreted as a history reference. Don't ask me what that means, but basically, you can't use an exclamation mark by itself at the command line. If you want to use one, precede it with a backslash so the computer will realize you actually want to type an exclamation mark and not a history reference. So, type \! instead of just ! . Windows is a trademark of Microsoft Corp., so don't pretend you thought of it yourself.  Back to the main page    This page hosted by  Get your own Free Homepage

Chainsaw Perl

Saturday 03 December 2011 at 06:05 am

Perl is sometimes called the Swiss-Army Chainsaw of programming languages.

Perl is an interpretive language which can easily be run on Linux and Windows platforms. With strong string handling, file i/o and the fame of the term 'Perl Regular Expressions', Perl has brought an rich and well defined lexicon to the world of procedural definition.

Why Procedural?

Unlike a GUI, a procedure is concise and well defined. While proprietary computing purveyors like Microsoft seek to hide the inner workings of their systems, the fact is we all know that there is a registry. They try to hide the fact that the computer code is text, but they can't entirely.

Perl gets right to the issue, doesn't hide, and short little programs can be quite powerful

Perl and the World Wide Web

Perl became widely used with the CGI server structure with Apache and the world wide web. Scripts in Perl are virtually unhackable in the CGI directory of a website making it an ideal method of managing login methods and secure server functions.

Syntax

Perl's syntax builds on several Linux and Unix boilerplate functions awk, sed, shell and C. Perl also often has many ways to achieve a task, and the resulting code is sometimes compared to APL. Some say that no Perl programmer can read anyone elses code. Nonetheless, skilled perl programmers produce powerful reults and the interpretaive nature allows quick development.

Perl Concatenation

Like PHP, Perl uses the period as the concatenation character.

Weak typing.

While Perl is a powerful text manipulation language, it is not a fast math language, and was not envisioned for heavy math operations. Perl also can perform quickly boolean operations on bytes like && for AND and || for OR.

Hello World with Perl

On your Linux system with Perl, create this program and chmod it to 755.

#!/usr/bin/perl -w

print "Hello World";

If you don't like the lack of a newline, add \n to the end of the output string. This assumes that your Linux system interprets Perl with /usr/bin/perl, this may vary.

Perl MySql Example

Tuesday 29 November 2011 at 10:29 am

#!/usr/bin/perl -w
#
#script to add up some table data

use DBI;
use CGI::Carp qw(fatalsToBrowser);

print “Content-type: text/html\n\n”;
my $dbh = DBI->connect(’dbi:mysql:database=DATABASE_NAME;host=localhost’, ‘USERNAME’, ‘PASSWORD’)
 or die “Couldn’t connect to database: ” . DBI->errstr;

my ( $k, $id, $book_date, $svc_type, $cust_id, $time_pref, $a_sched,$a_eight);
 my $t_date=”20080115″;

$sqlquery = qq( SELECT id, book_date, svc_type, cust_id, time_pref, FROM `orders` WHERE  `move_date` = $t_date );
  $sth = $dbh->prepare ( $sqlquery );
  $sth->execute() || die “Couldn’t execute query: ” . DBI->errstr;

  $k = 0;
  $sth->bind_columns( \$id, \$book_date, \$svc_type, \$cust_id, \$move_date, \$time_pref, \$est_men, \$est_trks );
  while ( $sth->fetch() ) {
    $a_sched  += 1;
    if ( $time_pref eq “8-9A.M.” ) { $a_eight  +=1; }
    }

#Now $a_sched contains the number of records $a_eight contains the number of 8-9A.M. record for that date.

atlanta custom database design   vehicle dispatch ERP

Python Quickstart

Tuesday 29 November 2011 at 10:27 am

virtualenv pyProject

cd pyProject

pip install ephem


  

import ephem
from matplotlib import pyplot

m = ephem.Mars()

d0 = ephem.Date('1971/1/1')
for i in range(0,365):
  d = d0 + i
  m.compute(d)
  print 

Law and Order

Friday 14 October 2011 at 08:15 am

-- phpMyAdmin SQL Dump-- version 3.3.10-- http://www.phpmyadmin.net---- Host: mytmp.mansup.biz-- Generation Time: Jul 13, 2011 at 09:48 AM-- Server version: 5.1.53-- PHP Version: 5.2.17
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
---- Database: `lawnorder`--
-- --------------------------------------------------------
---- Table structure for table `episode`--
CREATE TABLE IF NOT EXISTS `episode` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(32) NOT NULL,  `writer1` varchar(32) NOT NULL,  `writer2` varchar(32) NOT NULL,  `original_air_date` date NOT NULL,  `season` varchar(2) NOT NULL,  `guest_star01` varchar(32) NOT NULL,  `guest_star2` varchar(32) NOT NULL,  `guest_star3` varchar(32) NOT NULL,  `guest_star4` varchar(32) NOT NULL,  `guest_star5` varchar(32) NOT NULL,  `guest_star6` varchar(32) NOT NULL,  `guest_star7` varchar(32) NOT NULL,  `guest_star8` varchar(32) NOT NULL,  `guest_star9` varchar(32) NOT NULL,  `guest_star10` varchar(32) NOT NULL,  `guest_star11` varchar(32) NOT NULL,  `director` varchar(32) NOT NULL,  `number` varchar(32) NOT NULL,  `music_by` varchar(32) NOT NULL,  `editor` varchar(32) NOT NULL,  `producer` varchar(32) NOT NULL,  `casting` varchar(32) NOT NULL,  `casting_co` varchar(32) NOT NULL,  `with01` varchar(32) NOT NULL,  `with02` varchar(32) NOT NULL,  `best_boy` varchar(32) NOT NULL,  `dolly_grip` varchar(32) NOT NULL,  `Copyright` int(11) NOT NULL,  `Series` varchar(3) NOT NULL,  `link01` varchar(64) NOT NULL,  `link02` varchar(64) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
---- Dumping data for table `episode`--
INSERT INTO `episode` (`id`, `name`, `writer1`, `writer2`, `original_air_date`, `season`, `guest_star01`, `guest_star2`, `guest_star3`, `guest_star4`, `guest_star5`, `guest_star6`, `guest_star7`, `guest_star8`, `guest_star9`, `guest_star10`, `guest_star11`, `director`, `number`, `music_by`, `editor`, `producer`, `casting`, `casting_co`, `with01`, `with02`, `best_boy`, `dolly_grip`, `Copyright`, `Series`, `link01`, `link02`) VALUES(1, 'Families', 'Jonathan Greene', '', '2004-02-10', '', 'Helen Slater', 'Geofffrey Nauffts', 'Tom Mason', 'Patrick Flueger', 'Spencer Treat Clark', 'Daniel Sunjata', 'Joel de la Fuente', 'Michael Mulheren', 'Tamara Tunie - M,E, Warner', 'Michael Boatman - Dave Seaver', 'Jane Seymor - Debra Connor', 'Constantine Makris', '106', 'Mike Post', 'Karen Stern', 'Peter Leto', 'Jonathan Straus', 'Lynn Kressel Casting', 'Stefanie Nava - Lisa Faber', 'Jenna Gavigan - Shannon Coyle', 'Tom Ford', 'Tom Grunke', 2004, 'SVU', 'http://lawandorder.wikia.com/wiki/Families', 'http://www.imdb.com/title/tt0629654/');

Read More
  • 1