Custom table for file downloads embedded in query string

Cameron Webster

11 years ago
updated 11 years ago
Answered

Hi

I am trialling the software and see that the pro version allows you to create custom tables. The standard version is picking up certain downloads from our site ok, but it is ignoring other downloads where the filename is embedded in a query string on index.php.

So it would find CW-Product-Catalogue-13.5_A4_CH-Web.pdf from the GET below

113.3.233.6 - - [16/Jul/2013:11:52:05 +0100] "GET /documents/datasheets/CW-Product-Catalogue-13.5_A4_CH-Web.pdf HTTP/1.1" 200 21757022 "-" "www.Company.com" "Mozilla/5.0 (compatible; MSIE 6.0; Windows NT 5.0)"

but I'd like to find Company_cewBuildsp3-English.iso.exe from the query string below:

111.222.111.222 - - [16/Jul/2013:14:12:19 +0100] "GET /index.php?option=com_content&view=article&id=2061&dir=JSROOT%2FCompanycew4CD%2FcewBuildsp3%2FEnglish&download_file=JSROOT%2FCompanycew4CD%2FcewBuildsp3%2FEnglish%2FCompany_cewBuildsp3-English.iso.exe HTTP/1.1" 200 30408704 "http://www.company.com/cew4-installat..." "www.Company.com" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36"

How do I go about creating a custom table to search for specific file names as above?

Thanks

CW

Replies 9

Oldest first
Newest first Oldest first

Michael

11 years ago

You can create a table to show values of the download_file parameter. You can create a new table in Options > Report > Tables. When you add the table, you need to choose the "Query parameter value" as main data when you add the table, click the "Custom..." button to the right of this combo box, and enter download_file as parameter value.

There are also other custom table options available, e.g. you can modify the parameter using regular expressions, enable charts, etc. Please let me know if you need any help with such options.

Reply Link

Thanks

I've added a custom table as described but it does not show in the report. I've tried reanalysing and then deleting and remaking the report. Tried running as Professional and Enterprise version.

Am I missing an obvious checkbox somewhere?

Thanks

Cammy

You should check that this table is enabled in Options > Report > Contents, while it should be enabled by default. You should also check that you don't use custom report contents in Profile Properties > Report > Custom report contents, otherwise you need to enable the table here.

If it doesn't help, could you please send your settings to us at support@weblogexpert.com so we check them? You can save the settings using the File > Backup command.

Everything suggested looked OK so I've forwarded the settings to the support email addr.

Thanks

Cammy

The problem appears because in the "Query parameter value" custom settings (shown when you click the "Custom..." button) "download_file" is specified as custom field name, while it is to be specified as parameter name.

Got it.

Thanks for your help. Seeing the custom table now.

Hi

Is it possible to filter the results based on the query string returned from the parameter value?

Thanks

Cammy

I've managed to get close enough by excluding directories, although it has changed other results slightly which I don't understand, it will be good enough.

Thanks

Cammy

You can also use the "Query" filter, it allows you to specify parameter name and value.