If your email provider is not delivering the exported transaction logs, you may download them directly to your computer via SCP as described below.
Installing the scripts
First, download and install some extended scripts with this command:
curl https://raw.githubusercontent.com/naconner/lamascripts/master/logs/download.sh | bash
Exporting the log files
The commands it adds are:
These will save the latest logs as a spreadsheet in your server's /tmp folder.
For example, to export cash-in transaction logs from the database, run:
Saved to /tmp/cash_in_txs.csv
Downloading the log files
Linux / Mac OS
If the computer you use to access your server is running Linux or Mac OS, you can use scp to download the logs directly.
Within your computer's terminal (not your server terminal), run, replacing 18.104.22.168 with the IP of your droplet, and replacing 'cash_in_txs.csv' with the name of the file you just exported :
scp email@example.com:/tmp/cash_in_txs.csv ~/cash_in_txs.csv
It will prompt for the same passphrase that you use to connect to your droplet via SSH. The command will download the log file to your home directory.
Run the above for each log you exported, replacing 'cash_in_txs.csv' above with the appropriate file name. Examples for cash-out and bills:
scp firstname.lastname@example.org:/tmp/cash_out_txs.csv ~/cash_out_txs.csv
scp email@example.com:/tmp/bills.csv ~/bills.csv
Download and install the program WinSCP. When it offers to copy your settings from PuTTY, say yes.
You should see your existing server(s) now listed in WinSCP. Highlight your next-gen server, click Edit, then select the method 'SCP', enter 'root' as your user, leave password as blank.
Click Advanced. Under SSH > Authentication, select the path to your private SSH key file (ending in .ppk).
Click OK, click Save, then Login.
On the right side, double click on the /tmp folder in your server, where you'll find each exported log file.
Download them to your computer by dragging them to the desired folder on the left side.