[GDCBDE][2019-05-13 12:23:45] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3] [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Using data folder:...www/html/api/_godrive_data/db_cache [GDCBDE][2019-05-13 12:23:45] [SQLHLP] ODBC Conn try 1: DRIVER={ODBC Driver 17 for SQL Serv... [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Connection created on 37.251.139.87 [GDCBDE][2019-05-13 12:23:45] LOGfile: /var/www/html/api/_godrive_dat [GDCBDE][2019-05-13 12:23:45] Work folder: [/var/www/html/api/_godrive_data] [GDCBDE][2019-05-13 12:23:45] INIT DATA EXPLORER v0.1.1 [GDCBDE][2019-05-13 12:23:45] Setup predictors and raw data repo... [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Loading file [../SELECT_TOP_1000000_FROM_Codes_.csv] ... [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 134 rows [GDCBDE][2019-05-13 12:23:45] Loaded 134 predictors [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ... [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 1 rows [GDCBDE][2019-05-13 12:23:45] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'DeviceSN'] [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Loading file [..e/SELECT_TOP_1000000_FROM_Cars_.csv] ... [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 118 rows [GDCBDE][2019-05-13 12:23:45] Loaded 118 cars [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Loading file [..LECT_TOP_1000000_FROM_Accounts_.csv] ... [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2019-05-13 12:23:45] Loaded 3 accounts [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ... [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 118 rows [GDCBDE][2019-05-13 12:23:45] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID'] [GDCBDE][2019-05-13 12:23:45] Done data preparation. [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ra..] ... [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:23:45] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Dataset loaded: 68.66MB in 37.3s(0.6m) 1000000 rows [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ac..] ... [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 3 rows [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ca..] ... [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Dataset loaded: 0.01MB in 0.0s(0.0m) 118 rows [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Co..] ... [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Dataset loaded: 0.01MB in 0.1s(0.0m) 134 rows [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Downloading data [SELECT TOP(1000000) * FROM [Ca..] ... [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Check connection [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Connection ok [GDCBDE][2019-05-13 12:24:22] [SQLHLP] Dataset loaded: 0.02MB in 0.0s(0.0m) 519 rows [GDCBDE][2019-05-13 12:24:22] ....Trying to associate code and description columns to df_rawdata_toshow [GDCBDE][2019-05-13 12:24:23] Finished associating columns [GDCBDE][2019-05-13 14:58:35] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-05-13 14:58:35] [SQLHLP] Check connection [GDCBDE][2019-05-13 14:58:35] [SQLHLP] Connection ok [GDCBDE][2019-05-13 14:58:35] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows [GDCBDE][2019-05-15 04:08:54] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-05-15 04:08:54] [SQLHLP] Check connection [GDCBDE][2019-05-15 04:08:54] [SQLHLP] Connection ok [GDCBDE][2019-05-15 04:08:54] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-06-09 08:10:15] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-06-09 08:10:15] [SQLHLP] Check connection [GDCBDE][2019-06-09 08:10:15] [SQLHLP] Connection ok [GDCBDE][2019-06-09 08:10:15] [SQLHLP] Dataset loaded: 0.00MB in 0.2s(0.0m) 0 rows [GDCBDE][2019-06-11 16:41:17] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-06-11 16:41:17] [SQLHLP] Check connection [GDCBDE][2019-06-11 16:41:17] [SQLHLP] Connection ok [GDCBDE][2019-06-11 16:41:17] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-06-18 15:01:29] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-06-18 15:01:29] [SQLHLP] Check connection [GDCBDE][2019-06-18 15:01:29] [SQLHLP] Connection ok [GDCBDE][2019-06-18 15:01:29] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-06-19 04:51:05] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-06-19 04:51:05] [SQLHLP] Check connection [GDCBDE][2019-06-19 04:51:05] [SQLHLP] Connection ok [GDCBDE][2019-06-19 04:51:05] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-06-19 17:35:57] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-06-19 17:35:57] [SQLHLP] Check connection [GDCBDE][2019-06-19 17:35:57] [SQLHLP] Connection ok [GDCBDE][2019-06-19 17:35:57] [SQLHLP] Dataset loaded: 0.00MB in 0.2s(0.0m) 0 rows [GDCBDE][2019-06-23 03:24:54] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-06-23 03:24:54] [SQLHLP] Check connection [GDCBDE][2019-06-23 03:24:54] [SQLHLP] Connection ok [GDCBDE][2019-06-23 03:24:54] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-06-27 15:53:01] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-06-27 15:53:01] [SQLHLP] Check connection [GDCBDE][2019-06-27 15:53:01] [SQLHLP] Connection ok [GDCBDE][2019-06-27 15:53:01] [SQLHLP] Dataset loaded: 0.00MB in 0.2s(0.0m) 0 rows [GDCBDE][2019-06-29 16:52:58] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-06-29 16:52:58] [SQLHLP] Check connection [GDCBDE][2019-06-29 16:52:58] [SQLHLP] Connection ok [GDCBDE][2019-06-29 16:52:58] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-07-04 11:45:15] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-07-04 11:45:15] [SQLHLP] Check connection [GDCBDE][2019-07-04 11:45:15] [SQLHLP] Connection ok [GDCBDE][2019-07-04 11:45:16] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-07-06 08:31:24] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-07-06 08:31:24] [SQLHLP] Check connection [GDCBDE][2019-07-06 08:31:24] [SQLHLP] Connection ok [GDCBDE][2019-07-06 08:31:24] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-07-06 10:05:38] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-07-06 10:05:38] [SQLHLP] Check connection [GDCBDE][2019-07-06 10:05:38] [SQLHLP] Connection ok [GDCBDE][2019-07-06 10:05:38] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-07-12 23:58:52] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-07-12 23:58:52] [SQLHLP] Check connection [GDCBDE][2019-07-12 23:58:52] [SQLHLP] Connection ok [GDCBDE][2019-07-12 23:58:52] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-07-14 22:09:40] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-07-14 22:09:40] [SQLHLP] Check connection [GDCBDE][2019-07-14 22:09:40] [SQLHLP] Connection ok [GDCBDE][2019-07-14 22:09:40] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-07-18 21:52:41] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-07-18 21:52:41] [SQLHLP] Check connection [GDCBDE][2019-07-18 21:52:41] [SQLHLP] Connection ok [GDCBDE][2019-07-18 21:52:41] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-07-21 00:31:32] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-07-21 00:31:32] [SQLHLP] Check connection [GDCBDE][2019-07-21 00:31:32] [SQLHLP] Connection ok [GDCBDE][2019-07-21 00:31:32] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-07-30 14:14:49] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-07-30 14:14:49] [SQLHLP] Check connection [GDCBDE][2019-07-30 14:14:49] [SQLHLP] Connection ok [GDCBDE][2019-07-30 14:14:49] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-07-30 22:24:33] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-07-30 22:24:33] [SQLHLP] Check connection [GDCBDE][2019-07-30 22:24:33] [SQLHLP] Connection ok [GDCBDE][2019-07-30 22:24:33] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-08-02 20:57:02] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-08-02 20:57:02] [SQLHLP] Check connection [GDCBDE][2019-08-02 20:57:02] [SQLHLP] Connection ok [GDCBDE][2019-08-02 20:57:02] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-08-08 23:49:41] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-08-08 23:49:41] [SQLHLP] Check connection [GDCBDE][2019-08-08 23:49:41] [SQLHLP] Connection ok [GDCBDE][2019-08-08 23:49:41] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-08-09 17:53:35] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-08-09 17:53:35] [SQLHLP] Check connection [GDCBDE][2019-08-09 17:53:35] [SQLHLP] Connection ok [GDCBDE][2019-08-09 17:53:35] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-08-14 18:07:34] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-08-14 18:07:34] [SQLHLP] Check connection [GDCBDE][2019-08-14 18:07:34] [SQLHLP] Connection ok [GDCBDE][2019-08-14 18:07:34] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-08-18 00:35:10] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-08-18 00:35:10] [SQLHLP] Check connection [GDCBDE][2019-08-18 00:35:10] [SQLHLP] Connection ok [GDCBDE][2019-08-18 00:35:10] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-08-18 23:11:22] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-08-18 23:11:22] [SQLHLP] Check connection [GDCBDE][2019-08-18 23:11:22] [SQLHLP] Connection ok [GDCBDE][2019-08-18 23:11:22] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-08-20 07:46:29] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-08-20 07:46:29] [SQLHLP] Check connection [GDCBDE][2019-08-20 07:46:29] [SQLHLP] Connection ok [GDCBDE][2019-08-20 07:46:29] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-08-21 15:27:58] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-08-21 15:27:58] [SQLHLP] Check connection [GDCBDE][2019-08-21 15:27:58] [SQLHLP] Connection ok [GDCBDE][2019-08-21 15:27:58] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-08-22 16:34:02] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-08-22 16:34:02] [SQLHLP] Check connection [GDCBDE][2019-08-22 16:34:02] [SQLHLP] Connection ok [GDCBDE][2019-08-22 16:34:02] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-08-23 07:40:43] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-08-23 07:40:43] [SQLHLP] Check connection [GDCBDE][2019-08-23 07:40:43] [SQLHLP] Connection ok [GDCBDE][2019-08-23 07:40:43] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-08-24 15:19:24] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-08-24 15:19:24] [SQLHLP] Check connection [GDCBDE][2019-08-24 15:19:24] [SQLHLP] Connection ok [GDCBDE][2019-08-24 15:19:24] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-09-02 20:13:54] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-09-02 20:13:54] [SQLHLP] Check connection [GDCBDE][2019-09-02 20:13:54] [SQLHLP] Connection ok [GDCBDE][2019-09-02 20:13:54] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-09-03 00:43:07] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-09-03 00:43:07] [SQLHLP] Check connection [GDCBDE][2019-09-03 00:43:07] [SQLHLP] Connection ok [GDCBDE][2019-09-03 00:43:07] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows [GDCBDE][2019-09-04 01:38:51] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-09-04 01:38:51] [SQLHLP] Check connection [GDCBDE][2019-09-04 01:38:51] [SQLHLP] Connection ok [GDCBDE][2019-09-04 01:38:51] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-09-09 05:00:09] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-09-09 05:00:09] [SQLHLP] Check connection [GDCBDE][2019-09-09 05:00:09] [SQLHLP] Connection ok [GDCBDE][2019-09-09 05:00:09] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-09-11 03:08:10] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-09-11 03:08:10] [SQLHLP] Check connection [GDCBDE][2019-09-11 03:08:10] [SQLHLP] Connection ok [GDCBDE][2019-09-11 03:08:10] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-09-13 21:50:22] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-09-13 21:50:22] [SQLHLP] Check connection [GDCBDE][2019-09-13 21:50:22] [SQLHLP] Connection ok [GDCBDE][2019-09-13 21:50:22] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-09-14 02:07:23] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-09-14 02:07:23] [SQLHLP] Check connection [GDCBDE][2019-09-14 02:07:23] [SQLHLP] Connection ok [GDCBDE][2019-09-14 02:07:23] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-09-17 22:28:41] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-09-17 22:28:41] [SQLHLP] Check connection [GDCBDE][2019-09-17 22:28:41] [SQLHLP] Connection ok [GDCBDE][2019-09-17 22:28:41] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-09-17 22:28:42] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-09-17 22:28:42] [SQLHLP] Check connection [GDCBDE][2019-09-17 22:28:42] [SQLHLP] Connection ok [GDCBDE][2019-09-17 22:28:42] [SQLHLP] Dataset loaded: 0.00MB in 0.0s(0.0m) 0 rows [GDCBDE][2019-09-20 09:42:02] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-09-20 09:42:02] [SQLHLP] Check connection [GDCBDE][2019-09-20 09:42:02] [SQLHLP] Connection ok [GDCBDE][2019-09-20 09:42:03] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-09-27 22:49:55] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-09-27 22:49:55] [SQLHLP] Check connection [GDCBDE][2019-09-27 22:49:55] [SQLHLP] Connection ok [GDCBDE][2019-09-27 22:49:55] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-10-03 00:54:13] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-10-03 00:54:13] [SQLHLP] Check connection [GDCBDE][2019-10-03 00:54:13] [SQLHLP] Connection ok [GDCBDE][2019-10-03 00:54:14] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows [GDCBDE][2019-10-04 04:09:47] [SQLHLP] Downloading data [SELECT ID, Adresa_email FROM U..] ... [GDCBDE][2019-10-04 04:09:47] [SQLHLP] Check connection [GDCBDE][2019-10-04 04:09:47] [SQLHLP] Connection ok [GDCBDE][2019-10-04 04:09:47] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 0 rows