Nomadic Logo Orange Black tm

Information Tech

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

Fabrik List 1

  • Here we Go

Featured Articles - Accordion

Our service of installing TurnkeyLinux Builds on Linode Cloud - available now

Our service of installing TurnkeyLinux Builds on Linode Cloud - available now

I am pleased to announce the ability and availability to install for customers the latest TurnkeyLinux builds to the Linode cloud as well as custom modifications.

We have worked with TurnkeyLinux web applications for many years and are familiar with their value and flexibility.  Out of the box from TKL (TurnkkeyLinux) can be aquired via ISO and several versions of Virtual Machine as well as the Amazon Cloud install which TurnkeyLinux makes possible.

I have worked with nearly all of these variations and they do work well.  Still,  some 5 years ago now, I found that bringing the builds into the Linode Cloud envirionment gave me much greater possibilities from several points. 

Linode exceeds in value (bang for the buck) that is in Server Performance for the cost.  It also works very well in terms of being in control and able to scale on demand, either up or down, resources that are required..   It is possible to access via a range of ways, do migrations, modifications.   

TurnkeyLinux builds in the Linode Sphere are all the more valuable.  TKL has a great range of backup and migration capabilities, as does Linode, and they can work together.  Moreover, because the TKL platform is generally platform agnostic, it is also possible to migrate away from Linode with ease should you decide to go to a different platform, host your own, or simply stash away an archive of your system.

Read more

Organizing your culled information stream

Organizing your culled information stream

It is tremendously complicated these days keeping track of what you are learning.

As an example,  I am diving into the realm of dropping pre-built Drive Images into Cloud Instances.  I need to keep track of the difference between a bzip2 and tar file, and how to decompress them.  Very nice people have commented their answers in various places.  Answers like:

bzip2 -d filename.bz2

tar cvjf myfile.tar.bz *.txt

Certainly there are many more of these as well.  I likely have 20 Tabs open talking about all the various approaches, but that is not the point now.

The point now is simply, how to "keep track" and if possible, how to perhaps help other people in similar quests.

3 Basic Elements I am finding useful:

  1. Bookmark Organizing

    1. "Bookmark Manager and Viewer" a Chrome Extension is particularly valuable.  It takes a bit to get used to with one or two foibles, but nothing better that I have found.  Use this in conjunction with Chromes Bookmarking (they have the same icon) and spread them out so you know which one you are using.
    2. "Tabs Outliner" also a Chrome Extension lets you explore and tab to your hearts content.  You can close whole windows and keep track of the tabs.  Ideally you will move from here to your actual bookmarks, but with this you can see what you have been searching for, reading up upon and in many ways also reflect on what is important
  2. Durable Checklists
    1. Honestly, I am still looking for the ideal version here, but what I do know is that Outlines go a long way.  Lets go there
  3. Outlines and Outliners
    1. Now discontinued Bonsai is very good.  Very Very Good
    2. Android Outliner is VERY VERY VERY GOOD  (number 1 really except that I work in Bonsai more)
    3. Workflowy is the best web outliner I have found so far

There are others.  They all deserve attention, but the point is not the program but the work.

Nothing is perfect and no integrations, yet, are perfect.  I do also use

  • Simple Mind for Outlining and Mind Mapping . 
  • Odoo to keep track of issues and many other details. 
  • Evernote..  must have
  • Dropbox,  for me anyway, must Have

All are also excellent programs:

Like threads in a spider web though, you need to have your own system of reference to keep them together.  Things are getting better, but, there is still you in the middle.

Getting things done..  a book and a mantra.  The program did not work very well unfortunately (may have had another name - written for PC Tablet computers in about 2005 ?).  It should have worked better.  The concept was incredible.  It just had big, in fact large and untenable, memory leaks.

Read more

Using FileMaker Pro as a Magento Editing Tool

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.

Read more

Wild landing

Wild landing

Wild Article Landing is a bit like a landing strip for sparrows.  Somewhat incongruous.  That said, there is a place for wings and perhaps this is also one.  Technically it is a landing page looking for a home.

I am reminded of a favorite Poem.

The Sea Battle

An American aircraft carrier
and a Gothic cathedral
simultaneously sank each other
in the middle of the Pacific.
To the last
the young curate played on the organ.
Now aeroplanes and angels hang in the air
and have nowhere to land.

by G√ľnter Grass

This is a holder article

Read more