Known Issue: Running a business adapter deletes the schema.ini file specifying the format of the text file containing source data to be imported unless delimiter is configured as "none" (IOJ-1737437)

[#1]

Summary

When a business adapter is configured to import data from a text data file (commonly referred to as a "CSV file"), and a schema.ini file is supplied specifying the format of data in that file, the schema.ini file may be deleted when the business adapter is run.

Workaround

This issue can be worked around by edit the business adapter xml configuration file in a text editor (such as Notepad), and adding the following text in the properties of the ConnectionString attribute of the <Import> element:

;FMT=Delimited(None)

Here is an example of how this may appear:

<Import
    Type="CSV"
    ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Data;Extended
Properties='text;HDR=Yes;FMT=Delimited(None)'" [...]>

Additional information

See the following documentation pages for further information about importing data from text files and working with schema.ini files in business adapters:

• Working With CSV Files
• Completing Connection Properties for CSV Files

Fix status

This issue has been fixed in the following FlexNet Manager Suite releases: 2020 R2.3 / Apr 2021 (Cloud), 2021 R1 (On Premises)

Other information

Affected components: Business adapters

Master issue ID: IOJ-1737437

Also known as: FNML-71264