Sawmill
Download Sawmill 8.6.1
30 Days Free Trial
Home Products Downloads Purchase Support About About
Sawmill Sawmill

SAWMILLFORUM

Sawmill Discussion Forum

Subject: "Countries Cities and Regions"     Previous Topic | Next Topic
Printer-friendly copy    
Conferences Pre-Sales Topic #839
Reading Topic #839
WilliamD
Member since Apr-10-13
9 posts
Apr-10-13, 09:57 AM (PDT)
Click to EMail WilliamD Click to send private message to WilliamD Click to add this user to your buddy list  
"Countries Cities and Regions"
 
   LAST EDITED ON Apr-10-13 AT 10:13 AM (PDT)
 
Hi,

In the Filter Section I have certain choices from a drop down menu. Can I add other choices? And if yes, how?

So I fooled around with the Report Options and editor and while regions is now part of the drp down menu, something I did displays

OB in the Region Column. All other colums are populated with information.

What I would like to be able to do is filter so I can see the country and the provice in Canada.

So I would need to undo what I did and then ????


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
SawmillSupportadmin
Member since Apr-10-13
Apr-10-13, 11:19 AM (PDT)
Click to EMail SawmillSupport Click to send private message to SawmillSupport Click to add this user to your buddy list  
1. "RE: Countries Cities and Regions"
In response to message #0
 
   Which "Filter Section" and drop down menu were you referring to? And what changes did you make in the report editor that you need undone? Might be easier to start over with a new profile.

Generally, if you want to customize a report to filter on a region (province) in Canada, you can duplicate a regions report in the report editor, name it something that identifies the region, click on the report element to edit it, and select the filter tab. Then click "Show Available Fields" to see the field name for your log format. For instance, in an Apache NCSA profile, the region field name used in filter expressions is "geo_region". So, if you wanted to filter on Quebec, the filter expression would be:

(geo_region within 'QC')

Since "QC" is how Quebec shows up in the reports. Clicking on "Expression help" opens a page that explains report filter syntax.


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
SawmillSupportadmin
Member since Apr-10-13
Apr-10-13, 11:35 AM (PDT)
Click to EMail SawmillSupport Click to send private message to SawmillSupport Click to add this user to your buddy list  
2. "RE: Countries Cities and Regions"
In response to message #1
 
   Just realized that my filter expression example was wrong. Quebec actually shows up in reports as "QC (Canada)", so that entire value needs to be used in the expression.

(geo_region within 'QC (Canada)')


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
WilliamD
Member since Apr-10-13
9 posts
Apr-11-13, 01:49 AM (PDT)
Click to EMail WilliamD Click to send private message to WilliamD Click to add this user to your buddy list  
3. "RE: Countries Cities and Regions"
In response to message #2
 
   Hi,

Whatever I did, I can not correct it and all region are showing OB.

My best bet seems to be to remove the software and reinstall. BUT because I am on a trial, if I re-register how will that affect my time limit?

Thank you,


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
WilliamD
Member since Apr-10-13
9 posts
Apr-11-13, 01:52 AM (PDT)
Click to EMail WilliamD Click to send private message to WilliamD Click to add this user to your buddy list  
4. "RE: Countries Cities and Regions"
In response to message #2
 
   I can not fix whatever it was I did to the region section. Is there a restore defualt option?

If not, i beleive removing and reinstalling is my only option. How will that affect my trial?

Thanks!


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
WilliamD
Member since Apr-10-13
9 posts
Apr-11-13, 07:00 AM (PDT)
Click to EMail WilliamD Click to send private message to WilliamD Click to add this user to your buddy list  
5. "RE: Countries Cities and Regions"
In response to message #4
 
   LAST EDITED ON Apr-11-13 AT 07:02 AM (PDT)
 
After my remove and reinstall the "old" profile was there even though deleted by windows remove software.

Anyways, I did purchase via Paypal and am waiting for license. The problem with the regions can be seen here:

img282.imagevenue.com/img.php?image=91619_Sawmill_Regions_122_159lo.jpg

Please let me know how i can fix that or restore defaults.

Appreciate all of your help


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top

Conferences | Topics | Previous Topic | Next Topic
© 2013 Flowerfire | Copyright | Privacy Policy | License Agreement | Terms of Use | Contact | Feedback | About
Sawmill Software
Sawmill Software
Back to Sawmill Home