PM Counter Monitoring MCP Server

# 📤 How to Upload Sample Files to SFTP Server ## Prerequisites 1. Make sure the SFTP server is running: ```bash docker-compose up -d sftp_server ``` 2. Verify it's running: ```bash docker ps | grep pm_sftp_server ``` ## Method 1: Using the Upload Script (Easiest) ⭐ From the project root directory: ```bash ./scripts/upload_sample_files.sh ``` This will automatically upload `example_1.xml` and `example_2.xml` to the SFTP server. ## Method 2: Manual Upload with Docker Copy files directly into the container: ```bash # Upload example_1.xml docker cp example_1.xml pm_sftp_server:/home/sftpuser/uploads/example_1.xml # Upload example_2.xml docker cp example_2.xml pm_sftp_server:/home/sftpuser/uploads/example_2.xml ``` ## Method 3: Using SFTP Client Connect to the SFTP server and upload files: ```bash # Connect to SFTP server sftp -P 2222 sftpuser@localhost # When prompted, enter password: password # Once connected, upload files: put example_1.xml /home/sftpuser/uploads/ put example_2.xml /home/sftpuser/uploads/ # List files to verify ls /home/sftpuser/uploads/ # Exit exit ``` ## Method 4: Using SFTP from Inside Container ```bash # Copy files to container first docker cp example_1.xml pm_sftp_server:/tmp/example_1.xml docker cp example_2.xml pm_sftp_server:/tmp/example_2.xml # Move to uploads directory docker exec pm_sftp_server mv /tmp/example_1.xml /home/sftpuser/uploads/ docker exec pm_sftp_server mv /tmp/example_2.xml /home/sftpuser/uploads/ ``` ## Verify Files Are Uploaded Check if files are in the SFTP server: ```bash docker exec pm_sftp_server ls -la /home/sftpuser/uploads/ ``` You should see: ``` -rw-r--r-- 1 sftpuser sftpuser <size> example_1.xml -rw-r--r-- 1 sftpuser sftpuser <size> example_2.xml ``` ## Test SFTP Connection Test the connection manually: ```bash sftp -P 2222 sftpuser@localhost # Password: password ``` ## Troubleshooting ### SFTP server not running ```bash docker-compose up -d sftp_server docker ps | grep pm_sftp_server ``` ### Permission denied Make sure you're in the project root directory where `example_1.xml` and `example_2.xml` exist. ### Files not visible Check the uploads directory: ```bash docker exec pm_sftp_server ls -la /home/sftpuser/uploads/ ``` ### Connection refused Make sure port 2222 is not in use: ```bash lsof -i :2222 ``` ## Next Steps After uploading files: 1. Start the job server (it will fetch files automatically): ```bash docker-compose up -d job_server ``` 2. Check job server logs: ```bash docker logs pm_job_server ``` 3. Access the frontend to query the data: ``` http://localhost:8501 ```