Jump to content

David Zakary

  • Content Count

  • Joined

  • Last visited

  • Days Won


David Zakary last won the day on August 28 2012

David Zakary had the most liked content!

Community Reputation

1 Neutral

About David Zakary

  • Rank

Profile Information

  • Gender
  • Location
    Toronto, Canada

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    What ya got?

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet
    FileMaker Business Alliance

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Permissions seem fine. I'll try the PSoS method. Thanks all.
  2. 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?
  3. 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?
  4. 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.
  5. 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.
  6. 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
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  11. Will give it a shot. Thanks for the quick reply.
  12. 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?
  13. 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.
  14. The file appears to be missing now. Hopefully the original author (or other user) will repost it.
  • Create New...

Important Information

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