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
Lee Smith    145

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
Lee Smith    145

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
BruceR    152

Did you actually try a different file name?

Share this post


Link to post
Share on other sites
Posted (edited)

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
BruceR    152

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
Fitch    148

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

Share this post


Link to post
Share on other sites

Yes, TempPath, documents, C:, etc... all the same result for v16... fine for v15.

Share this post


Link to post
Share on other sites
Fitch    148

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
Fitch    148

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
Fitch    148

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 Jeff M
      Hello,
      I've done quite a bit with FileMaker in the past, but have never jumped into the XML arena. Now I have a need to do so, and I'm really needing some help with something I'm sure is quite basic...but still foreign to me. I have an external data source which export XML in a very specific format (see attached). I need to import that into FileMaker so I can manipulate the data, do some various lookups, etc. Once I've made my changes in the data, I need to export in the exact format it was when imported so the external data source can properly import.
      Not sure if it makes sense to import into 2 tables (workflows, workflow steps) or just a single table. I'm open either way. Once the data is in FileMaker I can get all my calculations and lookups and scripts going and make the data what I need it to be, but then I'll need to export it.
      Can someone point me in the right direction?
      Thanks so much in advance!
      Jeff
      workflows_export.xml
    • By pomilpetan
      Good morning everyone I created a database runtime solution with FileMaker Pro 15 advanced. The program must export the contents of a form in PDF format. In a solution that runs under FileMaker I could use the command "Save as PDF" but this command does not work in a runtime solution. Could someone tell me how I could make this function? thank you so much.
    • By ggt667
      When exporting XML as fmxmlresult.xml when does FileMaker populate the content of the layout attribute?
      Usually it looks like
      <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/> Yet sometimes it looks like this
      <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="menu" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/> Then again when querying the XML RPC it always look like this
      <datasource database="Menu.fp7" date-format="MM/dd/yyyy" layout="menu" table="Menu" time-format="HH:mm:ss" timestamp-format="MM/dd/yyyy HH:mm:ss" total-count="0" /> Asking the question myself, answering the question myself as well. Checking the following checkbox populates the LAYOUT-attribute of FMPXMLRESULT

    • By fm8443
      I have 4 Tables of Sales Records (1 per Store) for the same 1000 products (each sold in the 4 Stores).   Table1 (T1) has 30,000 records T2 has 50,000 records T3 has 10,000 records T4 has 10,000 records   The fields in the 4 Tables have different names and contain similar “core” content.   Tables are added to each month with additional records (imported into FM 14 Pro Advanced from Excel).   Unfortunately the same Products are named slightly differently in each of the 4 tables.  Each store / table has a (text) Product-ID but (for the same product) it is different per store. I do want to rectify this “naming problem” (perhaps in a Table #5?)  so I can produce a report showing sales for each of the 1000 products across all 4 stores (grouped by date etc.) I’m not sure how to structure/carry-out this in Filemaker most effectively.  Any ideas?   Ultimately, when the data is clean, I want to upload ALL the records (e.g. 100,000 records) in one export into one Excel spreadsheet so I can run a Pivot Table (Cross-Tab) report.   Do I need to combine the 4 Tables into 1 Master Table before doing an Export on the Master Table? If so, how would I do this?   Thanks for any ideas about this?
    • By shevyshevy
      I have come across this technique severally on this forum, but I can't figure out how this really works. Right now I am faced with a situation that requires similar technique and I can't seem to get it work.
      I have Table A and Table B.
      1. I want to script an import Process that will first export all records in Table A into Table B (kinda A Clone Copy of Table A) Thats just my basic objective
      2. Then from there, I would want to be able to do similar Process but this time, I will only update the records in Table B with that of Table A using a match field.
      3. I will also love to perform the process based on a found count. ie after performing a find of specific records
      I think If I can be guided on achieving NO. 1, then I can similarly script the others..
       
×

Important Information

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