creating word document from database data

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

creating word document from database data

Tami Williams
Anyone done this with lasso 8.5?

I need to go through a bunch of records stored in MySQL / FileMaker  
with 20+ fields and create 1 word (.doc/.docx) document for each record.

The word document has a certain amount of required formatting.

Before I got started I figured I'd ask the list - anyone done this?  
Anything you want to share?

Thanks in advance.


Note:  I don't know if you can use Lasso's file write to  
create .doc/.docx with proper formatting, but if not can you just  
create .rtf and then re-write the file name to .doc/.docx?  Or am I  
missing something?



#############################################################
This message is sent to you because you are subscribed to
  the mailing list <[hidden email]>.
To unsubscribe, E-mail to: <[hidden email]>
To switch to the DIGEST mode, E-mail to <[hidden email]>
To switch to the INDEX mode, E-mail to <[hidden email]>
Send administrative queries to  <[hidden email]>

Reply | Threaded
Open this post in threaded view
|

Re: creating word document from database data

Steffan A. Cline
This is FAR easier than you think. Open MS Word, create your document and
embed any graphics. Put in some place hlders like {{FIRSTNAME}} etc. Then,
save the file as an RTF. The reason I tell you to use MS Word is because,
unless its changed recently, TextEdit will save it as an RTFD if you embed
graphics which will not work. MS Word does it nicely, go figure. HA! Use
string_replace with the place holders and then use file_serve with the
correct mime type  "application/msword" and set the filename to
something.doc. The document will obviously really be a RTF BUT when the
client opens the document, it will open and save as a word doc. The end
client will never know.

I've done this MANY times and it works perfectly.


Thanks

Steffan

---------------------------------------------------------------
T E L  6 0 2 . 7 9 3 . 0 0 1 4 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline  
[hidden email]                             Phoenix, Az
http://www.ExecuChoice.net                                  USA
AIM : SteffanC          ICQ : 57234309
YAHOO : Steffan_Cline   MSN : [hidden email]
GOOGLE: Steffan.Cline             Lasso Partner Alliance Member
---------------------------------------------------------------





On 10/28/10 1:18 PM, "Tami Williams" <[hidden email]> wrote:

>Anyone done this with lasso 8.5?
>
>I need to go through a bunch of records stored in MySQL / FileMaker
>with 20+ fields and create 1 word (.doc/.docx) document for each record.
>
>The word document has a certain amount of required formatting.
>
>Before I got started I figured I'd ask the list - anyone done this?
>Anything you want to share?
>
>Thanks in advance.
>
>
>Note:  I don't know if you can use Lasso's file write to
>create .doc/.docx with proper formatting, but if not can you just
>create .rtf and then re-write the file name to .doc/.docx?  Or am I
>missing something?
>
>
>
>#############################################################
>This message is sent to you because you are subscribed to
>  the mailing list <[hidden email]>.
>To unsubscribe, E-mail to: <[hidden email]>
>To switch to the DIGEST mode, E-mail to <[hidden email]>
>To switch to the INDEX mode, E-mail to <[hidden email]>
>Send administrative queries to  <[hidden email]>
>



#############################################################
This message is sent to you because you are subscribed to
  the mailing list <[hidden email]>.
To unsubscribe, E-mail to: <[hidden email]>
To switch to the DIGEST mode, E-mail to <[hidden email]>
To switch to the INDEX mode, E-mail to <[hidden email]>
Send administrative queries to  <[hidden email]>

Reply | Threaded
Open this post in threaded view
|

Re: creating word document from database data

Tami Williams-3
Steffan,

thanks!

On Oct 28, 2010, at 4:38 PM, Steffan A. Cline wrote:

