Print

[Ram]

The following message is posted only as a matter of record. Probably useful to other users.

OrgPlus has notified me that this issue will be fixed in their maintainance release



-----Original Message-----
From:  

[Forum Administrator]

Ram,

You're right it will be helpful for other users to know the information you have posted. There is actually a good reason why OrgPlus does not refresh data from an empty column of data. We have decided not to import empty columns to help speed up the import/refresh process. OrgPlus looks at the column realizes it's empty so there is no need to important it or make any changes to it. If for some reason the data must be imported, even though there is nothing to import, try adding a period or a zero to one of the rows in the column. Let us know if you have more questions about this process.

As for your alphanumeric question, where are you changing the data type? Is it being changed in Data | Define Fields? It depends on what the field was set at during import and what it has been changed to. It could cause problems if the field was set as text and contained numbers and text, then it was changed to numbers. As a general rule we suggest that the data type is setup during the import process. Let us know if you have any questions about the above and this issue.

You can find additional support at our online Support Center at:

http://www.humanconcepts.com/support.

Please feel free to contact us if we can be of further assistance.

Sincerely,

The OrgPlus Support Team
OrgPlus. Organize. Visualize. Strategize

HumanConcepts
www.orgplus.com
support@humanconcepts.com

http://humanconcepts.com/servlets/res02.WebSupport

[Ram]

Hi,

As a workaround for the problem of not-refreshing empty columns, we created a dummy node and made it invisible and ensured that this node contains values for all the fields.

For the alphanumeric column, I dont change the datatype anywhere...I only change the values...Try this out...

Table t (col1 number, col2 number, col3 varchar2(10))

> select * from t

col1   col2    col3
100            abc
101    100     def

Create a chart for this table. Everything works fine...

Now change a value

> select * from t

col1   col2    col3
100            123
101    100     def

Do a refresh...Again everything is fine...abc is replaced by 123 in the chart.

Change another value

> select * from t

col1   col2    col3
100            123
101    100     123

Do a refresh...the def doesn't go off...it still stays...

[Forum Administrator]

Ram,

Thanks. I'm sure other people will find that very helpful.

You can find additional support at our online Support Center at:

http://www.humanconcepts.com/support.

Please feel free to contact us if we can be of further assistance.

Sincerely,

The OrgPlus Support Team
OrgPlus. Organize. Visualize. Strategize

HumanConcepts
www.orgplus.com
support@humanconcepts.com

http://humanconcepts.com/servlets/res02.WebSupport