mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 8:59 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 28 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Microsoft Dynamics NAV Style Sheet Tool v1.1
PostPosted: Fri Jul 06, 2007 8:57 pm 
Offline
Site Admin

Joined: Sun Nov 07, 1999 8:01 am
Posts: 1901
Location: Wilrijk, Belgium
Country: Belgium (be)
Microsoft Dynamics NAV Style Sheet Tool v1.0
The Style Sheet feature in Microsoft Dynamics NAV 5.0 has been enhanced with a new tool that allows you to easily and without programming knowledge create and modify style sheets in Microsoft® Office Word.

The release of Microsoft Dynamics NAV 5.0 introduced the option to export any form (apart from matrix forms) from Microsoft Dynamics NAV to Microsoft Office® Word and Excel®. By simply clicking a button, Microsoft Dynamics NAV will generate an XML document that works in conjunction with an XML style sheet that passes the requested information to either Word or Excel.

Seven style sheets are included in Microsoft Dynamics NAV. You can read about these in the White Paper ‘Creating XML Style Sheets for Data Export from Microsoft Dynamics NAV 5.0’. However, if you want to create more style sheets or modify an existing one, you need to have knowledge of XML and C/AL programming in order to add the relevant data elements.

To simplify this process, a style sheet tool has been created that does not require programming knowledge. The first version of this tool will support the export of data to Word, and this means that the only skill required to create additional style sheets is some end-user knowledge of Word.

The Microsoft Dynamics NAV Stylesheet Tool supports integration to Microsoft Word 2003 and Microsoft Word 2007.
It consists of a fob file and a user guide.

Note: To be able to use the tool, a license update is required.

http://www.mibuso.com/dlinfo.asp?FileID=869

Discuss this download here.


Last edited by Administrator on Fri Dec 14, 2007 12:02 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 09, 2007 7:04 pm 
Offline

Joined: Mon Oct 18, 2004 2:34 am
Posts: 198
Location: Canada, Toronto
Country: Canada (ca)
Great, it seams very nice, however i have got a quesstion. Maybe I am missing something. It seams that Table Relationships work only for the "Base Table". For instance if you want to create a template for Sales order you can attach the Customer Table to the Header and get Customer's Info but i could not find a way to attach the Item table to the lines to get Item information. Am I missing something?

_________________
Best Regards,
Oleg


Top
 Profile E-mail  
 
 Post subject:
PostPosted: Wed Jul 18, 2007 10:46 am 
Offline

Joined: Wed Apr 12, 2006 3:45 pm
Posts: 130
Location: Venlo
Country: Netherlands (nl)
Does anyone knows how to export pictures to these templates?

Example, Company LOGO or Item Pictures?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 23, 2007 1:06 pm 
Offline

Joined: Fri Dec 29, 2006 10:28 am
Posts: 11
Location: Dortmund
Country: Germany (de)
wwestendorp wrote:
Does anyone knows how to export pictures to these templates?

Example, Company LOGO or Item Pictures?


Hi wwestendorp

did you find out how to export Item Pictures?


Or does anybody else know how to do that?
It would be really great if someone could tell me how to export pictures.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jul 26, 2007 5:25 pm 
Offline

Joined: Thu Jul 26, 2007 5:22 pm
Posts: 2
Location: FRANCE
Country: France (fr)
Hi,

How can I make a link with some tables.

Example :

Item Card with :
table for sales prices
table for purch prices
Comment

When I do this, only the first table is multi-line. The others don't work.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 22, 2007 9:20 am 
Offline

Joined: Thu Aug 04, 2005 7:45 am
Posts: 11
Location: Taiwan
Country: Taiwan (tw)
I use the tool to make a exerise for item card. But when click "Send Option" and select the "item card", and click "Send", I only see the origin mail merge. the tag still on document. and does not change to the real item data. Can anyone tell me whick step should I notice?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 22, 2007 11:31 am 
Offline