> This is FAR easier than you think. Open MS Word, create your  
> document and
> embed any graphics. Put in some place hlders like {{FIRSTNAME}} etc.  
> Then,
> save the file as an RTF. The reason I tell you to use MS Word is  
> because,
> unless its changed recently, TextEdit will save it as an RTFD if you  
> embed
> graphics which will not work. MS Word does it nicely, go figure. HA!  
> Use
> string_replace with the place holders and then use file_serve with the
> correct mime type  "application/msword" and set the filename to
> something.doc. The document will obviously really be a RTF BUT when  
> the
> client opens the document, it will open and save as a word doc. The  
> end
> client will never know.
>
> I've done this MANY times and it works perfectly.
>
>
> Thanks
>
> Steffan
>
> ---------------------------------------------------------------
> T E L  6 0 2 . 7 9 3 . 0 0 1 4 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
> Steffan A. Cline
> [hidden email]                             Phoenix, Az
> http://www.ExecuChoice.net                                  USA
> AIM : SteffanC          ICQ : 57234309
> YAHOO : Steffan_Cline   MSN : [hidden email]
> GOOGLE: Steffan.Cline             Lasso Partner Alliance Member
> ---------------------------------------------------------------
>
>
>
>
>
> On 10/28/10 1:18 PM, "Tami Williams" <[hidden email]> wrote:
>
>> Anyone done this with lasso 8.5?
>>
>> I need to go through a bunch of records stored in MySQL / FileMaker
>> with 20+ fields and create 1 word (.doc/.docx) document for each  
>> record.
>>
>> The word document has a certain amount of required formatting.
>>
>> Before I got started I figured I'd ask the list - anyone done this?
>> Anything you want to share?
>>
>> Thanks in advance.
>>
>>
>> Note:  I don't know if you can use Lasso's file write to
>> create .doc/.docx with proper formatting, but if not can you just
>> create .rtf and then re-write the file name to .doc/.docx?  Or am I
>> missing something?
>>
>>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list <[hidden email]>.
>> To unsubscribe, E-mail to: <[hidden email]>
>> To switch to the DIGEST mode, E-mail to <[hidden email]
>> >
>> To switch to the INDEX mode, E-mail to <[hidden email]
>> >
>> Send administrative queries to  <[hidden email]>
>>
>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list <[hidden email]>.
> To unsubscribe, E-mail to: <[hidden email]>
> To switch to the DIGEST mode, E-mail to <[hidden email]
> >
> To switch to the INDEX mode, E-mail to <[hidden email]
> >
> Send administrative queries to  <[hidden email]>
>


#############################################################
This message is sent to you because you are subscribed to
  the mailing list <[hidden email]>.
To unsubscribe, E-mail to: <[hidden email]>
To switch to the DIGEST mode, E-mail to <[hidden email]>
To switch to the INDEX mode, E-mail to <[hidden email]>
Send administrative queries to  <[hidden email]>

Reply | Threaded
Open this post in threaded view
|

Re: creating word document from database data

Marc Vos
In reply to this post by Steffan A. Cline
Cool!

- -
Marc

Sent from my iPhone

On 28 okt. 2010, at 22:38, "Steffan A. Cline" <[hidden email]> wrote:

> This is FAR easier than you think. Open MS Word, create your document and
> embed any graphics. Put in some place hlders like {{FIRSTNAME}} etc. Then,
> save the file as an RTF. The reason I tell you to use MS Word is because,
> unless its changed recently, TextEdit will save it as an RTFD if you embed
> graphics which will not work. MS Word does it nicely, go figure. HA! Use
> string_replace with the place holders and then use file_serve with the
> correct mime type  "application/msword" and set the filename to
> something.doc. The document will obviously really be a RTF BUT when the
> client opens the document, it will open and save as a word doc. The end
> client will never know.
>
> I've done this MANY times and it works perfectly.
>
>
> Thanks
>
> Steffan
>
> ---------------------------------------------------------------
> T E L  6 0 2 . 7 9 3 . 0 0 1 4 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
> Steffan A. Cline  
> [hidden email]                             Phoenix, Az
> http://www.ExecuChoice.net                                  USA
> AIM : SteffanC          ICQ : 57234309
> YAHOO : Steffan_Cline   MSN : [hidden email]
> GOOGLE: Steffan.Cline             Lasso Partner Alliance Member
> ---------------------------------------------------------------
>
>
>
>
>
> On 10/28/10 1:18 PM, "Tami Williams" <[hidden email]> wrote:
>
>> Anyone done this with lasso 8.5?
>>
>> I need to go through a bunch of records stored in MySQL / FileMaker
>> with 20+ fields and create 1 word (.doc/.docx) document for each record.
>>
>> The word document has a certain amount of required formatting.
>>
>> Before I got started I figured I'd ask the list - anyone done this?
>> Anything you want to share?
>>
>> Thanks in advance.
>>
>>
>> Note:  I don't know if you can use Lasso's file write to
>> create .doc/.docx with proper formatting, but if not can you just
>> create .rtf and then re-write the file name to .doc/.docx?  Or am I
>> missing something?
>>
>>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list <[hidden email]>.
>> To unsubscribe, E-mail to: <[hidden email]>
>> To switch to the DIGEST mode, E-mail to <[hidden email]>
>> To switch to the INDEX mode, E-mail to <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>>
>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list <[hidden email]>.
> To unsubscribe, E-mail to: <[hidden email]>
> To switch to the DIGEST mode, E-mail to <[hidden email]>
> To switch to the INDEX mode, E-mail to <[hidden email]>
> Send administrative queries to  <[hidden email]>
>

