This is a command-line application, based on the Symfony CLI component. The application process a local or remote(ftp) XML file and push the data of that XML file to a Google Spreadsheet via the Google Sheets API.
- PHP 8.0.12
- Symfony CLI version 4.26.8
-
Create Google service account and download JSON file which will have all the details required to use Google API services.
-
Enable Google Sheets API and Google Drive API.
-
Next step is to setup environment. File
envcontains all the variables required for application. -
Primarily, For Google service account have to set the following env variable. Place the downloaded JSON file in repository and give a path of it in
GC_AUTH_CONFIG.
GC_AUTH_CONFIG=credentials.json- For accessing files from remote server(ftp) set following env details
FTP_HOST=
FTP_USER=
FTP_PASSWORD=- "dockerfile" file is added to the project. Running the following command creates an environment and bundle the project inside the docker container with container name "data-exporter".
docker build -t php-symfony . && docker run --name data-exporter php-symfony
- Run command
docker psin new terminal window to see the container details. - Open the bash to execute the project with the following command.
docker exec -it data-exportecr bash
- Inside the bash terminal we can run our project.
- For local export, place the xml file under
resourcedirectory and run the following command inside the php container
php bin/console app:export-data --source=local employee.xml
- For remote export run this command inside the php container
php bin/console app:export-data --source=ftp coffee_feed.xml
- Run the following command inside the container to check the test case result.
./vendor/bin/phpunit tests/
- Logs for the application are stored in the 'environment'.log file. Information log and Error log are written in 'environment'.log and 'environment'_errors.log files respectively which resides in the path
var/log/