GoZync5

One-Page Tutorial

GoZync5.Tutorial History

Hide minor edits - Show changes to output

Changed lines 11-12 from:
->'''☐ 1.''' Put your hosted file in the same folder as GoZyncHosted (“Host”). ''Note: Make sure your file is closed before moving it.''
Do not move the GoZyncHosted or GoZyncMobile files from their folders at this point.
to:
->'''☐ 1.''' Put your hosted file in the same folder as GoZyncHosted (“Host”). ''Note: Make sure your file is closed before moving it.''  Do not move the GoZyncHosted or GoZyncMobile files from their folders at this point.
September 17, 2019, at 12:00 AM by becca - made minor additions to step 1 and step 4 under gozync mobile due to my own experiences in setup
Changed lines 12-13 from:
to:
Do not move the GoZyncHosted or GoZyncMobile files from their folders at this point.
Changed line 72 from:
->'''☐ 4.''' Edit the "PSOS Config" script. Change the "Else If[]" condition to $TOName = "gzh_YourTable", and have the Perform Script step run your hosted file's "GoZync Call from GZM" script.
to:
->'''☐ 4.''' Edit the "PSOS Config" script. Change the "Else If[]" condition to $TOName = "gzh_YourTable", and have the Perform Script step run your hosted file's "GoZync Call from GZM" script.  Make sure its parameter is set to "Get (Script Parameter)."
Changed line 92 from:
->'''☐ 4.''' Select “Relogin” from the Scripts menu to log in as “administrator”.
to:
->'''☐ 4.''' Select “Relogin” from the Scripts menu to log in as “administrator” (Password is on the "License Admin" tab).
July 24, 2017, at 10:05 PM by KC Embrey - Added a note that the video is missing a step.
Changed line 5 from:
Follow along with a 23-minute [[https://vimeo.com/106831287 | movie]] of a sample integration using these instructions.
to:
Follow along with a 23-minute [[https://vimeo.com/106831287 | movie]] of a sample integration using these instructions. NOTE: In the video, the GoZyncHosted section is missing the added step 5. When following along with the video, make sure to follow the written steps below.
June 19, 2017, at 10:47 PM by Dan Wheelon - Copy/paste needed custom functions into their mobile file.
Changed lines 46-58 from:
->'''☐ 2.''' Make sure each table to be synced in your mobile file has a primary-key field. It should be a Text field, set to auto-enter Get(UUID) by calc. Uncheck the “Do not replace…” setting, and be sure Indexing is set to “All”.

->'''☐ 3.''' Copy/paste the “gz” table from WorxMobile into your mobile file.

->'''☐ 4. Copy four fields (gz_ModTimeStamp, gz_LatestAction
, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, and paste them into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options).

->'''☐ 5.''' Copy/paste the “GoZync” scripts folder from WorxMobile into your mobile file (or import it).

->'''☐ 6.''' Edit the Go to Layout step
in the "Zync - Is a new version permitted" script to use a layout that is associated with the primary TO you're syncing. The layout you use should have no script triggers on it. Duplicate the "Find any unsent records" section to check additional tables for unsynced records before allowing mobile users to update and overwrite their mobile file.

->'''☐ 7.''' Add a “Sync Now” button somewhere on the user interface that runs
the “Zync It - Everything” script.

->'''☐ 8.'''
Add a “Check for Updates” button somewhere on the user interface that runs the “Zync - Check for Updates” script.
to:
->'''☐ 2.''' Copy/paste these three custom functions from WorxMobile into your mobile file: URLScheme, IsNativeApp, and __GoZyncMobile__. Copying custom functions requires FileMaker Pro Advanced. If you don't have access to Advanced, feel free to reach out and we'll be glad to do this step for you.

->'''☐ 3.''' Make sure each table to be synced in your mobile file has a primary-key field. It should be a Text field, set to auto-enter Get(UUID) by calc. Uncheck the “Do not replace…” setting, and be sure Indexing is set to “All”.

->'''☐ 4.''' Copy/paste the “gz” table from WorxMobile into your mobile file
.

->'''☐ 5. Copy four fields (gz_ModTimeStamp, gz_LatestAction, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, and paste them into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options).

->'''☐ 6.''' Copy/paste the “GoZync” scripts folder from WorxMobile into your mobile file (or import it).

->'''☐ 7.''' Edit the Go
to Layout step in the "Zync - Is a new version permitted" script to use a layout that is associated with the primary TO you're syncing. The layout you use should have no script triggers on it. Duplicate the "Find any unsent records" section to check additional tables for unsynced records before allowing mobile users to update and overwrite their mobile file.

->'''☐ 8.''' Add a “Sync Now” button somewhere on the user interface that runs the “Zync It - Everything” script.

->'''☐ 9
.''' Add a “Check for Updates” button somewhere on the user interface that runs the “Zync - Check for Updates” script.
June 06, 2015, at 05:51 PM by 142.4.217.188 -
Changed line 11 from:
->'''☐ 1.''' Put your hosted file in the same folder as GoZyncHosted (“Host”). ''Note: Make sure your file closed before moving it.''
to:
->'''☐ 1.''' Put your hosted file in the same folder as GoZyncHosted (“Host”). ''Note: Make sure your file is closed before moving it.''
April 07, 2015, at 01:20 PM by 142.4.217.188 -
Changed line 7 from:
(:include: NeedHelp:)
to:
(:include NeedHelp:)
April 07, 2015, at 01:19 PM by 142.4.217.188 -
Added lines 6-7:

(:include: NeedHelp:)
November 06, 2014, at 04:21 PM by 63.144.78.193 -
Changed line 90 from:
->'''☐ 5.''' Edit the "Else If[]" step in the "Call Test GTRR in their Hosted File" script so the condition is $TOName = "gzh_YourTable", and have the Perform Script step run the "TEST Go To Related Records (Parent and Child To Test)" script from your hosted file.
to:
->'''☐ 5.''' Edit the "Call Test GTRR in their Hosted File" script. Change the "Else If[]" condition to $TOName = "gzh_YourTable", and have the Perform Script step run your hosted file's "TEST Go To Related Records (Parent and Child To Test)" script.
November 06, 2014, at 04:20 PM by 63.144.78.193 -
Changed lines 67-68 from:
->'''☐ 4.''' Edit the "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at your hosted file's "GoZync Call from GZM" script.
to:
->'''☐ 4.''' Edit the "PSOS Config" script. Change the "Else If[]" condition to $TOName = "gzh_YourTable", and have the Perform Script step run your hosted file's "GoZync Call from GZM" script.
Changed lines 90-94 from:
->'''☐ 5.''' Click the “Refresh and check for errors” button on the Configuration screen.

->'''☐ 6.''' Click on any caution icons that appear for guidance on how to correct errors.

->'''☐ 7.'''
If you are going to use [[Related Records | related syncing]], click the “Requires” column and follow the prompts.
to:
->'''☐ 5.''' Edit the "Else If[]" step in the "Call Test GTRR in their Hosted File" script so the condition is $TOName = "gzh_YourTable", and have the Perform Script step run the "TEST Go To Related Records (Parent and Child To Test)" script from your hosted file.

->'''☐ 6.''' Click the “Refresh and check for errors” button on the Configuration screen.

->'''☐ 7.''' Click on any caution icons that appear for guidance on how to correct errors.

->'''☐ 8
.''' If you are going to use [[Related Records | related syncing]], click the “Requires” column and follow the prompts.
November 04, 2014, at 07:13 PM by 98.245.117.26 -
Changed lines 15-16 from:
->'''☐ 4.''' If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name (make sure the file is closed before you duplicate it), then move it to the same folder as GoZyncMobile (“Local”).
to:
->'''☐ 4.''' If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name (make sure the file is closed before you duplicate it), then move it to the same folder as GoZyncMobile (“Mobile”).
Changed line 42 from:
->'''☐ 1.''' Put your mobile file in the same folder as GoZyncMobile (“Local”).
to:
->'''☐ 1.''' Put your mobile file in the same folder as GoZyncMobile (“Mobile”).
October 25, 2014, at 08:36 PM by 98.245.117.26 -
Changed lines 29-30 from:
->'''☐ 11.''' Edit the “Filter Records To Pull” script - Disable or delete the “Omit Multiple Records [No Dialog; 100]” and “Show Omitted Only” steps (leave the “Show All Records” step). Optional: set up [[Downloading Found Sets | filtering]] if desired.
to:
->'''☐ 11.''' Edit the “Filter Records To Pull” script - Disable or delete the “Omit Multiple Records [No Dialog; 100]” and “Show Omitted Only” steps (leave the “Show All Records” step). ''NOTE: These steps were removed in build 5.05.'' Optional: set up [[Downloading Found Sets | filtering]] if desired.
Changed line 71 from:
->'''☐ 6.''' Edit the "Finish Sync" script, changing If["1=0"...] to If["1=1"...] so the hosted files are closed after syncing. Specify your hosted file in the "Close File" step.
to:
->'''☐ 6.''' Edit the "Finish Sync" script, changing If["1=0"...] to If["1=1"...] so the hosted files are closed after syncing. ''NOTE: This default setting was changed to "1=1" in build 5.05.'' Specify your hosted file in the "Close File" step.
Changed lines 9-34 from:
->☐ 1. Put your hosted file in the same folder as GoZyncHosted (“Host”). ''Note: Make sure your file closed before moving it.''

->2. Make sure each table to be synced in your hosted file has a primary-key field. It should be a Text field, set to auto-enter Get(UUID) by calc. Uncheck the “Do not replace…” setting, and be sure Indexing is set to “All”.

->3. If you already had a primary-key field, you do not need to change the values in existing records (as long as the values are unique), but if you created the ID field AFTER there were already records in the table, you’ll need to populate that field for all existing records. Find those empty records, then use FileMaker’s “Replace Field Contents” command and the Get(UUID) function to populate the new ID field with a unique value in all found records. ''Note: if you are going to be duplicating your file to create the mobile version, populate this field in the main file BEFORE you duplicate the file.''

->4. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name (make sure the file is closed before you duplicate it), then move it to the same folder as GoZyncMobile (“Local”).

->5. Copy two fields (gz_ModTimeStamp and gz_id_ListOF) from the WorkOrders table in WorxHosted, and paste them into each table to be synced in your hosted file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options.

->6. Repair the gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Make sure it's a Summary field, defined as “List of[your ID field]”.

->7. Create a “gzh_TableName” TO on the graph for each table to be synced.

->8. Create blank “gzh_TableName” layouts for each table to be synced, associate each of these layouts with the TO of the same name. These layouts can remain empty (no fields).

->9. Copy/paste the “GoZync” scripts folder from WorxHosted into your hosted file (or import it).

->10. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzh_” TO (follow the pattern).

->11. Edit the “Filter Records To Pull” script - Disable or delete the “Omit Multiple Records [No Dialog; 100]” and “Show Omitted Only” steps (leave the “Show All Records” step). Optional: set up [[Downloading Found Sets | filtering]] if desired.

->12. If you are doing related syncing, make a relationship using the applicable key fields between the parent and child gzh_ TOs on the graph, then write a simple script to update the gz_ModTimeStamp field in the parent record, and set that up to run via the OnRecordCommit script trigger on any layouts where you will be editing the child records.

->13. Add the “If[]” condition shown below at the beginning of your startup script (if you have one) so it doesn’t run when the file is opened via a PSOS call.
to:
->'''☐ 1.''' Put your hosted file in the same folder as GoZyncHosted (“Host”). ''Note: Make sure your file closed before moving it.''

->'''☐ 2.''' Make sure each table to be synced in your hosted file has a primary-key field. It should be a Text field, set to auto-enter Get(UUID) by calc. Uncheck the “Do not replace…” setting, and be sure Indexing is set to “All”.

->'''☐ 3.''' If you already had a primary-key field, you do not need to change the values in existing records (as long as the values are unique), but if you created the ID field AFTER there were already records in the table, you’ll need to populate that field for all existing records. Find those empty records, then use FileMaker’s “Replace Field Contents” command and the Get(UUID) function to populate the new ID field with a unique value in all found records. ''Note: if you are going to be duplicating your file to create the mobile version, populate this field in the main file BEFORE you duplicate the file.''

->'''☐ 4.''' If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name (make sure the file is closed before you duplicate it), then move it to the same folder as GoZyncMobile (“Local”).

->'''☐ 5.''' Copy two fields (gz_ModTimeStamp and gz_id_ListOF) from the WorkOrders table in WorxHosted, and paste them into each table to be synced in your hosted file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options.

->'''☐ 6.''' Repair the gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Make sure it's a Summary field, defined as “List of[your ID field]”.

->'''☐ 7.''' Create a “gzh_TableName” TO on the graph for each table to be synced.

->'''☐ 8.''' Create blank “gzh_TableName” layouts for each table to be synced, associate each of these layouts with the TO of the same name. These layouts can remain empty (no fields).

->'''☐ 9.''' Copy/paste the “GoZync” scripts folder from WorxHosted into your hosted file (or import it).

->'''☐ 10.''' Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzh_” TO (follow the pattern).

->'''☐ 11.''' Edit the “Filter Records To Pull” script - Disable or delete the “Omit Multiple Records [No Dialog; 100]” and “Show Omitted Only” steps (leave the “Show All Records” step). Optional: set up [[Downloading Found Sets | filtering]] if desired.

->'''☐ 12.''' If you are doing related syncing, make a relationship using the applicable key fields between the parent and child gzh_ TOs on the graph, then write a simple script to update the gz_ModTimeStamp field in the parent record, and set that up to run via the OnRecordCommit script trigger on any layouts where you will be editing the child records.

->'''☐ 13.''' Add the “If[]” condition shown below at the beginning of your startup script (if you have one) so it doesn’t run when the file is opened via a PSOS call.
Changed lines 42-58 from:
->1. Put your mobile file in the same folder as GoZyncMobile (“Local”).

->2. Make sure each table to be synced in your mobile file has a primary-key field. It should be a Text field, set to auto-enter Get(UUID) by calc. Uncheck the “Do not replace…” setting, and be sure Indexing is set to “All”.

->3. Copy/paste the “gz” table from WorxMobile into your mobile file.

->4. Copy four fields (gz_ModTimeStamp, gz_LatestAction, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, and paste them into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options).

->5. Copy/paste the “GoZync” scripts folder from WorxMobile into your mobile file (or import it).

->6. Edit the Go to Layout step in the "Zync - Is a new version permitted" script to use a layout that is associated with the primary TO you're syncing. The layout you use should have no script triggers on it. Duplicate the "Find any unsent records" section to check additional tables for unsynced records before allowing mobile users to update and overwrite their mobile file.

->7. Add a “Sync Now” button somewhere on the user interface that runs the “Zync It - Everything” script.

->8. Add a “Check for Updates” button somewhere on the user interface that runs the “Zync - Check for Updates” script.

to:
->'''☐ 1.''' Put your mobile file in the same folder as GoZyncMobile (“Local”).

->'''☐ 2.''' Make sure each table to be synced in your mobile file has a primary-key field. It should be a Text field, set to auto-enter Get(UUID) by calc. Uncheck the “Do not replace…” setting, and be sure Indexing is set to “All”.

->'''☐ 3.''' Copy/paste the “gz” table from WorxMobile into your mobile file.

->'''☐ 4. Copy four fields (gz_ModTimeStamp, gz_LatestAction, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, and paste them into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options).

->'''☐ 5.''' Copy/paste the “GoZync” scripts folder from WorxMobile into your mobile file (or import it).

->'''☐ 6.''' Edit the Go to Layout step in the "Zync - Is a new version permitted" script to use a layout that is associated with the primary TO you're syncing. The layout you use should have no script triggers on it. Duplicate the "Find any unsent records" section to check additional tables for unsynced records before allowing mobile users to update and overwrite their mobile file.

->'''☐ 7.''' Add a “Sync Now” button somewhere on the user interface that runs the “Zync It - Everything” script.

->'''☐ 8.''' Add a “Check for Updates” button somewhere on the user interface that runs the “Zync - Check for Updates” script.

Changed lines 61-79 from:
->1. Add TOs to the Relationships Graph for each of your hosted and mobile tables to be synced (prefixed with "gzh_" and "gzm_", respectively), adding new External Data Sources as necessary.

->2. Establish relationships between each of your TOs and the GoZync TO, using the “=” operator to connect GoZync::PrimaryID to gzh/m_YourTable::YourIDField, with the “Allow creation…” option turned on on the “gzh/m_” side of the relationship.

->3. Remove any TOs you won’t be using (gzh_WorkOrderItems, etc).

->4. Edit the "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at your hosted file's "GoZync Call from GZM" script.

->5. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzm_” TO (follow the pattern).

->6. Edit the "Finish Sync" script, changing If["1=0"...] to If["1=1"...] so the hosted files are closed after syncing. Specify your hosted file in the "Close File" step.

->7. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, then add the fields you want to sync. Don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields.

->8. Delete any gzm_ or gzh_ layouts for TOs you aren’t using.

->9. External Data Sources - Delete WorxHosted and WorxMobile entries.

to:
->'''☐ 1.''' Add TOs to the Relationships Graph for each of your hosted and mobile tables to be synced (prefixed with "gzh_" and "gzm_", respectively), adding new External Data Sources as necessary.

->'''☐ 2.''' Establish relationships between each of your TOs and the GoZync TO, using the “=” operator to connect GoZync::PrimaryID to gzh/m_YourTable::YourIDField, with the “Allow creation…” option turned on on the “gzh/m_” side of the relationship.

->'''☐ 3.''' Remove any TOs you won’t be using (gzh_WorkOrderItems, etc).

->'''☐ 4.''' Edit the "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at your hosted file's "GoZync Call from GZM" script.

->'''☐ 5.''' Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzm_” TO (follow the pattern).

->'''☐ 6.''' Edit the "Finish Sync" script, changing If["1=0"...] to If["1=1"...] so the hosted files are closed after syncing. Specify your hosted file in the "Close File" step.

->'''☐ 7.''' Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, then add the fields you want to sync. Don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields.

->'''☐ 8.''' Delete any gzm_ or gzh_ layouts for TOs you aren’t using.

->'''☐ 9.''' External Data Sources - Delete WorxHosted and WorxMobile entries.

Changed lines 82-96 from:
->1. Close the WorxHosted and WorxMobile files (check the “Window > Show Window” list to make sure they aren’t still open in the background).

->2. Move the WorxHosted and WorxMobile files to a different folder (or to the trash).

->3. Delete “GoZyncMobile” and “WorxMobile” from the “Downloads” screen in GoZyncHosted.

->4. Select “Relogin” from the Scripts menu to log in as “administrator”.

->5. Click the “Refresh and check for errors” button on the Configuration screen.

->6. Click on any caution icons that appear for guidance on how to correct errors.

->7. If you are going to use [[Related Records | related syncing]], click the “Requires” column and follow the prompts.

to:
->'''☐ 1.''' Close the WorxHosted and WorxMobile files (check the “Window > Show Window” list to make sure they aren’t still open in the background).

->'''☐ 2.''' Move the WorxHosted and WorxMobile files to a different folder (or to the trash).

->'''☐ 3.''' Delete “GoZyncMobile” and “WorxMobile” from the “Downloads” screen in GoZyncHosted.

->'''☐ 4.''' Select “Relogin” from the Scripts menu to log in as “administrator”.

->'''☐ 5.''' Click the “Refresh and check for errors” button on the Configuration screen.

->'''☐ 6.''' Click on any caution icons that appear for guidance on how to correct errors.

->'''☐ 7.''' If you are going to use [[Related Records | related syncing]], click the “Requires” column and follow the prompts.

Changed lines 99-102 from:
->1. Edit a record in your hosted file (commit the change), then click that "Sync" button in your mobile file. The record you changed in the hosted file should change in the mobile file.

->2. Edit a record in your mobile file (commit the change), then click that "Sync" button. You should see the same change in the hosted file.
to:
->'''☐ 1.''' Edit a record in your hosted file (commit the change), then click that "Sync" button in your mobile file. The record you changed in the hosted file should change in the mobile file.

->'''☐ 2.''' Edit a record in your mobile file (commit the change), then click that "Sync" button. You should see the same change in the hosted file.
Changed lines 108-114 from:
->1. Move the hosted files (GoZyncHosted and your hosted file) to your host computer, and open them in FileMaker Server (or FileMaker Pro).

->2. Update the [[External Data Sources]] in GoZyncMobile for GoZyncHosted and your hosted file to reflect their network paths.

->3. Run the “Prep and Upload new File” script from your mobile file. This inserts copies of the mobile files into container fields in the GoZyncHosted file.

->4. Send an email to your mobile users with link to GZH “Downloads” screen. From here your mobile users can [[Distributing Mobile Files | download]] the mobile files directly to their devices.
to:
->'''☐ 1.''' Move the hosted files (GoZyncHosted and your hosted file) to your host computer, and open them in FileMaker Server (or FileMaker Pro).

->'''☐ 2.''' Update the [[External Data Sources]] in GoZyncMobile for GoZyncHosted and your hosted file to reflect their network paths.

->'''☐ 3.''' Run the “Prep and Upload new File” script from your mobile file. This inserts copies of the mobile files into container fields in the GoZyncHosted file.

->'''☐ 4.''' Send an email to your mobile users with link to GZH “Downloads” screen. From here your mobile users can [[Distributing Mobile Files | download]] the mobile files directly to their devices.
Changed line 9 from:
->1. Put your hosted file in the same folder as GoZyncHosted (“Host”). ''Note: Make sure your file closed before moving it.''
to:
->☐ 1. Put your hosted file in the same folder as GoZyncHosted (“Host”). ''Note: Make sure your file closed before moving it.''
Changed line 103 from:
->''If you encounter any errors or unexpected results, consult our [[Troubleshooting | Troubleshooting]] page for help.''
to:
->''If you encounter any errors or unexpected results, consult our [[Troubleshooting | troubleshooting]] page for help.''
Changed line 103 from:
''If you encounter any errors or unexpected results, consult our [[Troubleshooting | Troubleshooting]] page.''
to:
->''If you encounter any errors or unexpected results, consult our [[Troubleshooting | Troubleshooting]] page for help.''
Added lines 102-103:

''If you encounter any errors or unexpected results, consult our [[Troubleshooting | Troubleshooting]] page.''
Changed line 3 from:
''Follow the instructions on this one-page guide for a trouble-free GoZync integration. Be sure to do the steps '''in order'''. Our regular integration documents are [[Integration | here]].''
to:
''Follow the instructions on this one-page guide for a trouble-free GoZync integration. Be sure to do the steps '''in order'''. A longer, more descriptive version of our integration instructions are [[Integration | here]].''
Changed line 5 from:
Watch a 23-minute [[https://vimeo.com/106831287 | movie]] of a sample integration using these instructions.
to:
Follow along with a 23-minute [[https://vimeo.com/106831287 | movie]] of a sample integration using these instructions.
Added lines 1-2:
(:title One-Page Tutorial:)
Changed line 1 from:
''Follow these instructions for a trouble-free GoZync integration. Be sure to do the steps '''in order'''.''
to:
''Follow the instructions on this one-page guide for a trouble-free GoZync integration. Be sure to do the steps '''in order'''. Our regular integration documents are [[Integration | here]].''
Changed line 3 from:
Watch a 22-minute [[https://vimeo.com/106831287 | movie]] of a sample integration using these instructions.
to:
Watch a 23-minute [[https://vimeo.com/106831287 | movie]] of a sample integration using these instructions.
Changed line 3 from:
Watch a 22-minute [[http://screencast-o-matic.com/watch/c2Q3o4ec99 | movie]] of a sample integration using these instructions.
to:
Watch a 22-minute [[https://vimeo.com/106831287 | movie]] of a sample integration using these instructions.
Changed line 3 from:
Watch a 22-minute [http://screencast-o-matic.com/watch/c2Q3o4ec99 | movie] of a sample integration using these instructions.
to:
Watch a 22-minute [[http://screencast-o-matic.com/watch/c2Q3o4ec99 | movie]] of a sample integration using these instructions.
Changed line 3 from:
Watch a 22-minute [http://screencast-o-matic.com/watch/c2Q3o4ec99|movie] of a sample integration using these instructions.
to:
Watch a 22-minute [http://screencast-o-matic.com/watch/c2Q3o4ec99 | movie] of a sample integration using these instructions.
Added lines 2-3:

Watch a 22-minute [http://screencast-o-matic.com/watch/c2Q3o4ec99|movie] of a sample integration using these instructions.
Changed lines 59-73 from:
->3. Establish relationships between each of your TOs and the GoZync TO, using the “=” operator to connect GoZync::PrimaryID to gzh/m_YourTable::YourIDField, with the “Allow creation…” option turned on on the “gzh/m_” side of the relationship.

->4. Remove any TOs you won’t be using (gzh_WorkOrderItems, etc).

->5. Edit the "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at your hosted file's "GoZync Call from GZM" script.

->6. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzm_” TO (follow the pattern).

->7. Edit the "Finish Sync" script, changing If["1=0"...] to If["1=1"...] so the hosted files are closed after syncing. Specify your hosted file in the "Close File" step.

->8. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, then add the fields you want to sync. Don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields.

->9. Delete any gzm_ or gzh_ layouts for TOs you aren’t using.

->10. External Data Sources - Delete WorxHosted and WorxMobile entries.
to:
->2. Establish relationships between each of your TOs and the GoZync TO, using the “=” operator to connect GoZync::PrimaryID to gzh/m_YourTable::YourIDField, with the “Allow creation…” option turned on on the “gzh/m_” side of the relationship.

->3. Remove any TOs you won’t be using (gzh_WorkOrderItems, etc).

->4. Edit the "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at your hosted file's "GoZync Call from GZM" script.

->5. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzm_” TO (follow the pattern).

->6. Edit the "Finish Sync" script, changing If["1=0"...] to If["1=1"...] so the hosted files are closed after syncing. Specify your hosted file in the "Close File" step.

->7. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, then add the fields you want to sync. Don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields.

->8. Delete any gzm_ or gzh_ layouts for TOs you aren’t using.

->9. External Data Sources - Delete WorxHosted and WorxMobile entries.
Added line 54:
Added line 75:
Added lines 91-98:


!!Run a Sync

->1. Edit a record in your hosted file (commit the change), then click that "Sync" button in your mobile file. The record you changed in the hosted file should change in the mobile file.

->2. Edit a record in your mobile file (commit the change), then click that "Sync" button. You should see the same change in the hosted file.

Changed line 9 from:
->3. If you already had a primary-key field, you do not need to change the values in existing records, but if you created the ID field AFTER there were already records in the table, you’ll need to populate that field for all existing records. Find those empty records, then use FileMaker’s “Replace Field Contents” command and the Get(UUID) function to populate the new ID field with a unique value in all found records. ''Note: if you are going to be duplicating your file to create the mobile version, populate this field in the main file BEFORE you duplicate the file.''
to:
->3. If you already had a primary-key field, you do not need to change the values in existing records (as long as the values are unique), but if you created the ID field AFTER there were already records in the table, you’ll need to populate that field for all existing records. Find those empty records, then use FileMaker’s “Replace Field Contents” command and the Get(UUID) function to populate the new ID field with a unique value in all found records. ''Note: if you are going to be duplicating your file to create the mobile version, populate this field in the main file BEFORE you duplicate the file.''
Changed lines 11-12 from:
->4. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name (make sure the file is closed before you duplicate it), then move it to the same folder as GoZyncMobile (“Local”). ''Note: Make sure your file closed before duplicating it.''
to:
->4. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name (make sure the file is closed before you duplicate it), then move it to the same folder as GoZyncMobile (“Local”).
Changed line 48 from:
->6. Edit the "Zync - Is a new version permitted" script to Go to Layout for the primary TO you're syncing. Duplicate the "Find any unsent records" section to check additional tables for unsynced records before allowing mobile users to update and overwrite their mobile file.
to:
->6. Edit the Go to Layout step in the "Zync - Is a new version permitted" script to use a layout that is associated with the primary TO you're syncing. The layout you use should have no script triggers on it. Duplicate the "Find any unsent records" section to check additional tables for unsynced records before allowing mobile users to update and overwrite their mobile file.
Changed line 11 from:
->4. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name (make sure the file is closed before you duplicate it), then move it to the same folder as GoZyncMobile (“Local”). ''Note: Make sure your file closed before moving it.''
to:
->4. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name (make sure the file is closed before you duplicate it), then move it to the same folder as GoZyncMobile (“Local”). ''Note: Make sure your file closed before duplicating it.''
Changed lines 5-6 from:
->1. Put your hosted file in the same folder as GoZyncHosted (“Host”).
to:
->1. Put your hosted file in the same folder as GoZyncHosted (“Host”). ''Note: Make sure your file closed before moving it.''
Changed line 11 from:
->4. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name (make sure the file is closed before you duplicate it), then move it to the same folder as GoZyncMobile (“Local”).
to:
->4. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name (make sure the file is closed before you duplicate it), then move it to the same folder as GoZyncMobile (“Local”). ''Note: Make sure your file closed before moving it.''
Changed line 19 from:
->8. Create blank “gzh_TableName” layouts for each table to be synced.
to:
->8. Create blank “gzh_TableName” layouts for each table to be synced, associate each of these layouts with the TO of the same name. These layouts can remain empty (no fields).
Changed line 11 from:
->4. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name, then move it to the same folder as GoZyncMobile (“Local”).
to:
->4. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name (make sure the file is closed before you duplicate it), then move it to the same folder as GoZyncMobile (“Local”).
Changed lines 66-70 from:
->7. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, then add the fields you want to sync. Don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields.

->8. Delete any gzm_ or gzh_ layouts for TOs you aren’t using.

->9.
External Data Sources - Delete WorxHosted and WorxMobile entries.
to:
->7. Edit the "Finish Sync" script, changing If["1=0"...] to If["1=1"...] so the hosted files are closed after syncing. Specify your hosted file in the "Close File" step.

->8. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, then add the
fields you want to sync. Don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields.

->9. Delete any gzm_ or gzh_ layouts for TOs you aren’t using.

->10
. External Data Sources - Delete WorxHosted and WorxMobile entries.
Changed lines 31-35 from:
-->[-@@If [PatternCount (Get (ApplicationVersion); "Server")]@@-]

--->[-@@ExitScript[]@@-]

--
>[-@@End If@@-]
to:
-->If [PatternCount ( Get ( ApplicationVersion ) ; "Server" )]
--->ExitScript[]
-->End If
Changed line 65 from:
->6. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzm_” TO (follow pattern).
to:
->6. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzm_” TO (follow the pattern).
Changed line 57 from:
->1. Add TOs for your hosted and mobile tables to be synced (gzh_, gzm_) to the Relationships Graph, adding new External Data Sources as necessary.
to:
->1. Add TOs to the Relationships Graph for each of your hosted and mobile tables to be synced (prefixed with "gzh_" and "gzm_", respectively), adding new External Data Sources as necessary.
Changed line 45 from:
->4. Copy four fields (gz_ModTimeStamp, gz_LatestAction, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, paste into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options).
to:
->4. Copy four fields (gz_ModTimeStamp, gz_LatestAction, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, and paste them into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options).
August 29, 2014, at 04:02 PM by 174.16.113.66 -
Changed line 67 from:
->7. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, add fields to be synced. Note: don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields.
to:
->7. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, then add the fields you want to sync. Don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields.
August 26, 2014, at 02:12 PM by 98.245.117.26 -
Changed lines 17-19 from:
->7. Create a “gzh_TableName” TO on graph for each table to be synced.

->8. Create blank “gzh_TableName” layouts for each table to synced.
to:
->7. Create a “gzh_TableName” TO on the graph for each table to be synced.

->8. Create blank “gzh_TableName” layouts for each table to be synced.
August 25, 2014, at 11:35 PM by 50.134.130.56 -
Changed lines 7-32 from:
->2. Add the [[UUIDs | “UUIDDecimal”]] Custom Function (copy/paste code from WorxHosted). Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.

->3. Make sure each table to be synced in your hosted file has a primary-key field
. It should be a Text field, set to auto-enter UUIDDecimal by calc. Uncheck the “Do not replace…”, setting, and be sure Indexing is set to “All”.

->4. If you
already had a primary-key field, you do not need to change the values in existing records, but if you created the ID field AFTER there were already records in the table, you’ll need to populate that field for all existing records. Find those empty records, then use FileMaker’s “Replace Field Contents” command and the UUIDDecimal custom function to populate the new ID field with a unique value in all found records. ''Note: if you are going to be duplicating your file to create the mobile version, populate this field in the main file BEFORE you duplicate the file.''

->5. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name, then move it to the same folder as GoZyncMobile (“Local”).

->6. Copy two fields (gz_ModTimeStamp and gz_id_ListOF) from the WorkOrders table in WorxHosted, and paste them into each table to be synced in your hosted file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options.

->7. Repair the gz_id_ListOF
field if necessary (the field definition will break when pasted if your ID field’s name is different). Make sure it's a Summary field, defined as “List of[your ID field]”.

->8. Create a “gzh_TableName” TO on graph for each table to be synced.

->9. Create blank “gzh_TableName” layouts for each table to synced.

->10. Copy/paste the “GoZync” scripts folder from WorxHosted into your hosted file (or import it
).

->11. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzh_” TO (follow the pattern).

->12. Edit the “Filter Records To Pull” script - Disable or delete the “Omit Multiple Records [No Dialog; 100]” and “Show Omitted Only” steps (leave
the “Show All Records” step). Optional: set up [[Downloading Found Sets | filtering]] if desired.

->13. If you are doing related syncing, make a relationship using the applicable key fields between
the parent and child gzh_ TOs on the graph, then write a simple script to update the gz_ModTimeStamp field in the parent record, and set that up to run via the OnRecordCommit script trigger on any layouts where you will be editing the child records.

->14
. Add the “If[]” condition shown below at the beginning of your startup script (if you have one) so it doesn’t run when the file is opened via a PSOS call.
to:
->2. Make sure each table to be synced in your hosted file has a primary-key field. It should be a Text field, set to auto-enter Get(UUID) by calc. Uncheck the “Do not replace…” setting, and be sure Indexing is set to “All”.

->3. If you already had
a primary-key field, you do not need to change the values in existing records, but if you created the ID field AFTER there were already records in the table, you’ll need to populate that field for all existing records. Find those empty records, then use FileMaker’s “Replace Field Contents” command and the Get(UUID) function to populate the new ID field with a unique value in all found records. ''Note: if you are going to be duplicating your file to create the mobile version, populate this field in the main file BEFORE you duplicate the file.''

->4. If
you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name, then move it to the same folder as GoZyncMobile (“Local”).

->5. Copy two fields (gz_ModTimeStamp and gz_id_ListOF) from the WorkOrders table in WorxHosted, and paste them into each table to be synced in your hosted file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options.

->6. Repair the gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Make sure it's a Summary field, defined as “List of[your ID
field]”.

->7. Create a “gzh_TableName” TO on graph for each table to be synced
.

->8. Create blank “gzh_TableName” layouts for each table to synced
.

->9. Copy/paste the “GoZync” scripts folder from WorxHosted into your hosted file (or import it).

->10. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzh_” TO (follow the pattern).

->11. Edit the “Filter Records To Pull” script - Disable or delete the “Omit Multiple Records [No Dialog; 100]” and “Show Omitted Only” steps (leave the “Show All Records” step). Optional: set up [[Downloading Found Sets | filtering]] if desired.

->12. If you are doing related syncing, make a relationship using the applicable key fields between
the parent and child gzh_ TOs on the graph, then write a simple script to update the gz_ModTimeStamp field in the parent record, and set that up to run via the OnRecordCommit script trigger on any layouts where you will be editing the child records.

->13.
Add the “If[]” condition shown below at the beginning of your startup script (if you have one) so it doesn’t run when the file is opened via a PSOS call.
Changed lines 41-55 from:
->2. Add the “UUIDDecimal” Custom Function. Copy/paste the code from WorxMobile. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.

->3. Make sure each table to be synced in your mobile file has a primary-key field
. It should be a Text field, set to auto-enter UUIDDecimal by calc. Uncheck the “Do not replace…”, setting, and be sure Indexing is set to “All”.

->4. Copy/
paste the “gz” table from WorxMobile into your mobile file.

->5. Copy four fields (gz_ModTimeStamp, gz_LatestAction, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile
, paste into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options).

->6. Copy/paste the “GoZync” scripts folder from WorxMobile into your mobile file (or import it).

->7. Edit the
"Zync - Is a new version permitted" script to Go to Layout for the primary TO you're syncing. Duplicate the "Find any unsent records" section to check additional tables for unsynced records before allowing mobile users to update and overwrite their mobile file.

->8. Add a “Sync Now” button somewhere on the user interface that runs the “Zync It - Everything” script.

->9
. Add a “Check for Updates” button somewhere on the user interface that runs the “Zync - Check for Updates” script.
to:
->2. Make sure each table to be synced in your mobile file has a primary-key field. It should be a Text field, set to auto-enter Get(UUID) by calc. Uncheck the “Do not replace…” setting, and be sure Indexing is set to “All”.

->3. Copy/paste the “gz” table from WorxMobile into your mobile file
.

->4. Copy four fields (gz_ModTimeStamp, gz_LatestAction
, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, paste into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options).

->5. Copy/paste the “GoZync” scripts folder from WorxMobile into your mobile file (or import it).

->6. Edit the "Zync - Is a new version permitted" script to Go to Layout for the primary TO you're syncing. Duplicate the "Find any unsent records
" section to check additional tables for unsynced records before allowing mobile users to update and overwrite their mobile file.

->7. Add a “Sync Now” button somewhere on the user interface that runs the “Zync It - Everything” script
.

->8. Add a “Check for Updates” button somewhere on the user interface that runs the “Zync - Check for Updates” script.
August 25, 2014, at 09:37 PM by 50.134.130.56 -
Changed line 1 from:
''Follow these instructions for a trouble-free GoZync integration. Be sure to do the steps '''in order'''''
to:
''Follow these instructions for a trouble-free GoZync integration. Be sure to do the steps '''in order'''.''
August 25, 2014, at 09:36 PM by 50.134.130.56 -
Changed line 1 from:
''Follow these instructions '''in order''' for a trouble-free GoZync integration.''
to:
''Follow these instructions for a trouble-free GoZync integration. Be sure to do the steps '''in order'''''
August 25, 2014, at 09:10 PM by 50.134.130.56 -
Changed line 1 from:
''Follow these instructions ''''in order'''' for a trouble-free GoZync integration.''
to:
''Follow these instructions '''in order''' for a trouble-free GoZync integration.''
August 25, 2014, at 09:10 PM by 50.134.130.56 -
Added lines 1-2:
''Follow these instructions ''''in order'''' for a trouble-free GoZync integration.''
August 25, 2014, at 09:07 PM by 50.134.130.56 -
Changed line 95 from:
->2. Update the External Data Sources in GoZyncMobile for GoZyncHosted and your hosted file to reflect their network paths.
to:
->2. Update the [[External Data Sources]] in GoZyncMobile for GoZyncHosted and your hosted file to reflect their network paths.
August 25, 2014, at 09:05 PM by 50.134.130.56 -
Changed line 99 from:
->4. Send an email to your mobile users with link to GZH “Downloads” screen. From here your mobile users can download the mobile files directly to their devices.
to:
->4. Send an email to your mobile users with link to GZH “Downloads” screen. From here your mobile users can [[Distributing Mobile Files | download]] the mobile files directly to their devices.
August 25, 2014, at 09:03 PM by 50.134.130.56 -
Changed line 5 from:
->2. Add the [[“UUIDDecimal” | UUIDs ]] Custom Function (copy/paste code from WorxHosted). Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
to:
->2. Add the [[UUIDs | “UUIDDecimal”]] Custom Function (copy/paste code from WorxHosted). Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
August 25, 2014, at 09:03 PM by 50.134.130.56 -
Changed line 5 from:
->2. Add the “UUIDDecimal” Custom Function (copy/paste code from WorxHosted). Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
to:
->2. Add the [[“UUIDDecimal” | UUIDs ]] Custom Function (copy/paste code from WorxHosted). Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
August 25, 2014, at 07:50 PM by 50.134.130.56 -
Changed lines 89-90 from:
->7. If you are going to use related syncing, click the “Requires” column and follow the prompts.
to:
->7. If you are going to use [[Related Records | related syncing]], click the “Requires” column and follow the prompts.
Changed lines 93-94 from:
->1. Move hosted files (GoZyncHosted and your hosted file) to your host computer, and open them in FileMaker Server (or FileMaker Pro).
to:
->1. Move the hosted files (GoZyncHosted and your hosted file) to your host computer, and open them in FileMaker Server (or FileMaker Pro).
Changed lines 97-99 from:
->3. Run “Prep and Upload new File” script from your mobile file.

->4. Send email to mobile users with link to GZH “Downloads” screen
.
to:
->3. Run the “Prep and Upload new File” script from your mobile file. This inserts copies of the mobile files into container fields in the GoZyncHosted file.

->4. Send an email to your mobile users with link to GZH “Downloads” screen. From here your mobile users can download the mobile files directly to their devices
.
August 25, 2014, at 07:45 PM by 50.134.130.56 -
Changed lines 7-8 from:
->3. Make sure each table to be synced in your hosted file has a primary-key field, set to “Type: Text” and auto-enter UUIDDecimal by calc (uncheck “Do not replace…”). Be sure Indexing is set to “All”.
to:
->3. Make sure each table to be synced in your hosted file has a primary-key field. It should be a Text field, set to auto-enter UUIDDecimal by calc. Uncheck the “Do not replace…”, setting, and be sure Indexing is set to “All”.
Changed line 43 from:
->3. Make sure each table to be synced in your mobile file has a primary-key field, set to “Type: Text” and auto-enter UUIDDecimal by calc (uncheck “Do not replace…”). Be sure Indexing is set to “All”.
to:
->3. Make sure each table to be synced in your mobile file has a primary-key field. It should be a Text field, set to auto-enter UUIDDecimal by calc. Uncheck the “Do not replace…”, setting, and be sure Indexing is set to “All”.
August 25, 2014, at 07:43 PM by 50.134.130.56 -
Changed lines 27-28 from:
->13. If you are doing related syncing, make a relationship using the applicable key fields between the parent and child gzh_ TOs on the graph, then write a simple script to update the gz_ModTimeStamp field in the parent record, and run that via the OnRecordCommit script trigger on any layouts where you will be editing the child records.
to:
->13. If you are doing related syncing, make a relationship using the applicable key fields between the parent and child gzh_ TOs on the graph, then write a simple script to update the gz_ModTimeStamp field in the parent record, and set that up to run via the OnRecordCommit script trigger on any layouts where you will be editing the child records.
Changed lines 41-42 from:
->2. Add the “UUIDDecimal” Custom Function. Copy/paste the code from WorxHosted. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
to:
->2. Add the “UUIDDecimal” Custom Function. Copy/paste the code from WorxMobile. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
Changed lines 49-52 from:
->6. Copy/paste “GoZync” scripts folder from WorxMobile into your mobile file (or import it).

->7. Edit "Zync - Is a new version permitted" script to Go to Layout for the primary TO you're syncing.
to:
->6. Copy/paste the “GoZync” scripts folder from WorxMobile into your mobile file (or import it).

->7. Edit the "Zync - Is a new version permitted" script to Go to Layout for the primary TO you're syncing. Duplicate the "Find any unsent records" section to check additional tables for unsynced records before allowing mobile users to update and overwrite their mobile file.
Changed lines 65-68 from:
->5. Edit "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at the script "GoZync Call from GZM".

->6. Edit “Setup Go To Related Records (TOName)” script, make sure there is an “Else If” branch for each “gzm_” TO (follow pattern).
to:
->5. Edit the "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at your hosted file's "GoZync Call from GZM" script.

->6. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzm_” TO (follow pattern).
Deleted line 76:
Deleted line 91:
August 25, 2014, at 06:21 PM by 98.245.117.26 -
Changed line 33 from:
-->  [-@@ExitScript[]@@-]
to:
--->[-@@ExitScript[]@@-]
August 25, 2014, at 06:21 PM by 98.245.117.26 -
Changed lines 31-35 from:
[-@@If [PatternCount (Get (ApplicationVersion); "Server")]@@-]

  [-@@ExitScript[]@@-]

[-@@End If@@-]
to:
-->[-@@If [PatternCount (Get (ApplicationVersion); "Server")]@@-]

-->  [-@@ExitScript[]@@-]

-->
[-@@End If@@-]
August 25, 2014, at 06:20 PM by 98.245.117.26 -
Changed lines 31-35 from:
[-@@If [PatternCount (Get (ApplicationVersion); "Server")]@@

  @@ExitScript[]@@

@@End If@@-]
to:
[-@@If [PatternCount (Get (ApplicationVersion); "Server")]@@-]

  [-@@ExitScript[]@@-]

[-
@@End If@@-]
August 25, 2014, at 06:20 PM by 98.245.117.26 -
Changed lines 31-35 from:
[-@@If [PatternCount (Get (ApplicationVersion); "Server")]

  ExitScript[]

End If@@-]
to:
[-@@If [PatternCount (Get (ApplicationVersion); "Server")]@@

  @@ExitScript[]@@

@@
End If@@-]
August 25, 2014, at 06:19 PM by 98.245.117.26 -
Changed lines 31-35 from:
[-@@If [PatternCount (Get (ApplicationVersion); "Server")]@@-]

[-@@ExitScript[]@@-]

[-@@
End If@@-]
to:
[-@@If [PatternCount (Get (ApplicationVersion); "Server")]

  ExitScript[
]

End If@@-]
August 25, 2014, at 06:19 PM by 98.245.117.26 -
Added line 32:
Added line 34:
August 25, 2014, at 06:18 PM by 98.245.117.26 -
Changed lines 31-33 from:
   @@If [PatternCount (Get (ApplicationVersion); "Server")]@@
     @@ExitScript[]@@
 
@@End If@@
to:
[-@@If [PatternCount (Get (ApplicationVersion); "Server")]@@-]
[-@@ExitScript[]@@-]
[-@@
End If@@-]
August 25, 2014, at 06:17 PM by 98.245.117.26 -
Changed lines 31-33 from:
   @@If [PatternCount (Get (ApplicationVersion); "Server")]
      ExitScript[]
  End If@@
to:
   @@If [PatternCount (Get (ApplicationVersion); "Server")]@@
      @@ExitScript[]@@
  @@End If@@
August 25, 2014, at 06:17 PM by 98.245.117.26 -
Changed line 31 from:
   @If [PatternCount (Get (ApplicationVersion); "Server")]
to:
   @@If [PatternCount (Get (ApplicationVersion); "Server")]
Changed line 33 from:
   End If@
to:
   End If@@
August 25, 2014, at 06:16 PM by 98.245.117.26 -
Changed lines 3-4 from:
->1. Put your hosted file in the same folder as GoZyncHosted (“Host”)
to:
->1. Put your hosted file in the same folder as GoZyncHosted (“Host”).
Changed lines 11-12 from:
->5. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name, then move it to the same folder as GoZyncMobile (“Local”)
to:
->5. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name, then move it to the same folder as GoZyncMobile (“Local”).
Changed lines 15-16 from:
->7. Repair the gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Make sure it's a Summary field, defined as “List of[your ID field]”
to:
->7. Repair the gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Make sure it's a Summary field, defined as “List of[your ID field]”.
Changed line 31 from:
   If [PatternCount (Get (ApplicationVersion); "Server")]
to:
   @If [PatternCount (Get (ApplicationVersion); "Server")]
Changed lines 33-34 from:
   End If
to:
   End If@
Changed lines 37-38 from:
->1. Put your mobile file in the same folder as GoZyncMobile (“Local”)
to:
->1. Put your mobile file in the same folder as GoZyncMobile (“Local”).
Changed lines 45-50 from:
->5. Copy four fields (gz_ModTimeStamp, gz_LatestAction, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, paste into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options)

->6
. Copy/paste “GoZync” scripts folder from WorxMobile into your mobile file (or import it)

->7
. Edit "Zync - Is a new version permitted" script to Go to Layout for the primary TO you're syncing
to:
->5. Copy four fields (gz_ModTimeStamp, gz_LatestAction, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, paste into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options).

->6.
Copy/paste “GoZync” scripts folder from WorxMobile into your mobile file (or import it).

->7.
Edit "Zync - Is a new version permitted" script to Go to Layout for the primary TO you're syncing.
Changed lines 57-58 from:
->1. Add TOs for your hosted and mobile tables to be synced (gzh_, gzm_) to the Relationships Graph, adding new External Data Sources as necessary
to:
->1. Add TOs for your hosted and mobile tables to be synced (gzh_, gzm_) to the Relationships Graph, adding new External Data Sources as necessary.
Changed lines 61-72 from:
->4. Remove any TOs you won’t be using (gzh_WorkOrderItems, etc)

->5
. Edit "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at the script "GoZync Call from GZM"

->6
. Edit “Setup Go To Related Records (TOName)” script, make sure there is an “Else If” branch for each “gzm_” TO (follow pattern)

->7
. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, add fields to be synced. Note: don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields

->8
. Delete any gzm_ or gzh_ layouts for TOs you aren’t using

->9
. External Data Sources - Delete WorxHosted and WorxMobile entries
to:
->4. Remove any TOs you won’t be using (gzh_WorkOrderItems, etc).

->5.
Edit "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at the script "GoZync Call from GZM".

->6.
Edit “Setup Go To Related Records (TOName)” script, make sure there is an “Else If” branch for each “gzm_” TO (follow pattern).

->7. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, add fields to be synced. Note: don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields.

->8.
Delete any gzm_ or gzh_ layouts for TOs you aren’t using.

->9.
External Data Sources - Delete WorxHosted and WorxMobile entries.
Changed lines 80-83 from:
->3. Delete “GoZyncMobile” and “WorxMobile” from the “Downloads” screen in GoZyncHosted

->4
. Select “Relogin” from the Scripts menu to log in as “administrator”
to:
->3. Delete “GoZyncMobile” and “WorxMobile” from the “Downloads” screen in GoZyncHosted.

->4.
Select “Relogin” from the Scripts menu to log in as “administrator”.
Changed lines 93-99 from:
->1. Move hosted files (GoZyncHosted and your hosted file) to your host computer, and open them in FileMaker Server (or FileMaker Pro)

->2
. Update the External Data Sources in GoZyncMobile for GoZyncHosted and your hosted file to reflect their network paths

->3
. Run “Prep and Upload new File” script from your mobile file

->4
. Send email to mobile users with link to GZH “Downloads” screen
to:
->1. Move hosted files (GoZyncHosted and your hosted file) to your host computer, and open them in FileMaker Server (or FileMaker Pro).

->2.
Update the External Data Sources in GoZyncMobile for GoZyncHosted and your hosted file to reflect their network paths.

->3.
Run “Prep and Upload new File” script from your mobile file.

->4.
Send email to mobile users with link to GZH “Downloads” screen.
August 25, 2014, at 06:14 PM by 98.245.117.26 -
Changed lines 15-16 from:
->7. Repair the gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Should be “Type: Summary” using “List of[your ID field]”
to:
->7. Repair the gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Make sure it's a Summary field, defined as “List of[your ID field]”
Changed lines 25-29 from:
->12. Edit “Filter Records To Pull” script - Disable or delete the “Omit Multiple Records [No Dialog; 100]” and “Show Omitted Only” steps (leave “Show All Records” step). Optional: set up filtering if desired

->13. If you are doing related syncing, make a relationship using the applicable key fields between
the parent and child gzh_ TOs on the graph in your hosted file, then write a simple script to update the gz_ModTimeStamp field in the parent record, and attach that to an OnRecordCommit script trigger on any layouts where you will be editing the child records.

->14. Add an “If[]” condition in the startup script in your hosted file(s) so it doesn’t run when using PSOS, like this:
to:
->12. Edit the “Filter Records To Pull” script - Disable or delete the “Omit Multiple Records [No Dialog; 100]” and “Show Omitted Only” steps (leave the “Show All Records” step). Optional: set up [[Downloading Found Sets | filtering]] if desired.

->13. If you are doing related syncing, make a relationship using
the applicable key fields between the parent and child gzh_ TOs on the graph, then write a simple script to update the gz_ModTimeStamp field in the parent record, and run that via the OnRecordCommit script trigger on any layouts where you will be editing the child records.

->14. Add the “If[]” condition shown below at the beginning of your startup script (if you have one) so it doesn’t run when the file is opened via a PSOS call.
August 25, 2014, at 06:05 PM by 98.245.117.26 -
Changed lines 11-24 from:
->5. Only one file? Close it, then duplicate it to make your mobile file, renamed with “_mobile”, and put it in the same folder as GoZyncMobile (this folder is probably named “Local”)

->6. Copy two fields (gz_ModTimeStamp and gz_id_ListOF) from the WorkOrders table in WorxHosted, paste into each table to synced in your hosted file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options)

->7
. Repair gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Should be “Type: Summary” using “List of[your ID field]”

->8. Create a “gzh_TableName” TO on graph for each table to be synced

->9
. Create blank “gzh_TableName” layouts for each table to synced

->10
. Copy/paste the “GoZync” scripts folder from WorxHosted into your hosted file (or import it)

->11
. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzh_” TO (follow the pattern)
to:
->5. If you don't have a separate mobile file, duplicate your hosted file and add “_mobile” to the name, then move it to the same folder as GoZyncMobile (“Local”)

->6. Copy two fields (gz_ModTimeStamp and gz_id_ListOF) from the WorkOrders table in WorxHosted, and paste them into each table to be synced in your hosted file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options.

->7.
Repair the gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Should be “Type: Summary” using “List of[your ID field]”

->8. Create a “gzh_TableName” TO on graph for each table to be synced.

->9.
Create blank “gzh_TableName” layouts for each table to synced.

->10.
Copy/paste the “GoZync” scripts folder from WorxHosted into your hosted file (or import it).

->11.
Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzh_” TO (follow the pattern).
Changed lines 27-28 from:
->13. If you are doing related syncing, make a relationship using the applicable key fields between the parent and child gzh_ TOs on the graph in your hosted file, then write a simple script to update gz_ModTimeStamp in parent record, and attach that to an OnRecordCommit script trigger on any layouts where you will be editing the child records.
to:
->13. If you are doing related syncing, make a relationship using the applicable key fields between the parent and child gzh_ TOs on the graph in your hosted file, then write a simple script to update the gz_ModTimeStamp field in the parent record, and attach that to an OnRecordCommit script trigger on any layouts where you will be editing the child records.
Changed line 31 from:
   If [PatternCount ( Get ( ApplicationVersion ) ; "Server" )]
to:
   If [PatternCount (Get (ApplicationVersion); "Server")]
Changed lines 37-38 from:
->1. Put your mobile file in the same folder as GoZyncMobile (this folder is probably named “Local”)
to:
->1. Put your mobile file in the same folder as GoZyncMobile (“Local”)
Changed line 43 from:
->4. Copy/paste the “gz” table from WorxMobile into each table to be synced (or import it)
to:
->4. Copy/paste the “gz” table from WorxMobile into your mobile file.
August 25, 2014, at 05:53 PM by 98.245.117.26 -
Changed lines 3-6 from:
->1. Put your hosted file in the same folder as GoZyncHosted (this folder is probably named “Host”)

->2. Add the Custom Function “UUIDDecimal”. Copy/paste the code from WorxHosted. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
to:
->1. Put your hosted file in the same folder as GoZyncHosted (“Host”)

->2. Add the “UUIDDecimal” Custom Function (copy/paste code from WorxHosted). Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
Changed lines 9-10 from:
->4. If you already had a primary-key field, you do not need to change the values in existing records, but if you created the ID field AFTER there were already records in the table, you’ll need to populate that field for all existing records. Find those empty records, then use FileMaker’s “Replace Field Contents” command and the UUIDDecimal custom function to populate the new ID field with a unique value in all found records. Note: if you are going to be duplicating your file to create the mobile version, populate this field in the main file BEFORE you duplicate the file.
to:
->4. If you already had a primary-key field, you do not need to change the values in existing records, but if you created the ID field AFTER there were already records in the table, you’ll need to populate that field for all existing records. Find those empty records, then use FileMaker’s “Replace Field Contents” command and the UUIDDecimal custom function to populate the new ID field with a unique value in all found records. ''Note: if you are going to be duplicating your file to create the mobile version, populate this field in the main file BEFORE you duplicate the file.''
Changed lines 28-29 from:
14. Add an “If[]” condition in the startup script in your hosted file(s) so it doesn’t run when using PSOS, like this:
to:

->
14. Add an “If[]” condition in the startup script in your hosted file(s) so it doesn’t run when using PSOS, like this:
Changed line 39 from:
->2. Add the Custom Function “UUIDDecimal”. Copy/paste the code from WorxHosted. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
to:
->2. Add the “UUIDDecimal” Custom Function. Copy/paste the code from WorxHosted. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
August 25, 2014, at 05:50 PM by 98.245.117.26 -
Changed lines 1-2 from:
Preparing your hosted file
to:
!!Preparing your hosted file
Changed lines 10-18 from:
5. Only one file? Close it, then duplicate it to make your mobile file, renamed with “_mobile”, and put it in the same folder as GoZyncMobile (this folder is probably named “Local”)
6. Copy two fields (gz_ModTimeStamp and gz_id_ListOF) from the WorkOrders table in WorxHosted, paste into each table to synced in your hosted file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options)
7. Repair gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Should be “Type: Summary” using “List of[your ID field]”
8. Create a “gzh_TableName” TO on graph for each table to be synced
9. Create blank “gzh_TableName” layouts for each table to synced
10. Copy/paste the “GoZync” scripts folder from WorxHosted into your hosted file (or import it)
11. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzh_” TO (follow the pattern)
12. Edit “Filter Records To Pull” script - Disable or delete the “Omit Multiple Records [No Dialog; 100]” and “Show Omitted Only” steps (leave “Show All Records” step). Optional: set up filtering if desired
13. If you are doing related syncing, make a relationship using the applicable key fields between the parent and child gzh_ TOs on the graph in your hosted file, then write a simple script to update gz_ModTimeStamp in parent record, and attach that to an OnRecordCommit script trigger on any layouts where you will be editing the child records.
to:

->
5. Only one file? Close it, then duplicate it to make your mobile file, renamed with “_mobile”, and put it in the same folder as GoZyncMobile (this folder is probably named “Local”)

->
6. Copy two fields (gz_ModTimeStamp and gz_id_ListOF) from the WorkOrders table in WorxHosted, paste into each table to synced in your hosted file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options)

->
7. Repair gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Should be “Type: Summary” using “List of[your ID field]”

->
8. Create a “gzh_TableName” TO on graph for each table to be synced

->
9. Create blank “gzh_TableName” layouts for each table to synced

->
10. Copy/paste the “GoZync” scripts folder from WorxHosted into your hosted file (or import it)

->
11. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzh_” TO (follow the pattern)

->
12. Edit “Filter Records To Pull” script - Disable or delete the “Omit Multiple Records [No Dialog; 100]” and “Show Omitted Only” steps (leave “Show All Records” step). Optional: set up filtering if desired

->
13. If you are doing related syncing, make a relationship using the applicable key fields between the parent and child gzh_ TOs on the graph in your hosted file, then write a simple script to update gz_ModTimeStamp in parent record, and attach that to an OnRecordCommit script trigger on any layouts where you will be editing the child records.
August 25, 2014, at 05:49 PM by 98.245.117.26 -
Changed lines 27-35 from:
#1. Put your mobile file in the same folder as GoZyncMobile (this folder is probably named “Local”)
2. Add the Custom Function “UUIDDecimal”. Copy/paste the code from WorxHosted. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
3. Make sure each table to be synced in your mobile file has a primary-key field, set to “Type: Text” and auto-enter UUIDDecimal by calc (uncheck “Do not replace…”). Be sure Indexing is set to “All”.
4. Copy/paste the “gz” table from WorxMobile into each table to be synced (or import it)
5. Copy four fields (gz_ModTimeStamp, gz_LatestAction, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, paste into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options)
6. Copy/paste “GoZync” scripts folder from WorxMobile into your mobile file (or import it)
7. Edit "Zync - Is a new version permitted" script to Go to Layout for the primary TO you're syncing
8. Add a “Sync Now” button somewhere on the user interface that runs the “Zync It - Everything” script.
9. Add a “Check for Updates” button somewhere on the user interface that runs the “Zync - Check for Updates” script.
to:
->1. Put your mobile file in the same folder as GoZyncMobile (this folder is probably named “Local”)

->
2. Add the Custom Function “UUIDDecimal”. Copy/paste the code from WorxHosted. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.

->
3. Make sure each table to be synced in your mobile file has a primary-key field, set to “Type: Text” and auto-enter UUIDDecimal by calc (uncheck “Do not replace…”). Be sure Indexing is set to “All”.

->
4. Copy/paste the “gz” table from WorxMobile into each table to be synced (or import it)

->
5. Copy four fields (gz_ModTimeStamp, gz_LatestAction, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, paste into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options)

->
6. Copy/paste “GoZync” scripts folder from WorxMobile into your mobile file (or import it)

->
7. Edit "Zync - Is a new version permitted" script to Go to Layout for the primary TO you're syncing

->
8. Add a “Sync Now” button somewhere on the user interface that runs the “Zync It - Everything” script.

->
9. Add a “Check for Updates” button somewhere on the user interface that runs the “Zync - Check for Updates” script.
August 25, 2014, at 05:48 PM by 98.245.117.26 -
Changed lines 1-4 from:
!!GoZync 5 integration

'''Preparing your hosted
file'''
to:
Preparing your hosted file
Changed lines 7-8 from:
3. Make sure each table to be synced in your hosted file has a primary-key field, set to “Type: Text” and auto-enter UUIDDecimal by calc (uncheck “Do not replace…”). Be sure Indexing is set to “All”.
4. If you already had a primary-key field, you do not need to change the values in existing records, but if you created the ID field AFTER there were already records in the table, you’ll need to populate that field for all existing records. Find those empty records, then use FileMaker’s “Replace Field Contents” command and the UUIDDecimal custom function to populate the new ID field with a unique value in all found records. Note: if you are going to be duplicating your file to create the mobile version, populate this field in the main file BEFORE you duplicate the file.
to:
->3. Make sure each table to be synced in your hosted file has a primary-key field, set to “Type: Text” and auto-enter UUIDDecimal by calc (uncheck “Do not replace…”). Be sure Indexing is set to “All”.

->
4. If you already had a primary-key field, you do not need to change the values in existing records, but if you created the ID field AFTER there were already records in the table, you’ll need to populate that field for all existing records. Find those empty records, then use FileMaker’s “Replace Field Contents” command and the UUIDDecimal custom function to populate the new ID field with a unique value in all found records. Note: if you are going to be duplicating your file to create the mobile version, populate this field in the main file BEFORE you duplicate the file.
Changed lines 25-27 from:
Preparing your mobile file

1. Put your mobile file in the same folder as GoZyncMobile (this folder is probably named “Local”)
to:
!!Preparing your mobile file

#1. Put your mobile file in the same folder as GoZyncMobile (this folder is probably named “Local”)
Changed lines 37-63 from:
GoZyncMobile

1. Add TOs for your hosted and mobile tables to be synced (gzh_, gzm_) to the Relationships Graph, adding new External Data Sources as necessary
3. Establish relationships between each of your TOs and the GoZync TO, using the “=” operator to connect GoZync::PrimaryID to gzh/m_YourTable::YourIDField, with the “Allow creation…” option turned on on the “gzh/m_” side of the relationship.
4. Remove any TOs you won’t be using (gzh_WorkOrderItems, etc)
5. Edit "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at the script "GoZync Call from GZM"
6. Edit “Setup Go To Related Records (TOName)” script, make sure there is an “Else If” branch for each “gzm_” TO (follow pattern)
7. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, add fields to be synced. Note: don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields
8. Delete any gzm_ or gzh_ layouts for TOs you aren’t using
9. External Data Sources - Delete WorxHosted and WorxMobile entries

GoZyncHosted

1. Close the WorxHosted and WorxMobile files (check the “Window > Show Window” list to make sure they aren’t still open in the background).
2. Move the WorxHosted and WorxMobile files to a different folder (or to the trash).
3. Delete “GoZyncMobile” and “WorxMobile” from the “Downloads” screen in GoZyncHosted
4. Select “Relogin” from the Scripts menu to log in as “administrator”
5. Click the “Refresh and check for errors” button on the Configuration screen.
6. Click on any caution icons that appear for guidance on how to correct errors.
7. If you are going to use related syncing, click the “Requires” column and follow the prompts.

Deployment

1. Move hosted files (GoZyncHosted and your hosted file) to your host computer, and open them in FileMaker Server (or FileMaker Pro)
2. Update the External Data Sources in GoZyncMobile for GoZyncHosted and your hosted file to reflect their network paths
3. Run “Prep and Upload new File” script from your mobile file
4. Send email to mobile users with link to GZH “Downloads” screen
to:
!!GoZyncMobile

->1. Add TOs for your hosted and mobile tables to be synced (gzh_, gzm_) to the Relationships Graph, adding new External Data Sources as necessary

->
3. Establish relationships between each of your TOs and the GoZync TO, using the “=” operator to connect GoZync::PrimaryID to gzh/m_YourTable::YourIDField, with the “Allow creation…” option turned on on the “gzh/m_” side of the relationship.

->
4. Remove any TOs you won’t be using (gzh_WorkOrderItems, etc)

->
5. Edit "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at the script "GoZync Call from GZM"

->
6. Edit “Setup Go To Related Records (TOName)” script, make sure there is an “Else If” branch for each “gzm_” TO (follow pattern)

->
7. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, add fields to be synced. Note: don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields

->
8. Delete any gzm_ or gzh_ layouts for TOs you aren’t using

->
9. External Data Sources - Delete WorxHosted and WorxMobile entries

!!GoZyncHosted


->
1. Close the WorxHosted and WorxMobile files (check the “Window > Show Window” list to make sure they aren’t still open in the background).

->
2. Move the WorxHosted and WorxMobile files to a different folder (or to the trash).

->
3. Delete “GoZyncMobile” and “WorxMobile” from the “Downloads” screen in GoZyncHosted

->
4. Select “Relogin” from the Scripts menu to log in as “administrator”

->
5. Click the “Refresh and check for errors” button on the Configuration screen.

->
6. Click on any caution icons that appear for guidance on how to correct errors.

->
7. If you are going to use related syncing, click the “Requires” column and follow the prompts.

!!Deployment


->
1. Move hosted files (GoZyncHosted and your hosted file) to your host computer, and open them in FileMaker Server (or FileMaker Pro)

->
2. Update the External Data Sources in GoZyncMobile for GoZyncHosted and your hosted file to reflect their network paths

->
3. Run “Prep and Upload new File” script from your mobile file

->
4. Send email to mobile users with link to GZH “Downloads” screen
August 25, 2014, at 05:46 PM by 98.245.117.26 -
Changed lines 1-6 from:
GoZync 5 integration

Preparing your hosted file

1. Put your hosted file in the same folder as GoZyncHosted (this folder is probably named “Host”)
2. Add the Custom Function “UUIDDecimal”. Copy/paste the code from WorxHosted. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
to:
!!GoZync 5 integration

'''Preparing your hosted file'''

->
1. Put your hosted file in the same folder as GoZyncHosted (this folder is probably named “Host”)

->
2. Add the Custom Function “UUIDDecimal”. Copy/paste the code from WorxHosted. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
August 25, 2014, at 05:44 PM by 98.245.117.26 -
Added lines 1-62:
GoZync 5 integration

Preparing your hosted file

1. Put your hosted file in the same folder as GoZyncHosted (this folder is probably named “Host”)
2. Add the Custom Function “UUIDDecimal”. Copy/paste the code from WorxHosted. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
3. Make sure each table to be synced in your hosted file has a primary-key field, set to “Type: Text” and auto-enter UUIDDecimal by calc (uncheck “Do not replace…”). Be sure Indexing is set to “All”.
4. If you already had a primary-key field, you do not need to change the values in existing records, but if you created the ID field AFTER there were already records in the table, you’ll need to populate that field for all existing records. Find those empty records, then use FileMaker’s “Replace Field Contents” command and the UUIDDecimal custom function to populate the new ID field with a unique value in all found records. Note: if you are going to be duplicating your file to create the mobile version, populate this field in the main file BEFORE you duplicate the file.
5. Only one file? Close it, then duplicate it to make your mobile file, renamed with “_mobile”, and put it in the same folder as GoZyncMobile (this folder is probably named “Local”)
6. Copy two fields (gz_ModTimeStamp and gz_id_ListOF) from the WorkOrders table in WorxHosted, paste into each table to synced in your hosted file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options)
7. Repair gz_id_ListOF field if necessary (the field definition will break when pasted if your ID field’s name is different). Should be “Type: Summary” using “List of[your ID field]”
8. Create a “gzh_TableName” TO on graph for each table to be synced
9. Create blank “gzh_TableName” layouts for each table to synced
10. Copy/paste the “GoZync” scripts folder from WorxHosted into your hosted file (or import it)
11. Edit the “Setup Go To Related Records (TOName)” script, making sure there is an “Else If” branch for each “gzh_” TO (follow the pattern)
12. Edit “Filter Records To Pull” script - Disable or delete the “Omit Multiple Records [No Dialog; 100]” and “Show Omitted Only” steps (leave “Show All Records” step). Optional: set up filtering if desired
13. If you are doing related syncing, make a relationship using the applicable key fields between the parent and child gzh_ TOs on the graph in your hosted file, then write a simple script to update gz_ModTimeStamp in parent record, and attach that to an OnRecordCommit script trigger on any layouts where you will be editing the child records.
14. Add an “If[]” condition in the startup script in your hosted file(s) so it doesn’t run when using PSOS, like this:

  If [PatternCount ( Get ( ApplicationVersion ) ; "Server" )]
      ExitScript[]
  End If

Preparing your mobile file

1. Put your mobile file in the same folder as GoZyncMobile (this folder is probably named “Local”)
2. Add the Custom Function “UUIDDecimal”. Copy/paste the code from WorxHosted. Alternatively (or if you don’t have FileMaker Advanced), use the Get(UUID) function in the following step.
3. Make sure each table to be synced in your mobile file has a primary-key field, set to “Type: Text” and auto-enter UUIDDecimal by calc (uncheck “Do not replace…”). Be sure Indexing is set to “All”.
4. Copy/paste the “gz” table from WorxMobile into each table to be synced (or import it)
5. Copy four fields (gz_ModTimeStamp, gz_LatestAction, gz_Send and gz_TimeStampZynced) from the WorkOrders table in WorxMobile, paste into each table to synced in your mobile file. If you don’t have FileMaker Advanced, you’ll need to recreate these fields manually, matching all options)
6. Copy/paste “GoZync” scripts folder from WorxMobile into your mobile file (or import it)
7. Edit "Zync - Is a new version permitted" script to Go to Layout for the primary TO you're syncing
8. Add a “Sync Now” button somewhere on the user interface that runs the “Zync It - Everything” script.
9. Add a “Check for Updates” button somewhere on the user interface that runs the “Zync - Check for Updates” script.

GoZyncMobile

1. Add TOs for your hosted and mobile tables to be synced (gzh_, gzm_) to the Relationships Graph, adding new External Data Sources as necessary
3. Establish relationships between each of your TOs and the GoZync TO, using the “=” operator to connect GoZync::PrimaryID to gzh/m_YourTable::YourIDField, with the “Allow creation…” option turned on on the “gzh/m_” side of the relationship.
4. Remove any TOs you won’t be using (gzh_WorkOrderItems, etc)
5. Edit "PSOS Config" script. Find the comment ‘Call the script "GoZync Call from GZM" in your hosted file’ and point the next Perform Script line at the script "GoZync Call from GZM"
6. Edit “Setup Go To Related Records (TOName)” script, make sure there is an “Else If” branch for each “gzm_” TO (follow pattern)
7. Layouts - Create “gzh_TableName” and “gzm_TableName” layouts for each table to synced, add fields to be synced. Note: don’t include calc fields, summary fields, global fields, the primary key field (ID), or any of the “gz…” fields
8. Delete any gzm_ or gzh_ layouts for TOs you aren’t using
9. External Data Sources - Delete WorxHosted and WorxMobile entries

GoZyncHosted

1. Close the WorxHosted and WorxMobile files (check the “Window > Show Window” list to make sure they aren’t still open in the background).
2. Move the WorxHosted and WorxMobile files to a different folder (or to the trash).
3. Delete “GoZyncMobile” and “WorxMobile” from the “Downloads” screen in GoZyncHosted
4. Select “Relogin” from the Scripts menu to log in as “administrator”
5. Click the “Refresh and check for errors” button on the Configuration screen.
6. Click on any caution icons that appear for guidance on how to correct errors.
7. If you are going to use related syncing, click the “Requires” column and follow the prompts.

Deployment

1. Move hosted files (GoZyncHosted and your hosted file) to your host computer, and open them in FileMaker Server (or FileMaker Pro)
2. Update the External Data Sources in GoZyncMobile for GoZyncHosted and your hosted file to reflect their network paths
3. Run “Prep and Upload new File” script from your mobile file
4. Send email to mobile users with link to GZH “Downloads” screen
(855) SEEDCODE
[email protected]
Follow us: