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.

Importing really large XML file generates unknown error

Featured Replies

When I try to import a rather large XML file I get a rather unhelpful error message (see attachment).

The file in question is about 860MB and contains about 100 000 records in an XML ONIX format. Working with books this is not unusual. The error message in question is very poor though so it's nearly impossible to find what is not working. 

ONIX records grows and this file stopped working after it reached a certain size. I do believe all records are fine and properly formated, but FileMaker doesn't seem capable of handling such a large file. 

To me it almost seems like it runs out of memory? Is there anyway to circumvent this? 

Software: FileMaker 13, OS X 10.10.3, iMac 27" (late 2013), 8GB memory. 

Skärmavbild 2015-04-24 kl. 08.17.57.png

To me it almost seems like it runs out of memory? 

​That's possible. Have you tried cutting the file in half? Or importing into a new file?

Edited by comment

  • 2 weeks later...
  • Author

The file it imports to is pretty much empty. It has a couple os minor translation tables that relates to a few fields, but overall there is very little to no data in the database when the XML file is being imported. It's sort of a stop on the way before the data is imported to the real database.

Can't find that many good tools for splitting XML that can handle files of this size .  Even less that can do it in OS X.  :-(

 

I should say I've trie XSLT, but xsltproc only supports XSLT 1.0 och the remaining tools all crash from the stupid amount of data that is input into them from the files. 

Edited by AndreasG

  • 1 month later...
  • Author

I tried this in FileMaker 14 again and it works. The improved memory handling and 64-bit support seems to have resolved this issue. 

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.