Work web won't let me onto your link! But I will grab it from home tonight. Thanks, I will have a look at it.
Meanwhile I think I see where you're coming from. At present my export fields are calculated for each product, so it's something like ProductName, return, (ID tags) ProductDescription, return, (ID Tags) Was price (ID Tags) Now price There is also built in to the calculation a line which says: ' if this is the first found record, put the header field followed by a return at the top' - the header field includes the <ASCII-Mac> line and all the paragraph and character style definition for InDesign. So I think all the returns in that would need to be 'proper' returns, which means each line would have to be a separate field, if I'm understanding you correctly. Then all the export fields would need to be concatenated into one, and for the life of me I can't think how to do that. I'm probably missing something very obvious. I mean I need to put 'export field' from each found record into a single record and export that, along with the various 'header fields'. Of course those would all need to be in a separate table, which is fine. But how to combine them?? (I'm always exporting quite a small subset of the entire database, only the products which occur on a given page of a given catalogue) If the above makes any sense at all, which I doubt, I hope you can point me to the obvious solution! > I suspect the problem you describe is the result of two apparently > conflicting requirements: > > 1. InDesign tagged files require the start tag, eg, <ASCII-MAC> be the > entire first paragraph. > > 2. We want to convert FileMaker's internal representation of the > carriage return into <0x000D>. > > So if we assemble all the export text in a field, then convert FM's > returns to the ID tag, we no longer have the ID start tag on its own > line, and upon import ID doesn't recognise the file as tagged text. > > A workaround is to export 2 records: the first contains ONLY the > InDesign Tagged Text start tag, and the second record contains the > rest of the export text compiled from your database, with returns and > tabs substituted for ID tags. You might choose to create a special > Export table to hold these two records. Doing it this way means the > return that FM inserts between records in the export file is retained, > and hence the ID start tag line is maintained. > > I've uploaded a (very basic) example to my iDisk: > > http://files.me.com/tlm/69p0zx > > -- > Tim Mansour <[email protected]> > Neologica Print & Promotions ABN 63 904 335 408 > Certified FileMaker 10 Developer > > "Opportunity is missed by most people because it is dressed in > overalls and looks like work." -- Thomas Edison > > -------------------------------- > Inbound email scanned by Mimecast. > -------------------------------- > <BR> Emma Glaisher Artworker and Database Development Fourninety Limited <BR> Tel: 0113 238 2447 http://www.fourninety.com/ ----------------------------------------------------------------------------------------------------------------------------------------- Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered address Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ Confidentiality Notice: The information in this document and any attachments are confidential. It is intended only for the use of the named recipient. If you are not the intended recipient please notify us immediately and delete this document. The contents on this document must not be disclosed to any other person nor may any copies be taken. The views of the author may not represent the views of the Company. Security Warning: This e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. All liability for any claims arising as a result of using this medium to transmit information by us or to us is excluded to the extent permitted by law. -----------------------------------------------------------------------------------------------------------------------------------------
