Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Upgrading from FM4.1 to FM5.5 Unlimited (PC)

Featured Replies

Help me! :-)

I've just in the process of upgrading our company's web-based FMPro dbase. It used to run on FM4.1.

When upgraded the database takes many times *longer* to log a user on (the html pages use portal and other commands to fetch the list of users from the dbase), but once in the dbase searches etc are *many* times faster.

Is there a secret setting that I'm missing to speed up the log-on? The html is copied below.

I'd really really appreciate your help.

Thanks

-Andrew

<body>

<h2>Database ([fmp-currenttoken]): Login</h2>

<center>

Please select user i.d., enter password, and press "Login":

<form action="fmpro" method="post">

<input type="hidden" name="-db" value="[fmp-currentdatabase: raw]">

<input type="hidden" name="-lay" value="check_login">

<input type="hidden" name="-recid" value="[fmp-currentrecid]">

<input type="hidden" name="-edit">

<table>

<tr>

<td align=right>

User :

<td colspan=2>

<select name="_user">

[fmp-if: currentcookie:cdb_user .eq.]

<option value="" selected>- select your id -

[fmp-else]

<option value="[fmp-cookie:cdb_user]" selected>[fmp-cookie:cdb_user]

[/fmp-if]

[fmp-portal: show_users]

<option value="[fmp-field: show_users::user]">[fmp-field: show_users::user]

[/fmp-portal]

</select>

<tr>

<td align=right>

Password :

<td colspan=2>

<input type=password name="_passwd">

</table>

<input type="hidden" name="_ip_addr" value="[fmp-clientip]">

<input type="hidden" name="client_state: laugh.gif" border="0 b_name"

value="[fmp-currenttoken]">

<input type="hidden" name="-script" value="check_login">

<input type="hidden" name="-target" value="_top">

<input type="hidden" name="-format" value="add_menu.cdml">

<input type="submit" value="Login !">

</form>

</body>

I don't know about your speed question, but there will be a problem if there is a near-simultaneous call on your script.

I had exactly the same problem earlier this year. It turned-out to be some sort of coruption with the file. I rebuilt the file in 5.5 and all was fine.

Hope this helps.

Garry

Just incidentally, if your solution is being hosted on a shared FM Server, another solution's script can interfere with yours on a near-simultaneous request.

  • Author

Hi

Tried recovering the files in FM4.1 and FM5.5, ie before and after the conversion without any luck.

Anyone got any other ideas?

Thanks again.

-Andrew

Are the slowdowns only occuring if users are using Netscape 6.x browsers? We are having a problem with this on a Win2k server!

All the best.

Garry

Scripts on web and cookies are the most unreliable things in FileMaker. Maybe you are starting to discover the problems...

  • Author

Hi

Thanks for these thoughts.

No - everyone here uses Explorer (we standardised a while back) - and it's giving the problems.

Any thoughts?

-Andrew

  • Author

Hi

On further investigation, anything that goes thru' the webcompanion in FM5.5 Unlimited seems much slower than FM4.1's webcompanion.

Any thoughts?

Thanks

_Andrew

  • Author

I'm slowly getting there. It's something to do with the file relationships getting screwed up, but I've tried every recommended way to fix them including re-doing them all and no good.

Help!

Thanks

-Andrew

  • 4 weeks later...
  • Author

Hi

Now that everyone's back from Christmas and New Years - does anyone have any more thoughts on this please?

Any clues would be very helpful at this point.

Thanks

-Andrew

How is it with FMU v. 5?

Can you try that? That is 5-7 times faster than v. 4.

Did you try pages without scripts? Without cookies?

  • Author

Am working through it trying to find more clues.

It seems to be something to do with valuelists - the longer the lists, the longer they take to come thru' the webcompanion (ie much faster in 4.1 and slow in 5.5).

The code is:

[fmp-valuelist: itema, list=levels]

<option value="==[fmp-valuelistitem]">[fmp-valuelistitem]

[/fmp-valuelist]

Any thoughts would be appreciated.

Thanks

_Andrew

[ January 30, 2002: Message edited by: AndrewB ]

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.