import csv import os from datetime import datetime from md5 import md5 import sys def main(argv): if argv[1]: COL_ID = int(argv[1]) else: COL_ID = 1 if argv[2]: LVA_ID = int(argv[2]) else: LVA_ID = COL_ID SITE_ID = 1 LOCAL_TIME = "00:00:00" VISITOR_RETURNING = 0 GA_ACTION_URL = 1 GA_ACTION_NAME = 1 TOTAL_ACTIONS = 1 VISIT_TOTAL_TIME = 10 GOAL_CONVERT = 0 REFERER_TYPE = 1 CONFIG_OS = "GA" CONFIG_BROWSER = "GA" CONFIG_B_VER = "0.1" CONFIG_RES = "1600x1200" CONFIG_MD5 = md5(CONFIG_BROWSER+CONFIG_OS+CONFIG_RES).hexdigest() LOCATION_IP = "168450866" BROWSER_LANG = "en-gb" LOCATION_COUNTRY = "gb" LOCATION_CONTINENT = "eur" LOCATION_PROVIDER = "GA Import" data = csv.reader(open(argv[0])) piwik_output = [csv.writer(open('log_visit-'+argv[0], 'w')), csv.writer(open('log_vaction-'+argv[0], 'w'))] for row in data: hits = int(row[1].replace(',', '')) for i in range(0, hits): cookie = md5(datetime.now().__str__()).hexdigest() action_time = row[0] + LOCAL_TIME output = [COL_ID, SITE_ID, action_time, cookie, VISITOR_RETURNING, action_time, action_time, row[0], GA_ACTION_URL, GA_ACTION_NAME, TOTAL_ACTIONS, VISIT_TOTAL_TIME, GOAL_CONVERT, REFERER_TYPE, None, None, None, CONFIG_MD5, CONFIG_OS, CONFIG_BROWSER, CONFIG_B_VER, CONFIG_RES, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, LOCATION_IP, BROWSER_LANG, LOCATION_COUNTRY, LOCATION_CONTINENT, LOCATION_PROVIDER ] (piwik_output[0]).writerow(output) output = [LVA_ID, COL_ID, GA_ACTION_URL, 0, GA_ACTION_NAME, 0] (piwik_output[1]).writerow(output) COL_ID += 1 LVA_ID += 1 if __name__ == "__main__": main(sys.argv[1:])