Sean O'Donoghue

When I want to retain and replicate a set of exported fields, I have always created a new script after doing the export, with the "EXPORT RECORDS" command in the script, and name script accordingly. But for some reason or other, recently my exported files tend to be in the format of the immmediately previous export and not the the fields of the script I thought I had saved Any suggestions thanks

Thanks for that - it worked a threat Regards Sean O'D

Many thanks for that - I was just selected "text" for the data format, without selected the column to apply it to. I am now having another problem - one of the fields imported to Excel, when opened in file saved as a txt file in Excel, is in inverted commas ie "field" - and in the database it is nothing I am aware of which differentiates it from the other fields, which show without these inverted commas - very strangely, there are the odd field which does not have them - 2 out of 60 records I tested.

Sorry, incorrect question. It is not the passwords I require but the Key Number for FMP 5.5. Normally these things are on one of the files. I want to get it so that I can delete my FMP & everything else & reload it - without this key number it will not reload. Thanks in anticipation Sean o'Donoghue London

Greetings Preview is regular size. "Associated software" is the printer drivers Sorry - I misinformed you - all items from this computer are printing very large - not just FMP REgards Sean O'Donoghue London

Greetings Folks Can anyone tell me which file the password for Filemaker Pro 5.5 is stored? I need to reformat my computer & have mislaid this essential ingredient. Regards Sean O'Donoghue London Uk

Dan Yes, I have checked print setup. Have also deleted & reloaded associated software Sean O'D

When I print a record, it prints size 250 fonts, resulting in one record needing about 20 sheets to paper to complete its printing on, rather than the usual A5 size The only place I am getting this is on FMP (5.5) - anything else being printed from the computer works OK And, I have a second computer networked to this host computer - and the records print OK when printing from there. Any suggestions? Thanks in anticipation Sean O'Donoghue

Keith There are no overlaps from or to headers - so it is not that. CaptKurt The problem with this is that only the price is derivative - the monthly total is the sum of prices plus postage - which are in the invoice. Regards Sean O'D London

Greetings Folks Am I printing from Portal - Date & Customer are directly inputted & Grand_Total is a summery of Price fields from a portal plus postage costs. And I have set Records being browsed to be printed Regards Sean O'Donoghue

Greetings Folks On my "Accounts" form I have Date_Paid, Invoice_no, Customer & Total_Paid & Grand_Total fields of which are from my "Invoice" form. When I do a Query of the "Invoice" form for all paid invoices from 1/1/02 to 01/31/02 it finds all the invoices paid in that period & then when I open Accounts form in "View as List" mode, all the details are there, including Total. The problem is that when I go to print them out, I get either just the 1st record or sometimes all the "Total-Paid" fields & the Grand_Total. Any ideas as to why this happens? Thanks in anticipation Sean O'Donoghue

The Bridge Got it thanks Many thanks for your time & expertise - I appreciate it Sean O'Donoghue London

Thanks both for your responses Sharka - I have the field automaticall capitalised The Bridges - sounds simple but afraid I do not get it - I am very much a beginner at Filemaker. The field I want to create as capitals for exporting is an "Author" field - as it is at the moment, everything, including first letter are exporting as small letters - are you suggesting I create a script to do what you say or just a calculated field - which I tried unsuccessfully to do. Thanks for your help Sean O'Donoghue

Greetings Folks When I export a field which is all capitalized, the letters change to small ones in the export file - any solutions please - I want to retain the capital letters in the outcome. Regards & thanks Sean o'Donoghue

Got it & many thanks to all for your help Much appreciated from a demented Irishman in London REgards Sean O'Donoghue

Greetings Again Yes, Field_export is the field I am exporting - I have now discovered where the "Do not store calculation results" tick box is & have ticked it. Now I am getting mostly "1" & "O" in my exported txt file, with a couple of total blanks - Shouldn't the calculated field, Number_Export, contain the calculated result - as no doubt you will have deduced by now, mine only contains 1s & Os Also, you say "unstored calculated TEXT field" - I am unable to create a text field when I opt for the calculation field - >>Number_Export is the field you want to export, not book_id. << Regards Sean O'D

Sorry - I had created the Number_EXport field as a Number Field - have now changed it to a text field. "Number_Export" field is the calculated text field below, with "book_id" being the field whose properties I wish to export, retaining leading zero book_id=Right("00000" & NumToText(book_id), 5) I am using FMP 5.5 - you tell me to define an "unstored calculated text field" - the program Help & the book I am using (FMP Companion 5) both suggest that I should have a tick box by a "Do not store calculation results - calculate only when needed" command - I do not appear to have this, certainly on this tab - on the Storage tab for the Options for Field "Number_Export" box, I only have a) Repeating field with a maximum... Indexing On & Off tick boxes & c) Automatically turn indexing on if needed d) default language for indexing etc And this is the result of my export of the Number_Export field - with lots of expty "" "" "" "" "" "" "" "" "" "0" Yours mystified Sean O'D

Greetings Sorry I was not too clear. What I did was create some new records, starting from 00001 - the other records in my database are in the 28000s - the new records exported fine but the ones which were in the database previously did not export so I got the following - which is but a sample. "" "" "" "" "" "" "" "" "" "" "00001" "00002" "00003" "00004" "00005" Regards Sean O'D

Greetings Sorry I was not too clear. What I did was create some new records, starting from 00001 - the other records in my database are in the 28000s - the new records exported fine but the ones which were in the database previously did not export so I got the following - which is but a sample. "" "" "" "" "" "" "" "" "" "" "00001" "00002" "00003" "00004" "00005" Regards Sean O'D

Thanks for your help - however it does not work as I want it to do - it works fine on records created but leaves the existing numbers unexported Any more suggestions? Thanks S O'D

When I export a number field to a comma-delimited text file, the exported file looses its leading zeros Ie 00312 exports as 312. I need to retain all five digits - how can I do this Thanks in anticipation. Sean O'Donoghue

When I create a export file from a calculated calculated field, which is really a number of fields concatenated, the price field amongst them shows up without the two decimal points, which the source field is formatted to deliver - where there is 50p, it shows up as .5 Thanks in anticipation Sean O'D

Greetings When I do an export, eg 10 comma-delimited fields, HOW do I save this export so that I do not have to select each field seperately the next time I want to do the same export Regards & thanks in anticipation Sean O'D

Thanks Korky Have followed your instructions - have managed to move from inventory to invoice but for some reason I cannot get it to do the reverse with exactly the same appropriate scripts. Regards from London Sean O'Donoghue

Problem - trying to create a SCript which will automate opening up a file - however, when I put the Go To Layout command in box & then go to Specify drop-down box, the file I am looking for is not there - both files are in the same folder & relationship has been created between them. Thanks in acticipation Sean O'D