Let’s do the same thing with MySql
pip install MySQL-python
import MySQLdb class mydbconn(): def __init__(self): self.con = MySQLdb.connect('x', 'x', 'x', 'x') def get_columns(self,table): cuc = self.con.cursor() cursData = cuc.execute("SHOW columns FROM " + table) HEADERS = cuc.fetchall() keyName = HEADERS keyLen = self.lenFunction(HEADERS) return keyName, keyLen, HEADERS def lenFunction(self,varCharString): x = varCharString.find("(") varCharString = varCharString[x+1:] x = varCharString.find(")") varCharString = varCharString[:x] return int(varCharString) if __name__=="__main__": con = mydbconn() keyName, keyLen, h = con.get_columns("customer") for i in h: print i
On the fifth line of the program, use your MySql credentials. Sometimes the first parameter is localhost, the second x is the username for the database, the password is third and the name of the database is fourth.
You also have to change the parameter in line 2 of the main section to the name of the table you are using. This routine also has been used with databases that had a key other than named id for the first field, and it was important to have the name of the key and its length to proceed with scaffolding
In the Sqlite3 sqlalchemy example, we got a list of field names. In this example, we get a tuple of tuples. At this point, tuples might be a preferred format, they are immutable and hashable, and a utility crud function would not need to add and remove things from the tuple. However, in a more sophisticated scaffolding environment, you would add things like a field for password verification or especially remove things, like the ability to change certain fields.
CRM, or Customer Relationship Management is a class of collaborative applications for enterprises that keep track of prospects, leads, customers, customer complaints, orders and shipments.
CRM, or Customer Relationship Management is a class of collaborative 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.
Seo’s talk in ways that are hard enough to understand, but sometimes we use nomenclature straight out of a John Wayne movie. The good guys wear white hats, and the bad guys wear black hats. In SEO terms, we warn that ‘black hat’ techniques can lead to a possible temporary boost in ranking, but we stress that solid long term success requires the use of white hat techniques.
Bing has published a series of advisories for webmasters as follows;
- Use valid XHTML or HTML, use the W3C validator.
- The <title> tag should contain between 5 and 65 characters.
- the Meta Description tag should contain between 25 to 150 characters.
- the Meta Keywords tag should contain less than 874 characters.
I don’t know what the penalties on Bing are for violating these guidelines, but I can say that any
good promotion should not be overwhelming to either man or machine. For example, a dry cleaner that uses every popular keyword including ‘bikini pics’ is not really being honest. Black hat techniques don’t depend on honesty, they only seek traffic.
The problem for a legitimate dry cleaner is that the traffic that comes from ‘bikini pics’ does not lead to revenue. The search engines can tell this in advance by heuristically comparing the keywords to the real content and message of your site and they assign a value to the keywords as they pertain to your website, and where your website does not match the hype, that hurts the value they give to your website.
Building long term success
There are two major categories of getting noticed on the search engines, organic and pay per click. Most cold calls you receive to promote your website will be from pay per click companies. We can provide everything these boiler room operations provide, for the same price, while gradually training you and your staff on how to manage your pay per click campaigns. You should build this expertise within your office, or you will be paying too much forever. Within a year of using our pay per click service at web-Atlanta you will be able to control your phone from your pay per click budget panel. Really. Call me for references. They will tell you.
Some high pressure sales calls are actually from organic companies. This is more difficult, because it entails subtle refinement of the website content to optimize your website’s presence on the first page of search engines. This is the area where a reputable SEO firm is required. Many ‘get to the top quick’ schemes use tricks to change your ranking. These tricks may show a short term gain, but in the long run they will hurt the credibility that search engines assign your site.
Some examples of dirty tricks are; buying links, mass reciprocal e-mailings, (we reject more than 5 out of 6 reciprocal requests), mass link dumping to blog comments, email spam, incredible keyword deviation and link farm injection.
The ethical, and responsible way to promote websites involves understanding the search engines and how they ‘think’ (OK, they don’t think, they use heuristic techniques to algorithmic traversal, index and catalog the context and content of domains). Our object is to improve, refine, and enhance the content of our customers websites to honestly reflect their business. We create credible taglines and promote them within the website and about the internet at large. We optimize title tags and meta keyword and description elements to maximize the quality rankings of your website. Search engines respond to our techniques in time periods of from weeks to up to a year for newer domains. Take shortcuts, and you will regret not using web-Atlanta, or a reputable firm of your knowledge.
MAPICS was a Manufacturing Requirements Planning system, MRP, developed for IBM mainframes which evolved to run as MAPICS ERP on the Linux operating system with IBM eServer iSeries computers. MAPICS ERP for iSeries and Linux for iSeries provides greater stability, reliability, scalability, performance and economy. MAPICS ERP for iSeries’ uses Java-based interfaces for rich fat-client Desktops in the local area network as well as thin-client Internet and wireless access. Mapics claims to help manufacturers to collaborate better over the Internet, “improve customer service, deliver products faster and make better business decisions”.
“MAPICS recognizes the manufacturers’ need for flexible, open, real-time collaboration to streamline operations, and the Linux operating solution gives them a competitive edge,” said John P. Carter, Jr., senior vice president and general manager, North American Operations, MAPICS. “The Linux operating system, which will leverage manufacturers’ existing technology investment, is an extremely stable, open operating system that provides a heterogeneous, integrated, reliable server operating system across a manufacturer’s eServer technology platforms.”
Linux provides not only the sturdiest foundation in server software but boasts the highest transactions per second in many benchmarks. IBM has a long history of solid hardware products and a dedicated service force to maintain IT centers.
“Linux, represents an exciting new technology that is rapidly gaining market acceptance. It is a simple and economic way to implement next generation e-business applications,” said Per Larsen, vice president of eServer solutions at IBM. “By being one of the first ERP application vendors to support Linux deployment for its solutions, MAPICS is ahead of the curve in helping manufacturers move toward e-business.”
Headquartered in Alpharetta, Georgia, world wide provider of ERP applications MAPICS was the oldest ERP provider, with roots in the MRP days of the ’60s and ’70s, before being acquired by Infor. Scientifically strong, MAPICS has helped manufacturers compete with improved and more timely procurement, often called JIT, better information for strategic decisions, enhanced production planning tools and interfaces between departments and through-out the supply chain. MAPICS’ comes in two enterprise resource planning (ERP) foundations. (need more info)
Customers include Honda Motor Co. Ltd and the Bayer Corporation.
MAPICS is a trademark of MAPICS, Inc. The IBM e-business logo, eServer, and iSeries, are registered trademarks or trademarks of IBM Corporation in the United States and/or other countries. The IBM eServer brand consists of the established IBM e-business logo with the following descriptive term “server” following it. Other brand and product names may be trademarks of their respective owners.
From 2002, a press announcement for pre Infor Mapic is linked below.
The ADempiere project began in in September 2006 as a solution to ongoing philosophical differences with the development team at Compiere. Frustrated with commercial aspects and goals at the Compiere project, the developers behind aDempiere sought a more robust and impassioned technology sharing and leveraging effort, rather than concentrating on the freezing of the standards and building of the installed base which may well have been the more important focus at Compiere.
ADempiere is based on JBOSS and the JVM client platforms interacting with databases such as PostgresSql. Sourceforge hosts a client download for Windows which is a package of the ADempiere java based business logic, the JDK and a PostgresSql installation. The ADempiere client can be configured to interface with Linux servers running the Oracle database, so scalability is wide ranging. Instructions for installing the client on Mac, Ubuntu or Fedora are available here.
ADempiere boasts modules for Quotations, Proposals, Sales Orders, Work Orders, Invoicing and Shipping. Also Purchasing, Requisitions, Receiving, Vouchers. Also Bills of Materials, Warehouse, Physical Inventory, forecasting, discrete manufacturing, maintenance and costing.
Adempiere also contains General Ledger, Accounts Receivable, Accounts Payable, Human Resources and even boasts of CRM, POS and ecommerce. Likely these are more of restful capabilities to meet other solutions.
Lean manufacturing zealots have declared that web-site design and development can be done faster with the help of Lean manufacturing techniques. They contend that even copywriting is faster, don’t ask us how. Lean manufacturing is a promising practice in the delivery of goods that eliminates pointless and wasteful elements of the production and delivery cycle for elimination. Somehow, this is done by hiring wasteful and self absorbed Lean Manufacturing consultants, because you were too stupid to do this. But let’s examine the Lean Manufacturing premises and promises to see if we can just apply some common sense to our operation. We can even ponder the creative process of copy-writing and look for an application for these principles.
First, widely we hear claims for Lean, these I will call the promises;
- 1/2 the man hours
- 1/2 the defects (quality improvements )
- 1/3 the engineering man hours
- 1/2 the floor space for the same factory/distribution productivity
- 1/10th or less of in-process inventories, i.e. Just in Time or JIT WIP management
To back up these goals, the Lean evangelists ask us to envision a ‘fictitious Boat Factory.’ In their workshop they ask teams to for a production line to make as many cardboard sailboats as possible in 30 minutes. They say that the workers struggled to produce 20 good boats and produced 30 defective boats. They then reorganize the divisions of labor in an improved manner to help the team produce 36 boats with only one defective. They hope their dupes miss the point that the initial crappy production line was designed to be unwieldy by the creators of the workshop. They instead only stress the results.
- 80% output improvement
- 70% reduction in lead time
- 97% reduction in defects
All because the assigned method forming the assembly line was optimized. Their assumption is that manufacturers are too stupid to do this, and their data is whatever they say. This is not to say that a production line exists that cannot be improved. My only point is that this little workshop and its purported lessons are rather pedantic.
The relevant facts of Lean Manufacturing consist of looking at the production line in terms of bottlenecks, length, capacity and people. They squeeze those terms into the word FLOW by calling this Faults, Length, opening and workforce. I think they wasted a lot of time doing that. My first suggestion for the Lean Manufacturing people is to quit wasting their time on silly acronyms and stick to the point. A line consists of capacity and operations, and is never perfect. Wow, C-O-NP. Whatever. One claim of the Lean Manufacturing people is that Toyota has seven to ten times the productivity of American companies. Any experienced manufacturing professional knows the utilization of KanBan by Toyota, which can help any manufacturer improve throughput at the expense of WIP. Not surprisingly, when you optimize one thing, something else has to be loosened up to accommodate.
No better example of Lean Manufacturing in practice would be the delivery of water to a fire. Dozens of firemen may spend hours and days idly at the firehouse, and then when called upon all traffic on the road should yield to the firetrucks. Sacrifices made in the productivity in some areas to get water on a fire most quickly.
But even more fascinating is the application of this cheerleader driven logic excercize to web design
The Lean people start with the word FLOW. F stands for faults, and they assume first that clients know what they want. In the Lean Manufacturing model of ideal web-design they encourage lots of meetings to determine the exact number of pages and design of the web-site required. Those meetings of course, are roughly a waste of 75 to 90 percent of meeting time. The purpose of a website is to present information, via the internet and search engines, to an audience of information consumers. Some meetings are required but for the most part only delay the publishing of the website to the internet and search engines. But never mind that, isn’t it just extraordinary how they work the word FLOW into things. At Web-Atlanta we have published web-sites with copywriting in 72 hours. Atlanta web design doesn’t get leaner than that.
At Web-Atlanta, one difficulty we do have is with the graphics department. They insist that a certain amount of ping-pong, fuse-ball and fresh fruit juice are components of a happy workforce. In our copy-writing department, I can assure you that a whip and a cattle prod are quite sufficient. Seriously, the rapid publishing affords us interaction with our clients supplementing the design. The budget is not spent on a myriad of wasteful workshops cutting out cardboard boats with blunt scissors, the real interaction begins when the prototype hits the clients desk and conference calls begin with the clients and Atlanta web design.
The next letter is L, and as you can see, Atlanta web design from Web Atlanta can bring forth a published web site before ten percent of the scheduled meetings have occurred for other web design firms. Then we come to the letter ‘O’ which pertains to the capacity to produce web-sites. Not including graphics, Atlanta web design firm Web-Atlanta produces three sites per day, technically and in copy-writing. In business for fifteen years, we are still waiting for the graphics arts department to decide on the logo for our stationary.
Web Atlanta is a great advocate of incorporating existing EPS graphics into the web design. If you have a public relations graphics package then we can save countless weeks of waiting by allowing our graphics arts department to just play fuse-ball and drink juice while they think about our Logo at Web-Atlanta – our technical department can do the manipulations required to use your existing graphics.
The Lean Manufacturing folks would be a little peeved if I finished without mentioning the W in the word FLOW. As I have mentioned, our use of cattle prods and corporal punishment is all we need to mention in dealing with our technical and copy-writing departments. But another invention of the Lean Manufacturing world are the 5 esses.
- remove clutter
Yes, those are the five esses of Lean Manufacturing. Ess means the letter ‘S’ and they make one thing into two because a number 5 looks like a letter ‘S’. Wonder how much time they wasted on that? Don’t waste your time wondering – too much.
Load times for five style sheets of 10kb can be more than double that of one stylesheet of 50kb. Thus, the railsish optimizations can double the speed of RoR webpage delivery. Many designers are afraid that cached webpages may lead to content served but not statistically captured. In the GA model though, the use of an asynchronous JS client side seems to insure that each client reports each web page at least exactly once per cookie-life. However, in distributed content environments the server managers such as Amazon and Yahoo suggest that if your files have changed, use a new file name. You can trick browsers into thinking the file URL has changed by adding a useless query string, e.g. index.php?moonjuice=fryed-okra.
SaaS – Software as a Service
Prospects measured and filed when receiving calls, emails, inquiries.
API to integrate the CRM – Customer relationship Management
Product sales procedure.
Sales managers can track and adapt to shifts in customer attitudes and perspective in purchase to make effective product sales methodologies.
Efficient ways to apply and keep track of advertising expenditures and evaluate them in relation to prospective income.
Prospects delegated within the product sales team.
Evaluate sales operations to supply group leaders with data of income forecasting in Sigma CRM Probability assessments are tracked and mapped.
Sales data extended phrase reviews and give the sales force maximum visibility.
Buyer Service Automation, customer service, likelihood of demand, replacement parts demand, precise purchasing.
Small and Medium Enterprises in Atlanta interested in an open source solution for CRM and ERP can rely on the groundwork laid at MSInc for LAMP based products in the Enterprise Resource Planning and Customer Relationship Management arenas. MSInc has a rich background developing and implementing LAMP and unix or Linux based Material Requirements Planning, Resource Planning, Customer service and core accounting functions. MSInc built the famous Support Series II application that flourished on Zilog, Arix and SCO Unix based systems in the 1990’s. With it’s IEEE based Y2K initiative, S2I2 provides to this day a flawless if somewhat legacy in technological terms orented solution covering core areas of ERP such as Customer Relationship Management with core modules like LQDE, Material Planning with IQDT and JQDA / SQDK core accounting foundations.
Despite the robust nature of S2I2 applications, MSInc is now developing in the cloud, using Software as a Service in such applications as FMCSA compliance with their leased WRbil product for dispatched service enterprises. Even plumbers, local movers and retail companies with a delivery fleet can now manage hours of service without dependence on a finicky spreadsheet and a full time harried DOT compliance clerk ever hoping their complex excel formula not fail them.
WRbil is a LAMP application, that is it is based on Linux, Apache, MySql and PHP/Perl. It is implemented on the cloud model and provides a limited scope of functions compared to the more robust S2I2 application. WarBil is a part of the mix in modern SME application environments which also house accounting environments like QuickBooks, Peachtree Accounting or MAS 200/500. With this product in hand at MSInc we have then sought out alternatives to closed technologies and found three interesting alternatives to the formerly named solutions. At MSInc we have begun evalutating Compiere, OpenBravo and last but not least, perhaps our favorite, XTuple.
Pronounced with a long ‘U’, XTuple is a solution out of the Southeastern United States, which we at MSInc find attractive in itself. Like Rehat, this application comes in the free as in open (not free as in beer) open source model. While we see the depth and complexity of these applications to be sufficient that client modifications should be considered carefully. Our investigations are partly centering on the seperations of the format, template, gui and business logic layers. One common requirements in modifications are the additions of fields to the database and the addition of business logic to provide extra funtionality.
Information on LAMP ERP is available from MSInc.