Monday, March 16, 2009

FAQ: Role Based Value List Filtering

QUESTION: The Sales Rep ID in the sales order module needs to be changed to a pull down like the Staff ID field.

ANSWER: OK, this does work like that but it has a bit of a twist. It is a good twist, so let me run this by you. The pull down list for the Sales Rep ID is filtered to show only the staff members assigned to Sales. You haven’t assigned anyone to sales in the staff file yet, so the current state of this value list, for you, is empty. As soon as you assign a staff member to sales, it will then show up in the value list.

This list option is great unless you have staff members that wear multiple hats. The security within InBizness (as well as many of the value lists) are role based. So I can reassign the Sales Staff value list to be a general staff member list (not role specific).

If you have staff members that wear multiple hats, we might want to create a role for them specifically.

Tuesday, March 10, 2009

FAQ: Can You Sell Me Modules Of The Overall Solution

QUESTION: Is it possible to purchase InBizness per module?

ANSWER: I don't sell the InBizness product by module but that is an interesting notion for the future. If you want a lighter version of the InBizness product, just let me know. I'm sure we can work things out. I have done this for customers in the past. In fact, the InBizness Money product was born out of someone just wanting the Finance modules from InBizness 2.5.


It would be quite possible to extract the campaign or proposal modules and make them a free standing solution. You could extract the leads, events and staff module to make a light lead tracking solution for example.

So if you are interested in something like that, please do not hesitate to contact me at info@dwaynewright.com.

Sunday, March 1, 2009

Back Into The 360WORKS Email Saddle Again

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

Sometime during the third week of January (2009), my business simply exploded. I sold numerous copies of my InBizness FileMaker CRM product and most of those customers purchased customization services as well. My time for daily blogging simply vanished and I'm still under the gun. Before the deluge happened, I was working on a series of posts about the 360Works email plug-in and it has bothered me that I haven't made incremental progress on those. Today I reached an action item in which one of my clients wants to have InBizness automatically import email receipts from their online shopping cart and build sales orders from them.

It has been a couple months since I worked with the 360Works email plug-in and that is one great acid test for a plug-in. How difficult is it to pick up the ball again and start running with it? For me, I spent more time finding the example file I was working on, than it took to wire it up to my clients email address. You can see a series of links about my example file at the end of this post.

In order to test the plug-in with my clients email account ... I simply plugged in the email server address, the email address and the password. Hit the button that I had built back when the current year ended with an eight ... and ... it worked! I tweaked a few other things about the example file but then realized I had real work to do! I need to take this and integrate it into InBizness for my client. This is also a feature that I'll want to include in the next update of InBizness.

SO WHAT ABOUT FILEMAKER 10?
All my active development for the next release of InBizness is being done in FileMaker 10 and all my client work is being done in FileMaker 9. That will change soon because I have a client that really needs the script trigger and active report features of FileMaker 10. Right now, I'm using a Macintosh that is running FileMaker 10 and FileMaker 9 at the same time. My development version of InBizness is the same one that I use to run my business. So all my client timecard tracking is done there. Besides my timecard tracking, there is another benefit to this step. I can copy and paste code between the two versions of FMP9 and FMP10. So I tend to prototype new features in my FileMaker 10 development version of InBizness and test it there. Then I copy the code over to my clients version of InBizness, test it and then release that version to my clients. Works pretty well but I wondered about the 360Works compatibility with FileMaker 10.

CRUISING OVER TO THE 360WORKS WEB SITE
So my version of the email plug-in is 1.81 and I need to see what the current version is. I navigate over to the page dedicated to the email plug-in (found here) and in the right hand side I see that the current version is 1.86. So I've missed out on five updates and I'm thinking I might need to follow this a little closer. If I release this plug-in with my product, that may be a very good idea. I wonder what 360Works has in regards to notifying their customers of plug-in updates. I went ahead and clicked the link for the users that own a license and about to give it a go.

Here you can see what was downloaded.

Being the curious sort, I opened up the ChangeLog.txt file and found the following about the updates I missed.

Version 1.86
* Improved unicode support for attachment names when attachments are stored as container references.

Version 1.85
* Improved unicode support for plain-text messages with accent characters, foreign characters.

Version 1.84 (1/28/2009)
* Fixed compatibility issues with running on Server 10 and IWP

