It is currently Sun Dec 16, 2018 7:35 pm




Post new topic Reply to topic  [ 10 posts ] 
Filling a template word document online using data in form 
Author Message

Joined: Mon May 04, 2009 7:58 pm
Posts: 13
Post Filling a template word document online using data in form
Is it possible to take the data being shown in a dbqwiksite view and insert it into a document template online. If so how is this achieved please?

Thanks


Wed May 20, 2009 9:10 pm
Profile E-mail

Joined: Sat Aug 09, 2008 8:48 pm
Posts: 227
Location: China
Post Re: Filling a template word document online using data in form
Hi miwillans

Im not sure I understand your question fully but DBQWIK does have the ablity built into it to export datapages to DOC's or Excel files if thats what you mean.

If so let us know and if your still stuck we can tell you a step by step.

Cheers

Geno

_________________
DBQWIK-INSITE Resource Center


Wed May 20, 2009 9:43 pm
Profile E-mail WWW

Joined: Mon May 04, 2009 7:58 pm
Posts: 13
Post Re: Filling a template word document online using data in form
Hiya Gino,

I have a word template. Its a School Students Target Document. I would like to use the data that is displayed in a form to fill areas of the document. For example and area marked **Full_Name** with Full Name on the form. hope that makes it a little clearer


Wed May 20, 2009 11:19 pm
Profile E-mail

Joined: Sat Aug 09, 2008 8:48 pm
Posts: 227
Location: China
Post Re: Filling a template word document online using data in form
Hi Miwilans


If I unbderstand you correctly, what you would need to do is create a custom layout using your word template and in the Doc fields add the input varibles.

Hope this helps, if im still on the wrong track on this one please say and ill try to help more.

Cheers

Geno

_________________
DBQWIK-INSITE Resource Center


Thu May 21, 2009 6:24 am
Profile E-mail WWW

Joined: Mon May 04, 2009 7:58 pm
Posts: 13
Post Re: Filling a template word document online using data in form
Yes Gino,

Thats correct, i have a target writer that allows comments to be added that are stored in a mysql database and would like to add that comments to the form in the correct places. I have included the target form and the word doc if that helps you see it a little clearer.

Attachment:
Targets.doc


Attachment:
targets_more.txt


thanks
miwillans


You do not have the required permissions to view the files attached to this post.


Thu May 21, 2009 1:50 pm
Profile E-mail

Joined: Sat Aug 09, 2008 8:48 pm
Posts: 227
Location: China
Post Re: Filling a template word document online using data in form
HI miwillans

From what I see its just a matter of creating a custom layout. See posts on cretaing customs layouts.

Or do you need us to help you further?

Cheers

Geno

_________________
DBQWIK-INSITE Resource Center


Thu May 21, 2009 1:56 pm
Profile E-mail WWW

Joined: Mon May 04, 2009 7:58 pm
Posts: 13
Post Re: Filling a template word document online using data in form
Gino

As far as I can tell custom layouts just allows you to change the layout of the online form. I have a seperate word document (targets.doc) that I want the data from the form (targets_more.php) to be transfered into so that the document can be saved and printed.


Thu May 21, 2009 6:00 pm
Profile E-mail

Joined: Sat Aug 09, 2008 8:48 pm
Posts: 227
Location: China
Post Re: Filling a template word document online using data in form
HI miwillans

Yes you are right, DBQWIKSITE custom layout for form pages will only allow small changes to the form layout at present (to be improved in ver 6) BUT that was my bad explaination.

What I meant is that you will have to design a custom layout to dol what you want. Sorry i used the same term for both.

Dbqwik has the ablity to take data and export it to a word DOC, I surjest you use this feature, genertae the site and nthen edit the WORD output form.

I must admit its something I have not done myself But I will hafve a play over the weekend cause its something that could be usful in the future.

Cheers

Geno

_________________
DBQWIK-INSITE Resource Center


Fri May 22, 2009 6:24 am
Profile E-mail WWW

Joined: Sun Jan 13, 2008 1:49 am
Posts: 146
Location: Texas, USA
Post Re: Filling a template word document online using data in form
I do not know of a way to write data into MS Office applications directly from QS.

I have used the QS to collect data into Oracle. I had to export the desired fields as CSV, then write code in MS Word using VB for applications to fill in the data from the CSV file.

I looked at your Word file. It looks like a Grade Report. In this case you can create a Report Table in QS and design the QS Report Template. Each student record can then be viewed in the screen. You can then export each report as a Word document.


Mon Jun 08, 2009 9:32 am
Profile

Joined: Fri May 09, 2008 5:38 am
Posts: 271
Location: Texas USA
Post Re: Filling a template word document online using data in form
You might have a look at
http://www.programmershelp.co.uk/phpcreateword.php


Tue Jun 09, 2009 7:18 am
Profile E-mail YIM WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Copyright © 2004-2008 TheDevShop Ltd. All Rights Reserved