|
|
export to text format including field types
I use FilemakerPro 6.0.
I want to export the database to a text format for postprocessing with
perl.
The field-types should be preserved.
Which export formats could be used?
Where do I find Information about the structure of the export formats.
I already tried DIF, MERGE and SYLK.
With MERGE the field-types are not preserved.
The other two seem to include more information, but I was not able to
"decode" it.
Any help would be appreciated.
Thanks in advance.
Martin
--
Epur Si Muove (Gallileo Gallilei)
|
|
0
|
|
|
|
Reply
|
Martin
|
1/22/2005 9:27:03 AM |
|
in article slrncv4737.c5b.news@maki.homeunix.net, Martin Kissner at
news@chaos-net.de wrote on 1/22/05 1:27 AM:
You are going to need to use the Design Functions, or use one of the
Utilities available at fmfiles.com (see url), to your information you want I
think.
http://www.fmfiles.com/dev1.html
HTH
Lee
> I use FilemakerPro 6.0.
> I want to export the database to a text format for postprocessing with
> perl.
> The field-types should be preserved.
>
> Which export formats could be used?
> Where do I find Information about the structure of the export formats.
>
> I already tried DIF, MERGE and SYLK.
> With MERGE the field-types are not preserved.
> The other two seem to include more information, but I was not able to
> "decode" it.
>
> Any help would be appreciated.
> Thanks in advance.
> Martin
|
|
0
|
|
|
|
Reply
|
Lee
|
1/22/2005 5:28:41 PM
|
|
Lee Smith wrote :
> in article slrncv4737.c5b.news@maki.homeunix.net, Martin Kissner at
> news@chaos-net.de wrote on 1/22/05 1:27 AM:
>
> You are going to need to use the Design Functions, or use one of the
> Utilities available at fmfiles.com (see url), to your information you want I
> think.
>
> http://www.fmfiles.com/dev1.html
>
Thank you for that link. I will chech if I can find any suitable
solution there.
What do you mean by th "Design Functions"?
Martin
--
Epur Si Muove (Gallileo Gallilei)
|
|
0
|
|
|
|
Reply
|
Martin
|
1/22/2005 6:32:09 PM
|
|
in article slrncv5718.cvn.news@maki.homeunix.net, Martin Kissner at
news@chaos-net.de wrote on 1/22/05 10:32 AM:
There are Functions that you can use in Define Fields, Calculation. Check
out the pull down list on the right hand side.
I don't have FileMaker installed on this machine, so I'm sorry to be so
brief. Try opening the Online Help and typing Design Function in the Index
window, or check out the Manual for design functions.
BTW, the Utilities use these in some of the reports that the produce.
HTH
Lee
> Lee Smith wrote :
>> in article slrncv4737.c5b.news@maki.homeunix.net, Martin Kissner at
>> news@chaos-net.de wrote on 1/22/05 1:27 AM:
>>
>> You are going to need to use the Design Functions, or use one of the
>> Utilities available at fmfiles.com (see url), to your information you want I
>> think.
>>
>> http://www.fmfiles.com/dev1.html
>>
>
> Thank you for that link. I will chech if I can find any suitable
> solution there.
> What do you mean by th "Design Functions"?
>
> Martin
|
|
0
|
|
|
|
Reply
|
Lee
|
1/22/2005 6:43:04 PM
|
|
Lee Smith wrote :
> in article slrncv5718.cvn.news@maki.homeunix.net, Martin Kissner at
> news@chaos-net.de wrote on 1/22/05 10:32 AM:
>
> There are Functions that you can use in Define Fields, Calculation. Check
> out the pull down list on the right hand side.
>
> I don't have FileMaker installed on this machine, so I'm sorry to be so
> brief. Try opening the Online Help and typing Design Function in the Index
> window, or check out the Manual for design functions.
Thank you for your feedback.
I will check out if I can find anything there.
Martin
--
Epur Si Muove (Gallileo Gallilei)
|
|
0
|
|
|
|
Reply
|
Martin
|
1/23/2005 9:03:04 AM
|
|
|
4 Replies
179 Views
(page loaded in 0.125 seconds)
Similiar Articles: split a multivalue text fields in columns - comp.groupware.lotus ...Hello, in a form I have a 'historical' text field allowing multiple values and using the Newline as separator values. This field is maintained by t... Export field list to a file - comp.databases.filemakerconvert btrieve to csv or other export format - comp.databases ... Export field list to a file ... You could import the date value into a field of type Text ... Column headers for exported data - comp.databases.filemaker ...... export the field names? > >Sam Straight export to text ... have a field called temperature og "number" type ... export the field names? > > Sam Export in MERGE file format. convert btrieve to csv or other export format - comp.databases ...... of the files, as well as the data types in ... convert btrieve to csv or other export format ... Date field convert/export as formatted text - comp.databases ..... in a ... File extension to force Tab-Delimited Text Import? - comp ...I'm importing fixed-field data in to a text field ... will assume Comma Delimited as the file format ... From Excel - Access Create Wrong Data Type ... Import or export text ... Import/export Auto-Enter fields? - comp.databases.filemaker ...My thinking was that I could export the data as FileMaker format, then re-import it to the ... You could import the date value into a field of type Text. ... as is ... Fail to import due to date format - comp.databases.ms-access ...You could import the date value into a field of type Text. This could ... Re: using proc export/dbms=xls and excel lost date format - comp ... Fail to import due to date ... exporting to pdf - only background - comp.graphics.apps.gimp ...If the "Save by file type" option in the ... Problem exporting drawing to wmf format - comp.cad.autocad ... ... up 11x17 PDFs into 2 pages - comp.text.pdf Exporting to ... proc import - how to define char or numeric as char - comp.soft ...... date includes 10022009 (most of them in this format) and ... is there a way where i can change the type of the ... Converting a datetime field to a date without using ... Adding simple database, excel export, and reports with D4 Pro ...There will also be a field for test type, which may ... unit that could manipulate that format, as it is mostly text ... database and I can import and export the format ... Export data to a text file - Access - Office.com... of formats, including ... data without any formatting or layout, the Export Text Wizard starts and prompts you to select the type ... of the multivalued field in the text ... When you export date fields to text, the time format is included ...... behavior that you cannot export only the date information from a Date/Time field to a text ... Type: Select Query Field: Birthday2: Format([Birthday], "mm/dd/yy") 7/14/2012 8:52:23 AM
|
|
|
|
|
|
|
|
|