#############################################################
This message is sent to you because you are subscribed to
  the mailing list <[hidden email]>.
To unsubscribe, E-mail to: <[hidden email]>
To switch to the DIGEST mode, E-mail to <[hidden email]>
To switch to the INDEX mode, E-mail to <[hidden email]>
Send administrative queries to  <[hidden email]>

Reply | Threaded
Open this post in threaded view
|

Re: creating word document from database data

stevepiercy
It's just like reverse-engineering an Excel document.

I think that the new .docx format is XML and is directly
editable.  However that might not be backward compatible for
some users.

--steve


On 10/28/10 at 10:50 PM, [hidden email] (Marc Vos) pronounced:

>Cool!
>
>- -
>Marc
>
>Sent from my iPhone
>
>On 28 okt. 2010, at 22:38, "Steffan A. Cline" <[hidden email]> wrote:
>
>>This is FAR easier than you think. Open MS Word, create your document and
>>embed any graphics. Put in some place hlders like {{FIRSTNAME}} etc. Then,
>>save the file as an RTF. The reason I tell you to use MS Word is because,
>>unless its changed recently, TextEdit will save it as an RTFD if you embed
>>graphics which will not work. MS Word does it nicely, go figure. HA! Use
>>string_replace with the place holders and then use file_serve with the
>>correct mime type  "application/msword" and set the filename to
>>something.doc. The document will obviously really be a RTF BUT when the
>>client opens the document, it will open and save as a word doc. The end
>>client will never know.
>>
>>I've done this MANY times and it works perfectly.
>>
>>
>>Thanks
>>
>>Steffan
>>
>>---------------------------------------------------------------
>>T E L  6 0 2 . 7 9 3 . 0 0 1 4 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
>>Steffan A. Cline  
>>[hidden email]                             Phoenix, Az
>>http://www.ExecuChoice.net                                  USA
>>AIM : SteffanC          ICQ : 57234309
>>YAHOO : Steffan_Cline   MSN : [hidden email]
>>GOOGLE: Steffan.Cline             Lasso Partner Alliance Member
>>---------------------------------------------------------------
>>
>>
>>
>>
>>
>>On 10/28/10 1:18 PM, "Tami Williams" <[hidden email]> wrote:
>>
>>> Anyone done this with lasso 8.5?
>>>   I need to go through a bunch of records stored in MySQL / FileMaker
>>> with 20+ fields and create 1 word (.doc/.docx) document for each record.
>>>   The word document has a certain amount of required formatting.
>>>   Before I got started I figured I'd ask the list - anyone
>>>done this?
>>> Anything you want to share?
>>>   Thanks in advance.
>>>    Note:  I don't know if you can use Lasso's file write to
>>> create .doc/.docx with proper formatting, but if not can you just
>>> create .rtf and then re-write the file name to .doc/.docx?  Or am I
>>> missing something?
>>>     #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list <[hidden email]>.
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> To switch to the DIGEST mode, E-mail to <[hidden email]>
>>> To switch to the INDEX mode, E-mail to <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>>
>>
>>
>>
>>#############################################################
>>This message is sent to you because you are subscribed to
>>the mailing list <[hidden email]>.
>>To unsubscribe, E-mail to: <[hidden email]>
>>To switch to the DIGEST mode, E-mail to <[hidden email]>
>>To switch to the INDEX mode, E-mail to <[hidden email]>
>>Send administrative queries to  <[hidden email]>
>>
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list <[hidden email]>.
>To unsubscribe, E-mail to: <[hidden email]>
>To switch to the DIGEST mode, E-mail to <[hidden email]>
>To switch to the INDEX mode, E-mail to <[hidden email]>
>Send administrative queries to  <[hidden email]>
>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy               Web Site Builder              
Soquel, CA
<[hidden email]>                  <http://www.StevePiercy.com/>


#############################################################
This message is sent to you because you are subscribed to
  the mailing list <[hidden email]>.
To unsubscribe, E-mail to: <[hidden email]>
To switch to the DIGEST mode, E-mail to <[hidden email]>
To switch to the INDEX mode, E-mail to <[hidden email]>
Send administrative queries to  <[hidden email]>