Version 1.83 (1/13/2009)
* Explicitly sends a sent-date header, to address complaints from SMTP servers about missing DATE header
* Added "count" option for EmailReadMessageValue, this returns the total number of messages fetched from the server. Useful for progress bars.

Version 1.82 (12/28/2008)
* Fixed IMAP message retrieval by uid for gmail servers, bug which caused incorrect uids to be used. Update to this version is you are using UID-based IMAP fetches!


The last two updates don't have a date attached to them but it still looks like an update has been rolling out every couple weeks or so. Only two of them seems to address a fix and only one of them is remotely FileMaker 10 related. I'm not going to use the plug-in with IWP yet, but good to know they are on the ball with updates for that feature! Everything else seems to be a set of self actualization improvements, that is good to know as well!

POPPING THE PLUG-IN INTO FILEMAKER 10

I quit out of FMP10 and cruise over to my FileMaker 10 folder to install the plug-in. Here I get a little freaked out about what I find. I have multiple copies of extension folders where my plug-in is supposed to go. What the heck is up with that? The five copies of the extensions folder are all empty, so I make a command decision to delete them.

Here you can see my extension folder seems to have replicated itself on January 9th, what weird mojo went on that day?

My example file has my license information within it for startup, so I close it from my FileMaker 9 application and open it up in FileMaker 10. I wander over to the development tab in the example file and see if my registration was successful on startup. This is logic I copied directly over from the 360Works example file. Houston, we DO NOT appear to have a problem. The plug-in reports that my registration was successful and verifies that I have the latest version! That is about as smooth of a process as you can expect for a plug-in experience.

Here is something that continues to be funny to me. I open up my example file in FileMaker 10 and get annoyed almost immediately. My thoughts are "Why did this open with the status area missing?" and I click the show status area button. Then realize this is FileMaker 10, I don’t have the benefit of a status area, click the button again and proceed to my FileMaker 10 arch enemy (the status bar). Yes, I'm firmly entrenched in the "hate it" camp for all things status bar related but what is a poor developer to do? In my case, my only option is to mutter a “dab nab it” and travel all the way up to the top of the monitor for everything I need to do.

Back to the discussion about the plug-in compatibility ... sorry about the mini rant ... I click the button to download the emails and it works like a charm! It worked exactly the same as the FileMaker 9 experience and mentally I stand up and do a quick snoopy dance. Next up, integrating the 360Works plug-in into InBizness. I'm going to start on that right after taking a Wii Fit yoga break.

Here are some links to other posts that might be of interest in regards to this topic...
External Functions Registering Your Plug-in
Custom Function - Name On Email
A Friday Afternoon With The 360Works Email Plug-In
Constant Relationship Portals And Tab Panels
Looping Script To Clean Email Addresses
Extraction, Transformation And Loading Process Explored


=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

ADVERTISEMENT ==================
Help support this blog by considering a donating to its ongoing growth. For more details, please visit http://www.dwaynewright.com/donate.html

Friday, February 27, 2009

FAQ: Protecting Credit Card Data Information

QUESTION: What is the most straight forward to remove access within InBizness for a majority of the users to clients credit card data?

ANSWER: The most straight forward way is to remove the field access permissions to the credit card related fields in the Clients module. This is done for each privilege set that corresponds to the business role of a staff member.

First up, open up the privilege set dialog box for one of the privilege set.

Under the records data access settings, choose the Custom Privileges option.

Next we want to choose the "limited" option for field access for the CLIENT table. This will allow us to target options for fields in the Client module.

From here, we want to remove the access for the privilege set for the credit card field. In the case of InBizness, these fields are have a prefix of cc_ .

So when you are done, it should look something like this.

Thursday, February 19, 2009

Google And MapQuest Directions For InBizness

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

A while back (January 27th 2009, to be exact) a custom function popped up on briandunning.com to allow you to do MapQuest directions for a FileMaker record. At that time, I did what many of us do, mentally filed it away as something to check out during the mythical free time moments. About a week later, someone emailed me and they wondering about how to integrate google maps into a FileMaker record. I passed them the custom function link for the MapQuest function, recommended they search there for google map features as well and again filed the topic away for later review.

As fate would have it, on Saturday morning, I received 27 new feature requests from a client that purchased my FileMaker based CRM product called InBizness. The first item on the list was integration of service calls module to google maps so that technicians could print out map directions to call locations.