Joined: Mon Jan 23, 2006 1:52 pm
Posts: 10
Location: Denmark
Country: Denmark (dk)
If I understood you correctly you followed all the steps in the guide to create style sheet, but instead of a Word document with item data, you got a Word document with the original merge fields?

I've seen something like that happen on rare occasions, but when trying to reproduce it just doesn't wan't to do it.

One way I've solved it myself, was to export the definition and merge docs, delete the definition in NAV, and then re-import the documents and have the system generate a new style sheet - this seems to work . . .

What's even more funny is that if you the delete the item defintion in the system and try to do exactly the same steps as when you originally created the first definition - the error does not show up!!??

Hope this helps.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 12, 2007 3:20 pm 
Offline

Joined: Thu Apr 13, 2006 3:30 pm
Posts: 33
Location: Italy
Country: Italy (it)
wwestendorp wrote:
Does anyone knows how to export pictures to these templates?

Example, Company LOGO or Item Pictures?

You just have to add the picture to the word document the normal way
As the normal way I mean as described in the whitepaper
LnZ


Top
 Profile  
 
 Post subject: Microsoft Dynamics NAV Style Sheet Tool v1.1
PostPosted: Fri Dec 14, 2007 12:03 pm 
Offline
Site Admin

Joined: Sun Nov 07, 1999 8:01 am
Posts: 1901
Location: Wilrijk, Belgium
Country: Belgium (be)
Microsoft Dynamics NAV Style Sheet Tool v1.1
The Style Sheet feature in Microsoft Dynamics NAV 5.0 has been enhanced with a new tool that allows you to easily and without programming knowledge create and modify style sheets in Microsoft® Office Word.

The release of Microsoft Dynamics NAV 5.0 introduced the option to export any form (apart from matrix forms) from Microsoft Dynamics NAV to Microsoft Office® Word and Excel®. By simply clicking a button, Microsoft Dynamics NAV will generate an XML document that works in conjunction with an XML style sheet that passes the requested information to either Word or Excel.

Seven style sheets are included in Microsoft Dynamics NAV. You can read about these in the White Paper ‘Creating XML Style Sheets for Data Export from Microsoft Dynamics NAV 5.0’. However, if you want to create more style sheets or modify an existing one, you need to have knowledge of XML and C/AL programming in order to add the relevant data elements.

To simplify this process, a style sheet tool has been created that does not require programming knowledge. The first version of this tool will support the export of data to Word, and this means that the only skill required to create additional style sheets is some end-user knowledge of Word.

The Microsoft Dynamics NAV Stylesheet Tool supports integration to Microsoft Word 2003 and Microsoft Word 2007.
It consists of a fob file and a user guide.

Note: To be able to use the tool, a license update is required.


The following issues have been corrected in version 1.1:

- If a Header or Footer was specified, the Style Sheet Tool ignored them.
- If a long option strings was defined for a field, the user received a text overflow error message.
- When changing local languages, the Style Sheet tool only looked for a '.' instead of the local language decimal separator.
- When you create the mail merge document, the Style Sheet Tool would ignore the landscape orientation.
- If you have created a table relationship and the value being looked up doesn't exist, the style sheet won't load. If you close down NAV then you would get an error indicating that the value couldn't be found.
- When using page numbers (page x of y), then all pages come out as page 1 of 1

http://www.mibuso.com/dlinfo.asp?FileID=869

Discuss this download here.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jan 15, 2008 11:16 am 
Offline

Joined: Tue Jan 15, 2008 11:09 am
Posts: 1
Location: Hamburg
Country: Germany (de)
Hi,

what does "Note: To be able to use the tool, a license update is required." excatly mean? I know how to update a license, but do I have do pay for it in this case?

Cheers,
Bob


edit: It's free.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jan 15, 2008 2:57 pm 
Offline

