Jump to content

Andreas T.

Members
  • Content count

    66
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Andreas T.

  • Rank
    member

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
    Expert
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Sierra
  1. 360Deploy Solution Bundle and user accounts

    Thank you, Zach. I suppose that would be a feasible, although not ideal, solution. One would need to delegate passwords to users, keeping them in a separate secure local file. Users would not be able to change their own passwords in the solutions.
  2. 360Deploy Solution Bundle and user accounts

    I am surprised that no one from 360 Works has responded to this. Isn't this their official support channel?
  3. I’m considering the solution bundle for a vertical market solution. One major issue looks to be the handling of user accounts. The various deployments all have lots of different internal Filemaker user accounts that are managed from within each solution by the local admins. How can one migrate those user accounts from the production version or is it something that can be recreated after the import? Advice welcomed.
  4. Using the Diff Processor

    The diff processor won’t work with different file names. You need to edit the file names and the xml files. Do a search/replace in a text editor before import.
  5. Thanks to you I finally managed to get the BE_ApplyXSLT function working after consolidating all external references into the main XSL. Obvious when you think about it it, but I somehow didn't catch that only the unparsed selected file was read in and got hung up in the fact that there seemed to be no errors. IMO, the function needs some better error handling and the docs needs some error correction as well as maybe a note on this potential pitfall. Thank you again.
  6. No.... Seems I made a mistake about that, there was an include in the one I was thinking about. Really confusing when the function doesn't report on such errors. That's what tripped me up. I have tested with so many scenarios that I'm not sure anymore what worked and what didn't. Have to assume then that it is missing dependencies that is the general cause. The function should error report on missing dependencies. All other processors do. Going to start over after I combine the dependencies into the main XSL. Thank you again so much, Comment for your time.
  7. Ah, you are probably right, but then it should at least have thrown exceptions about missing references. I have also tried with other XSL-files which have no dependencies and they also silently fail. I will try to combine thes files into one.
  8. I can send you a PM with the files, if you are willing to give it a try. Would be useful to teste it on another machine, for sure. The files are small, the XML is about 11K and the XSL with includes totals less than 100K. I have verified that all includes are included.
  9. After spending close to two days on this annoying issue, I've reached the end of my rope and I'm giving up on these functions. They seem to fail to transform or error report many documents, even though I cannot see a pattern to it. Simple documents work fine, something a bit more complicated and they often fail silently. Every other transformer I have found works including Oxygen, libxml2, AppleScript XMLLIB and this Java based (jaxp) online transformer: http://www.utilities-online.info/xsltransformation/#.WRWJHVLJLmE As I cannot see a way to bug report this without paying $199, I'm out. I'll have to find an XML library I can use on Windows and use Applescript on the Mac. Thanks for your input , Comment.
  10. Thanks again. I had already tried the BE_ApplyXSLTInMemory function in a similar fashion, but I did try again with your excact example and it fails in the same way with nothing returned. All paths are working and the files are being read into the fields. The function silently fails. I am going to try the function with some other XML and see if I can make out where it fails.
  11. Thank you, Comment for your confirmation of the documentation error and your suggestion. I have already verified the paths with the BE_SelectFile function and they are correct. Btw, using direct adressing with /private/var or the symlink /var makes no difference in any of the test scenarios I have tried. They both work, except in BE_ApplyXSLT where neither works. I think the function somehow chokes on my XML or XSLT, but then there should be an error. Besides, libxml2 transforms the file with no errors or warnings.
  12. I need some help in determining if I am missing something crucial here or if there is a limitation or bug in the function BE_ApplyXSLT from the BaseElements plugin. I am using version 3.3.4 (which is the latest) on Mac OS X 10.11.6 using FileMaker 15 Adv. and 16 Adv. I am unable to get any output from the transformation, nor any error. According to the documentation, the command shall return either 0 when successful or an error. Link In my testing it only returns blank, and gives no error even when no output file is generated. It should not return blank in cany case according to the docs. (I suspect there may be a documentation error and that it actually returns blank when there is no error.) No error is found using Get(LastError). BE_GetLastError returns 0. The function format is this: BE_ApplyXSLT ( xmlPath ; xslt ; outputPath ) Here are the input parameters I have used: BE_ApplyXSLT ( "/var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/ABC_nota_108.xml" ; BE_ReadTextFromFile ( "/var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/HTMLvisning/Stylesheet_Full.xsl" ); "/var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/output.html" ) I have verified that the files exist and that both the XML and XSLT are valid. All files are in UTF-8. I can transform the XML with this XSLT using other methods without errors. I have also tried having the XSLT in a variable. As I understand it, BaseElements uses the libxml2 engine. I have tried doing the transform from the command line directly and it works as it should: xsltproc -o /var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/output.html /var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/HTMLvisning/Stylesheet_Full.xsl /var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/ABC_nota_108.xml It also works fine using the XMLLib OSAX in AppleScript. Unfortunately, I need Windows support also so I would like to get the BaseElements function to work. I hope somone can shed some light on what may be going on.
  13. Indeed it does! You are the man! (Sorry i didn't respond earlier, I did not get a notification) This is exactly what I was looking for, thank you very much. In fact, I tried to look into a SQL query that could yield this result, but I couldn't do it and after seeking advice in Stack Overflow, I was informed that it probably could not be done within FileMakers SQL framework. Here is the link to the post if you are interested. Thanks again!
  14. Thank you for your advice. It is sometimes useful to get input on what not to do as well as how to do things. It could be solved as a script, running a looping sub-script for the concatenations for each of the about 10 similar results that comes from the SQL queries. Each SQL query acts as a basis for a bar plot in the D3 graph. There could be 10 or more of those in addition to a few line plots. I was thinking that a looping script running a looping subscript 10 times would be slower than a CF being run 10 times. Maybe I am wrong about that. I would like the graph to update momentarily after the record is commited, but if it becomes too slow I will have to resort to a popup or something and generate on demand.
  15. Thank you comment for your insight. Yes, it would indeed seem like an XY problem as you say, but there is a reason. If I can get the results of the SQL query (which is quite complex) procesed like I want, I can easily loop through the resulting rows and generate the JSON. So in this case I know Y. I only mentioned the final JSON result thinking that it might be useful for someone considering a solution to the concatination. As this is only a small part of a large graph being plotted in D3.js in a WebViewer, I would like it to be done in memory for speed and "simplicity". XSLT is an option, but I think the concatination can be solved with a CF. I see some related CFs over at briandunning.com, but nothing that fits. I hope someone with experience in this sort of thing can figure out something as these recursive CF things always give me an headache.
×

Important Information

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