Philip Sommers

We are upgrading from FMS16 to FMS19. We let our license agreement lapse and now are having to buy new Filemaker 19 client licenses "for Teams" (with the server included). We previously had perpetual named-user licenses, but are now considering buying perpetual concurrent licenses (at about half the number of the named-user licenses). We use external authentication (active directory) for our named-user licenses. Please explain any differences, if any, between active directory authentication for named-user and concurrent licenses? How does it work for concurrent licenses? Is the FMS configuration different? Thanks in advance ...

Thanks, Wim. Wasn't aware that FMS16 end of life was coming up so soon. Guess we need to upgrade. Thanks again ...

I currently administer a Filemaker 16 Server and only use Oracle Java for the admin console (web publishing is turned off). We want to get rid of Java rather than start paying for it. Rather than upgrade to FMS18, is it possible to use OpenJDK instead of Java for the FMS16 admin console? If so, is there anyone that can provide some guidance on how to do that?

The Filemaker folks tell me that error 959 is “custom web publishing technology disabled; XML is turned OFF”. After making some changes to the web publishing engine configuration (such as turning XML off, then later turning it back on), the Server Status Information page may list XML as "ON", but does not tell the whole story. You may still have to run the Deployment Assistant (the "Edit Server Deployement" link) to sync up with IIS.

I am hosting a number of databases on FMSA 9. When performing the following query: https://myserver/fmi/xml/fmresultset.xml?-db=myDatabase&-lay=Data%20Entry&-find Firefox renders the following: Internet Explorer renders the following for the same query: The XML page cannot be displayed Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later. The download of the specified resource has failed. Error processing resource 'https://myServer/fmi/xml/fmresultset.dtd'. I can't find anything on [color:red]fmresultset error 959. Has anyone seen this before or can anyone provide any insight? Thanks in advance ...

Thanks to all who responded. Fitch, I think that will work for me. Thanks ...

