Jump to content


Productive Computing
  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About PCIPal

  • Rank

Profile Information

  • Location
    San Diego County, CA, USA
  • Interests
    QuickBooks Integration, Outlook/Exchange Integration, FileMaker Hosting, FileMaker Plug-ins, FileMaker Custom Development

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet
    FileMaker Business Alliance
    FIleMaker Platinum Member
  1. With the holidays right around the corner, Devon 2017 feels like a long time ago. If you are missing that exciting buzz experienced at DevCon, we invite you to take a listen to FileMaker Talk’s podcast from DevCon – “ Live at DevCon in Phoenix 2017” . You need to open it up in iTunes, but it will certainly transport you right back to Phoenix (lazy river and 99-degree weather not included). The podcast starts out with Matt Navarre interviewing Jesse Barnum from 360Works. Jesse talks until about minute 11:40 and discusses their MirrorSync product, including its pricing and what’s new with version 4. Jesse’s portion of the podcast also includes an insightful discussion on 360Deploy and how that product works. After Jesse, our very own CEO, Marc Larochelle, is on from about minute 11:40 until 41:00. Marc talks about what’s new (as of July 2017) here at Productive Computing – which included discussing our latest plug-in, the Exchange Manipulator SE, and its functionality. Marc also hinted that a Google plug-in might be in the pipeline for PCI (wink) and he mentioned that we are now Intuit Authorized QuickBooks Resellers! Marc and Matt also discussed AWS (Amazon Web Services) and PCI’s hosting services, including how we manage our servers and why we use Amazon Workspaces. Lastly, they discussed PCI’s hiring and training practices (including our training program for all new hires). At minute 41:41, Nicholas Orr from Goyacomes on to talk about their flagship product, BaseElements (which now has a new annual pricing model, making it more affordable and easier to upgrade) and RESTfm (cool story – FileMaker came to Goya to discuss RESTfm when they were creating the FileMaker Data API). Nick also discusses his vendor session, which touched on the differences between RESTfm and Data API, including format flexibility and authentication flexibility. The fourth and fifth guests on the show are James (Dave) Ramsey and Todd Geist from Geist Interactive at minute 52:15. In his segment, Todd’s talks about his 2017 FileMaker Award (for Advocacy) and Dave discusses their new product – FMPerception – and what exactly it is/does (hint: FileMaker DDR analysis tool that is crazy quick). Todd also talks about his training day session and what topics that training covered. The last guest on the show is Mark Richman from Skeleton Key at 1 hour and 4 minutes. Mark discusses Skeleton Key’s extensive participation in DevCon, including the many sessions he and his staff presented during the week (Security 101 and The ABCs of reselling; 7 Tips for Getting More out of FileMaker Cloud and Introduction to SQL and ODBC; The Power of Bi-Directional Relationships and Programming for Power Users). Mark also gave his opinions on the benefits of being a one-stop shop for your clients and the benefits of reselling FileMaker software. There are some great interviews here – hope you enjoy! View the full article
  2. Check Connection Mid-script

    Hi Wendy, Could you please let me know which version of the plug-in you are currently using? You can find out by using the demo; it should be listed in the "Plug-in Version" field. Please note that if you are using the 64-bit version of FileMaker with the 64-bit version of FM Books Connector v9, there was a bug in early versions of FM Books Connector before the release of v9.0.1.1 where the 64-bit version of the QB Bridge would lose its session after 2 minutes of inactivity or during a large volume of requests. This fix will require a reinstallation of the latest version of FM Books Connector v9. I hope this helps!
  3. Richard Carlton (Richard Carlton Consulting) recently did a video with our CEO, Marc, and our plug-in developer, Chris, discussing our sleeper plug-in, the Biometric Fingerprint Reader. Released in 2011, this plug-in connects your FileMaker solution to the U.are.U fingerprint reader, enabling your solution to scan fingerprints for fast identification and secure verification. We don’t talk about this plug-in very much nor do we spend a lot of time marketing it, but it’s a well-designed, tried and true, a workhorse of a plug-in. If you are curious to learn more, check out the video below. In this 15 minute video they cover: 1. What is the Biometric Fingerprint Reader 2. How the plug-in works 3. Why companies need and use the plug-in (integration example) 4. What the plug-in is and what it is not 5. Demo of the plug-in 6. Discussion of practical application 7. This is Windows only plug-in – is there the possibility of a Mac version? View the full article
  4. When it comes to hosting your FileMaker solution, there are a lot of options out there. You can host it yourself onsite, you can host with a service, or you can explore FileMaker Cloud. Let’s assume that you’ve decided the hassle and costs associated with hosting your solution yourself are too prohibitive and you’ve decided to host with a service. Now you’re looking at plans. There is shared hosting and dedicated hosting and concierge services for FileMaker Cloud (not discussed in this blog, but follow this link for more info). Shared Hosting Shared hosting is the most economical option available on the market and very appealing to a lot of people looking to host their FileMaker solution. In order to figure out if shared hosting is the right option for you and to help you choose between our Starter or Professional Plan, let’s start with a few questions: First: What version of FileMaker Pro is your solution currently running on? What version of FileMaker Server are you currently using and what version of FileMaker Pro and FileMaker Server do you want or need to be on? Okay, that was technically three questions, but they are all important. Our shared hosting plans support FileMaker Server 11-14 and FileMaker Pro (client) 7-16. The compatibility chart below details what FileMaker Pro versions are available on the different FileMaker Server versions. If don’t want to or don’t need to upgrade to FileMaker Server 15 or above, a shared hosting plan could be perfect for your needs. Second: How many files do you want to host (and how big are your files)? The Starter plan is ideal for one file and up to 1 GB of data. If you need to host more than one file, the Professional plan supports up to five database files and 5 GBs of storage. Third: Do you need FileMaker WebDirect or FileMaker Go connections? If yes, you need to go with the Professional plan. Our Starter plan does not support WebDirect or Go connections. Dedicated Hosting If you want or need to be on FileMaker Server 15 or higher, you need to go with dedicated hosting. We offer four plans (Micro Team, Small Team, Medium Team, and Large Team – henceforth referred to as Micro, Small, Medium, and Large) designed to cover, accommodate, and service a wide variety of needs and requirements. Let’s review some of the factors that go into deciding which plan is the best fit for you. 1. File size Each plan allows you to upload up to 125 database files, but the size of your files is a determining factor in deciding which plan is right for you. Our dedicated hosting plans offer varying quantities of disk space to accommodate the overall size of your files. Our Micro and Small plans have limited storage. If the files being hosted are too large, it becomes difficult to provide redundant backups without incurring additional costs. If your files’ total sizes are less than 5 GB, you are probably okay going with the Micro plan. With 60 GB of disk space available, anything larger than 5 GB becomes too big for the standard backup routines that are included with the plan. What if your FileMaker files are just a little too big for the Micro plan? Then the Small plan should work for you since it can host files up to 10 GB. With either of these plans, you can also purchase additional blocks of 100 GB for $20 a month. If you have files over 10 GB, then you may want to consider a Medium or Large plan. These servers can hold files up to 150 GB – giving you lots of room for your FileMaker file and even external data too. 2. Performance What kind of performance do you need and what do you intend to do on your server? If you plan to run continuous routines or regular audit systems, you are going to want to opt for the Medium or Large plan. With more RAM available, these plans are better equipped to handle complex processes that won’t result in lag. Interested in learning more about FileMaker performance when hosting? Check out this video Marc Larochelle, our CEO, did: Click here to view the embedded video. 3. Bandwidth Depending upon how you use your solution, you may need a lot of bandwidth. Several things can determine if you need unlimited bandwidth: A. if you work with a lot of interactive containers B. if you plan to regularly download data to your local machine C. if you use custom web publishing D. your backup is going to Dropbox All of these use a lot of bandwidth, so we’d suggest our Medium or Large plan. If you use your solution more for regular data entry and as storage for historical documents that you are not downloading daily – you’ll be fine with a Small plan (or maybe even a Micro). 4. Number of FileMaker users / WebDirect access Here are two more things to consider. Do you have less than 10 FileMaker Pro users? Look at the Micro Plan. Anything over 10 users, your options are wide open with the Small, Medium or Large plans. While all plans support FileMaker Go access, only the Small, Medium, and Large Team plans support FileMaker WebDirect access. If you intend to have more than 10 users connecting to your solution via FileMaker Go or you want to use WebDirect, also stay with any plan above the Micro plan. The Small, Medium and Large plans come with 8 GB or 16 GB of RAM, respectively – which is needed if you intend to have a larger number of users connecting remotely. 5. Backups Each of our dedicated plans have a robust backup schedule. Your ideal plan will depend on your backup needs. The Micro and Small plans keep a daily backup for 7 days. At any point, your oldest backup will be from one week ago. Additional backups or DropBox storage (for archive purposes) may be requested for an added cost. If you need more longevity on your backups, you can consider a Medium or Large plan. These plans hold backups for up to one year. Both plans (Medium and Large) include twice daily backups completed at 12:30 pm and 1:00 am. These daily backups are kept for one (1) week. We then run weekly backups that are kept for one (1) month and monthly backups that are kept for up to one (1) year. For redundancy and disaster recovery, all backups are stored on a 1 TB external drive and a daily backup is uploaded to a dedicated folder on Dropbox (see #6). If you are considering creating your own backup schedules, we highly recommend the Medium or Large plan. Additional backups can be costly on the Micro or Small plan, due to the fact both are running on AWS. AWS charges per GB of space, as well as bandwidth usage. 6. Dropbox Do you want your backups available via Dropbox and do you want the ability to access a Dropbox backup up to 365 days later? Dropbox is automatically included with Medium and Large plans. Dropbox is available with our Micro and Small plans, but it does cost extra. With Dropbox, we can provide you with backups that are up to 365 days old. Dropbox also allows for more redundant storage of your backups. 7. SSL Certificates We include a wildcard SSL certificate with all of our plans. If you would like a customized SSL cert for a custom domain name or other requirements, this options is available for an additional fee. One last piece of advice. Before contacting a hosting provider, you should know: 1. How many users you will have using FileMaker Pro, Go, and WebDirect. 2. How many files you want to host, as well as the size of those files. 3. What version of FileMaker Pro and Server you plan to use. If you’re interested in hosting your solution with us, give us a call today (760-510-1200) and talk to one of our hosting engineers. We’ll discuss your requirements and specifications and get you on track with exactly what you need. View the full article
  5. The eSign plug-in is only supported with one of the three Topaz devices listed on our website: http://www.productivecomputing.com/electronic-signatures The following devices are confirmed compatible with the eSign plug-in: - Topaz T-S460-HSB - Topaz T-L462-HSB - Topaz T-LBK462-HSB - Topaz T-LBK462-BSB You can purchase these devices directly from Topaz or through our website.
  6. If you receive this error, you will need to install the Acrobat plug-in. Please follow these steps: 1) Close Acrobat and FileMaker 2) Navigate to Applications > Adobe Acrobat DC, right click on Adobe Acrobat and select “Show Package Contents” 3) A new Window will pop up. Navigate to Contents > Plug-ins 4) Copy and Paste the Acrobat plug-in “PDFManipulatorDCAcrobatPlugin.acroplugin” (which can be found in the “Extras” folder in the Installer) into the Contents > Plug-ins folder from step 3 above
  7. This error, usually preceded with the message "Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client", means that the bitness of Outlook and FileMaker don't match. Both applications need to be either 32-bit or 64-bit, but not a mix of the two. Please make sure that the bitness of the both FileMaker and Outlook match and try again.
  8. In certain cases, such as Windows updates or Outlook updates, Outlook Manipulator may return an error “80040155” (“Unknown MAPI Error” or “Interface Not Registered”) result when calling PCEM_Authenticate( username ; password ). The following fix has been provided for the plug-in: ‣ Ensure that FileMaker and Outlook are both closed. ‣ Right-click on the FileMaker application and select “Run as Administrator.” (In Windows 7, 8, or 10, you may need to right-click on FileMaker within the first pop-up box to see “Run as Administrator”) ‣ Allow FileMaker to run with the administrator elevated privileges. ‣ Once FileMaker has completed loading, close and reopen FileMaker as normal. ‣ Optionally, you may reopen Outlook if your solution requires Outlook to be open. ‣ This fix will make a modification to the Windows Registry to ensure that the communication interface the plug-in uses to talk to Outlook is properly set up. The changes will only work if FileMaker runs in “administrator” mode. Once FileMaker has been run with these elevated permissions for the first time, the fix will be set and any further calls to PCEM_Authenticate, whether FileMaker is running in standard or administrator mode, will have the proper communication interface set up for it.
  9. You can refer to the Intuit OSR which has the available field names in QuickBooks that you can use: https://developer-static.intuit.com/qbSDK-current/Common/newOSR/index.html
  10. Clearing registration certificates can usually fix most QuickBooks connection/session issues, however, it will require the user to re-register their FM Books Connector plug-in. In order to re-establish a connection properly, there are specific steps that need to be followed: 1) Open Quickbooks and log into the company file that you want to establish a connection to with an admin account in single-user mode 2) From the “Edit” menu, click on “Preferences”, click on “Integrated Applications” and in the “Company Preferences” tab remove any instances of FMBooks Connector and click OK. 3) Close FileMaker. 4) Go to C:\Users\<current user>\AppData\Local\PCINC 5) Delete the folder called FMBCONNECT* 6) Open the demo file provided with the FM Books Connector plug-in 7) Enter your License ID and click “Register” 8) With both Quickbooks and FileMaker open, click on “Test” 9) Quickbooks will prompt about making a connection with FileMaker. Choose your desired connection type and click “Continue...” *If using the 64-bit version, you may need to reinstall the QB Bridge after deleting the FMBCONNECT folder
  11. When running the setup.exe file on a 32-bit operating system, the installer may not complete properly. If this happens, you can install the components individually instead of using the installer package. First, you must install the Visual C++ 2013 redistributable package: 32-bit - http://download.microsoft.com/download/0/5/6/056dcda9-d667-4e27-8001-8a0c6971d6b1/vcredist_x86.exe Once this is installed, run one of the demo files included with the plug-in by navigating to the plug-in's "Extras" folder, then in the "Demo Files" folder, you'll find the demo file. Just open the demo file and click the "Install" button. Once it's installed, you can register the plug-in with your license ID or the Demo license.
  12. Error 1550 is defined as “Unable to install plug-in”. The most common case is that the system lacks the required dependencies in order to run the plug-in. To resolve this, there is a download link in the bundle for the plug-in, that points to a download link for the Visual C++ 2008 and 2013 Redistributable Package, available from Microsoft’s support website. Save the installer file and run it on your machine, and that should add in the required dependencies into your environment. Once the installer is finished, re-open FileMaker, and you should see a splash screen upon initialization. Visual C++ 2008 redistributable package: 32-bit - http://www.microsoft.com/en-us/download/details.aspx?id=29 64-bit - http://www.microsoft.com/en-us/download/details.aspx?id=15336 Visual C++ 2013 redistributable package: 32-bit - http://download.microsoft.com/download/0/5/6/056dcda9-d667-4e27-8001-8a0c6971d6b1/vcredist_x86.exe 64-bit - http://download.microsoft.com/download/0/5/6/056dcda9-d667-4e27-8001-8a0c6971d6b1/vcredist_x64.exe .NET Framework link: https://www.microsoft.com/en-us/download/details.aspx?id=30653
  13. Error 1551 means you are using a 32-bit plug-in with a 64-bit version of FileMaker. You will need to install the 32-bit version of FileMaker in order to get the plug-in installed.
  14. This error typically occurs when you are trying to use a 32-bit plug-in with a 64-bit version of FileMaker. You can run FileMaker 14 in 32-bit mode, however starting with FileMaker 15 going forward, support for 32-bit mode has been dropped. To run FileMaker 14 in 32-bit mode for Mac OS, do this: 1) Locate the FileMaker Pro 14 application icon in the Applications folder 2) Right-click the app icon and select the “Get Info” option 3) Enable the “Open in 32-bit mode” option 4) Close the FileMaker Pro Info window Please note that there is a known issue when launching FileMaker from the Mac OS Dock. When launched from the Dock FileMaker assumes it should be opened in 64-bit mode. In order to run FileMaker in 32-bit mode, you will need to launch FileMaker directly from a FileMaker file (instead of using the Dock) in the application folder.
  15. If you used the setup.exe file to install the plug-in, you can uninstall the plug-in using the same method. Just run the setup.exe file and it should give you the option to uninstall the plug-in. If you didn't use the setup.exe file or would like to uninstall the plug-in manually, depending on the version of FileMaker and OS version, you can uninstall the plug-in by closing FileMaker and removing the file “PCXX.XXXX.fmx or PCXX.XXXX.fmplugin” from the following locations below: Windows: - “C:\Program Files (x86)\FileMaker\FileMaker Pro Advanced\Extensions” - “C:\Program Files\FileMaker\FileMaker Pro Advanced\Extensions” - “C:\Users\“User”\AppData\Local\FileMaker\Extensions” - “C:\Users\“User”\AppData\Local\FileMaker\FileMaker Pro Advanced\“version”\Extensions” - “C:\Users\“User”\AppData\Local\FileMaker\FileMaker Pro\“version”\Extensions” Mac: - “Applications/FileMaker Pro/Extensions/” - “Library/Application Support/FileMaker/FileMaker Server/” - “Users/“User”/Library/Application Support/FileMaker/Extensions/” - “Users/“User”/Library/Application Support/FileMaker/FileMaker Pro/“version”/Extensions/” - “Users/“User”/Library/Application Support/FileMaker/FileMaker Pro Advanced/“version”/Extensions/” - “~/Library/Application Support/FileMaker/Extensions/” - “~/Library/Application Support/FileMaker/FileMaker Pro/“version”/Extensions/” - “~/Library/Application Support/FileMaker/FileMaker Pro Advanced/“version”/Extensions/” Note: Be sure to quit/exit the FileMaker application before removing the plug-in file

Important Information

By using this site, you agree to our Terms of Use.