Joined: Thu Jul 17, 2003 10:52 pm
Posts: 638
Location: Capelle a/d IJssel
Country: Netherlands (nl)
It uses new objects, so the customer license need to be updated (for free).

_________________
Create dynamic Excel or Word documents, ReportX


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 25, 2008 8:43 pm 
Offline

Joined: Wed Apr 07, 2004 7:18 pm
Posts: 8
Location: fort collins
Country: United States (us)
I'm using Style Sheet Tool v1.1 (StyleSheetToolW111.fob dated 10/29/07)

Relates to replies in this thread from
SRAD750
Quote:
Example :

Item Card with :
table for sales prices
table for purch prices
Comment

When I do this, only the first table is multi-line. The others don't work.


and

zeninoleg
Quote:
It seams that Table Relationships work only for the "Base Table". For instance if you want to create a template for Sales order you can attach the Customer Table to the Header and get Customer's Info but i could not find a way to attach the Item table to the lines to get Item information. Am I missing something?


Also relates to another similar topic with subject:"Multiple multi lines in style sheets" http://mibuso.com/forum/viewtopic.php?t=23007&start=0&postdays=0&postorder=asc&highlight=style+sheet&sid=76729974b89d6c5e5a0e74c7514d366f

I've debugged and diagnosed the reason. NAV incorrectly creates a beginning TR tag(beginning of table) and ending TR tag(End of table) when building the XML node for the table. It does not account for two tables within a single style sheet. So the result is a table with a begining TR and ending TR with the end of the first table and begining of the second sandwiched in as text.

Workaround is to modify the XML. You need to create a style sheet with table 1 as you would normally. I'll call this "MAIN". Create the second table as a basic empty table with no merge fields. Save it. Then create another style sheet with just the second table formatted the way you want. I'll call this one "Second Table". Save it, then open (xslt file) in XML editor. Copy the table node from "Second Table" and paste it over the table node in "MAIN". Save.

This solution would need to be duplicated every time the Style Sheet is modified via Word, which is what the client will no doubt use. Not a great solution unless you have a style sheet that doesn't change often and you have someone willing to get their hands dirty doing a little XML editing.

Hopefully, MS will fix this issue in coming releases of the Style Sheet toolkit.

_________________
Jon Long - ArcherPoint
MCP - Dynamics NAV


Top
 Profile E-mail  
 
 Post subject:
PostPosted: Thu Mar 20, 2008 2:10 pm 
Offline

Joined: Thu Sep 07, 2006 11:58 am
Posts: 471
Location: Mendrisio
Country: Switzerland (ch)
I have some problems with Microsoft Dynamics NAV Style Sheet Tool v1.1
I have used it for export sales quote on Ms Word.

I have created some table relation to a new table ( > 50000 - MyTableName) but when exporting the fields are not recalculated for this table - it comes : «RELATION_MyTableName» and not the value. The others relations to standard tables work... Is that normal? Is there some work around?


Thank you very much


Top
 Profile  
 
 Post subject:
PostPosted: Thu Mar 20, 2008 3:04 pm 
Offline

Joined: Thu Sep 07, 2006 11:58 am
Posts: 471
Location: Mendrisio
Country: Switzerland (ch)
The other problem is that if I insert a MergeField in Page Footer - for example: «Sales_Header_No», it comes updated when I have the Word Document on screen but when I make a print preview of a print on printer it shows the variable name «Sales_Header_No» and not the value of Document No.
The same merge field out from page footer is printed correctly.

Thank you very much


Top
 Profile  
 
 Post subject: Hello
PostPosted: Mon Jul 07, 2008 5:48 pm 
Offline

Joined: Thu Jul 03, 2008 11:36 am
Posts: 3
Location: NANTES
Country: France (fr)
I have the same problem with multiline tab, only the first multiline tab is show..
I've test your solution but what .xslt file I have to modify ?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 28 posts ]  Go to page 1, 2  Next

All times are UTC + 1 hour [ DST ]


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


Search for:
Jump to: