dbTalk Databases Forums  

Getting text from external file into FM7 field

comp.databases.filemaker comp.databases.filemaker


Discuss Getting text from external file into FM7 field in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sam McSpadden
 
Posts: n/a

Default Getting text from external file into FM7 field - 09-12-2005 , 11:05 PM






I need to create a Filemaker script that will open an external text file
(possibly using the Send Event script step to open the file in Notepad or
Wordpad). Once the file is open, I need to copy its entire contents to the
Windows clipboard (using the script -- not the Windows copy command), and
then paste the contents into a FileMaker text field. Is there a simple way
to do this without writing an ActiveX control, vbscript, etc.? I know there
are plugins available to do this, but I would prefer not to go that route.
Any ideas?



Reply With Quote
  #2  
Old   
Matt Wills
 
Posts: n/a

Default Re: Getting text from external file into FM7 field - 09-13-2005 , 04:16 AM






Sam McSpadden wrote on (9/13/2005):

Quote:
I need to create a Filemaker script that will open an external text file (possibly using the Send Event script step to open the file in Notepad or Wordpad). Once the file is open, I need to copy its entire contents to the Windows clipboard (using the script -- not the Windows copy command), and then paste the contents into a FileMaker text field. Is there a simple way to do this without writing an ActiveX control, vbscript, etc.? I know there are plugins available to do this, but I would prefer not to go that route. Any ideas?
Those are your choices.

FM will import, but not all in one clean shot: every tab will delimit to a field, every return a new record.

I suppose if you had a utility table with enough fields, you could use a calc to concatenate the fields into one, then loop through the records, concatenating everything into your single destination field.

Matt


Reply With Quote
  #3  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: Getting text from external file into FM7 field - 09-13-2005 , 09:36 AM



Go to File > Import Records > Folder > Text Files. This will import all
text files from a particular folder. Only import the 'content' into a
text field and you will have a separate record for each text file.

Sam McSpadden wrote:
Quote:
I need to create a Filemaker script that will open an external text file
(possibly using the Send Event script step to open the file in Notepad or
Wordpad). Once the file is open, I need to copy its entire contents to the
Windows clipboard (using the script -- not the Windows copy command), and
then paste the contents into a FileMaker text field. Is there a simple way
to do this without writing an ActiveX control, vbscript, etc.? I know there
are plugins available to do this, but I would prefer not to go that route.
Any ideas?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance


Reply With Quote
  #4  
Old   
Sam McSpadden
 
Posts: n/a

Default Re: Getting text from external file into FM7 field - 09-13-2005 , 05:24 PM



Howard,

Thank you! Your suggestion does exactly what I needed. Unfortunately, this
feature is not well documented in FileMaker.... I had spent hours reading
the help files and trying everything I could think of with no luck. I would
never have thought to look at the "Folder" option.

Sam McSpadden

"Howard Schlossberg" <howard (AT) antispahm (DOT) fmprosolutions.com> wrote

Quote:
Go to File > Import Records > Folder > Text Files. This will import all
text files from a particular folder. Only import the 'content' into a
text field and you will have a separate record for each text file.

Sam McSpadden wrote:
I need to create a Filemaker script that will open an external text file
(possibly using the Send Event script step to open the file in Notepad or
Wordpad). Once the file is open, I need to copy its entire contents to
the Windows clipboard (using the script -- not the Windows copy command),
and then paste the contents into a FileMaker text field. Is there a
simple way to do this without writing an ActiveX control, vbscript, etc.?
I know there are plugins available to do this, but I would prefer not to
go that route. Any ideas?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.