Odoo ERP Management

Odoo Installation and Management Services

We are skilled and and able to bring your business effectively to the Cloud or backoffice server using open source Odoo ERP and a variety of complimentary systems.

Our fundamental approach is to get you setup on either Amazon's AWS Cloud (international) or the Linode Cloud in the United States.  We have found incredible performance gains in the last few years and are happy to share this with you.

Odoo 8.0 is a vibrant and effective ERP system which will help you efficiently manage your business.  Additionally we tie the system generally together with the Magento E-Commerce system and the Joomla CRM system.  (All of this is optional).

Please Contact Landis Arnold for more information

Print Email

Using FileMaker Pro as a Magento Editing Tool

I have put together today an extensive and effective way to use FileMaker Pro 12 as a content editing tool for Magento.  This has been on my "to do list" for a long time, but after exploring this actively for a few days, I was excited to have it come together in a real and immediately useful way.

The way to do this involves 

Setting up an active ODBC connection to Magento

Building an Empty FileMaker Database.

Importing One field from the Catalog_Product_Entity field.

Building a series of relations to bring forth the critical Data for each the additional information on each field.

The difficulty in this is the exploration in setting it up properly.

Having set it up now for myself and tested it extensively I would be in a position to help other clients set up this method for FileMaker editing.

Advantages

The primary advantage to this approach is the speed with which the Database can be "Selected From" and Reviewed and Updated.

Spell Checking is "built in" to FileMaker and brings to light otherwise hard to see errors.

The slow start and exploration involved in understanding Magento's EAV struture is short cut.  In turn, seeing the method it should be easier to build further tools on your own.

Scope:

In terms of scope I am focused primarily on the Text Attributes of the Magento File.

It would certainly be possible to edit various Product Images as well if accompanies by related uploads.  However, I can see that the Magento method for this is very effective.  

Magento editing itself is also very effective.  It is just a bit clunky when you start working with 100's and 1000's of products.

Specifically tuning Long and Short Descriptions, Meta Tags and Meta Titles and other elements likewise is tedious and difficult work to quicly review.

Alternatives:

Certainly Magento Modules can be found to improve some of these things.  Many of these modules have costs.  Further, they are normally not very flexible unless you get into PHP / Magento programing.

My approach is quite flexible and the display of information, the process of selection and other items can be easily modified via FileMaker Pro methods.

Navicat is my other Data Tool of choice.  I tend to use it hand in hand with FileMaker and the Magento Admin interface.  

Requirements:

I am using FileMaker Pro Advanced v 12  to do these methods.  It is possible you can do this with normal FileMaker Pro.  I have done similar work (but not updating) going back to FileMaker Pro v 4.1.  

Please Contact Me if you would like to discuss an integration of this method for your company.  I feel you will be quite happy with the result.

Screenshot 2016 04 11 22.16.33

Print Email

Building an effective TKL Base

There are many components to setting up an effective IT infrastructure.  Different systems have different capabilities.  This is one of the reasons I like the the Turnkeylinux set of applications.  They are very consistent in their operating model and it is possible to install them in to a wide variety of server environments.

Each can be easily accessed via SSH, WebShell or Webmin interfaces.  This gives a full range of capabilities as well as a reduntant and intuitive access approach.  All those with Database backends come with, generally, the Adminer database access module with which most simple edits and explorations can be pursued.

But even with this installation capability and their excellent set of apps which surround there are things that you may want to accomplish.

For me, one of those things. are data-access via separate Database Clients.  I happen to like both Navicat and FileMaker pro for database interactions and both systems can access TKL data if approached in a deliberate, security oriented method.  The advantage to this of course is that you can very much streamlilne some of your interactions with your systems which are otherwise bogged down by assumed needs put forth by the app centric programming, and the somewhat limited Adminer Interface.  (Do note that you can install PHPMyAdmin nd PSGAdmin (get the names right!) with a little extra work.

Print Email