Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About sfpx

  • Rank

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application
    16 Client

Platform Environment

  • OS Platform
  • OS Version
    10.11 el captain

Recent Profile Visitors

2,648 profile views
  1. sfpx

    Migration to a new server

    Thanks for help. The thing is that I would like to avoid having to do initial syncs. We currently have in place an update system that works. It installs an empty version of the database on the device and imports all the data from the previous version (including the mirrorsync table). This way, users still can sync normally after an update. My idea : 1.Change my current mirrorsync config to point to the domain name instead of the ip address 2.Wait until everyone has the new version that syncs to the domain name 3.Stop mirrorsync on the current server 4.Install mirrorsync on the new server 5.Copy everything related to mirrorsync on the new server (device sync data , logs etc) 6.Change the ip associated with the domain name 7. Wait for propagation 8.Users sync to new server Could that work ?
  2. sfpx

    Migration to a new server

    That is correct. The new server is not set up yet. Ideally users would still continue to sync to the old server and gradually , when they update to the newest version would sync to the new server. But I understand that it's probably more complicated because of the licensing issues , would necessitate a server to server sync and would also probably necessitate an initial sync on the new server. I would not mind if I had to hard stop all the syncs for an hour or 2 if it means that I can import de device sync data on the new server and they can continue to sync normally once I started mirrorsync on the new server (after I changed the ip associated with the domain name...not sure how long it takes to propagate). Of course with this 2nd method I would need to make sure all the users have the version that syncs on the domain name before stopping mirrorsync and start the migration. I do not really want to increase the number of users. It's just that I understood that I can not install the same mirrorsync license on 2 servers (at least that's what I read somewhere) so I would actually need to buy a new license with the same amount of users if I want both servers to sync at the same time. Maybe I got that wrong. Thanks for your help.
  3. sfpx

    Migration to a new server

    I guess that an easier transition would be done in a few steps 1.We change our mirrorsync config to point to our domain name instead of the ip address 2.We have an app update system that imports all the tables(including mirrosync) from a previous app to the new one. So a user that was syncing to the ip address now syncs to the domain name but keeps using his device sync data on the current server. 3.Once everyone has the new version then we can stop mirrorsync .Copy it on the new server.Copy the new database. 4.Change the domain name ip address. 5. Restart mirrorsync something along those lines. Would it work ?
  4. What is the typical procedure when you have to move your filemaker server to a new server with a new ip address ? Are there instructions or a tutorial for a smooth transition ? I understand that we can't install a license of mirrorsync on 2 computers. Let's suppose the current Mirrorsync license has 50 users. Let's say we buy a new license for the new server that syncs data from the old server and the new database and 50 users. Can we merge the 2 licenses together and have 100 users on the new installation after we delete the previous installation ? I'm quite intimidated by the task ahead.
  5. yeah I just figured that out. Thanks for the info about the concatenate function
  6. Adapted file from http://leodicroce.com/combine-pdfs-without-using-fm-append/ Changes from the demo file: -Latest Scriptmaster version instead of 4.32 -Loaded 2 additional Jars (bcprov-jdk15on-160 and bcpkix-jdk15on-160) The merge PDF function RegisterGroovy( "MergePDF( files ; output )" ; "import java.io.FileOutputStream;¶ import java.util.ArrayList;¶ import java.util.List;¶ ¶ import com.itextpdf.text.Document;¶ import com.itextpdf.text.pdf.PdfReader;¶ import com.itextpdf.text.pdf.PdfCopy;¶ import com.itextpdf.text.pdf.PdfImportedPage;¶ ¶ try {¶ String[] inFiles = files.split(\"\n\");¶ int f = 0;¶ int pageOffset = 0;¶ String outFile = output;¶ Document document = null;¶ PdfCopy writer = null;¶ ¶ while (f < inFiles.length) {¶ // Create a reader for the next document¶ PdfReader reader = new PdfReader(inFiles[f]);¶ reader.consolidateNamedDestinations();¶ ¶ // Retrieve the total number of pages¶ int n = reader.getNumberOfPages();¶ ¶ pageOffset += n;¶ ¶ // Create the master document¶ if (f == 0) {¶ // step 1: Create the document-object¶ document = new Document(reader.getPageSizeWithRotation(1));¶ // step 2: Create the writer that listens to the document¶ writer = new PdfCopy(document, new FileOutputStream(outFile));¶ // step 3: Open the document¶ document.open();¶ }¶ // step 4: Add content¶ PdfImportedPage page;¶ for (int i = 0; i < n; ) {¶ ++i;¶ page = writer.getImportedPage(reader, i);¶ writer.addPage(page);¶ }¶ ¶ f++;¶ }¶ ¶ document.close();¶ return outFile;¶ } catch(e) {¶ return 'ERROR'¶ }" ) The function generates the pdf correctly but locks all the files except for the output file so I can't delete them. I added writer.flush();¶ writer.close();¶ It did not change anything. Tried to add reader.close() but it generates an error. Any idea ?
  7. I added a script in the "Post-Sync Hub actions" section of the mirrorsync customization script and tried to pass the $$MIRRORSYNC_USERTOKEN variable as the parameter. The script does get executed but with a blank parameter. P.S. I only modified the script on the server and not on the device if that makes a difference...
  8. sfpx


    Great to know Thanks
  9. sfpx


    Forgot about that.. But it will eventually though. Pretty sure I read something about that .
  10. sfpx


    I understand that it would be quite the task to update MirrorSync to use the FM 16 REST API but I'm curious if it could be done and if this would result in a better overall performance.
  11. Got this kind of message twice this week. Not sure what it means and how to fix it. where XXX is an uuid with some user token
  12. sfpx

    Renaming devices ?

    That would be a really nice new feature . Thanks
  13. Is that possible to rename the device (the name that appears in the licenses list) without having to do an initial sync ? If I change the field clientname of the mirrorsync table, will it change the name in the mirrorsync config utility ? I'm asking because I always used the default naming but now I see that some devices end up having the same name and it's quite confusing when I have to delete a particular device. I would like to change it for the account name that is used to connect to the database. Possible or not ?
  14. I actually would remove the fields on the sync layouts only on the device version of the database . Should take 5-10 minutes of additional work each time I prepare a new offline version. I will test some initial syncs it to see if it's worth the hassle.
  15. I noticed that writing data is a bit faster when the layout has nothing on it. No object or field. Can we remove the fields from the sync layout on the device (iphone, ipad)? (I understand that the fields must be on the sync layouts on the server) Just a crazy idea I had this morning

Important Information

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