I am busy evaluating Aspose.Words for Java, we need it inorder to do a mailmerge using a CSV file as datasource. I have been able to setup a quick prototype (getting a ResultSet from the CSV file), but found two problems with it already:
1.)First problem was that the merged date value wasn't formatted correctly:
There are two date fields in the source file, one is in the format 2011/10/17 (YYYY/MM/DD) and needs to be merged into a date field with the following formatting set: \@ "yyyy/MM/dd". The result however is 0184/10/17. It seems to get the year wrong. The second date field is in the format 20101015 (YYYYMMDD) and needs to be merged into a date field with the following formatting set: \# "0000/00/00". But the result is 20101015 //.
I should probably note that we can change the formatting in the template, but not in the source file as these are not in our control and there are litterally hundred different one's being used and there simply isn't time to have them changed (so best we can do if need be, is to change the format on the template).
2.)Second problem that I have picked up so far is that the allignment of any table columns are changed during the merge. They need to stay exactly the same as they were on the template.
I was previously using the OLEAutomation and found that calling Word's Mail-Merge did the merge 100% using the date formatting as specified and the table's allignment were left exactly as was. The problem we are having with opening Word handlers is that they tend to get out of control and actually started opening MS Word and running the Mail-Merge in the foreground which eventually leads to handler conflicts.
I have only two days to evaluate your software before I need to make an informed decision for our business to purchase the licenses. Hope you can help me asap.
Thank you and regards