Jump to content
Sign in to follow this  
Polyphony

Portal Problems

Recommended Posts

I am doing an inventory of this publishing company. I have One database to list computer ID, serial number, ram, etc, and a portal to a second database that has software title, it's version, and its serial number.

I want to use web companion so that I can go to each computer in the company, and enter all of the data for that machine over the web. The problem is, I go to make a new record, I fill in all the data, but I am only allowed to enter one item of software. When in Filemaker, I can enter as many software titles as I want into the portal, but on the web, it only lets me edit existing entries, not create new ones....

Can anybody help me?? I'd really appreciate it!

Share this post


Link to post
Share on other sites

I'm having similar problems with Portals.

Through Web Companion, I can't enter any data into the portal unless something is already there (the only way to input to begin with is FMP directly).

Have you had any luck finding an answer?

I am using 5.0v1.

Share this post


Link to post
Share on other sites

I use FMP 4 things might be different with FMP 5.

The way that I do it is to locate the master record first, then completely break out into the related database and avoid using portals (I use portals just for listing options, not for adding and editing records -- it people want to edit a record they've got to click on it forst which takes them into the related database.)

The flow is a bit like this: through the web the users search the first database and find the computer, the software will be listed in a portal with links on each line that go to the related record (this works well). To add or edit a software record they have to click on the link which takes them out of the master db and into the related db.

This completely avoids the use of portals and make for a slightly less confusing interface for the user and the developer since work in different databases appears on different pages.

Share this post


Link to post
Share on other sites

Vaughan (or anyone else who can advise me):

I hope you see this post (it's a year later than the last one). I like Vaughan's method of linking from a portal in one format file to another format file to work with related records. It's a good idea which would be much simpler to understand (for maintenance folks later down the line) and/or modify than other methods I've heard of.

After I read his post, I tried to implement something similar. But I can't figure out how to go to the correct related record in the second format file. How do you pass the related record's record ID or other key to the second format file?

Thanks!

Skye

Share this post


Link to post
Share on other sites

The easiest way (& this I learnt recently thanks to Jeff Spall) is to carry the value of the link field forward in the URL.

That is, FMP Field Name in Link file = value of link from current file & -new.

If there are any other values you wish to carry forward, you can either carry them forward as mentioned above (though that can make your URL very long), or set them up as Lookup fields from the main file.

Trust this makes sense.

Rgds, Partha

Share this post


Link to post
Share on other sites

Thanks very much for responding!

I had indeed read the post in which Jeff Spall responded to your questions. In fact, that's how I got the idea to try the code below, set up as a button within a portal, to allow the user to link to the format file which will display and allow editing of the related record.

<A HREF=FMPro?

-db=NRT%20Contacts.fp5&

-format=manager_contacts.htm&

-error=manager_error.htm&

-lay=All%20fields&

-op=eq&

ContactsRecID=[FMP-field: NRT Contacts::ContactsRecID]>

<FONT SIZE="+2" COLOR="#CC0000">

<B><IMG SRC="images/update_this_recd.gif"

ALT="Button: Go to update this record"

WIDTH=165 HEIGHT=21

X-CLARIS-USEIMAGEWIDTH X-CLARIS-USEIMAGEHEIGHT BORDER=0

ALIGN=bottom></B>

</FONT>

(NRT Contacts.fp5 is the related file; the master file and NRT Contacts have a one-to-many relationship. ContactsRecID is NRT Contacts.fp5's unique "key" field.)

When I view my format file's source code via a browser, here's what it looks like:

<CENTER><A HREF=FMPro?

-db=NRT%20Contacts.fp5&

-format=manager_contacts.htm&

-error=manager_error.htm&

-lay=All%20fields&

-op=eq&

ContactsRecID=1043>

<FONT SIZE="+2" COLOR="#CC0000">

<B><IMG SRC="images/update_this_recd.gif" ALT="Button: Go to update this record" WIDTH=165 HEIGHT=21 X-CLARIS-USEIMAGEWIDTH X-CLARIS-USEIMAGEHEIGHT BORDER=0 ALIGN=bottom></B>

</FONT></CENTER>

This looks like exactly what I wanted, but when I try to use it, I get Error 4 (Command is unknown).

I'm obviously doing something wrong. I would certainly appreciate your feedback on this!

I would also love to be able to see sites where things like this are up and working. I learn a lot from examples. Can anyone point me to a site where someone successfully jumps from a format file which looks at a portal to another format file which allows editing of related records?

Thanks!

[ July 19, 2001: Message edited by: Skye Ridley ]

Share this post


Link to post
Share on other sites

Dear Skye,

It's easier to pick up the value from the portal.

Presuming that the portal is called "Link_Contact", and the unique value in the file is "ID_Contact", then the most convenient way to pick the record up is: -

<A HREF=FMPro?

-db=NRT%20Contacts.fp5&

-format=manager_contacts.htm&

-error=manager_error.htm&

-lay=All%20fields&

-op=eq&

ID_Contact=[FMP-field: Link_Contact::ID_Contact]

& -Find>

If you want to find ALL the related records, then just use the common contact value to find data from the related field, which will be easier as then you pick up the value from your main file, and run a search in the field that you are relating it with.

I would also suggest removing the spaces (%20) from the file and field names as this has caused me some wierd problems once in a while - especially with Netscape which is not as forgiving as Internet explorer!

Aslo, does the 'manager_contacts.htm' refer to fields from 'NRT_Contacts' or the master file ?

If you still have a problem, do let me know, and I'll mail you the files that Jeff had so kindly forwarded me for refering to.

Rgds, Partha

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By AlesD
      Hi I can not fiddle out how to make it work. I have tried several browsers with same result. We are using FM 12 server. I tried this file paths
      file:///C:/file.jpg
      C:/file.jpg
      file://localhost/C:/file.jpg
      and few others
       
      I'm using this code in the Web Viewer which is working fine in FM client but not in browser
      "data:text/html, <html> <head> <style type=text/css> " & table::style & " </style> </head> <body> <div class='thumb'> <span class='helper'></span><img class='thumb' src='" & table::ThumbnailPath & "'> </div> </body> </html>"  
      If it's caused by fact image is not present in web site folder as stated in document then my question is if it possible use unc network path in filename like file://///other_than_fmserver/networkpath/file.jpg. I wasn't successful either. 
      Any help appreciated
       
      Thank you
    • By KevinArevalo
      Good morning! I need some help getting something working.
       
      We have a company website, and we are trying to create a instant web publishing portal for our customers to login and view their open invoices. Pretty simple. We have all of our information on a FileMaker solution that is hosted with FileMaker Server 12. The problem is we can't get it to work the way we want it to. 
       
      This is our idea and how we kind of want it to work. We want the have our customers create their accounts/passwords on our actual website. We will store their account information on our web server. We will authenticate their login on our web server. Then, after they log into our website, we want to take their username, bypass the filemaker instant web publishing login page, and then set their username (which they used to log into our website, not filemaker) to a global variable or a field or something, we just need it in filemaker so we can do searches on it. We have the instant web publishing layouts built and we can get all that part working fine, we have the login authentication working on our site, that part is fine. It's just bridging the two together. 
      We are using WordPress to build the website, and our site is hosted on GoDaddy. Our problem is that we can't find a way to auto-login and bypass the login web publishing page. We currently have one account called "WebLogin" which we have been trying to use as a general login (since the actual customer login is authenticated on our website, not FileMaker) but we can't seem to bypass the page. I found this page through google searching: http://lnx.acidsoft.net/problemsolved/bypass-filemaker-iwp-login-via-url.html
      and tried to do it the way that he describes, but it is not working. It gives me an error saying:
      Bad Request
      The server could not process your request due to a missing command: ""
       
      And I get another dialog box that says: 
      Bad Request
      The server could not process your request because your session has timed out, been closed, or communication with the server has been lost.
      Please reselect the database to begin a new session. If you cannot open the database, please contact your database administrator.
       
      That is one of the problems, how can I resolve this?
       
      My other problems is we are trying to pass through the username that the customer uses to login to our website as a variable in filemaker or even set it to a field. I am not sure how to do this. Is this even possible?
      Thank you so much!
    • By djlane
      I have an application that was using IWP under FM Server 12, to allow my friends and friends of friends to upload their golf scores, and my system would calculate their USGA handicaps.
       
      After upgrading to FM Server 13, IWP not longer exists, and WebDirect does not support mobile devices.
       
      So, I set up an alternative server using FM12.
       
      A lot of guys that I don't have contact details for, used that IWP based system to upload golf scores. So I don't have a way to tell them all the new URL.
       
      Using the old IWP URL, you are presented with a screen that says "The requested page is not found. Check the URL you are using to access FileMaker WebDirect."
       
      I want to edit that page to add some additional information telling them the new URL etc. But I can't find any document with that content in any FM Server folder or sub folder. 
       
      Anyone know where I can find it ?
       
      thanks
    • By cchaski
      Hi, I have a databse hosted in IWP that uses Supercontainer for people to upload documents. The process works fine when I use FMPA 12 to access the hosted database, but when I go through the web browser (the IWP approach), the process does not work. A button "Upload Doc" calls a script that goes to the upload layout, generates the SC id code for the record, shows the webviewer with upload and delete buttons. This works fine when I am using FMP to access the database, but this does not work when I use IWP. When I click the button in IWP, nothing happens. Any ideas?? Thanks in advance!
    • By cchaski
      Hi, I have a databse hosted in IWP that uses Supercontainer for people to upload documents. The process works fine when I use FMPA 12 to access the hosted database, but when I go through the web browser (the IWP approach), the process does not work. A button "Upload Doc" calls a script that goes to the upload layout, generates the SC id code for the record, shows the webviewer with upload and delete buttons. This works fine when I am using FMP to access the database, but this does not work when I use IWP. When I click the button in IWP, nothing happens. Any ideas?? Thanks in advance.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.