Import CSV File Text Data Type 32 chars Limitation (Cognos 10.1 Report Studio)

[Balthazar]

Hi,

When I import a CSV file using manage external data and use it in the report, the text data type is getting truncated to 32 characters. Please let me know if there are any settings to be performed to increase the number of characters or is this a Cognos limitation?

Thanks in Advance.

[MFGF]

Hi,

When I import a CSV file using manage external data and use it in the report, the text data type is getting truncated to 32 characters. Please let me know if there are any settings to be performed to increase the number of characters or is this a Cognos limitation?

Thanks in Advance.

Hi,

Works fine for me in 10.2.2 - I just tried it with a simple file having descriptions over 100 characters in length and I see the entire description in my report.

When you are importing the file, if you click on the column when on the Data Attributes page, what is the Data type set to be?



MF.

[Balthazar]

Hi MFGF,

The datatype is text. I tried in two separate 10.1 installs and still not able to display more than 32 characters in the report. Even view tabular data is truncating it to 32 characters. I am now wondering if this is a bug in 10.1 corrected in later versions.

The only article I found by googling recommends upgrading to 10.2 Refresh Pack1.

http://www-01.ibm.com/support/docview.wss?uid=swg1PM49171

Thanks

[MFGF]

Hi MFGF,

The datatype is text. I tried in two separate 10.1 installs and still not able to display more than 32 characters in the report. Even view tabular data is truncating it to 32 characters. I am now wondering if this is a bug in 10.1 corrected in later versions.

The only article I found by googling recommends upgrading to 10.2 Refresh Pack1.

http://www-01.ibm.com/support/docview.wss?uid=swg1PM49171

Thanks

Sadly I don't have 10.1 to test with. The link you included seems to suggest it's a product issue fixed in a later build. It does mention inserting an extra first row of all digits seems to be a workaround, as does saving the file as xls and importing the xls. Are either of these viable options for you until you can try a newer build of Cognos?

MF.

[Balthazar]

Thanks MFGF, for pointing the workaround to insert first row as digits. I tried and it worked  :)