cursulak

I understand the comment about the viable number of columns, however the client wishes to see a training matrix with all workers and all training taken in a table. 100 is likely not going to be that big, but I do have several clients whose numbers get up into the 40's per worker. Thanks for confirming, I didn't think it was possible.

I am fairly certain I can't do what I'd like in a native table view layout but thought I'd ask to clarify. What I am looking for a table view layout which will grow both vertically and horizontally based on data available. I can get the vertical growth no problem, however, horizontal is the trick. Here's the situation: Tables: Company, Employees, Training, Required courses Employees is currently setup as a join table between the other two such that I want it to list all the employees vertically, with the training they have taken. However, the company builds a list of courses that all of it's employees could potentially need to take. This I'd like to the horizontal growing growing list (dynamic columns) to the right of the worker name. If the company only has 10 courses it requires it's employees to take, then only 10 columns would show to the right of the name. If there is 100, then it would expand to show the 100. I've got a logical field showing a check box if the training taken by an employee is both valid and matches the course category entered as required by the company. This of course I can get to work fine, except for the horizontal dynamic part which at this point I can't see to do in list or table view however I thought table might be the best. Am I correct this cannot be done, or can it be, but I'm not approaching the problem correctly with the right table structure or methodology? Thanks in advance for thoughts.

Ok I did get this to work, rather unprofessionally I might add due to my rush and time constraints. However... I found I couldn't use scgetcontainer to create a relative url (after setting base url). Instead just pulled the string as text. Doing this gave me the string which I could then apply some formulas to to remove the filename=" and the trailing ". Given that I was able to complete the cycling script to perform what the SC functions would normally do all contained. Try doing this if you've having troubles with the file name issue in FM 13 and SC.

I installed both the server side and client plugins from the 2.89 download. I have a number of things curious. Supercontainer doesn't seem to play nice with a dual machine install (it's wants the web server on the same machine is the server install package) moving it to the second worker machine seems to cause grief. The SC package also looks for Java 6.x whereas I've got 7.45 installed. This could potentially be a problem, still looking deeper into that one.

I am having this same result (or pretty similar) as we migrate an older server to Mavericks, FM 13 Server install. Machine is an xServer running Mavericks, Filemaker 13.0.1 installed, deployed as a 2 machine install, Supercontainer 2.89 had to be manually installed on the server as the install script would not run in mavericks. I suspect there is a 32 bit issue here. Filenames for me look like "filename=_actualfilename.pdf_ Oddly enough the file sizes match like it is exporting the data, but the file is totally unusable, and unrecognizable. This is important for me to find a fix for this as the system goes live in a couple days and we were supposed to have all the data migrated to the native filemaker container by then.... tick tock ;-) Anybody else... I'm currently looking at issues potentially on the server side. Since it was manually installed... that could be part of my problem.

I can do that. It would probably be easier and faster to do screen sharing right on the server so that you can see source logs and browser response at the same time. Log files I can email you directly now. As for supercontainer yes I will do that, the clients have the latest but the server hasn't been updated in a bit. I am at the office near the server today (19jul11) if today works. I will give you a call. chris

I am having trouble with this plugin as well, however I have no error at all. I can browse the log files, users connected, but the orange file icon returns no open databases at all. WIth no errors, however there are several open (8). All other functions seem to be ok. Here's what I've got: OS X Server Leopard running on Xserve with Xraid attached through fibre. FM server 10.0v2 Updated recently released Java update (so fmadmin runs again - yeah!) adminanywhere version 1.4 licensed version also running supercontainer plugin 2.631 Any thoughts on the setup which might affect this? Apache wise I'm running: apache 2.2.17, php 5.2.5 release 6 Anything else help narrow this down? The log doesn't show anything on the FM server, system server wise not sure which log to look in. Chris

Yeah, that has come up several times, we're laughing over the different possibilities for a sub-clause ;-) I've been fiddling with calc's of different sorts to generate a list of what's in the various tables. and then drop that calc field in a portal to display the listings and make them GRR. I can get a cascading portal to do it for me, but not in a single listing... i was hoping that's all.

I have done that in the past and here's why I'm trying to get away from it. Each section can have a "fairly large" text block with it such that 2 (1) (a) (i) there will be a large block at 2, another subsection 1 and another at claus a...etc. When this is all in one flat table it makes it more difficult to compile reports layered properly with the sections combined and fit it on a 13 page limit output. With this method I could use the body section and have an almost limitless report length. 13 pages sounds like a lot of room until lawyers get involved... and then you find out it's not very much space at all unless you want the font at 6 pt ;-)

