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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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 number

    RS01087

  • Reported component name

    ILOG INV & PFO

  • Reported component ID

    5725A0400

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-08-08

  • Closed date

    2012-08-23

  • Last modified date

    2012-08-23

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM ILOG Inventory and Product Flow Analyst

Software version:

760

Reference #:

RS01087

Modified date:

2012-08-23

Translate my page

Machine Translation

Content navigation