RS01087: DATASTORE 'IMPORT TABLE' FAILS TO IMPORT .CSV FILES FROM THE RAD

APAR status

• Closed as program error.

Error description

• The Data Store Import Table Wizard fails to import .CSV files
  from the server (aka, Rapid Access Directory or RAD). The
  location of the Server folder is defined in the web.config under
  the key="ServerImportDirectory" and is located on the same
  server as the IPFA interface.
  
  Custom Datastore tables can be imported from files or from other
  Data Store tables using the Import Data Store Table Wizard.
  
  Supported file types for import: .xls, .xlsx, .mdb, .accdb,
  .csv.
  
  Location of Source: Upload (files located on users computer),
  Server (RAD located on the same server as the interface), Data
  Store (any existing table located in any existing data store).
  
  To Reproduce:
  1. Open Data Store
  2. Select DATA>IMPORT TABLE from Top Dropdown menu
  3. Select Location of Source: Server
  4. Select a .CSV file from the list of files displayed
  5. Click 'Next>'
  6. Error Message displays "Only files with the following
  extension types can be imported: Access(.MDB, .ACCDB),
  Excel(.XLS, .XLSX) or .CSV"
  

Local fix

• Current Workaround:
  1. Put the .CSV file in a valid folder for upload.
  2. Select Location of Source: Upload
  3. Click 'Browse...'
  4. Navigate to and select the .CSV file and click open
  5. Click 'Next>'
  
  Alternately, you can use a different file type (e.g., .XLS).
  

Problem summary

• This issue has been resolved and fix will be available in IBM
  ILOG Inventory and Product Flow Analyst 7.6.15.2.
  

Problem conclusion

• The fix is now available on FixCentral.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  ILOG INV & PFO

• Fixed component ID

  5725A0400

Applicable component levels

• R760 PSY

     UP

• R750 PSN

     UP