Forum Discussion

carpino00's avatar
carpino00
New Contributor
2 months ago

Automating BAI uploads in Workflow

Hello OneStream Community,

Currently working on setting up an automated process to handle BAI file uploads directly into each specific bank workflow in our OneStream application. 

1. BAI Parser & Data Source Configuration - We've installed the BAI Parser dashboard to view and manage all imported BAI files. The BAI data source has been configured and initial tests with sample files have been successful.

2. File Transfer & Business Rules - Plan is to automate the transfer of finalized BAI files from our system via FTP to the OneStream file system. This requires a BR to connect with the FTP site and currently developing a BR to facilitate this connection. Once the files are in OS, they'll be imported into the appropriate bank workflow.

3. SFTP Wrapper and Workflow Integration - After the initial FTP transfer, a separate BR will be implemented to securely retrieve and upload the BAI file into the bank workflows.

Question: For those who have set up similar BAI automation processes, are there specific best practices or additional BR configurations that you would recommend? Any insight would be greatly appreciated.

Data Integration
Data Sources
Workflow
  • jseavey's avatar
    jseavey
    New Contributor II
    20 days ago

    We are currently trying to configure the BAI Parser and running into some issues with it. We found that it is not pulling in any of the transaction data, and it is not adding the decimal, so all of our amounts are off. Did you have to do some configuration outside of what OneStream has in its guide?

    • sniece's avatar
      sniece
      New Contributor II
      20 days ago

      As for transaction data, did you map the BAI fields (FH,GH,AH,TH,AT,GT,FT fields) to attribute fields on your BAI data source?  I did get transaction data for 95% of my initial test file.  There was a small percentage not loading transaction level BAI data, but my source system for BAI files is still working their file formatting, so I chalked it up to that for now.  When my source system starts sending me finalized BAI files I was going to recheck.  But since you seem to be having that same issue it might be an OS issue.

      As for amounts and the decimal place, yes the decimal was missing for me as well.  So that might be an OS issue.  This is a first for me dealing with bank BAI files, so I was not sure if that was a normal BAI format. Like amount lines all coming in positive with DR/CR indicator.

      Because I can't get finalized BAI files from my source system I have stopped my BAI Parser effort at this time, but I'd still like to hear how your effort goes.  And happy to provide help if I can.

      • jseavey's avatar
        jseavey
        New Contributor II
        20 days ago

        We mapped all the BAI fields that our business's use. It's parsing the data but appears to be missing some of the data. We can look at the BAI file and see the transactions detail that it should be pulling in but is not. We can also tell by the type codes in OneStream. The decimal place issue is just strange. I do have a ticket open with OneStream support to look into this and see if they can provide any more information about configuring the BAI Parser. I will reply back once I hear something from them.

  • sniece's avatar
    sniece
    New Contributor II
    28 days ago

    I'm in the process of working these exact same requirements. 

    - I'm still waiting to get a FTP connection established to pull BAI bank files.  I've cloned the OneStream documentation supplied FTP BR to pull files once that connection is established.

    - I have tested BAI files successfully as well with the BAI Parser and loaded bank workflows via the BAI Preview Upload/Import steps manually.

    - I've started looking into a BR to perform the BAI file upload and Import into Workflow steps.  I see the delivered BAI objects for those steps but I'm not sure I can replicate in a custom BR.

    I would be very interested in knowing how things are going for you.

    Thanks.