Re: Import text file into a field



Helpful Harry <helpful_harry@xxxxxxxxxxxxxxxx> wrote:

In article <1189552805.367487.78200@xxxxxxxxxxxxxxxxxxxxxxxxxxx>, d-42
<db.porsche@xxxxxxxxx> wrote:

I need to import a text file into a field for further parsing. All to
be done via a script.

I know I can do this with Import Folder, selecting text files, but is
there a way of doing this by just naming the file?

Importing a folder (and arranging things so that there is only one
file in the folder) seems clumsy.

The Import Records script command allows you to specify a filename ...
but it will have to be the same filename every time the script is run
(or at least in my version the filename is "hard coded" and you can't
use a field to hold filenames).

Same in version 9. It lets you specify a list of files, so it will be
able to search for several candidate files, but you can't use a field or
calculation to construct the filename(s).

You can also import all files (either pictures/movies or text) in a
specified folder or from the first folder it can find in a list.

You can also import an XML data source from a specified file, with an
HTTP request, or a calculation which derives a file or HTTP request.

This is for FM8, but if 8.5 / 9.0 can do it better/differently, I am
always looking for more reasons to justify an upgrade.

Personally, the more I hear about the silly non-Committing of records,
the less I want to upgrade from FileMaker 5.5. :o(

That appears to have started with version 8, so d-42 won't be worse off
with version 9 (apart from activation).

--
David Empson
dempson@xxxxxxxxxxxxx
.



Relevant Pages

  • Re: Make folder with accompanying shortcut if possible
    ... (Filename can be a filename, ... Traverse Folder / Execute File ... /P user:perm;spec Replace specified user's access rights. ... Wildcard characters can be used to specify more than one file in a command, ...
    (microsoft.public.scripting.vbscript)
  • Re: User account and Personal folder mismatch script
    ... I believe you want a script that can be run by an administrator that will ... The script above only documents if a home folder has been assigned. ... > End Sub ...
    (microsoft.public.scripting.vbscript)
  • Input on CleanUp script
    ... Since I'm going to be using this script in a production environment, ... If the script is used with a backup folder ... var strTargetFolder, strBackupFolder, args0, args1, args2, noArgs; ...
    (microsoft.public.scripting.wsh)
  • Input on CleanUp script
    ... Since I'm going to be using this script in a production environment, ... If the script is used with a backup folder ... var strTargetFolder, strBackupFolder, args0, args1, args2, noArgs; ...
    (microsoft.public.scripting.jscript)
  • Re: Disappearing Links
    ... I believe someone has a script for rebuilding links but I'm unable to find it at the moment. ... It could be adapted to trawl through the whole mail folder tree - if you really need that, ... -- to any contacts in the address book that match the sender of the messages ... set theSelection to selection ...
    (microsoft.public.mac.office.entourage)