Here is something I'm trying to do which I've found out is beyond my ability to figure out today. I am creating a database to hold government acts and regulations for quick lookup. I have attached a copy of the joins. I added the extra ID's being carried through because a duplicate number problem across regs and acts and this solved it and kept them easier to track. However... What I want to do is have only layout with a portal in it that lists the acts and regs by number so that I could just click on it and it would should show below the portal. For example Regs are by type;section;subsection;claus;subclaus. 1 (1) (a) (i) for example of course you can have all sorts of depths depending but the max is the tables I've setout. I'm currently trying to do this for only 4 layers deep (section;subsection;claus;subclaus). I want the portal to show something like this: 1 2 (1) 2 (1) (a) 2 (1) ( (i) 3 (1) 4 (1) (a) (i) 4 (1) (a) (ii) etc. What I'm not clear on here is either how to setup the join table to show the 4 different layers 'individually' like that (I can get 2 to work no problem) or another method of approach. Can any of the great ones tell me how to do this, or at least point me in the right direction? Thanks.

ok thanks for that. Could I have essentially ?style=readonly become ?style=accesscalc where the accesscalc is a calculation looking at my lock field. When the lock field is on and evaluates true, the text readonly becomes the field (probably using case), other is just ""? This way it can be a calc and not have to be part of a script?

I've setup security in my database such that if a lock field is set, several things happen. Script triggers will verify from the field either allowing or disallowing events, and user privileage set is affected by it not allowing certain classes of users to edit or change the record (essentially everyone except admin). However, this doesn't work for supercontainers on that same layout. I have successfully been able to lock the layout and all portals from it... but not supercontainers. Can this be accomplished where if a field evaluates true, supercontainer does not allow changes but will display current content?

I looked at the LockParent example uploaded. Thanks very much for that. Simple, elegant and functional. I think this may be just how I will accomplish this. Pushing all my clients to version 10 so I can use the script trigger as well is acceptable to me (on many different levels). Thanks again, you've all been a big help.

Thanks for that everyone. I understand the layout trigger as you described it. Still a lot of work for all the layouts but of course doable. I'll check out this posted file this morning. Thanks again for everyone's suggestions, it's bumped me along the road to a solution fairly quickly.

I'd have to have a hidden tab on the same layout I think to do that such that when the record is locked it causes the second tab to be the foremost (with the user never realizing the other tab is behind and can't get to it). I'm not sure how to make mulitple layouts work when the locked record would appear in both essentially. In my own real example, I'm talking about 46 layouts and 70 or so relationships...so I'm trying to keep my working model to something I can handle. Great suggestion but I was hoping for something like a formula that could affect the relationship itself possibly through a global field.

I read the post Locking Records Against Changes (Topic#210439) and I think it's great, thanks for offering that it was exactly what I was looking for. And now... I'd like to ask how to take it just a step further. I would like to be able to lockout entry through portals on the locked out record. Here's an example (fictious). I have an event database. Attendees can be added through a portal. At some point in time I will lock the event record preventing further changes. It was also be necessary to prevent further attendees from being added as well. Yet for events not locked, attendees should still be able to be added. I fiddled with the same lock field as mentioned in the other post Click here for post but can't seem to get the same function to work through the relationship. Is this possible to have a conditionally locked out relationship and hence portal?

I just wanted to note for those using this in a mixed environment (XP, VISTA Mac) there has been a new release which for me fixed an issue of a black non-functional screen in XP when the plugin and SC are running server side as well. The help and assistance from 360works was fast and super helpful. If you're considering purchasing this product I am very satisfied with the support I received and fixed my issue for me quickly (which actually resulted in the new release). You get get the latest release on their website. 2.1.4 download

There has been a recent upgrade to 2.1.4. I would give it a try and it addressed a similar issue on the windows side and might not hurt to try it. If that fails, make sure you have the 6_10 release of JVM installed.

As a matter of fact I saw your exact comment like this in another post and checked my version number. Sure enough it was 2.1.1... so I did that late last night. Everything seems to be working ok now as well. Thanks for the feedback.

Ok I think I found the problem... with the server version (FMS9A) you don't need to start the standalone server java for SuperContainer. or at least I think that's what my problem is. I still don't have it working yet though. chris

I'm having difficulty figuring out why the server won't startup on my server. I get the error: Problem starting/stopping: could not start Supercontainer because of an unknown error in Tomcat. My setup is: Leopard Server, running on an intel xserve running Leopard 10.5.5. FMS9A is installed and everything on it is running fine. Im running Tomcat 6, php and a bunch of other things all running fine. Tried the java installer app which says everything went well. Restarted the server, tried to start up SC and that's the error I get. Anyone know why it has a problem with Tomcat?