Jump to content

"Container fields cannot be exported" for some, but not all records


This topic is 2842 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I'm using Filemaker Pro 11 in Windows 7, trying to automate the exporting of files from container fields.  I've written a script that goes through all the records to export the files in the container fields while skipping empty container fields.  The code works well, except that there are a number of records with container fields where I get the "Container fields cannot be exported." error.  When I try go to these records and try manually exporting the container field contents by right clicking, the "Export Field Contents..." option is grayed out, though I am able to open the document and then manually save it.  There are, however, way too many of these cases for me to practically do this one by one, so I'm hoping if someone has an idea what's going on here and how I might be able to automate the exporting of these fields that are giving me this error.

 

To help me troubleshoot this, I wrote a shorter code that focused on exporting the field contents of just one record.  This helped me figure out which records were giving me this error.  Here's the code:

 

If[not(isEmpty(TABLENAME_::FIELDNAME))]

     Set Variable [$filePath; Value:"filewin:" & Get(DocumentsPath) & TABLENAME_::TABLE_ID_FIELD]

     Export Field Contents [TABLENAME_::FIELDNAME; "$filePath"]

End If

 

I've been searching and trying a bunch of different things, but with no luck.  Any tips and pointers would be greatly appreciated.

 

Thanks!

Link to comment
Share on other sites

In a record where you cannot export the container field, what do you see as the result of GetAsText ( YourContainerFiled )? This may return several lines, so make sure you see them all. Also, how exactly do you "open the document"?

Link to comment
Share on other sites

  • Newbies

Thanks comment.  When I use GetAsText(MyContainerField), I get "?".  How would I make sure that I've seen all the lines?

I "open the document" by right clicking on the icon within the container field and selecting "Open Document".

Thanks!

On 6/15/2016 at 5:38 PM, comment said:

In a record where you cannot export the container field, what do you see as the result of GetAsText ( YourContainerFiled )? This may return several lines, so make sure you see them all. Also, how exactly do you "open the document"?

Link to comment
Share on other sites

2 hours ago, Cyrus said:

When I use GetAsText(MyContainerField), I get "?".  How would I make sure that I've seen all the lines?

if you're doing this in a calculation field, make sure the field is tall enough. Although if the first line is "?", there probably won't be any subsequent lines.

 

2 hours ago, Cyrus said:

I "open the document" by right clicking on the icon within the container field and selecting "Open Document".

And what exactly is the nature of this "document"? Could it be that your solution is really old and contains linked/embedded OLE objects?

 

Edited by comment
Link to comment
Share on other sites

  • Newbies
2 hours ago, comment said:

Could it be that your solution is really old and contains linked/embedded OLE objects?

Yeah, I have documents going back to 2006, I think OLE objects are a possibility.  How would I be sure that what's in the container field is an OLE object?  Thanks for you help!

Also, I just used a custom dialog in a short script to see the output of GetAsText() and the only thing I see is "?".

Link to comment
Share on other sites

37 minutes ago, Cyrus said:

How would I be sure that what's in the container field is an OLE object?

I don't really know. What kind of document opens up, in what application? Excel? Word? Also, can you post a screenshot of the shortcut (right-click) menu?

  • Like 1
Link to comment
Share on other sites

  • Newbies

The kind of document depends on the kind of file.  A  good number of these are PDFs, but some appear to be images.  The images, interestingly, open in Word.

Attached is an example of the right click menu with a PDF (possible) OLE object and the right click menu of an image.

 

PDF.png

Picture.png

Link to comment
Share on other sites

Well, I am reasonably certain that 'Edit Document' would only appear if the field contains an OLE object. And I would guess the same about the PDF - if only because 'Export Field Contents…` is greyed out.

 

Edited by comment
  • Like 1
Link to comment
Share on other sites

  • Newbies

Thanks, yeah, I do think it's an OLE object from everything that I've been reading.  Is manually opening and saving these files one by one the only way to get these OLE objects out, or is there some other way I can get these out quickly?  If not, do you know of a way to at least search for all records with OLE objects?  Any tips on this would be appreciated.  Thanks!

Link to comment
Share on other sites

16 minutes ago, Cyrus said:

Is manually opening and saving these files one by one the only way to get these OLE objects out, or is there some other way I can get these out quickly?

If it's at all possible, it would have to be automated using OS-level scripting, not natively in Filemaker. I am afraid I know practically nothing about doing that in Windows.

 

19 minutes ago, Cyrus said:

do you know of a way to at least search for all records with OLE objects?

Searching for ? in a calculation field defined as GetAsText ( YourContainerField ) should find all of them, I think. But it also may find others, e.g. images pasted directly into the field. Do you get an error when you try Export Field Contents [] in a script? If yes, you could loop through the found set and omit those that do not return an error.

 

Link to comment
Share on other sites

This topic is 2842 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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