Problem Note 65218: A CSV file that contains multi-line or single-line text separated by commas is not imported properly in SAS® Business Data Network 3.3
 |  |  |  |  |
Importing CSV files for SAS Business Data Network 3.3 is not working properly when the files contain either the attribute type Multi-Line Text or the attribute type Single Line Text, and commas are used in the text values.
For example, if a Multi-Line Text type attribute contains the values "mlte1,mlte2, mlte3;mlte4; mlte5", the messages about the import process appear as follows in the SASBusinessDataNetwork.log:
addOtherAttributes: attribute label 'mlte' with value 'mlte1' added as COMMON
attribute for term 1001106.
. . .
addOtherAttributes: attribute label 'mlte' with value 'mlte2' added as CUSTOM
attribute for term 1001106.
. . .
addOtherAttributes: attribute label 'mlte' with value 'mlte3;mlte4; mlte5' added
as CUSTOM attribute for term 1001106.
attribute for term 1001106.
. . .
addOtherAttributes: attribute label 'mlte' with value 'mlte2' added as CUSTOM
attribute for term 1001106.
. . .
addOtherAttributes: attribute label 'mlte' with value 'mlte3;mlte4; mlte5' added
as CUSTOM attribute for term 1001106.
The UI shows that only the first value that appears before the comma is captured.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Business Data Network | Solaris for x64 | 3.3 | 9.4 TS1M6 | ||
| Linux for x64 | 3.3 | 9.4 TS1M6 | ||||
| HP-UX IPF | 3.3 | 9.4 TS1M6 | ||||
| 64-bit Enabled Solaris | 3.3 | 9.4 TS1M6 | ||||
| 64-bit Enabled AIX | 3.3 | 9.4 TS1M6 | ||||
| Microsoft® Windows® for x64 | 3.3 | 9.4 TS1M6 | ||||
A fix for this issue for SAS Business Data Network Mid-Tier 3.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F9W.html#65218| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-12-16 15:42:18 |
| Date Created: | 2019-12-09 06:56:30 |