David Zakary

Just renewed my ABM, downloaded the current version. When trying to register in the Demo file I get a dialog with the body of "Success" and title of "Registration Failed". The result text is "-10 Failed - Contact PCI to purchase more licenses". I'm only using it on one computer. Suggestions?

Currently in the process of upgrading a client from 1.0.1.0 to the current version. Is there a function guide available for that version anywhere?

Permissions seem fine. I'll try the PSoS method. Thanks all.

Realized that I had an old version of the Base Elements plugin on my macOS FMS installation. Disabled the plugin in the Admin Console Removed the file from the Database Server > Extensions folder Put the new version in the folder Restarted the server The plugin is recognized in the Admin Console but it is disabled and I can't enable it. Any thoughts?

Went to use the Diff Processor function for the first time today. Old version local on my machine, dev version on Server. Loaded both DDR's into the Processor window and got messages about "no matching Modified file" and "no matching Original file". Didn't find any documentation about the Diff Processor. The file names are different. Any suggestions?

After a quick search, I couldn't find anything about MirrorSync and FileMaker Cloud. Is MirrorSync compatible with FM Cloud? Found it in the MS documentation, yes with an asterisk.

Hi all, If anyone else is using Parallels 12 on a Mac this may be of use to file away somewhere. I run my development FM 15 Server in an OS X El Capitan Parallels environment. Host machine is OS X Server, VM is OS X. FileMaker Server runs on the VM. Generally works well for me. Upgraded to Parallels 12 when it came out a few weeks ago. Had to replace my backup drive as it wasn't big enough. The new drive is 4 tb, USB 3.0. The Host computer would see the drive but when I tried to attach it to the VM it would vanish - neither the VM or Host would see it, nor would Disk Utility on either side. Only way to get it back was to reboot the Host machine. Parallels tech support had no idea on what the problem was and told me that the drive (G-Technology) was probably the culprit. According to Parallels, if it doesn't say "Parallels compatible" on the outside of the box they can't officially support it. When I asked which drives were marked as "compatible" I didn't get an answer. Buggers. Tried a few brands of drives (LaCie, G-Technology and a generic) with similar results. Only thing in common was USB 3.0 and they were large drives (4 or 5 tb). Turns out, if you disable USB 3.0 support in Parallels 12 all works fine. Tech support didn't know that. A Parallels forum member suggested it. The drives mounted fine with a Mac OS X Host and Windows 7 Pro VM. The combination of a Mac Host and Mac VM seemed to be the issue. Maybe its time to try VMWare.

I'm working on a cross-tab report using ExecuteSQL. I'd like to try to do it as a single eSQL statement but I'm not sure if its possible or not. I'm still a bit of an eSQL newbie. Background, the database manages work done in a condominium building. Each apartment in the building is identified by a floor and a location in the building; 1-9 for the floors and N, NE, SE, W for the location. For the report, the floor is on the vertical axis and location is the horizontal axis. Each cell in the report is a sum of apartments where the work has been completed. I have the first part of the statement working, I can grab a total number of apartments completed on each floor. What I need is the total for each location, on each floor. So far the SELECT statement looks like this. I didn't include the eSQL and the delimiter bits. It returns the floor # and the total number of apartments completed correctly. "SELECT a.\"apt_loc_floor\", COUNT (a.\"zz_ID\") FROM \"rep_Apartments\" a INNER JOIN \"accounts\" b ON a.\"zz_ID\" = b.\"zz_fk_apartment\" WHERE b.\"ac_conversion_date\" is not null GROUP BY a.\"apt_loc_floor\" ORDER BY a.\"apt_loc_floor\" I know it could be done via several eSQL statements but I'd like to try to do it with as few as possible. Any suggestions? Also, the second field for the location is "apt_loc_location" Dave Zakary

Actually it isn't that vague. Sheju wants to import into multiple tables at the same time to build the related records. You can't do that in one step. Likely the easiest way to do this type of process is to create a table that is used just for importing. Bring the Excel file into that table. You then have to work your way through each record in this temporary table. You'll start with all of the "parent" data, go to the parent table, create a new record, record the primary key value and then set the fields as needed. The next step is to go to the child table(s) and create all of the records required there. As you've got the primary key value in a variable you set that into the foreign key field to build the relationship between parent and child tables. When you do the set fields your lookups should trigger. It's a lot of jumping around and looping but pretty straight forward. There are other methods too but you may find this the easiest.

If the Computers table is the base table for the layout, a portal based on the Join table which contains fields from Users should do the trick.

Yes I did. Thanks to Michael we got it up and running. A tweak to the DocuBin file and some of the SuperContainer settings was required. Thanks again Michael.

Getting closer. Most of the plugins seem to install and I get to the main DocuBin browser window. Whenever I click on any of the Library items I get an error (see screen grab). In the FileMaker Pro prefs the Docubin Companion Plugin is inactive. Trying to activate it causes an error. Quit FM, manually removed the plugin from the extensions folder. Do not get prompted that the plugin needs to be installed.

Will give it a shot. Thanks for the quick reply.

I'm trying to get DocuBin up and running on my development FMS14 machine. I installed SuperContainer and it is running on the server in demo mode right now. I uploaded the DocuBin files to the server machine. When I open the DocuBin file I get an error that the DocuBin Companion plugin isn't installed. It tries to install but is disabled in the FileMaker Pro Preferences. When It try to enable it in the Prefs I get an error. Installing apps from anywhere is enabled. The Remote Scripter plugin is also not installed and isn't. Any suggestions?

Wondering what the status of SuperContainer and DocuBin are for use with FileMaker 14? Been trying to get them configured on my dev FMS14 machine without a lot of luck yet.

The file appears to be missing now. Hopefully the original author (or other user) will repost it.

Thank you Steven.

Sorry. Never used MirrorSync

I modified a CF from Briandunning.com and have been using it for several years. I use the vertical pipe as a separator. I retrieve the parameter with GSP (x), where x is whatever parameter number I need. IIRC, Todd Geist wrote a blog post a while back against the use of the name-pair format - basically it was too much to manage.

Its pretty much Matt P.'s example file.

So I finally got ScriptMaster to combine the PDF's for me. Now I have a couple of other issues... I use SM to combine the PDF's. If the generated SM PDF file is over 20 megs - it won't open. Corrupt somehow. So I set the PDF routine to create 100 PDF's and then SM combines the 100 into a single file, delete the 100 source files and then continue on to the next 100, combine, delete, etc. The first combined PDF is fine. Each subsequent PDF that SM creates is only 51kb and won't open. The first combined PDF is 6.7 megs. Anyone have any thoughts?

I had missed one custom function when I moved everything over. Amazing how much better it works when you have all the code. Thanks for the help everyone.

Watched Matt Petrowsky's video on using ScriptMaster and iText to combine PDF files instead of using FileMaker's very slow Append to PDF script step. I've tried to move the code from the example Matt provided into my code. ScriptMaster is installed and I've got the code pretty much intact from what Matt did. For some reason it won't work. Some of the code comes across commented out (sm.exist). I'm not able to un-comment the code without getting an error. What am I missing?

Is it possible to call a FileMaker script from a web viewer? This would be a controlled HTML file, either local or hosted. A button in the HTML file would need to call a script and possibly pass a parameter or two.

I need to pass a couple of parameters in an FMNET link for an email being sent from FileMaker 11. Yes it could be done with a snapshot link, but we want a text link in the body of the email. I can't find any documentation for passing parameters (like a record number, etc.) Can anyone point me in the right direction? Dave Zakary