Manage Style Sheet in Nav 5.0

kolaboy

Hi gays,

I am trying to make the excel, word and send to work on my nav 5.0. When i open a form and click on the word icon or the excel icon, nothing works. It tell me "there is no default StyleSheet for the program you are exporting to". Contact your system administrator.
I went to tools

---

> Manage Style Sheet, but nothing pops out for me to create default stylesheets. any idea please.
Thanks.

jannestig

Firstly the expressions is "GUYS" not a good way to start relations with the "gays".

Anyway, Which form are you running the style sheet tool for, Forms are link to specific style sheets, try click the export or a purchase or sales documents. Otherwise you will have to create a new style sheet for the form in question.

Have you downloaded and installed the stylesheet tool and update if you are a partner?

kolaboy

Sorry for that expression,
I have not downloaded the tool. Where do you think i can get this tool? Can you please send me the link to the download please.
Thanks.

jannestig

it should be on mibuso under downloads

kolaboy

thanks, i have downloaded it from mibuso and have imported it to my database, but if i try running it it gives me the following error:

TableData 681 does not exist.

i defined the styles sheet variable, but still giving the same error. Here is the code:

IF Fields.GET("Table No.","Field No.") THEN
  IF Fields.Type <> Fields.Type::Decimal THEN
    ERROR(Text002);

Currency - OnLookup()

ValidateFieldNo(LookUp : Boolean)
IF LookUp THEN BEGIN
  Fields.SETRANGE(TableNo,"Table No.");
  IF FORM.RUNMODAL(FORM::"Style Sheet Fields",Fields) <> ACTION::LookupOK THEN
    EXIT;
END ELSE BEGIN
  IF NOT Fields.GET("Table No.","Field No.") THEN
    ERROR(STRSUBSTNO(Text001,FORMAT("Field No.")));
END;

"Field No." := Fields."No.";
"Field Name" := Fields.FieldName;

BuildPlaceHolders()
StyleSheetTables.GET("Style Sheet Code","Table No.");
"XML Path" := 'Object/' + StylesheetFunctions.StyleSheetFieldName(StyleSheetTables."Table Name","Field Name");
"Merge Field" := StylesheetFunctions.MailMergeFieldName(StyleSheetTables."Table Name","Field Name");

Is there anything i am not doing correctly,
Please !
Thanks

ajhvdb

You need to run cu 403, this way the stylesheets are imported from your company folder. Do a search for "style" on this site if you are upgrading to 5.0

kolaboy

I have ran cu 403 and imported the form style sheets, but still telling me there is no default style sheet for the program you are exporting to.
Can anyone tell me the steps to take please, may be i am not doing things right.
Thanks

kolaboy

Hi Experts,

First. You have to get your license updated.

Export all the tables from 4.0. Uninstall 4.0. Install 5.0. Upgrade the db.
Import all the tables.

Open 5.0 Cronus. Export 690-694 Forms, and CU 403. Import them to the upgraded db.

In 5.0 Cronus. Design CU 1. Goto Function. Copy and paste the following function to Upgraded db.
LaunchApp
SelectStyleSheet
ManageStyleSheets

Compile and save CU 1.

Copy and past all the records from table following tables
2000000065 Send-To Program
2000000066 Style Sheet


That's it. Close the Upgraded database. and reopen it and now you can use the three new buttons.
_________________

I have tried the above procedure to make nav.5.0 word, excel and send to work, but to no avail. My style sheet is still not working.
Any idea please.
Thanks

ritaninav

I have the same problem. Were you abel to find a fix? Another provider said i need to buy extra license for additional objects. I am not so sure. Please let me know.

vaprog

The functions you copied to the new db's Codeunit 1 need to have the same IDs as on CRONUS.

I recommend running codeunit 403 over copying table contents to import the initial stylesheets.

The stylesheet tool is an addition to ease creating and managing stylesheets. It is not needed to use the basic functionality. I'd recommend to install it only after the standard functionality works.

vaprog

I forgot to mention:
You should recompile all imported objects in the new database and resolve any errors. Some objects may be referenced which are nor present in your database. Fix those error.
After all, if you had a fully updated database, all triggers and objects had been present from the beginning and all you needed to do is creating the stylesheet and sendto program entries manually or by running CU403.