Forum OpenACS Q&A: Response to Clickstream solutions

Collapse
Posted by Nick Carroll on
Is there a file in the clickstream data warehouse that parses a web server log file, and creates another specially formatted file that can be used to load data into the database with the following sql load statement...
OPTIONS (DIRECT=true)
LOAD DATA
INFILE *
TRUNCATE
INTO TABLE cs_event_log
FIELDS TERMINATED BY X'09'
(event_id, event_time, end_time, date_id, url, instance_id, user_ip, user_id, query,
    content_type, bytes, session_id, browser_id, user_agent_string, accept_language, referring_url,
    method, status, secure_p)
BEGINDATA