Jump to content




Export .dot from container field to open in word as .doc - Help please

container export field

  • Please log in to reply
5 replies to this topic

#1 OFFLINE   bigwang916  member

bigwang916
  • Members
  • 7 posts
  • FM Client:11 Advance
  • Platform:Windows XP
  • Skill Level:Entry Level
  • Time Online: 4h 16m 55s

Posted 17 February 2012 - 03:50 PM

Hi guys. I want to export a .dot file that's stored in a container and open as .doc. I have a button next to the container that will export the file to the default temp storage location and open the file automatically. The file only opens as .dot. Is there a way to make it open as .doc?

Thank you.

#2 ONLINE   Ocean West  I have an idea!

Ocean West
  • Administrators
  • 2,131 posts
  • LocationSan Diego
  • FM Client:12 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Mac OS X Lion
  • Skill Level:Expert
  • Certification:7, 8, 9, 10
  • Membership:TechNet, FileMaker Business Alliance
  • Time Online: 16d 20h 57m 24s

Posted 17 February 2012 - 04:50 PM

set a variable $filename to "/path/to/file/yourfilename.doc" and use that variable in the export field contents script step.
Stephen Dolenski
FM Forums.com Founder, Administrator

#3 OFFLINE   bigwang916  member

bigwang916
  • Members
  • 7 posts
  • FM Client:11 Advance
  • Platform:Windows XP
  • Skill Level:Entry Level
  • Time Online: 4h 16m 55s

Posted 21 February 2012 - 10:11 AM

I am storing the files directly in the database, it is not a reference link.
Right now I have this script running:

Set Variable [$path; Value:"file:" & Get (TemporaryParth) & GetAsText(ContainerFieldName)
Export Field Contents [ContainerFieldNAme; "$path"; Automatically open]

#4 OFFLINE   Ron Cates  journeyman

Ron Cates
  • Members
  • 432 posts
  • FM Client:11 Advance
  • Time Online: 13d 15h 7m 50s

Posted 21 February 2012 - 10:16 AM

It looks like you are exporting without a file extension.

So perhaps
Set Variable [$path; Value:"file:" & Get (TemporaryParth) & GetAsText(ContainerFieldName) & ".doc"
"I don't think I am a Newbie anymore. But I still feel like one sometimes :)"

Ron Cates

#5 OFFLINE   bigwang916  member

bigwang916
  • Members
  • 7 posts
  • FM Client:11 Advance
  • Platform:Windows XP
  • Skill Level:Entry Level
  • Time Online: 4h 16m 55s

Posted 24 February 2012 - 09:37 AM

Thank you. I believe adding the .doc at the end just adds an extra filename. It isn't actually opening it as a .Doc file. When you go to Save As in the document, you'll see the default name to be Test.dot.dot.

#6 OFFLINE   Ron Cates  journeyman

Ron Cates
  • Members
  • 432 posts
  • FM Client:11 Advance
  • Time Online: 13d 15h 7m 50s

Posted 24 February 2012 - 04:05 PM

OK, here's another shot :)


Set Variable [$path; Value:"file:" & Get (TemporaryParth) & substitute ( GetAsText(ContainerFieldName ) ; ".dot" ; ".doc" )
"I don't think I am a Newbie anymore. But I still feel like one sometimes :)"

Ron Cates


Back to Importing & Exporting


1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users

FMForum Advertisers