glimmieglimbo

DDE export MS Word limited 255 characters

Discussion created by glimmieglimbo on Jan 30, 2012

Hello FileMaker-lovers,

 

I work with EZxslt to generate XSL-files which FM use to generate MS-Word reports. This works perfect. The Word-docs are rather large due to several pictures (company logo etc.) in the original document (4 mb) and the fact that the docs are first save in rtf-format.

Now the company wants to work in the cloud and the bandwith is the bottleneck here. So in order to increase the datatraffic I want to call the Word-doc and replace the fields with the data from filemaker with a DDE call.

This works perfect but I have one problem and that is the limitation of 255 characters export to Word.

for example:

 

WordBasic.EditReplace Find:="<<VersSomHuur>>", Replace:="Huurdersbelang" + Chr(9) + ": €." + Chr(9) + "2.000.000,--" + Chr(13) + "Inventaris" + Chr(9) + ": €." + Chr(9) + "3.000.000,--" + Chr(13) + "Goederen" + Chr(9) + ": €." + Chr(9) + "4.000.000,--" + Chr(13) + "Bedrijfsschade" + Chr(9) + ": €." + Chr(9) + "5.000.000,--" + Chr(13) + "Extra kosten" + Chr(9) + ": €." + Chr(9) + "6.000.000,--" + Chr(13) + "Reconstructie" + Chr(9) + ": €." + Chr(9) + "7.000.000,--" + Chr(13) + "Opruimkosten" + Chr(9) + ": €." + Chr(9) + "8.000.000,--" + Chr(13) + "Elektronika" + Chr(9) + ": €." + Chr(9) + "9.000.000,--" + Chr(13) + "Machinebr" + "euk" + Chr(9) + ": €." + Chr(9) + "10.000.000,--" + Chr(13) + "Machinebreuk/Bedrijfsschade" + Chr(9) + ": €." + Chr(9) + "11.000.000,--" + Chr(13) + "Bedrijfsaansprakelijkheid " + Chr(9) + ": €." + Chr(9) + "12.000.000,--" + Chr(13) + "Goederen elders " + Chr(9) + ": €." + Chr(9) + "13.000.000,--", ReplaceAll:=1, Wrap:=1

 

Does anyone knows a workaround for this limitation or is there another way to generate the MS-Word documents with the data from filemaker.... with sometimes large amount of data for one field.

 

Thanks for the information.

 

Greetings,

Martin van Wijnen

The Netherlands.

Outcomes