AusPayNet BSB data is now available via download from a public FTP connection. Downloadable files include a full list and an update list, both available in CSV and TXT file formats. AusPayNet BSB data is generated and published at least once a month on the first business day of the month. However, it is possible that data could be generated more than once in a given calendar month.

File Naming Conventions

The file naming convention for the full list is comprised of the previous month and report number. An example of this is below:

• BSBDirectoryMay13-205.csv
• BSBDirectoryMay13-205.txt

The file naming convention for the update list is the date of the day after the last report was generated. An example of this is below (data was generated on 1 May 2013):

• BSB Directory Update 02May13-03Jun13.csv
• BSB Directory Update 02May13-03Jun13.txt

URL

Please note that this is not the address to use if you’re attempting to set up an automated FTP procedure.

The BSB Data can be downloaded from the following location: ftp://bsb.hostedftp.com/~auspaynetftp/BSB

Instructions for downloading via FTP, including worked examples and file formats can be downloaded here.

Contact

Should you have any questions or encounter any issues whilst downloading from the AusPayNet BSB Data FTP, please contact us at [email protected].

• Docker
• Mongo

• Build ./gradlew clean build
• Start Mongo container docker-compose up -f docker-compose.yml -d (references docker-compose.yml)
• Start application ./gradlew bootRun
• This will read contents of BSB file and load them into MongoDB collection.
  • all-records: "BSBDirectoryNov19-284.csv.original" Points to classpath file resource that has all BSB details
• You can now lookup BSBs
  • all http://localhost:8080/bsb
  • specific http://localhost:8080/bsb/182-182

• Instead of needing BSB file as classpath resource, the application should FTP it from APCA
• Instead of loading files at scheduled intervals, maybe
  • provide REST endpoint to upload file?
  • OR FTP from configured path at scheduled intervals?
• Add creationTime and bsb file name while loading entries
• Handle case when BSBs no longer sent in file i.e. was present originally but not sent anymore - should be deleted from Collection.
  • Is this even possible ? Or will APCA always send through all BSBs, closed ones will have empty string for PEH payment flag.

The following guides illustrate how to use some features concretely:

• Spring Batch
• Creating a Batch Service
• Testing your Batch Job
• Spring Batch: CSV to Mongo