brownt

Yeah, that was what I was afraid of. I did some digging into Virtual List Reporting (https://www.soliantconsulting.com/blog/using-virtual-list-technique-part-1) that looked promising, but I'm a bit too "intermediate" to go all the way with that yet, and I still run into issues with figuring out how it could possibly get the numbers to all add up... I appreciate your input. Maybe I'll dig into the HTML table in the web viewer and see how it stacks up against Virtual List Reporting... Thanks!

I have a friend for whom I've done a bit of consulting helping him build some project tracking tools in FileMaker. Helped him through the basic stuff around relating tables together, doing a bit of scripting, creating some basic reports based on data he's entered... Well, now he's hooked! And would like to do everything for his business in FileMaker. His current partner does everything in Excel, and has over the years developed a project management spreadsheet he uses to track project funds, activities and generate a financial summary for their clients... Well, now I've been asked to see if it can be redeveloped in FileMaker, because my friend doesn't want multitudes of Excel sheets for every project, that he has to paw through when he wants to pull data for his other tracking tools that are in FileMaker. He'd like to be keeping all the data in one place. His partner's Excel sheet basically tracks the date of an activity, a note about the activity (what business or consultant or company performed the activity), what kind of activity it is (each spreadsheet for each project may have anywhere from 8 to 16 different kinds of activity) and how much money was associated with that activity (credit or expense). Tracking that is not a tough deal in FileMaker, that piece I've already sketched out. Reporting on it is where I'm having problems, because he'd like FileMaker to produce a report that looks as close to what the Excel sheet looks like, including columns for each kind of activity they're tracking, with activity totals, balances, budget remaining, etc... Where I'm really really running aground is the fact that there may be any number of different kinds of activity going from project to project. Some may have 7 different kinds of activity, some may have 15 or 20. I've included a sanitized, example version of one of his Excel files. I can't wrap my head around how best to do up a report that doesn't have a set number of fields (what would correspond to the columns in his Excel). I could do it as a great big flat file database and put in fields for every possible kind of project activity, I guess, but.... argh! I would welcome any thoughts on how a report like the one I've included as an Excel file here could be created in FileMaker... Or if the combined expertise here figures this is something that is best left to Excel (I must admit, my thoughts have drifted that direction as I wrestle with this). Thanks in advance! report.xlsx

I have the same issue in FMSA 12, I cannot launch the Admin console on my Mac OS X.7.4 machine running Java 1.6.0_33-b03-424. The java application downloads but then doesn't ever launch completely. I found THIS article, which says clear the cache, which I have done numerous times and it doesn't help. Arg. I've tried watching my log files, but I can't see where it coughs out on me.... Edit Edit! Well NOW I feel like a total idiot... I had port 16000 open in my firewall, but apparently the admin console depends on Port 16001.... After 20 minutes on the phone with FileMaker Tech Support I now know this.

I'm running Appleshare Fileserver 6 on MacOS X.6.7 (MacMini server). I have Filemaker Server Advanced 11 installed. Instant Web Publishing works fine. XSLT web publishing works fine. I have SSL enabled on the server (ie, all my urls are HTTPS _ :443). I have my server set to "List only the databases each user is authorized to access". I have a valid, institutionally signed security certificate for my server. I have used the built-in Appleshare server version of php, it is PHP Version 5.3.2. I have checked my include path, it is set to .:/usr/lib/php, I have, in that directory, both the Filemaker.php file and the directory Filemaker containing Command Error.php Layout.php RelatedSet.php Command.php Field.php PEAR.php Result.php Error Implementation Record.php conf When I run the PHP Custom Web Publishing Test, I receive the following error: XML error: SYSTEM or PUBLIC, the URI is missing at line 1) I'm stumped.....

Did you ever get this resolved? I am having the same issue.

Thanks, that's exactly what I'm looking for!

I believe I know the answer to this one, but for the benefit of my client, I'll post it anyway.... Uploaded a database to my FMSA 11 test server for him today, and of course, when he went to access it with Filemaker Go, he was able to see all the OTHER files on my test server. "Is there no way to set Filemaker Server up so that Filemaker Go users only see the one file they're supposed to?" Hmmm... I dunno... I only very rudimentarily know how to set it up so that regular Filemaker Network users only see selected files... Thoughts?

That is an amazingly elegant piece of coding! Thanks so much! So elegant, I'm still struggling to understand it! And time pressures have kept me from implementing it yet... I'll get there, tho... You'll probably know when I do, 'cause I'll likely have questions!

The Category value list is taken from the category field in the Items table Attached is a simplified example of how this currently works... test_of_categories.zip So, there are two tables, Items and Collection.... the Items table contains the information about what each item is, including the item and category for the item. There are two table instances of the items table. The first instance, items_category, is related to the Collection table. items_category::category = Collection:Category The second instance, items_items, is related to the Collections table this way items::item = Collection::item and items::category=Collection::category I have 2 value lists defined... The first, Category is from the field items_category:category, and takes all items The second value list is from the field items_category::items and takes ONLY related values from Collection So, what happens is the users create a new record in Collections, click on the Category popup menu, then they choose a Category. Based on their choice of category, when they click on the Items field they ONLY see in the popup menu those items in the Category they selected previously... NOW what I'm being asked to do is to provide the ability to make unavailable an entire category of items... So, for example, I have Dog and Cat and Bird as categories. WITHOUT deleting anything from the Items table, I need to be able to make the Dog category unavailable when you click on Category in Collections.... This is really making my brain hurt.... I SUSPECT I will need to move to 2 related tables, one for items and one for categories, but I STILL can't figure out how to make that work.... (I'm not very good at relationships, ask my ex-wife!)

This is Filemaker 11 on MacOS X.6 My client has a table of items that we are using as a lookup table to populate some value lists The fields in this table are: item_key - primary key for each item, a sequential number item_category - the category of the item, a text field item - the item, a text field How the lookup works is they first choose a category, then they choose the items within that category. The relationships to make that happen look like this: and I have two value lists set up using those two instances of the tables to fill in the popup menus This all works great... Except... Now my client wants to be able to disable entire categories, ie, make them NOT appear in the popup menu... How can I make table data unavailable using a relationship? I've been beating this one up for 2 days now and I just can't figure it out... Thanx