I'm trying to use a business adapter to import data from a csv with a custom query, my problem is that when I save the adapter it does not remember the path to the csv file, nor does the checkbox for "Auto-generate SQL Query" stay unchecked. I noticed that if I check "Auto-generate SQL Query" and don't use a custom query, then the path to the csv file is saved correctly.
I see ChrisG mentions this issue in Solved: Business Adapter ignore null values - rows found with rejection messages - Community (flexera.com) from 2020. Is this issue still unresolved?
āJul 17, 2023 10:08 PM
For reference, I believe what you are seeing here is covered by the following known issues (which may be duplicate entries for the same issue - I'm not sure):
IOJ-1757306: Business Adapter Studio may replace .csv file name with complex query text
Unfortunately these issues are not resolved in any current releases.
I can see some notes that indicated as suggested workaround is to uncheck the "Auto-generate SQL Query" option before re-selecting the file, and that will prevent the custom query from being overwritten. I'm not sure if this workaround will cover all the nuances of what you're seeing though.
āJul 17, 2023 10:43 PM
For reference, I believe what you are seeing here is covered by the following known issues (which may be duplicate entries for the same issue - I'm not sure):
IOJ-1757306: Business Adapter Studio may replace .csv file name with complex query text
Unfortunately these issues are not resolved in any current releases.
I can see some notes that indicated as suggested workaround is to uncheck the "Auto-generate SQL Query" option before re-selecting the file, and that will prevent the custom query from being overwritten. I'm not sure if this workaround will cover all the nuances of what you're seeing though.
āJul 17, 2023 10:43 PM
Ok no worries. I'll use excelcnv.exe to convert the csv to xlsx (which works fine in the BAS)
āJul 17, 2023 10:51 PM