Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About dickiechung

  • Rank

Profile Information

  • Gender
  • Location
    Hong Kong
  1. dickiechung

    Deploying a solution with 500+ base tables

    I force quit after 2 hours.
  2. Will 360Deploy handle a Filemaker solutions that has more than 500 base tables (File size: 3.63Gb without graphic) ? I have no problem of deploying the original demo file. Since the documentation 360Deploy Roadmap indicates that "You can also try 360Deploy out with your own solution, just be sure to rename your database file '360Deploy demo solution.", I tried, but failed. Filemaker Pro Advance 16 always hanged at Step 8: Copy Script steps into '360Deploy Import Worker". See attached. Any idea?
  3. dickiechung

    RFID Hardware and Software integration with Filemaker

    Thank you very much for your inputs. We have successfully build an Access Control System with the following features: Access control hardware are installed in different locations for different departments. Access control hardware are updated regularly the official working hours and access rights of each employee. Filemaker can access and control the hardware over our internal network. Our solution: We bought a 2 in 1 (finger print recognition and smart card reading) Access Control Hardware from www.jd.com, a Chinese online retailer at around US$100. (ZKT U100) The hardware came with a management software to work with the hardware. We asked the supplier to give us a .DLL file (not came with the hardware). We use PowerBuilder to create a .exe file to execute the functions of a .DLL file that works with the hardware. To update the records of the hardware, we use Filemaker to create a .txt file (containing info of employee names, IDs, working hours etc.) in a temporary directory and immediately call the .exe file (using Send Event) to execute the .DLL functions to update the hardware. To download attendance data from the hardware, we use Filemaker to call the .exe to import data directly into Filemaker. (The .exe is created by PowerBuilder and Filemaker acts as an ODBC database of PowerBuilder when data is downloaded from hardware.) The smart cards we buy have unique serial number pre-encoded so that we avoid the need of encoding smart cards.
  4. We are using Filemaker Pro 14 to develop a Staff Management and Control Access System. Each employee will be issued a RFID card as identity card. We need to integrate RFID encoder and RFID reader with our Filemaker database. May anyone point me to the right direction how this can be done? Are there proven RFID hardware and software that will work with Filemaker Pro from encoding/writing to decoding/reading?
  5. Is there any way for Filemaker Pro 14 to load and use commands/functions in a .DLL file? In my old system using PowerBuilder/Oracle, we can load a .DLL file to PowerBuilder with “OLE Control” and call the functions inside .DLL to work with PowerScript. Can I do the same thing with Filemaker? Is there any plug-in that will do the job?
  6. Other than the scenario as described by tmr_slh, could it also be due to the incorrect clocks of the mobile devices A and B? If the clocks of device A and device B are 5 minutes ahead and 5 minutes behind the clock of the server respectively, would they affect what records are to be pulled or pushed?
  7. Hi Tim, Thank you for your feedback. I am afraid UTC Timestamp does not fully solve the problem. I tested the Get ( CurrentTimeUTCMilliseconds ) of Filemaker. If I change the system clock, the value return by Get ( CurrentTimeUTCMilliseconds ) will change accordingly. The Help of Filemaker does not mention that Get ( CurrentTimeUTCMilliseconds ) needs an internet connection for an external reference of the precise UTC Time. What I worry is when a mobile device is used offline, the modified time will be set according to the system clock. Another scenario: what happen when 2 databases are synchronised over an intranet with with no internet connection to get the precise UTC time? Will they both rely on their own system clock to get the UTC time? My preliminary test of EasySync seems to indicate that the accuracy of the system clock do matter.
  8. If a user of a mobile device set the clock of his device wrongly, say year 2015 becomes 2014, and do a sync with EasySync, would it mess up data in the FMS13 server? If so, what would be the best strategy to avoid such incidence. In general, how can we synchronize the clock of the server and the mobile devices BEFORE a sync action is done by EasySync?
  9. Problem solved. Just uncheck the "Delineate fields on current record only" in the Layout Setup. If you select Delineate fields on current record only, borders and fill will show on the current record in List View, but not when you print, print to PDF, or preview the records being browsed. Borders and fill do print for all records in a field if the option is deselected.
  10. I set up a repeating field in my layout with borders and vertical lines to separate each cell. They look fine in browse mode. However, all borders and vertical lines disappear when I switch to preview mode. Is it a bug, or is there anyway to show the border and vertical lines of a repeating field in preview mode? I use FMP 13 Adv. with the same behaviour in OSX Maverick and Windows 7.
  11. dickiechung

    Popover from non button

    Is it possible to show the popover panel just by hovering the mouse over the popover button (or the button with go to object script) without clicking?
  12. Sometimes we miss the obvious. I did created before a number of one-row portals that laid horizontally to simulate the horizontal repeating field. I tried hard to use different formula to filter the portal to display only the row I want. Only after reading your message did I suddenly realise that I can solve the problem simply by specifying the initial row to be displayed under Format of Portal. Thank you.
  13. I am working on a system for garment industry. There are many grids of data (eg. color/size, style/country combinations) with finite rows and columns. Using repeating field simplifies input process and presentation. My idea is to allow user to enter data intuitively and efficiently. The major problem is that there is no horizontal portal. There is only a vertical scroll bar and fields of each child record has to be listed vertically, not horizontally. What puzzled me was the same calculation works with a field definition in Manage Database but not by a script step, and it seems there is no work around.
  14. I have a value list $$List with 5 values and I want to assign those values to a repeating field with 5 repetitions. If I define a calculation field with 5 repetitions, I can set the values of $$List to the field successfully with: GetValue($$List; Get ( CalculationRepetitionNumber )) However, if I define a text field with 5 repetitions and use Set Field to assign the values, the same formula does not work. I have put Get ( CalculationRepetitionNumber ) under Repetition of the field to be set. However, the value of Get ( CalculationRepetitionNumber ) always remain as 1. How can I get it done? Is there a simple way to clear all the repetitions by calculation without using a loop to clear each repetition one by one?

Important Information

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