PCIPal

Hi Sue, Try to do the following: 1. In Contacts, go into Find mode. 2. Select the "Company" checkbox and select "Omit" for "Matching records:" 3. Click "New Request", select "Omit" for "Matching records:" and enter in "NOMAIL" in the "Keywords" field. 4. For each keyword that you want to find, click "New Request" and enter in the keyword in the "Keywords" field. 5. Perform Find Sincerely, Carson

Hi soundsessential, You can set the "metaData" attribute in the request and look for the retCount attribute in the response. Here is an example for Customer Query. PCQB_RqNew("CustomerQuery" ; "metaData=MetaDataOnly" ); PCQB_BeginSession(); PCQB_RqExecute(); PCQB_RsGetResponseAttribute( "retCount" ); Also, you should be using the latest version 11.0.0.1 of the FM Books Connector plug-in. There were bugs on setting the attributes in a request in version 10 and 11.0.0.0 of the plug-in. I've tested the confirmed that it is working on 11.0.0.1 of the plug-in. Sincerely, Carson

San Diego, CA – November 9, 2018 - Productive Computing, Inc., a Platinum member of the FileMaker Business Alliance, is proud to announce a new Maintenance Support Program for FileMaker users. This program is intended to provide FileMaker customers a low-cost alternative to time and materials billing when performing “fix it” type programming and regular maintenance on their systems. Support plans are designed to improve the performance of a FileMaker app by fixing nagging issues that users create workarounds for, reducing the costs associated with upgrading from one version of FileMaker to the next, providing a means to clean up and modernize legacy code, improving a solution’s user interface, and regularly meeting with and getting advice from a certified FileMaker development team. This program allows its users unlimited access to FileMaker experts without worrying about the bill. Productive Computing’s FileMaker Support Program includes: Unlimited support on small development and support requests Unlimited support on FileMaker Pro usage/training Free consulting sessions on programming best practices and workflow recommendations Free Health Assessment ($1,000 value) One free subscription to Productive Computing University ($149/yr value) Annual customer workflow audit, FileMaker new features overview, and system recommendation report "We just completed a massive upgrade in our FileMaker system and, now that we’re on the maintenance program, we’re able to reduce ongoing costs for any remaining open issues as a result of the deployment. The maintenance program has unquestionably delivered a tremendous value for an affordable price." Alana W., 25 Users, Historic and Fine Art Industry Representatives Clients who also purchase their FileMaker licensing through Productive Computing will be provided with the following services at no additional charge: Discounted hourly billing rates for larger custom development projects Unlimited FileMaker Pro client and server installation support Unlimited SSL Certificate installation for security of FileMaker Server Unlimited support on issues related to FileMaker upgrades and conversions This support program is designed for customers who: Are considering making changes to their system but are concerned about the cost Have recently invested in major custom development to expand their solution’s functionality Would like to have an on-call FileMaker support resource who knows and cares about their business and specific workflow Like programming themselves but occasionally need a little bit of help or advice Are interested in outsourcing their FileMaker development to free up staff time Do not have an internal employee maintaining their system Value annual system checkups and would benefit from regular service to keep their solution working at maximum efficiency Are interested in continuing to improve their system and business processes Want to capitalize on FileMaker’s newest features to benefit their company Productive Computing’s FileMaker Maintenance Support Program is available for $200/mo for up to five users, additional users can be added for $40/mo. For more information on plan details and restrictions please visit https://www.productivecomputing.com/filemaker-maintenance-support-program/.

Hi Paul, You will need to edit your sales tax rates in QuickBooks Online. Then you can do a query to pull in the tax codes and tax rates into FileMaker. Edit Sales Tax Rate in QuickBooks Online Sincerely, Carson

Hi jfk_25, That error indicates that QuickBooks has not been accessed by the third-party application (in this case, FileMaker 14) before. This is expected behavior when connecting to QuickBooks after upgrading FileMaker to a new major version. All you need to do is open QuickBooks and your company file, then begin a session and configure the QuickBooks configuration certificate as per the Developer's Guide, just like you were doing a first-time startup. You will then be able to use QuickBooks in unattended mode once more. The reason behind this is that the QuickBooks treats the combination of the FM Books Connector plug-in and the version of FileMaker as the key to determine when a different application has tried to access QuickBooks. If you were to set up a connection with FileMaker 14, and then upgrade to FileMaker 17, QuickBooks would treat FileMaker 17 as a "new application", and so the first-time setup would need to be repeated. It's a bit of extra work, admittedly, but it's necessary, and once it's been re-configured, anyone with access to your company file can connect from that new version of FileMaker. Hope this helps! - CT

Hi Paul, You are correct! There is, however, a cap that Intuit uses which natively sets the limit to 500 records, due to a limitation of bandwidth and throughput on the network connection. You can also use pagination to pull in all records from QuickBooks, by setting a combination of the "StartPosition" and "MaxResults" fields, and looping until there are no more records left to pull. We have an example of how to paginate in the Developer's Guide, for future reference. Thanks! - CT

Hi Trebor, Runtime versions of FileMaker have their own Extensions folder that any needed plug-ins should be placed into. Usually, this is in the runtime's primary folder, in the "Extensions" subfolder. Place the plug-in into that folder to have FileMaker Runtime load the plug-in on initialization. To install the QB Bridge, when you download the installer package of the FM Books Connector, we have included in the Extras folder a copy of the QB Bridge installer as a standalone installation package. Normally, you'd just run the primary installer (the first "setup.exe" file), which would take care of the plug-in and the QB Bridge program all in one go. But some instances only need the bridge file separate, so we have the separate QB Bridge installer provided. You'd simply run that setup.exe file and it will take care of installing the bridge. Hope this helps! Chris Turner

