Re: Text File Output

Jenny,

it would be very simple to NOT export the data
and then import it. BUT connect the two files, or perform an import
directly
from one file to an other. Any in-between data management (like search and
replace) will make the output liable to unwanted changes. IF you have a
fmp
table you can import from any other fmp table as long as the data-types
are
the same (textfield into textfield, etc)

Keep well, Ursus- Hide quoted text -

- Show quoted text -

Hi Ursus

You don't state from which kind of database (I suppose fmp) TO which other
database (I also suppose fmP)

Yes I will be wanting to export my fields from one FMP table to
another.

IF you have a fmp
table you can import from any other fmp table as long as the data-types
are
the same (textfield into textfield, etc)

I will make the data types the same. Will I acheive the export/import
in the same way; create a script with an 'export records' step,
specify the file type and then the export order? If so then I guess
there is a .fp7 extension available in the list of file extensions - I
don't have Filemaker in fornt of me ;-/

Hi Jenny,

With two fmp files in place you don't need to export. In fact the source
file doe not have to be open at the time of import, but often will be open.
Because you probably want to import only a portion of the file.
The way to set this up:
find the records you want to export
switch to the file you want to import them
create a script that imports the records.
Make sure you connect all the fields (by field name) properly. After that
you can do this without user intervention. It is easiest if fields in both
sourcfe and target file have the same names. Filemaker can then auto-connect
them.

first script (source file) only has one script step : find records
second script (target file) only has one script step: import records

BUT if you are going to this often you might want to think WHY you are doing
the import of data you already have. Unless you are going to give away each
target file setting up a relationship would normally the way to go.

As a rule of thumb you can say, if you are doing an action over and over
again (like duplicating records or fields) there probably will be a quicker
and better way to achieve the same result.

Keep well, Ursus


.

Relevant Pages

  • The nightmare begins...
    ... the data arrives back on the server, there is a script on the server ... I last really used FMP back when it was version 3 or 4 and have always ... TIA for any advice or suggestions you might have. ...
    (comp.databases.filemaker)
  • Re: Why does database not open to the last record visited
    ... Marc-Andre it sounds like yours is doing the same thing as mine. ... I'm not opening the file from a machine that is not the file's host, ... install FMP; or, is this really something innate with FMP8. ... rather than having to have a script and relationship in every database ...
    (comp.databases.filemaker)
  • Re: Live byte count possible whilst *in* a field?
    ... Is it possible in FMP 6 and/or 9 to have a live byte counter? ... end loop ... I had to tinker with the script a bit and got it ... possible after the loop has been left) and needs to edit the message and to ...
    (comp.databases.filemaker)
  • Re: ? instant ? incremental ? interactive search
    ... Once the desired word or portion thereof is typed, script it so that clicking a button or pressing the enter key will run a script to find the results based on what has been typed. ... The related table would have to be reconstructed for each new word by adding a table row for just first letter, the first two letters, three letters, ... ... Can FMP be told to perform the search after each keystroke? ... Member, FileMaker Business Alliance ...
    (comp.databases.filemaker)
  • Re: little Ajax problem
    ... it was really not necessary to post the whole script here. ... When you attempt to use the object as a string, the "toString" method is called. ... Since it has not been overriden in the Node class, ... The value property is (in this case, and only because "time" is a textfield) a string containing the content of the textfield. ...
    (microsoft.public.dotnet.framework.aspnet)