This topic is 2609 days old. Please don't post here. Open a new topic instead.
By Andreas T.
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?
By Stephen Murphy
I have an excel spreadsheet with contact names, company names , email, phone etc.
I imported the company details email & phone to the Accounts module and I imported the contact names & associated account name to the Contacts module
How do I "relookup" the account names so that the contact is assigned to the Account in the accounts module?
I am experiencing a peculiar behaviour, which is creating a user case problem, in a solution that is utilizing the Data Separation Model and WebDirect. I need to know if this behavior is normal, a bug, or if my implementation is incorrect.
I've got an interface file and a data file. Each file has two Privilege Sets defined (in addition to [Full Access]); call them Floor and Manager. Floor has very restricted access, and Manager has more liberal access (but no where near Full Access).
Scenario 1) I've made a script in the interface file which performs a re-login. A user logs in as Floor privileges via WEBDIRECT. User then performs the script and enters credentials for Manager. The interface file successfully performs the re-login and gains the privileges associated with Manager. However, the data file does NOT change, it does not re-login, and it still exhibits the behaviour of the Floor privileges. I know this is an incorrect implementation. Which brings me to:
Scenario 2) I've made a script in the interface file which collects the account name and password from the user (show custom dialogue), stores them in temporary global fields and as local variables, clears the temporary global fields (keeps the variables), then performs the re-login using those variables (which works). The interface file gains the new privileges as expected. Then, that same interface script calls a re-login script in the data file, passes those login credentials to it, and then performs a re-login there in the data file as well. This works perfectly in FileMaker Pro Advanced, but it does not work in WebDirect. WebDirect still exhibits the same behaviors as described in Scenario 1: interface file does gain the new privileges, but the data file remains unchanged, retaining the original login's privilege set.
Thus, how can I make WebDirect act like FileMaker Pro in regards to getting both parts of data separation model to perform a re-login?
I am currently working on a database that will score our company's suppliers.
I have one table that contains all contact information for the suppliers (Suppliers), and another related table that contains the actual score entries (Scorecards). Suppliers are scored on pieces shipped on time and quality reports. We only ever send a scorecard to suppliers based on information from the current year, so I have a field in the Scorecards table for year. The layout I am working with is based on the Suppliers table, with a portal displaying the related entries from Scorecards in the specified year.
Now, where I'm running into trouble is my attempt to retrieve a total for Shipped pieces for a specific Supplier in a Specific year. In other words, how do I get FMP to take many related records, and sum only related records based on data in a third field?
HELP! I am trying to get my FM layout to have a self aware object. The object is named appropriately and the object (For example, a portal) would then use the name to filter with some form of get(name) method. Can this be done?
In theory i want singular row portals with the name "Portal 1" to be copy an pasted. When pasting FM will automatically name this "Portal 2" (3,4,5,6 and so on). The filter will then use a "RightValue(Get(Name))" to filter down on this number.
CAN THIS BE DONE? I am racking my brains trying to figure a way of doing this and making this layout dynamic >_<
Who Viewed the Topic