AnsweredAssumed Answered

Generate numbered list in Word from FileMaker data?

Question asked by andrewblackwell on Nov 6, 2014
Latest reply on Dec 2, 2014 by andrewblackwell

My client is hoping that I can create a module that would allow them to generate contracts in Word based on data entered in FileMaker.

 

The sting in the tail is that the contracts should be editable, and that they should be strictly formatted as a numbered list, to enumerate all the contract items. It should basically look as follows:

 

1. Duration of Contract

 

1.1. Start and End of Contract

 

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sollicitudin iaculis nibh, ac posuere lacus eleifend dictum. Fusce turpis leo, luctus in neque eget, consectetur consequat velit. Maecenas vel pretium massa. Aenean lectus nibh, rutrum at sapien vitae, vestibulum euismod quam. Phasellus tincidunt, sapien a volutpat ultrices, mi enim feugiat orci, sit amet bibendum turpis odio a mi. Aenean vitae magna nulla. In gravida mi vitae mauris ornare, id faucibus ex facilisis.

 

1.2. Termination Option

 

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sollicitudin iaculis nibh, ac posuere lacus eleifend dictum. Fusce turpis leo, luctus in neque eget, consectetur consequat velit. Maecenas vel pretium massa. Aenean lectus nibh, rutrum at sapien vitae, vestibulum euismod quam. Phasellus tincidunt, sapien a volutpat ultrices, mi enim feugiat orci, sit amet bibendum turpis odio a mi. Aenean vitae magna nulla. In gravida mi vitae mauris ornare, id faucibus ex facilisis.

 

2. Content of Contract

 

2.1. Contract Clause A

 

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sollicitudin iaculis nibh, ac posuere lacus eleifend dictum. Fusce turpis leo, luctus in neque eget, consectetur consequat velit. Maecenas vel pretium massa. Aenean lectus nibh, rutrum at sapien vitae, vestibulum euismod quam. Phasellus tincidunt, sapien a volutpat ultrices, mi enim feugiat orci, sit amet bibendum turpis odio a mi. Aenean vitae magna nulla. In gravida mi vitae mauris ornare, id faucibus ex facilisis.

 

2.2. Contract Clause B

 

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sollicitudin iaculis nibh, ac posuere lacus eleifend dictum. Fusce turpis leo, luctus in neque eget, consectetur consequat velit. Maecenas vel pretium massa. Aenean lectus nibh, rutrum at sapien vitae, vestibulum euismod quam. Phasellus tincidunt, sapien a volutpat ultrices, mi enim feugiat orci, sit amet bibendum turpis odio a mi. Aenean vitae magna nulla. In gravida mi vitae mauris ornare, id faucibus ex facilisis.

 

 

etc. etc.

 

What I'm hoping to achieve is have a simple database table, which basically has three fields: title, text and parent_id, the latter to indicate which contract item a sub-item belongs to.

 

Generating an output as a pdf in FileMaker would be a piece of cake, but as a Word document it seems next to impossible, as there seems to be no way to tell word that a) the items pasted into the document are list items, and b) what hierarchical level the numbering should be at (1., 1.1. or 1.1.1. etc.) so this is where I'm asking for help.

 

Has anybody worked on a similar solution and found a way to generate something similar in a clean way in Word? Is there a fairly easy way to accomplish this, say, with or via XML, without having to learn Microsoft Word's entire XML syntax and programming logic.

 

Thanks in advance for your help!

Andrew

Outcomes