Jump to content

David Zakary

Moderators
  • Content count

    19
  • Joined

  • Last visited

  • Days Won

    1

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
    newbie

Profile Information

  • Gender
    Male
  • Location
    Toronto, Canada

Contact Methods

  • Website URL
    http://www.apokeinthebrain.com
  1. 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.
  2. 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.
  3. 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
  4. import

    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.
  5. How to, on the layouts, relate two many-to-many records

    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.
  6. SuperContainer / DocuBin & FM14

    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.
  7. Installation issues

    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.
  8. Installation issues

    Will give it a shot. Thanks for the quick reply.
  9. Installation issues

    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?
  10. 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.
  11. TimePicker for FileMaker

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

    Thank you Steven.
  13. Error from server: 802: "Unable to open file"

    Sorry. Never used MirrorSync
  14. "Strongest" way to pass multiple parameters.

    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.
  15. Combining PDF files

    Its pretty much Matt P.'s example file.
×

Important Information

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