Well, I could no longer keep this topic in the “check out someday” file, so I cruised over to the briandunning.com site and did some poking around. I came up with the following ...

GOOGLEDIRECTIONS
Added GoogleDirections from briandunning.com (http://www.briandunning.com/cf/724 ) and submitted by Chris Pye, Mactec, http://www.mactec.com.au. Takes two addresses and returns text formatted as a URL to display a Google Map with directions. This can be used to open a URL or Web Viewer window.

MAPQUEST_DIRECTIONS
from briandunning.com (http://www.briandunning.com/cf/959 ) and submitted by Robert Schaub, Starr Data, http://starrdata.com. Use your start and end address fields from you database or enter your custom find.

I tested both of these out and they seemed to work OK. The google map function seemed to have a problem when there is a comma in the street address. So I thought I’d warn my client about that and see if they want me to program around the possible issue.

ADDING AS A WEB VIEW IN A LOWER TAB PANEL
The first thing I tried was adding the feature as a web viewer within a lower tab in the tab panel. This worked OK but I still had the classic web viewer problem. The web viewer is like an oversized dresser that never really fits in the bedroom. You can move it around and around but it still never fits snugly.

You will need to click on this image to see it in detail. This is the tab panel setup I went with. You can see that I have an opening tab that explains the process, directions for both Google & MapQuest and then tab for maps of the location (sans the directions). These are setup to auto resize with FileMaker 9 but the Web Viewer still takes up a lot of screen real estate.

Pondering how to use the power of the Web Viewer, you may consider ripping out a wall to resolve the issue (and in FileMaker, that is what you do sometimes). However you realize that is a real pain and a huge productivity whole. You consider bringing up a new layout window with the web viewer viewer only but that also is a productivity hole and doesn’t net you much more than what you can do with the Open URL script step.

FYI ... The Open URL Script Step opens a specified Internet URL address or performs other specified URL protocol commands. This means that you can have a combination of web and FileMaker actions within a script that you use in your database solution. Here are some links to other posts that might be of interest in regards to this topic... The Open URL Script Step and EXAMPLE: Open URL Via Portal Records.

COMBINATION PLATE APPROACH FOR THE MAP TAB IN SERVICE
Since custom menus are so flexible and functional, I decided to use this method for utilizing similar mapping features across multiple modules. Of course, this would be much faster for me to implement if FileMaker would support copy and paste features for entire custom menus but that feature hasn’t been added as yet. (hint - hint - hint)

As I mentioned, I started off by implementing this feature in the Service/Support module of my InBizness product. I then added the Google/MapQuest directions Go To URL (via a custom menu) feature into the Clients module using my current set of recycling techniques from my tool bag. I found a couple tweaks that I needed to go and quickly implemented those changes. Now I have the map direction features in two InBizness modules (Support & Clients). Next up, I wanted to do a test to see how long it would take me to add this feature to another module. So I started the timer for the implementation into the Leads module.

I started at 7:58 AM and finished up the implementation at 8:06 AM. So within 8 minutes I was able to duplicate / edit existing script steps for leads, build the two custom menus for leads, test, troubleshoot, tweak and test again. I did run across a problem with the MapQuest function in that it did not like the entry of “United States” for the country data. A quick change of the county value list to “USA” fixed the problem and seemed to play well with Google Maps as well.

SUMMING THIS UP
InBizness (as with most robust CRM packages) has many independent modules that work together in concert. Using a modular design method, you can implement a feature in one module and invest the normal amount of development time. Written properly, the underlying code can quickly be implemented into multiple modules and this has multiple benefits (the least of which is a consistent feature set across modules that users can leverage during the business day).

ADVERTISEMENT ==================
Help support this blog by considering a donating to its ongoing growth. For more details, please visit http://www.dwaynewright.com/donate.html

Wednesday, February 11, 2009

Thank You For Your InBizness Money Purchase

I’m still evolving what I send to customers that purchase my framework products but don’t hire me to do the customizations. Here is a quick peek at my last quick message to a recent purchase of InBizness Money. If you have any suggestions about things I should add, I would love to hear from you!

**********

Thank you for your order. Here is a copy of our FileMaker framework application InBizness Money. As with most framework applications, this one ships without any data (so that you can add your own data, of course). There are some value lists that look for data, so you may need to create a few records to build this up or change the value lists to be in a typical list format. There may be a few other things that might seem unfamiliar, please feel free to email me with any questions you might have.