cancel
Showing results for 
Search instead for 
Did you mean: 

BRFplus: Exporting Old NW701 Decision Table Data to Excel After Upgrade

Former Member
0 Kudos

Hi,

we are in the process of upgrading from NW701 to NW731, and one of the anticipated new features is the export to Excel / import from Excel facility for Decision Table data.

However we find that Decision Table data that existed prior to the upgrade simply exports as UUIDs of the cell's underlying expressions, which is not usable.  Presumably this relates to the new data model used since NW702.

Data that has been entered after the upgrade exports as it appears in the Decision Table, as expected.

For example, the export might look like this:

Column 1Column 2Comment
15E64AB012C8418AF9D213486B48634215E64AC365C8418AF9D213486B486342Old data entered under NW701
ABCtrueNew data entered under NW731

Is there a fix or workaround to allow the export of old NW701 Decision Table data to Excel ?  Or do we need to develop our own ?

Thanks,

Greg

Accepted Solutions (1)

Accepted Solutions (1)

carsten_ziegler
Active Contributor
0 Kudos

Hi Greg,

As you wrote there has been a change in the data model, or to be precise, the data model has been extended and the default has been changed to the new options. In the past a decision table cell was an unnamed range expression and a decision table result cell was an unnamed constant. In NW 702 the decision table (as many other expressions) learned to save cell content as simple ranges and simple values (all part of the decision table, no other objects required).

For the transition of existing content we have provided tools. Please check out:

  • Report FDT_REORGANIZE_OBJECTS
  • In BRFplus workbench: Application Administration Tool > Operation: Reorganize Objects

In both cases the IDs are converted into attributes of the decision table. Then, the IDs get deleted. As a result your application will be much smaller and the decision table export will show the cell content directly.

Regards,

Carsten

Former Member
0 Kudos

Thanks Carsten,

I have given FDT_REORGANISE_OBJECTS a quick try on a small Decision Table and it seems to do the trick.  I will liaise with the functional teams to work through the remainder.

Regards,
Greg


Answers (1)

Answers (1)

former_member190447
Participant
0 Kudos

It is not about old data vs. new data. But expressions are exported as their ids, while data that were input directly are exported as values. In your example above, I assume that you used some expressions (e.g. constants) in line 1, while entering values ABC and true in line 2.

If this is not the case please report this issue through OSS to allow our support organization to look into it.