Honored Contributor.
Honored Contributor.

How to import text file data to a table

Hi Experts,


I am trying to import the contents of a text file to a new table in SM 9.40 through import descriptor(Text import wizard).

But I am getting the attached error.

Could anyone please suggest me a solution.


Thanks & Regards,

Sandhu Mol

1 Reply
Super Contributor.. Super Contributor..
Super Contributor..

As you see the error is about the unique key issue, you firstly findout what is the unique key defined in dbdict of that particular table. And then add that unique key values in your text file if your  are updating the records in the table. For example if you are importing to cm3r table, the unique key should be "number" field. Unique keys can not be Null. Hope this helps you.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.