Leaderboard

There exist several variations of the CSV format. The variation that Filemaker uses encloses all fields in double quotes. This allows exporting fields that contain commas, carriage returns and double quotes. According to the RFC 4180 specification: Any field may be quoted (with double quotes). Fields containing a line-break, double-quote or commas should be quoted. (If they are not, the file will likely be impossible to process correctly.) If double-quotes are used to enclose fields, then a double-quote must be represented by two double-quote characters. It should be noted that Filemaker's implementation does not fully conform to these requirements (or perhaps better put, it exceeds them) because it converts in-field carriage returns to vertical tabs, for no good reason. You need to create your own. The available methods depend on the version in use - see: https://fmforums.com/topic/106027-need-to-export-a-text-file-with-each-field-on-a-separate-line/?do=findComment&comment=479210 If you're indeed using version 11, then XML/XSLT is your only option - unless your target application can read UTF-16 encoded files. If it does, you can have a script write the CSV into a global text field, then export the field's content. Or, if you're willing to limit yourself to the Mac platform, you could use AppleScript to create the file (you could probably use OS-level scripting in Windows, too - but then you would have to put in twice the work). -- P.S. Your profile says version 11 on Catalina; I believe that's a very unstable combination. PP.S. What's up with the title?

I am afraid you've lost me at this point. If it's possible to assign an item to a spot automatically, then why can't be dynamic? Of course, you can always number (or renumber) items by script (with the usual caveat regarding record locking).

Hi BCooney, Tutorial on using the package makes a huge difference - no, I didn't watch it before (hangs head in shame). Thanks, Greg

This might be helpful https://www.geistinteractive.com/2018/03/13/filemaker-json-parsing-generator/

The problem here is not curly braces, but square brackets. Same as with your previous question, these signify an array whose objects need to be accessed by their index number. In this case there is only one object, so the expression: JSONGetElement ( $$_JSON ; "list[0].weather[0].id" ) will return 801. Do note that list is also an array and it contains no less than 40 objects. The above expression extracts the weather id value from the first object only. Not all objects have the same weather id value, for example: JSONGetElement ( $$_JSON ; "list[2].weather[0].id" ) returns 800. How to solve such problems in general: It is very convenient to use the JSONListKeys() function to analyze the given JSON and help to select the next step in your keyOrIndexOrPath expression. Starting with an empty path, the expression: JSONListKeys ( $$_JSON ; "" ) returns: city cnt cod list message If you pick list, then: JSONListKeys ( $$_JSON ; "list" ) will tell you there are 40 objects to pick from. If you pick the first one, then: JSONListKeys ( $$_JSON ; "list[0]" ) will return: clouds dt dt_txt main sys weather wind Next: JSONListKeys ( $$_JSON ; "list[0].weather" ) returns "0". This is how we know it's an array containing a single object. And finally: JSONListKeys ( $$_JSON ; "list[0].weather[0]" ) gives us: description icon id main allowing us to construct the final path used above. -- Note that the dots after the index predicate are optional; the expression: JSONGetElement ( $$_JSON ; "list[0]weather[0]id" ) will work just as well.

you need to change the sub summary on the layout to that of the new number field. Then sorting by the ProductType isn't necessary you are sorting by Category and ProductTypeNumber.

I believe you have missed the edit to my previous post.

I am not able to reproduce this behavior. Can you provide a step-by-step description of what you are doing? EDIT: I managed to get the error when trying to use the * or # operators (but not the = operator). To get around this, use a numeric expression - e.g. search for > 99 to find entries with 3 or more digits.

There isn't. But it sounds like there is an opportunity to change the design a little. If you find that many fields are repeated across the panels then add them outside the tab panel object so that you don't need to repeat it. Resize the tab panel and use it only for those pieces of information that are different.

Try ScribeDifferenceReport: https://static.360works.com/plugins/Scribe/documentation.html#ScribeDifferenceReport

Does this work the way you expect? A_Better_Example.fmp12

Hi Kent, As long as the session to QB is opened the number of stacks should not have an effect. There is a chance that something within the stack in between could have caused the connection to end early, or interfere with the data. It is great to hear you got it working though! If you wish to investigate it further, then I suggest closely looking at the second call stack to see if you can spot anything that may cause one of these issues. Also, another option is to view the Windows event logs and, if you are lucky, it could show a bit more information about the error. Thanks! PCIPal

Ideally you would click on a button on the message go to a related detail page of the message and have yet another portal to the recipient each person would get their own record - if you intending to send these out then they have an independent timestamp or respond for the target person. You could create some portal or other button bar to add each person to the join table, and a means to remove them from the list (if added in error)

Hi Kent, This error indicates a FileMaker or system error generated by FileMaker. The best recommendation is to review and walk through the scripts to find where the error is occurring. As a general rule of thumb, if the dialog box or error box has a red X icon, (i) symbol, or an <!> icon it is a system generated error. Thanks, PCIPal

And in one of these posts you'll find me saying that if a method is not reliable enough to be used for keys, then it's not good enough to be used for any other purpose.

Keep in mind that Google is going to take away that kind of 'basic authentication' (or less secure as they call it) for the SMPT protocol and other protocols. Consider switching over to their APIs as quickly as you can. Here's a write-up for Office 365, it has links to the Google announcements and some links to other community blog posts that show how to use the Google APIs https://www.soliantconsulting.com/blog/microsoft-graph-api-filemaker-one/

The TextStyleAdd() function does not "transform" the text. It merely adds a style to the existing text. When you copy styled text and paste it into another application, you may get the styled text or the plain text version, depending on the target application. Certainly, only plain text is exported when the target is a plain text file. If you want to really "transform" the text - i.e. modify the actual characters - use the Proper() function instead.

Mod 2, set up as Comment suggests (change calc to Last( Booked::Booked To ) Test-23Mod2.fmp12.zip

Just installed FMS 9, (previously had from FMS 8). I am trying to access FMServer_Sample.fp7 in Safari 3.0.4. via the PHP test from the FileMaker Server 9 Technology Tests. I am getting the following error: Safari can’t open the page. Safari could not open the page “http://192.168.X.X/fmi-test/phptest.php?lang=en&server=.local” because the server stopped responding I am trying to access from a local machine. On the XServe that hosts the FMS 9 databases, Web services show as being enabled. In the FileMaker PHP Site Assistant I also get the error, "Connection failed. Please check server address. I can access FileMaker Server Admin console and it shows FMServer_Sample.fp7 as being enabled for PHP. I think this is actually a web server issue. How can I test the XServe web server? Thanks I am very new to php etc.