Re: Text File Output

On Mar 22, 4:43 pm, "Ursus" <ursus.k...@xxxxxxxxxx> wrote:
"JayBee" <Jennifer_Beecr...@xxxxxxxxxxx> schreef in berichtnews:786faa9b-ca7f-4c50-8cfd-134313abb2db@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx





Hi There

I once again call upon you Filemaker experts to help me solve a
problem ;-)

I need to export the fields from one record in my database and upload
the resulting text file to another database.  At the moment the
external database does not want to accept the files. I am currently
working on the formats etc so that there shouldn't be any problems on
that side.  However the database administrator has given me an example
file as below:

ABC.txt
"123";"1";"C01"
"123";"2";"C02"
"123";"2";"D17"

Where 123 Represents a number field automatic serial number.

However in my Filemaker database the serial number field represents
one single job and therefore one record.  When I export the data at
the moment the resulting text file is displayed as below:

ABC.txt
"123";"1";"C01";"123";"2";"C02";"123";"2";"D17"

Do you think that this is why the external database will not acept my
text file.  If so (dare I ask) is there a simple way around it.

:-)

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 ;-/
.

Relevant Pages

  • Re: Layout mode grayed out
    ... FMPRo 10, Mac OS X 10.5.6. ... You can bypass all the automatic login mechanisms by holding down the ... Option key when you open the database. ... with those credentials and won't show the FMP login dialog. ...
    (comp.databases.filemaker)
  • Re: Filemaker or Access?
    ... We are going to develop our own database and are ... and a trial version of FMP 8.5. ... with a SQL Server backend, the free version supports 2GB of data. ... Internet access with Terminal server would simplify things for MSAccess. ...
    (comp.databases.ms-access)
  • Re: Layout mode grayed out
    ... FMPRo 10, Mac OS X 10.5.6. ... You can bypass all the automatic login mechanisms by holding down the ... Option key when you open the database. ... with those credentials and won't show the FMP login dialog. ...
    (comp.databases.filemaker)
  • Sudden Unexplained Proliferation of Records
    ... FMP 8/9/10, database hosted on Windows machine, FMP 9, FM Network ... Shared over wireless network. ... Had two cases of sudden unexplained proliferation of records in two ...
    (comp.databases.filemaker)
  • Going to Specific Record in Preview Mode
    ... This is FMP 7.03 running on FM Server for both PC and Macs. ... I have a database with printable layouts that run one to three pages, ... from the aforementioned confusion. ...
    (comp.databases.filemaker)