Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Lutmers

  • Rank
  1. Ok... this how it works... you try to find a solution for 5 long hours... Finally decide to post tot fmforums... And than within 20 min. you fix your own problem... crazy!! It's way easier than I thought.... Let ( [ STRING = GetValue ( $$D ; $$Tel ); COLUMN = Middle ( STRING ; 1 ;Position ( STRING ; "|" ; 1 ; 1 )-1) ; WLENGTE = Position ( STRING ; "|" ; 1 ; 2 )- Position ( STRING ; "|" ; 1 ; 1 ) - 1; WAARDE = GetField (Middle ( STRING ; Position ( STRING ; "|" ; 1 ; 1 )+1 ; WLENGTE)); FORMAT = Middle ( STRING ; Position ( STRING ; "|" ; 1 ; 2 )+1 ; 10) ] ; MBS( "XL.Sheet.CellWriteText"; $$MBS; 0; $$R ;COLUMN; WAARDE; Evalueren(FORMAT) ) ) Works like a charm... Filling template excel sheet with the MBS plugin is great!! Ok.. a little support for Christian here ;-) Jeroen
  2. Friends, I have had it for today... can't seem to get it right... I'm writing an Excel sheet using the MBS plugin. The plugin let's me set FORMATS so I can underline or center cells etc. For every FORMAT I declare a variabel i.e. that gets a value from the plugin $$Format1 = 89 $$Format2 = 90 I pull data from FMPro and 'filling' up an Excel Template with field values. Some of these field's need formatting. Since all data is dynamic, my script needs to handle this accordingly. I 'build' the excel sheet row-by-row, therefore pulling data from FMPro, row-by-row. A VARIABLE is handeling the data in the LOOP...The variable content looks like: "7" & "|" & "FM08_SAMPLE::ID_NUMERIC" & "|" & "FORMAT1" & "¶" & "8" & "|" & "FM08_SAMPLE::FM08_Sample_date" & "|" & "FORMAT2" & "¶" & "9" & "|" & "FM08_CUSTOMER::COMPANY_NAME" & "|" & "FORMAT1" In the script the data is pulled apart, set to the right CELL and a FORMAT needs to be applied. Now, here's my question, I need to have this function filled: MBS( "XL.Sheet.CellWriteText"; $$MBS; 0; ROW ;COLUMN; VALUE; FORMAT) Where format of course should not be "FORMAT1" but "89"... I tried things like: Let ( [ STRING = GetValue ( $$D ; $$Tel ); COLUMN = Middle ( STRING ; 1 ;Position ( STRING ; "|" ; 1 ; 1 )-1) ; WLENGTE = Position ( STRING ; "|" ; 1 ; 2 )- Position ( STRING ; "|" ; 1 ; 1 ) - 1; WAARDE = GetField (Middle ( STRING ; Position ( STRING ; "|" ; 1 ; 1 )+1 ; WLENGTE)); FORMAT = Middle ( STRING ; Position ( STRING ; "|" ; 1 ; 2 )+1 ; 10); VAR = "Let ( $$" & FORMAT & "; ")" ] ; MBS( "XL.Sheet.CellWriteText"; $$MBS; 0; $$R ;COLUMN; WAARDE; Evalueren(VAR) ) ) But It does not work... where do I go wrong?? Thanks, Jeroen
  3. Tim and others, I had checked all relationships, references, field names, TO's and ES_ prefixes, cleaned everything, check for old payloads and add new records... and was still left with 'funny behavior'. One of them was that my largest table (70 fields) was not synced but generated not error's as well. I decided to rebuild, but since I would like to know what's was wrong I first did a 'break down' of existing tables. And some curious things happened. These are my findings up to now: 1. Corrupt fields break the sync? Because I thought off field corruption I had FMPro rebuild the DB >> result: No change. I created fully new tables - did all install steps - and COPIED 70 OLD fields to the NEW table... > result: EasySync did NOT work. 2. Within that new database I deleted 60 of the OLD field and where left with a table with 10 fields... > result: EasySync DID work. 2. One record left alone: With a fully empty 6 tables, I added 4 records to a table... I did a Sync and.. > result: Only record 2, 3 and 4 were synced. record 1 was left alone. (this record was NOT excluded). Was this an incident or what? >> Have not tried to recreate situation yet 3. Sync problem when records made on iPad: With everything fully new build with 6 tables to sync, I added records on the server side and synced .. > result: IPad received new data -> OK I modified these records on iPad side and synced..> result Server was updated -> OK With everything fully new build with 6 tables to sync, I added records on the iPad side and synced .. > result: Server received new data -> OK I modified these records on the server and synced..> result Ipad was NOT updated -> Conclusion: I agree with Tim when he states that most errors are human and support is mainly a reference to the documentation. But I also find that: - it looks like renaming tables, fields and especially table occurrences is some how a possible breaking point; - Field corruption (?) or larger tables (many fields) look like a possible breaking point; - Am I still making a mistake, is it a bug or is it a logical choice that ipad added records are not update by the server? ps. the 102 / 106 errors are gone since downgrading the 70 field table... there is something in that table. Looking forward to your thoughts.. Jeroen
  4. Tim, I checked a million times... everything is equal. iPad does take records from Server but nog updates back. I cleaned all up.. made new records... nothing... it's quite cumbersome as soon as EasySync decides to not play ball ;-) Any ideas?
  5. Hi Tim and others, Does anybody have experience with a situations where EasySync is going crazy because of some Table occurrences changes AND RESETS? I'm mean, while testing I added some table occurrences, try to hook up more tables to sync. I broke the EasySync function. I tried to get back to the old situation but things got worse by the minute. A lot of 201 and 106 error for apparently no reason. I have seen Filemaker doing that before with ExcecuteSQL. I than had to replace occurences to have this fixed... but today seems a bad day and noting helps :-(... Yes I did do a Wipe and reset and di clean the sync dates Hope to here from you Jeroen
  6. Hi Tim, I have been looking at EasySync from day one and I'm happy ;-) I think it's a great job. I had implemented my own similar sync but yours I way more charming. What I need though and wonder how to this could be done best is the following: - In have a server file from which 'Collectors' with their iPad pull about 700 personal (name=collector) records weekly; - Records that are ready to pull have a status "iPad" which sets your 'exclude' to 0, others 1; - During the days of the week, Collectors update the records while on the road (locally - no wifi); - At the end of the day Collectors sync back the records they have updated as soon as they have wifi; Tim, whats best practice when we keep in mind: - Only records with name=collector should be pulled. - Pulled records (those that are on ipad) should get a status change so I can block them on server. - Synced records get a status change thus 'exclude' becomes 1 (this is easy by syncing back the status field thus changing 'exclude' to 1). - The synced records should - after successful sync- be deleted from the iPad (when all files are updated and no new files are offered, the iPad will be empty). Looking forward to your reply, Thanks! Jeroen Aqualab Zuid, The Netherlands
  7. Wow Wim and Comment, I tried to follow this discussion but I only understood the last part .... there seems to be no solution?? So do I understand correctly: 1. When we do an FMPro export the regular way (menu or script) we can add a XSL to format the FMgrammer output; 2. But based on a http query to a server we are not able to create (scripted or not) output that's able to be formatted through xsl? 3. And there is no way I can present the content of 1 field as a result of a http request, just as is.. with no grammer around it? I do understand that i could hand my customer the original fmgrammer xml but their demand is that I format the result :-( Any other solutions here? I seems so simple? But maybe that's why it's difficult thanks up to now! Jeroen Besides Comment, You helped me before.. the import part with XML en xsl is done and working ;-) but now I'm hanging with my export.
  8. Dear friends, Every time I'm so surprised how little data and examples there are online on filemaker server side xml requests / query's. Specially in combination with XSL. My case: 1. Customers come and ask me... please send results as xml and it should look like "this". 2. The results should be a result of a query they do on my server (so I supply a sort of webservice) 3. I can get them to send parameters, even do some pre scripts, get the results, but their browser wil show them the ugly FILEMAKER GRAMMER Result set. I need to be able to change the way the results look in a simple and easy manner. And the result should be passed back as a result of a http request. Any advice on the best practice here when we consider 2 things: 1. I'm not an XML/XSLT crack.. nor want I to be one; 2. My service provider won't let me place PHP in the server root. Which rules out 360 webservice I quess. My idee was to generate the result XML myself by looping through records and putting the result (parsed with some xml tags) back into one global field. After looping through all the fields this one field is published on the result layout of my the original query... This makes me very flexible because I symply translate the original xml to a header, middel and footer area that I later concatenate to one field. Unfortunately now it will show up WITHIN the ugly fmresultset. Should I and how apply xsl here? If you know the best solution, let me know. Thanks jeroen
  9. Hi Tim, I taking it for run.. looks great and promising. Feedback will follow ;-) Jeroen
  10. Brilliant Comment! Tested it, works like a charm.. Thanks! Jeroen
  11. Hi Comment, Please find enclosed zip... Thanks jeroen XML_problem.zip
  12. Chadski, Use a script trigger (OnObjectEnter) the number field with a script that shows a Custom Dialog with a password field. If pasword correct than enter field else exit field. Your can work along with more options on this (ie depending on user). Good luck Jeroen
  13. Try: $PATH = "filemac:/Machintosh HD/User/ryankivi/" & OrderNumber & "/file.pdf" Than on filepath location use: $PATH Good luck! Jeroen
  14. Hi Ron, Do know that you can get rit of that 'ugly user experience' on windows..... Put this in your start up script: IF (ABS(Get(SystemPlatform)) ≠ 1 Resize window to GET(Windowdesktopheight) - 4 and GET(Windowdesktopwidth) - 4 (I have a dutch fmPro version so excuse the crooked language) Good luck! jeroen
  • Create New...

Important Information

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