cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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)

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)

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:

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

Labels (1)
Was this article helpful? Yes No

Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.

No ratings
Version history
Last update:
‎Jun 12, 2022 03:51 AM
Updated by: