Need Info related to Essential DocIO

[Amit Kumar]

SoftArtisans,

We are interested in purchasing your Office Writer product.

Requirement is:

1. We don’t have Office 2003 installed on Production Server.
2. We need to develop Letter Generation System, which should fetch the letter template and Placeholders (both) from the Oracle DB.
3. Place Holders is stored in HTML format since it contains formatting.
Can we dynamically combine the Template and Place Holder and display the word doc without saving on Server?

Does Office Writers provide support to fetch Word Template and Placeholder (both) from the Oracle Data source?

We look forward to hearing from you.

[Administrator]

Hi Amit, Thank you for your interest in Syncfusion Essential DocIO 1) Essential DocIO does NOT require Office 2003 to be installed on the sever. It''s has absolutely no dependancy on Office Interop. 2)The next release of Essential DocIO(version 4.2) will have mail merge functionality which would allow you to fetch data from a variety of Data sources like DataTable, DataView etc and merge with place holders inside a Template file. Here is a sample that previews this functionality MailingLetter.zip The above sample uses an Access database but the code would be the same for Oracle also. Please reference the syncfusion assemblies found inside the folder called "Assemblies" in the attachment before running the sample. You can also stream the output to the browser directly using an overload of the WordDocument.Save without having to save a copy on the server. 3) Currently we only support Plain text mail merge but we have an open feature request regarding this issue http://www.syncfusion.com/support/features/docio/Default.aspx?ToDo=view&questId=660 I will consult with the development team and provide an estimate soon. Please let me know if you have any questions. Thanks, Stephen. >SoftArtisans, > >We are interested in purchasing your Office Writer product. > >Requirement is: > >1. We don’t have Office 2003 installed on Production Server. >2. We need to develop Letter Generation System, which should fetch the letter template and Placeholders (both) from the Oracle DB. >3. Place Holders is stored in HTML format since it contains formatting. >Can we dynamically combine the Template and Place Holder and display the word doc without saving on Server? > > >Does Office Writers provide support to fetch Word Template and Placeholder (both) from the Oracle Data source? > > >We look forward to hearing from you. > >

[Administrator]

Hi,

Thanks for giving precious information.

We have one more query: Image in our case is actually stored as binary stream in OracleDB.
Can we load the image into document from Oracle DB using Essential DocIO?

Thanks,
Amit Samniwala.

>SyncFusion,
>
>We are interested in purchasing your Office Writer product.
>
>Requirement is:
>
>1. We don’t have Office 2003 installed on Production Server.
>2. We need to develop Letter Generation System, which should fetch the letter template and Placeholders (both) from the Oracle DB.
>3. Place Holders is stored in HTML format since it contains formatting.
>Can we dynamically combine the Template and Place Holder and display the word doc without saving on Server?
>
>
>Does Office Writers provide support to fetch Word Template and Placeholder (both) from the Oracle Data source?
>
>
>We look forward to hearing from you.
>
>

[Administrator]

Hi Amit, Thank you for your interest with Syncfusion Essential DocIO. Yes, we do have support for inserting binary stream BLOB images from database. We can get the BLOB image field from the table and need to convert it as binary stream. Then we can pass the binary stream value to AppendImage( Image ) overlaod. Here is a small code snippet for your reference. // getting photo value from database. byte[] ImageBytes = ( row[ "Photo" ] as byte[] ); //Writing image to the document. paragraph.AppendPicture ( Image.FromStream ( new MemoryStream ( ImageBytes ) ) ); I have use Access database for getting BLOB images. But the code will be same for Oracle also. Please refer Syncfusion assemblies from “Assemblies” folder in the attachment. Here is a sample for your reference : ImageStream.zip <> Please let me know if you have any questions. Thanks, Prabhu.