Re: Text File Output

On Mar 21, 7:48 am, JayBee <Jennifer_Beecr...@xxxxxxxxxxx> wrote:
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.

:-)

I would expect to see a carriage return between each record. Without
that, your external database very well might think there's only one
record in the file. What file format are you exporting in?

Kevin
.

Relevant Pages

  • Text File Output
    ... I once again call upon you Filemaker experts to help me solve a ... I need to export the fields from one record in my database and upload ... Do you think that this is why the external database will not acept my ...
    (comp.databases.filemaker)
  • Re: Text File Output
    ... I once again call upon you Filemaker experts to help me solve a ... I need to export the fields from one record in my database and upload ... You don't state from which kind of database (I suppose fmp) TO which other ... the same (textfield into textfield, ...
    (comp.databases.filemaker)
  • Re: Btrieve legacy migration
    ... The first question is to figur eout your file format and database ... and get the white paper on "Finding Your Database Engine Version". ... do a STAT of one of your data files to determine ... or a description of the file format. ...
    (comp.databases.btrieve)
  • Re: Two questions about moving data between a SQL DB and XML
    ... better method of exporting data to a file format for later reimport be? ... Is there a better option than XML? ... dozen tables from one database and importing them into another database ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Stuff
    ... You don't have to have Access installed to use it's file format. ... Set ogAccess = Nothing ... End Function ' OpenDataBase ... of separate machines such that each person is accessing the same database ...
    (microsoft.public.vb.general.discussion)