Jump to content
Kevin Groder

Un able to Export Reocrds as fmp12

Recommended Posts

Hi,

Has anyone else found that you are unable to export .fmp12 records from FM 16? I use this step in many scripts and the first machine I upgraded ( out of 48 ) I get the "unable to save file" error every time. FM 15 works, FM 16 fails on the same DB, same table, same record set. I can't even export manually.

I made a screen movie here: https://www.youtube.com/watch?v=iOGcm4bt86o

 

Share this post


Link to post
Share on other sites

Change the file options, but remember any of v16 "New to this release" will not work.

File >> File Options >> Open 

 

1 hour ago, Kevin Groder said:

export .fmp12

BTW, all files made in v12 through v16 have the file extension of .fmp12

Share this post


Link to post
Share on other sites

Hi Lee, I'm not sure what you mean. Change the file options for Minimum Version Allowed? ... and yes, I understand that .fmp12 has been standard for a while, thanks.

Share this post


Link to post
Share on other sites

Click this dropdown option and change it to your other version.

https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help%2Ffile-options.html

FileOptions.png

 

As I stated above, if you use one of the Features introduced in FileMaker 16 it will NOT be available in say version 15 (14, 13, 12).

 

Share this post


Link to post
Share on other sites

Thank you, I appreciate your help, but I'm don't think you understand my problem. I am unable to Export Records from v16 even though this works from v15. Opening or importing files is not an issue.

Share this post


Link to post
Share on other sites

Did you actually try a different file name?

Share this post


Link to post
Share on other sites

Yes, I've tried several Dbs and several machines (PC... Mac is fine) and various file names for the export.

Edited by Kevin Groder

Share this post


Link to post
Share on other sites

Your example does not show that; and it is hard to tell whether you are using an extension in the file name.

Share this post


Link to post
Share on other sites

Yes, I tried using no extension and letting FM add it and I tried adding the .fmp12 extension. I didn't bother to record all that. I've also checked disk and user permissions. I am convinced it is something in the new v16 because, as the video shows, v15 works just fine. FM Tech hasn't been much help.

Share this post


Link to post
Share on other sites

Just some further clarification per Lee's suggestion:

I upgraded to FMS 16. This was smooth fast and simple, though I am struggling a bit with installing a wildcard SSL Cert, but that' another story for another day.
Most of my network is running PCs and all of those are Win 7. I have a handful of Mac clients but they all work fine with this exporting issue... it's only the Win 7 machines having this issue.

My personal workstation used for development and such is a late generation Macbook Pro running Sierra and Parallels Desktop for Windows development/testing.

Thank you all for you help.

Share this post


Link to post
Share on other sites

Have you tried exporting to a different location? Desktop might have a security issue.

Share this post


Link to post
Share on other sites

What if you quit FileMaker 15?

Do you have any plugins installed?

Share this post


Link to post
Share on other sites

Quitting FM 15 has no affect. I use TroiFile and is updated to the most recent version. Haven't tried removing it but I guess i could.

Share this post


Link to post
Share on other sites

Yes it's best to eliminate as many variables as possible. Have you tried exporting from a local (non-hosted) file?

Share this post


Link to post
Share on other sites

Yes, same problem with local files. I'll try removing plugins and see if that makes a difference.

Share this post


Link to post
Share on other sites

Problem solved... it was unknowingly self inflicted.

I use Assisted Install and had set NONEWDATABASES=1, thinking this was only related to File>New Solution... it didn’t occur to me that this extended to Export records, which, of course, it does, since export creates a new fmp12 file.
 
I’ve adjust the assisted install parameters and reinstalled… all is well.
 
Thanks for your help. Maybe my error will help someone else who has made the same assumption.

Share this post


Link to post
Share on other sites

Thanks for reporting back -- that's an obscure one for sure! Good job.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Anuj Kumar
      HI,
      In My DB- Table ( Product) have a Container field. 
      i want Export Container Field. & save in The create folder. 
      i have write these script:- 

       

       
      In this script Folder Create successfully. & also Image Export Sucessfully On Desktop. 
      But I want export Image in The newly created folder. .
      can any one help me  to release this.
      thanks in advance
      Austi
    • By brokenmouse
      I have a database that we use to update our website inventory. A few years ago we began offering customized merchandise that gets dropshipped direct from suppliers.  Suppliers give us data feed files with their inventory levels, pricing, etc. and this file manipulates the data. It takes our current web database, compares values and exports those products with their updated values.
      Importing the data and exporting used to take less than hour but now it takes several since the size of the web database has grown and the number of suppliers has grown.  Everything is automated through scripts. In the main table (web database), the proposed quantities, pricing, leadtime, variations, etc. all use unstored calculated fields to determine the new value. I then have a separate field which is used to flag items that need updating. The major bottleneck of the entire process is the searching of this field. It can take sometimes over an hour to search this field. Other steps like exporting the changes can take a while, too.
      I have done some things to optimize the database but it still seems that these unstored calc fields are what is dragging everything down. I have tried replacing some of those calc fields with text/num fields with "replace field contents" script steps (or auto entry) but it does not seem to make a difference because of the indexing.  The database is not hosted or shared and my computer has decent specs with an SSD HD. I've got a simplified design chart attached for reference.
      I am not sure that this is what comes with a large complex database file or if my design is flawed. The only two things I can think to try to reduce the processing time is:
      1) Rewrite the scripts to update the supplier/inventory table records instead of replacing the records fresh each time.
      2) Use a looped set field script to set the "change flag" field and/or the other updated price/qty/etc fields
       
      Any thoughts or advice is much appreciated.

    • By dkey
      I'm surte this is quite a simple task ... for someone expert
      I see I can export Record content using a Variable as the new filename for the exported file.
      I have more than 1200 records in my db and I hope to export 3 fields using one [fieldname: Title] as a filename.
      The path for my db is as follows
      file:/Macintosh HD/Users/Claudio/Documents/Synch Test Copy Copy.fmp12
      Thanks a lot
    • By Toni
      Hello forumers
      I have a small issue with an export on a network path. Generally the path is alive, but very rarely it can happen that is not reachable. When not reachable, you'll get the error message from FileMaker that file can not be created .... (error code = 800). Since this dialog box can not be suppressed by Error Capture =On, the script will stop there until someone goes and clicks on the OK button of the message.
      Was wondering, is there a way to check if the path is reachable, and if it is not reachable then to exit script?
      Thank you, Toni
    • By transpower
      Suppose I have a column of numbers in a text field and I wish to export that field.  What happens is that only the last number of the column gets exported.  If, on the other hand, I separate each number by a comma, one after the other (not in a column), the export function works:  all numbers are exported.  The problem is that some other applications cannot easily read a comma-delimited text file--they prefer to read a column of numbers.  So:  is there any way to export a column of numbers (contained within one text field) to the disk?
×

Important Information

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