Transforming Excel tables into SDMX csv tables

The goal of this package is to allow users to be able to generate SDMX csv files out from published statistical excel files.

Excel file preparations

Before using the fbosSDMX R package, you will need to reorganize your published excel tables to the proper standard format:

Balance of payment (BOP) excel reorganisation

The BOP excel should be re-organised according to the followingsteps:

1. Create an excel file

2. Add the following worksheets in the excel file:

   1. DF_BOB_TABLE1 – Balance of Payments
   2. DF_BOP_TABLE2 – CURRENT ACCOUNT - GOODS AND SERVICES
   3. DF_BOP_TABLE3 – CURRENT ACCOUNT - PRIMARY AND SECONDARY INCOME
   4. DF_BOP_TABLE4 – CAPITAL ACCOUNT
   5. DF_BOP_TABLE5 – FINANCIAL ACCOUNT

Installation

You can install and execute the fbosSDMX package as per the following steps:

# **************** How to install the package from R console ******************** #

install.packages("remotes") # Ensure remotes package is installed before proceeding
library(remotes) # load the remotes package
remotes::install_github("https://github.com/PacificCommunity/sdd-excel-to-sdmx-fbos") # Install the fbosSDMX package
# if "remotes::install_github("https://github.com/PacificCommunity/sdd-excel-to-sdmx-fbos")" does not work. try the following
remotes::install_github("https://github.com/PacificCommunity/sdd-excel-to-sdmx-fbos", force = TRUE)

# **************** How to run the imtshiny app from R console ******************** #
library(fbosSDMX) # Load the fbosSDMX package
fbosSDMX::run_fbosSDMX() # Execute the fbosSDMX package