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.
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.
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.
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.
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.
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 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. When installed, the main "outward" work of the App works well, but the Linux management is generally consistent between apps.
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. Further there is an excellent backup system built into TKL Apps, TKLBAM, with which it is normally possible to migrate an App between servers and server generations. Daily Security updates are de rigour.
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.
Server Platforms to which TurnkeyLinux Aps can be installed are wide and many. Nearly any computer, or Virtual Platform can be done quite easily. TurnkeyLinux also makes it easy to install to AWS (Amazon Web Services). For my part, I have found the best value and performance to be with Linode.com. I need to come back around to how I actually got my installs built, but once there they run like a charm. I will post a related article on making a Turnkey Linode install soon.
TurnkeyLinux's Web site can be found here https://www.turnkeylinux.org/