ensta

Hi, Am trying to establish if it is possible to output from an FM DB for publishing in InDesign. The process for transferring into InDesign involves converting to a CSV. The DB has pics as refs and text with line breaks. Both of which are causing problems. The line breaks are interpretted as separations and as such they are seen as new fields and the pics aren't displayed, only the filename is recorded in the field. Also one of the text field, that has a large amount of text in it, is just displayed as ######. Any tips on parsing the text so its readable and keeps the line breaks but stays in the same field? Also can pics be embedded and retain their full path details in an Excel save as? Many thanks in advance. N

seems to have fixed itself , after a crash and a reboot

Hi, Having issues getting more than one fields to slide. Have sucessfully got the upper field to behave but no joy with ones below, tried all the slide settings as far as I can see. Any tips?] Cheers, N*

Thanks guys again for the speedy replies, been off track for a while -installing pumps and flushing out water tanks. But hey listen, forget about the web thing, that's a bit of a red herring in this regards. I just want FM to output sections of the DB into preformatted text as below, with the spacing, the bold and the dash (or similar), this then can be opened in Word as is, even if the file format isn't a .doc. Help with this, pointers to resources/vids are gratefully received. Cheers, Niels DESCRIPTION Trained fruit trees. Fan-trained, espaliered, cordon High yield from a small space. Utilises vertical space POSSIBLE PLANTS – (Field data) eg Espalier: comice pears; black mulberries. Fan-trained: almonds, plums, figs. BENEFITS – utilises vertical space, utilises favourable microclimates SUITABLE LOCATIONS – all types of walls, along paths etc

Agree. However the web tool I'm using won't format the text and I want to avoid having to manually enter the data from each field onto the each web page. For that reason I want to output the entries for each product formatted as above in raw text. That said if there's a better intermediate format I'm well up for that. Also outputting to Indesign, or some other pro layout tool would be really good to know about . Thanks again for all the input. The dbase import from excel worked well.

Thanks for prompt reply. Presumably you can only output to Word Mail Merge rather than to a normal Doc. That said, is there an easy way to acheive my aims outputing to PDF? Am happy to copy and paste from PDFs (it's destined for web content). Thanks again, N

Hi, I'd like to setup a very basic database, from an excel spreadsheet, that outputs to ideally a text or Word file (but am happy to cut and paste from a PDF if necessary) with some very basic formatting: fields headings in bold for example. Example of formatted output below: DESCRIPTION Trained fruit trees. Fan-trained, espaliered, cordon High yield from a small space. Utilises vertical space POSSIBLE PLANTS – Espalier: comice pears; black mulberries. Fan-trained: almonds, plums, figs. BENEFITS – utilises vertical space, utilises favourable microclimates SUITABLE LOCATIONS – all types of walls, along paths etc Data currently being aggregated into an excel file, which I've imported into FM. Any help gratefully receveived.