Apache visit log, match text order log

I have an order text log. I also have it imported in SQL and MS Access so you may chose if you prefer to do it in a database or work on the text log. Text log logs all system variables like timestamp, IP, and browser. Apache logs the referrers in the web access log, together with the same variables: timestamp, IP, browser - but apache also logs ALL pages accessed, which may include a path of referrers and accompanying time stamps. I'd like to match these two logs so that we get all data on each visit, thus seing the times and paths people ordering have used during their visit. The order log may contain more than one line for each order, these have a sessionID to identify them as a group of orders. Basically what we'd like is a copy of the Appache log, but with [login to view URL] appended in the beginning of each line IF there's an order, otherwise append "NO ORDER". And then have log sorted by visitor, thus we see a complete path for each visitor. System should be able to append new logs, though preferably not reimport logs, this can be check with timestamps in the logs. EXAMPLE RESULT TABLE [login to view URL] [login to view URL] (autoincrement? Whatever you prefer to identify as a visitor) Linenumber (incremental within each visit) [login to view URL] (blank if not in orderlog, actually a Linuxtimestamp+3digits) [login to view URL] remaing data for the line in the apache log OR [login to view URL] remaing data for the line in the apache log You may use the raw format of the logs, I've simplified in the example below. Example OUTPUT (very simplified) 01.01.2006 12:11:31|1|1|1434112|[login to view URL]|12:11:31|[login to view URL]|[login to view URL] etc. 01.01.2006 12:11:31|1|2|1434112|[login to view URL]|12:11:35|Name|Email| 01.01.2006 12:11:31|1|3|1434112|[login to view URL]|12:11:39|Name|Email|Street 01.01.2006 12:11:33|2|1|1434115|[login to view URL]|12:11:33|[login to view URL]|/[login to view URL] etc. 01.01.2006 12:11:33|2|2|1434115|[login to view URL]|12:11:36|Name|Email| I will attach complete log examoples. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows (source logs are created on Linux)