Jump to content

Franco

Members
  • Content Count

    70
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Franco

  • Rank
    member
  • Birthday 09/21/1955
  1. i had a bad bad bad bad experiences with wouldcloud for the filemaker server 13 clouding, does can you suggest a serious cloud company?
  2. The scenario is Local mac with plugin base element. Server mac fms server13 with plugin base element. ------------------------------------------ The server side script job is: List the backup folders Select the last backup and set $$folderPath Set the $$SourceFolderFilePath Set theDestination $$FolderFileRenamedPath /*The Job*/ Duplicate and rename the file on the server backup folder to my "service" folder ------------------------------------------ This doesn't work: a local file call a server side script of my job This doesn't work. This it work: Open the file on the server were there is the script of my job. Lunch the script as server side script, It work fast because all happen between server disks (2 disk). I use for both the same path because i suppose that the server side script work as if i do my job in my local Cpu, were i am wrong? My best regards. Franco
  3. how didi you set " $$use_psos_during_pull " on " EasySync Settings " script on the mobile file? This variable set if the pull scripts of the hosted file is solved by the server or in the mobile device.
  4. Finally I finished the test. IT WORK. I add this future: A) The same file for hosted and remote. Differents kind of sync, some table are synched for all the records, other only the records related to the privilege setting. The final result is that all the groups have common informations, but each group has specific informations related to it. Let say thank you to all the people that made me possible to do this. My best regards Franco
  5. this query should select from the table only the records of the group set by the variable $PrivGroup, the query work fine without the red part, please were i am wrong? Var $dyn_sql : -------------------------------- "SELECT " & $dyn_sql & ", '" & $$record_delimiter & "'" & " FROM "" & $sync_table & """ & " WHERE " & " ( ES_PrivGroup = "" & $Privgroup & "" ) " & " AND ( COALESCE ( ES_Exclude, 0 ) = 0 ) ) " & If ( ( $$sync_method = "Merge" ) and ( $last_pull_utc > 0 ); "AND ( ES_UTC_Time > " & $last_pull_utc & " ) " & "AND ( COALESCE ( ES_Device_ID, 'X' ) <> '" & $client_persistent_id & "') " ; "" ) -------------------------------- the red part is my add, i get the error code 106. Please tell me were i am wrong?
  6. still doesn't work Var $dyn_sql : -------------------------------- "SELECT " & $dyn_sql & ", '" & $$record_delimiter & "'" & " FROM "" & $sync_table & """ & " WHERE " & " ( ES_PrivGroup = "" & $Privgroup & "" ) " & " AND ( COALESCE ( ES_Exclude, 0 ) = 0 ) ) " & If ( ( $$sync_method = "Merge" ) and ( $last_pull_utc > 0 ); "AND ( ES_UTC_Time > " & $last_pull_utc & " ) " & "AND ( COALESCE ( ES_Device_ID, 'X' ) <> '" & $client_persistent_id & "') " ; "" ) -------------------------------- the red part is my add, i get the error code 106. Please tell me were i am wrong?
  7. on the script "Prepare Payload for Client" i am changed in this way:  the Var $dyn_sql setting: ------------------------------------------------------------------- "SELECT " & $dyn_sql & ", '" & $$record_delimiter & "'" & " FROM "" & $sync_table & """ & " WHERE " & // Exclude records flagged for sync exclusion. "( COALESCE ( ES_Exclude, 0 ) = 0 ) /* $pg var is the privilege group. Pgroup is the field with the privilege. esclude all the group different to $Pg /* and ( COALESCE ( Pgroup, 0 ) <>  " & $Pg & " ) " & // If the client is merging new/updated data with data already on the device... // Only include records that have been added/updated since the last pull... // And only include data that they did not just push (i.e. no "round tripping!")... If ( ( $$sync_method = "Merge" ) and ( $last_pull_utc > 0 ); "AND ( ES_UTC_Time > " & $last_pull_utc & " ) " & "AND ( COALESCE ( ES_Device_ID, 'X' ) <> '" & $client_persistent_id & "') "; "" ) -------------------------------------------------------------------  it doesn't work because i don't know sql, then again please any suggest?
  8. i finisched my test, my goals were: single file. upgrade thr filemaker standard invoice file to a "synckable" solution. Result: IT WORK. now i have to add the second level of test: The products and clients tables have to be completly syncked. The Invoices and stock tables have only synched by devices. Many thanks for you help franco
  9. my explnation was "fuzzy", i made new test, i put all the scripts and layouts on the file FM_Surveys_Hosted, then, i put one copy in the server and a second renamed on my ipad. it work. New test is to implement the sync option in the Invoice example included with the filemaker Pro, and this is my goal: 1) Products list, Client tables shared between all, 2 remote iPad and 1 connected clients to the server. all will see the same data. 2) Invoices, products in stock tables have different progressive numbers for each remote pos and clients, then as they sync they should sync only from remote to server. each one will see only their data. About the connected client is just a script problem, for the 2 ipad i am trying to understand the right way to do, probably the answer is already in the easysynk demo, but at the moment i have some problem to understand how, could you huo tell me how to do sync by device or account? My best regards Franco
  10. for some reason i have to put all the synk option in a single file, do i have to have a easysynk table for the hosted option and a copy of it for the mobile synk option? i made some change in your example having to synk tables but i get a 106 error in the "pull payload" script. As you can see in the picture i prepared all to be merge in to the host file. Â
  11. This is my scenario: Fms 13 3 clients fmpro connected to the server. (do not sync) 5 Fmgo off line I have to synk the 5 fmgo clients, not concurrent connections, max 3 concurrent. Some tabels to be synched bidirectionally. Should i buy: 5-Pack of FileMaker Pro/Go Devices and With Server/Client Type 1 x FileMaker Server 1 x FileMaker Pro/Go Many tanks Frnaco Pagano
  12. There are two plug in, 360works FTPeek and cns FTPit, the alternative is to use "Url " or custom function. I have to delete and upload a new file in a static site, my server has also a "robot" that create pdf then i can use the same robot to update the file on the site. 1) before i start could you suggest me the simpliest way? 2) The base element plug in could be used for ftp funcions? 3) any example other then for the plugin mentioned above? Thank you in advence for your attention. Franco
×
×
  • Create New...

Important Information

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