Automatic backup of user database ?

[mfleury]

Hello to all happy users of firstspot,

I look for a way to make the export of the users database to the userdata.csv file automatic (like when you click on "export all" on the users tab).
The idea is to have a program exporting it automatically, let say, every 24 hours.
Command line, or any specific program, any idea would be more than welcome.

Thanks a lot

Matthieu, from Tahiti

[gsgriffin]

Mattieu,

You bring up a good request and one that I just said to myself, "of course, why am I not doing that!" I adapted the script and put in a couple little notes that you can adjust if you want it to do something slightly different.

In short, put this script into its own file your cnfmgr folder. Save the file as anything you want .php. Call up the script through IE and windows scheduler. The script will run through and backup your user info immediately and then done. Just in case, call it at http://localhost:5787/whatever.php

Keep in mind that anyone logged into your system that can figure out the port of 5787 can run this script. That may not be a big security risk, but it is not password protected like the rest of the cnfmgr files. That is on purpose so you don't have to log in.


<?php

include_once("..\\authserv\\common_functions.php");

$settingobj = new COM('FSCONFIG.Cfgmgr') or die('settingok.php FSCONFIG.Cfgmgr Object cannot be created!');
$Datasource_Tablename=$settingobj->getKey('Datasource_Tablename', 'gateway');
$Datasource_Plans_Tablename=$settingobj->getKey('Datasource_Plans_Tablename', 'gateway');
$Datasource_PayPal_Table=$settingobj->getKey('Datasource_PayPal_Table', 'gateway');
$Datasource_Url_Tablename=$settingobj->getKey('Datasource_URL_Log_Tablename', 'gateway');
//free COM object
$settingobj->Release();
$settingobj=null;

//*******************************************************************************************************************
// Change the following value to whatever you desire to be exporting
$table='user';
//I wouldn't advise making the import function automatic. Doing so with the program running can and will cause corruption to the Db
//allow only one of the following lines to run. $export will export only the file as you designate in the line above. Export all will backup all user, plan, cc, and url data at the same time
$export='true';
$exportall='true';

if (isset($table) && $table == 'user')
$exportImportFile='userdata.csv';
if (isset($table) && $table == 'plan')
$exportImportFile='plandata.csv';
if (isset($table) && $table == 'cc')
$exportImportFile='ccdata.csv';
if (isset($table) && $table == 'url')
$exportImportFile='urldata.csv';

if (isset($export)) {
if (isset($table) && $table == 'user')
$Datasource = $Datasource_Tablename;
if (isset($table) && $table == 'plan')
$Datasource = $Datasource_Plans_Tablename;
if (isset($table) && $table == 'cc')
$Datasource = $Datasource_PayPal_Table;
if (isset($table) && $table == 'url')
$Datasource = $Datasource_Url_Tablename;

$msg = exportDB($exportImportFile, $table, $Datasource);
} else if (isset($exportall)) {
$table = 'user';
$exportImportFile='userdata.csv';
$Datasource = $Datasource_Tablename;
$msg = exportDB($exportImportFile, $table, $Datasource);
$table = 'plan';
$exportImportFile='plandata.csv';
$Datasource = $Datasource_Plans_Tablename;
$msg .= '<br>'.exportDB($exportImportFile, $table, $Datasource);
$table = 'cc';
$exportImportFile='ccdata.csv';
$Datasource = $Datasource_PayPal_Table;
$msg .= '<br>'. exportDB($exportImportFile, $table, $Datasource);
$table = 'url';
$exportImportFile='urldata.csv';
$Datasource = $Datasource_Url_Tablename;
$msg = '<br>'. exportDB($exportImportFile, $table, $Datasource);
}
echo $msg;
?>


<script type='text/javascript'>
self.window.close()
</script>
_________________
Greg

[mfleury]

Hey Greg, thanks a lot, i'm going to try that really fast !

Best Regards,

Matt

[mfleury]

I would know how to import the csv file as well.

[gsgriffin]

I wouldn't try to automate the importing of the CSV. Go to the Config Mgr and login. Go to the Users tab and scroll down to the bottom. There is a database selection box and then import/export buttons. Find the CSV you want to import and then click IMPORT. Make sure that the CSV is in your main FirstSpot folder. That is where it will automatically look.
_________________
Greg