Hi TJ53, At this time, the Cloud Manipulator is not server-side compatible, so unfortunately it will not work with FM Go. I have added your name to our interest list, and if the plug-in is later updated to become server-side compatible, we'll send out an announcement. Thank you for your interest! CT

San Diego, CA – October 18, 2018 - Productive Computing, Inc., a Platinum member of the FileMaker® Business Alliance, is proud to announce the release of Cloud Manipulator. This AWS FileMaker plug-in connects your FileMaker app to Amazon Web Services S3 storage. The Cloud Manipulator allows the user to upload, download, query info, and move buckets and objects in AWS S3 (Simple Storage Service). “As a company, we’ve been using AWS in an increased capacity over the past few years for hosting, testing, and automated backup routines. We also have several hosting customers with advanced needs who use S3 for their document/file storage and are able to gain all the benefits that go along with S3. Our new plug-in makes working with files on S3 much easier and far more available to provide automated workflows for end-users without the FileMaker developer having to learn advanced programming languages or master the sophisticated S3 API. "In my experience, I’ve found S3 storage to be arguably one of the most durable, flexible, and infinitely expandable storage technologies available. With the Cloud Manipulator plug-in for FileMaker, the world of S3 becomes more readily accessible for our FileMaker customers looking to have a world-class storage option at their fingertips.” Marc Larochelle, Chief Executive Officer, Productive Computing, Inc. The Cloud Manipulator Plug-in: Allows communication with Amazon Web Services S3 buckets, objects, and properties Enables FileMaker to upload and download object/files from AWS S3 Manages buckets and folders Pulls object details such as when last modified, size, owner name, and storage class Creates, copies, moves, and deletes objects on AWS from FileMaker Uploads objects to standard AWS storage class and downloads objects from any storage class The plug-in comes complete with developer tools including a Functions Guide with full function details and available bucket and object fields, a Developer’s Guide with detailed information and example scripting, and an unlocked demo file to exhibit all of the main features of the plug-in. The Cloud Manipulator plug-in is compatible with FileMaker client 15-17 and is available starting at $50 per year for a single user license. For more information on the Cloud Manipulator plug-in and system requirements visit http://www.productivecomputing.com/aws-filemaker-integration or email sales@productivecomputing.com.

Hi Duncan, You might want to check to see if the file permissions on the PDF document allow your user account to make modifications to the file. We've seen situations where a file downloaded to a Mac does not receive the proper file permissions. If this machine was a Windows machine, I'd suspect that another process is trying to use the file at the same time, but based on your file paths, that doesn't seem to be the case here. If you can, try making a copy of the file and reference that file. Also, make sure you're following the standard PDF Manipulator workflow to open the file with PCPF_OpenPDF before calling PCPF_SaveAsPDF. Thanks! CT

Hi Duncan, You can use standard FileMaker text functions to trim the leading slash. In this case, you'd want to use the "Right" function to get the rightmost characters, and pass it the file path and the length of the file path minus 1 ("Right( $filePath ; Length( $filePath ) - 1 )"), that will give you the filepath without the first / character. For other folders, you'd probably need to hard-code the file path and then append the dynamic file name. So you could do: Set Variable [ $filePath; Value: "Macintosh HD/Users/adgilcan/Box Sync/PSRB&H4FA/Applications/Navy Applications/" & Veterans::__pkVeteransID & " " & Veterans::VeteranName & " Application Form.pdf" ] You'd obviously need to make sure that the folders in the path actually exist, so that the system won't experience the error you're receiving. And in this second case with the example step above, you wouldn't need to remove the leading / because there is none to remove. Hope this helps! CT

Hi adgilcan, That's a pretty straight-forward question. You can use the values of the Veterans::VeteranName and Veterans::__pkVeteransID fields in the calculation for the file name / file path. For example: Set Variable [ $filePath; Value: Get(DocumentsPath) & "Database/" & Veterans::__pkVeteransID & " " & Veterans::VeteranName & " Application Form.pdf" ] This should create a variable called $filePath with a value of "/Macintosh HD/Users/Robert/Documents/Database/pk100 John Doe Application Form.pdf", assuming that the key parts are the same as the examples you've provided. You may need to trim off the leading / character at the start when passing it to PCPF_SaveAsPDF, as the function requires a properly-formatted system file path for saving the PDF. Hope this helps! CT

Hi cday2003, This kind of error might come up if there is an issue with the Outlook configuration on the machine. Are you able to test the connection from another machine with a similar Outlook account setup (You can use the Demo license on that machine for the test)? Also, can you confirm that the data file for the Outlook account is properly configured? You might be able to connect successfully if you remove and recreate the account in the Mail account setup in Outlook or the Windows Control Panel. Thanks! - CT

Hello, I do believe that this is possible but personally haven't seen any plug-in that does specifically this. If our PDF plug-in ever incorporates this features we'll update you. Best Regards, -Quincy

Hello Veselko Thank you for reviewing your issues with me. Based on what I see, this will require a more in depth review of your scripts. This in-depth review with a certified developer will require that a paid tech support ticket be opened with a credit card so that a meeting can be scheduled. Paid technical support is billed at $185 per hour. All time spent by our certified developers is billable including meetings, follow up calls, correspondence, planning, etc. However, you will only be billed for the time incurred and we round down to the nearest minute with no minimums. If there is a plug-in bug, then there will not be a charge for our support session. Our developers typically are available Monday - Friday 8:00am - 5:00pm PST. Do you wish to proceed with a paid technical support ticket? This will be Paid Tech Support unless there is a bug with the plug-in. Best Regards, -Quincy