Not sure if this is the right forum for this, but here goes. I know how to make a record conditionally editable by using Custom Privileges in the Privilege Set dialog, but how can I make only one field conditionally editable? For example, I have a text field (Field A)and a numeric field (Field . I only want to allow editing of Field A when, say, Field B > 10. How can I do this? Thanks in advance ...

Comment and SD: OK, I figured it out. Haven't worked alot with repeating fields until now. Comment, you were right about the 100 set field steps. I also had something broken in one of my relationships that I didn't see until I stepped through the script. Thanks for all of your help ...

SD and Comment: Thanks for the quick replies. It needs to happen to on a single-record basis, but it will happen every time a new record is created. The DBCR Mod field will be editable by a privilege set that is not allowed to edit the DBCR Number data. The DBCR Number is sort of like an "as-designed". The DBCR Mod is like "as-built".

Hello, all: I have a repeating field (DBCR Number) with 100 repetitions. In a second table, I have another repeating field (DBCR Mod), also with 100 repetitions. I want to write a script that copies the data from all of the repetitions in DBCR Number to the corresponding repetitions in DBCR Mod. I have tried using Set Field and specifying "100" for the repetitions of the target field DBCR Mod, but it only changes the value of the first rep. Can someone show me how to do this? Thanks in advance ...

Can anyone think of any conceivable way that a record in a Filemaker 6 database hosted on Server 6 could be edited simultaneously by two users? I have a couple of users that both swear that this has happened, but I think they are mistaken.

Thanks, Mikhail. I'll give it a try.

Steven: Thanks for your reply. I closed the file on the server and then tried what you suggested. When I tried to open the file I got a message to the effect that the file's security settings had been damaged or possibly tampered with, and to contact Filemaker. Once closed on the server, I was unable to get it to open again (on or off line). Fortunately, I had an older copy that was essentially the same as the original that I was able to press into service. The solution seems to be working OK now, but I would still like to know what happened to that other file. Weird ...

I am seeing something in one of my solutions that I have never seen before (see attached graphic of Accounts & Privileges window). In the accounts/privileges setup, one of the accounts appears to have gotten corrupted during creation. No account name or privilege set is listed for the account. It was supposed to be an externally authenticated account, but the account type says "Filemaker" (the account type is the only bit of information listed for the account, and even that's wrong). Filemaker will not let me edit it, delete it, duplicate it, inactivate it or do anything else with it through the Accounts & Privileges window except move it up and down the authentication order. Additionally, Filemaker will not let me create another account with the same name as the intended account name. I tried creating a new external account with another name for all databases in the solution (and changing the authentication order to make the "broken" one last, but the solution still prompts the user for a password, despite being an externally authenticated account. How do I get rid of this account that is hosing the solution?

This should be a simple problem, but I have been scratching my head about it for a good while now. I have a CDML application that collects survey information. There is a link on one of the pages that uses JavaScript to render the results of the survey questions as a simple bar chart. Currently, the link renders the bar chart for ALL records in the database because I'm using "-FindAll": Horizontal Bar Chart I would like the link to render the chart for the current found set, whatever that might be. I have tried replacing "-FindAll" with "-Find" (does the same thing) and "-View" (renders charts with no data). I have also tried using [FMP-CurrentFind], but I am probably not using it properly What is the correct link to make it chart the current found set? Thanks in advance ...

We are trying to create a one-stop, web-based collaboration area for our organization (see post #185069). It will include spreadsheets, Word documents, Filemaker databases, etc. I have been tasked with integrating all of our Filemaker databases into the portal (or die trying). The requirement is a single sign-on to access everything (domain groups), including the FMP databases. I am also in the process of converting our all of our FMP 6 databases to FMP 8.5. I have been told by Management that if I want to "save" Filemaker, make it go through the portal. We are currently developing a Sharepoint portal for the portal application, but Sharepoint doesn't want to work with anything but Microsoft products. There is the additional thorny problem that the Filemaker web publishing engine and Sharepoint services cannot coexist on the same server. The problem seems to be related to ISAPI redirection. We have tried creating two different web sites on the same server, but to no avail. Putting them on different servers defeats our single sign-on requirement. As of yesterday, we are starting to look for something to replace Sharepoint with that will better suit our needs (i.e, work with more than just other Microsoft products). I plan on using IWP or custom web publishing to get the databases into the portal. Management would like the ability to "crawl" the databases with the portal search engine, but this might be a bit too much to ask.

OK, so Sharepoint Services doesn't work with Filemaker Server Advanced. We are starting to look for a replacement for Sharepoint Services that does more than just Microsoft products. Does anyone know of a portal application that DOES work with FSA?

Thanks, Wim and Steven, for your responses. My .Net coworker thinks that the problem is that the isapi filters for the WPE and Sharepoint don't like each other. From our experimentation, he may be right. If anyone has a way to make this work, I'd love to hear it. I might be able to do a work-around if we put the WPE on its own virtual server, but I was hoping to not create a lot of extra work for our sysadmins if I could help it. Thanks again ...

Hi, Wim: Thanks for your response. Ultimately, we are trying to port all of our databases into a Sharepoint portal (not just our databases, but all of our documentation). I am trying to use a Filemaker back end with Sharepoint Services. Management has told me that if I want to "save" Filemaker on this project, make it go through the portal. I am having two big problems: (1) Getting Sharepoint and FMSA to coexist on the same server. When Sharepoint works, the WPE doesn't and when WPE is working, Sharepoint doesn't (port conflicts, from what I've read). (2) Also, it seems that most people want to use FMP as a front end. In this case, I want to use a FMP back end and the web part structure that comes with Sharepoint. The trouble is that Sharepoint only supports a limited number of data types without some manipulation. I am not a .Net programmer, but one of my coworkers is very knowledgeable about .Net. However, I am trying my best not to get into that if I can help it.

I have a project where I am trying to integrate Filemaker and Microsoft Sharepoint Services. Has anyone out there tried to do this (successfully or unsuccessfully)?

Thanks, Lee.

Thanks, guys. I guess linking by inserting constitutes embedding, based on the "?" that is returned. Next question: How do you return the filename of the file "embedded" in the container field?

I've looked at many posts regarding the use of [color:red]GetAsText to return the path of files stored in a container field, but I've yet to see one that explains my problem. We have a database hosted on Server 7 that has Excel spreadsheets inserted as an object from file (link, display as icon) in a container field. The Excel files were initially stored locally but, of course, we want to move them to a server where everyone can access them. I want to use GetAsText to return the file name, then use another calculation to generate the new path to the file on the server. However, when I created a field using GetAsText (mycontainer), Filemaker 8 returns only "?". I have tried moving the file directory where the spreadsheets are located into the Filemaker 7 Server folder and re-inserting a few of the files, but I still get the "?". I even tried creating a new database on my Desktop with only two fields (the container and the GetAsText calculation)and inserting a spreadsheet that is also on the desktop, but it still doesn't work. I am using Windows XP. Does GetAsText work in Windows? What am I doing wrong here?

I have been tasked with converting about 120 FMP 6 databases to FMP 8. In the process, I am converting over from Filemaker authentication to domain authentication for most of the databases (except for full-access accounts). I understand how domain authentication works and already have it operating on a few files on our Filemaker 7 Server Advanced/Windows Server 2003. Currently, I plan on having three privilege set groups to authenticate externally: Read only, Read/Create/Edit, and Read/Create/Edit/Delete. The problem is that I do not want, for example, everyone in the Read/Create/Edit group to be able to edit data in every database, only certain ones. I know this could be remedied by having three groups per database, but the guys who manage the domain accounts don't want to have to contend with three groups per database (and I don't blame them). What is everyone else doing in this situation? Is there a better way doing this (by calculation maybe)?

Ahhhhh. Thanks, FMNewbie. Saved me alot of headaches. Best regards ...