Skip 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.

Import Records Script Step

Featured Replies

I have a solution developed in FM4.0 on a MAC. There is no indication of a problem on the MAC side.

In Win98, under FM4.0, the 'Import Records' script step fails and damages the file (I get the Windows message 'If this problem persists, contact the vendor'). 'Recover' does not fix the problem. I suspect there is some other damage to the file.

The import records script step is used to update one version of the solution to another. It is a technique I have used successfully for some 30 previous version updates of this solution and it has allowed me to 'skip' versions when updating a data base. The import records specs are set up to import all fields from a backup of the current version. For this reason, when importing from an earlier version, some of the fields the import records step looks for may not exist. This has worked well up to now. There are 24 files in the solution and this is happening to 2 of them.

Does anybody know of anyone who looks at and attempts to repair such file problems? The problem is reproducible and I have tracked it to the specific script statement that fails. It would be a nightmare to rebuild the files from scratch.

TIA

Do you still get the damage file if you do the import manually on these two files? Does the data set have any effect?

I am wondering if just rewriting these scripts is the solution, or if there is some corrupt data.

This is a very difficult type of problem to diagnose on a web board!

Jerry

  • Author

Thanks for the response, Jerry.

When I do the import manually, everything looks ok. But the manual import isn't exactly the same request. In the script, I select the 'restore', 'no dialog' and 'file' options for the 'import data' script step. If the file has fields a, b, and c, the 'restore' is set up to look for a, b, and c in the data being imported. If a, b, and c are there, everything's OK. But if importing from an earlier version of the file, there may only be fields a and b. That's when the problem occurs (illegal operation/invalid page fault). When that occurs, the file becomes 'damaged'. Does anybody know how to read/debug with the 'details' of the Windows error message?

I tried clearing the script and reentering the script steps (haven't deleted and recreated the script - will try that) to no avail. Same problem. Because I can import manually, I don't think the data is corrupt - but something is!! I've been using this technique for over a year and this is the first time it's bit me.

Any other insight will be greatly appreciated.

TIA again

Check with Filemaker, Inc on this one. However I am afraid that you may be stuck with creating multiple scripts to deal with the missing field conditions. I am going to guess that Filemaker, Inc will not really support that kind of importing, even if it did work in the past.

  • Author

Hi Kurt.

Thanks for the response. I've gone the multiple script route as of now to get around the problem. I'll try to contact Filemaker, Inc.

Tom

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.