1 person found this helpful
Have a look on Text export as InDesign Tagged Text txt:
- Create a simple file formatted with the text styles you want to format it at the end. Keep that document.
- Export this text with placeholder text as InDesign Tagged Text .TXT. Each format has to appear at least once. (Not needed for nested styles.)
- Open the text now in a text editor.
- Read out the tags of the text, not of the defiition.
- Build up the export of your data base to add these tags you have learned in step 4 upon export from the DB.
- This export needs not to have the style definition, because it is still alive in your InDesign document. Only the tags have to include the text.
- Import the text in the previous created INDD file. Because of the tags every paragraph gets its styling according to the paragraph styles of that document.
Thanks for your reply!
Does this mean I will have to paste the tags on each line in the source textfile? I dont have control over the database, thats the problem. My client is just sending this huge chunk of #-separated text.
And, how do I automate the placement of the tabs?
Normally you can export data from a data base and transform it, like adding or trunceting text elements, formatting numbers, time and day and such things are best done upon file export from FileMaker or Access or whatever you use.
Another possibility is exporting from a DB as XML. For InDesign you will need to transform that information with a XLST rule and you can import that transformed XML file into InDesign and tag XML tags to text styles in InDesign. If you cannot handle the export from the DB of the client I would choose this way.
If you are the owner of the DB or at least have direct access to it you could consider the use of a special plugin which connects InDesign to the DB. With this solution you could rewrite changes from InDesign to the DB. This could be useful as you detect errors or you can make changes in the document and you want to repair that information in the DB for later use.
1 person found this helpful
I have forgotten:
Maybe that you can import your clients output in your own DB application and transform it there.
With tabulators, what do you mean? If it is between "Email:" and the firstname.lastname@example.org you can specify a paragraph style which contains "Email & Tabulator" as a numbered list without numbers, otherwise you could decode it as any normal letter.
You say you have this in Excel now? It looks like a perfect candidate for using Data Merge.
From Excel you can save as tab-delimited text, or you can do a find/change operation on the original text file and convert the # to tab, then save again as plain text to use as the data source. All of the formatting is then done in your merge template file in ID.
This sounds really promising, I'll investigate it, looks like it just might do the trick.
I'll let you know if it works or if I have any more questions.
Thanks again for the help!