A colleague at work today had some questions regarding Google Calendar that I attempted to assist him with. In the process I ran into some things that didn’t make a lot of sense to me so I wanted to point out some of the issues I found with importing Calendar Events into Google Calendar. Below I will explain the error I received and how I worked around the error and was able to successfully import the items I had been having an issue with.
When working on a project where I was required to merge two sets of like data to make sure there were not any conflicts I needed a way to dump PostgreSQL database tables to Excel formatted .CSV files. Anyhow dumping Postgres tables to excel is easy to do by following the below directions.
Google Docs is a great tool for storing spreadsheets and other documents because it provides an centralized storage space for all of your documents which can be shared with users and accessed from any where that has an Internet connection. One thing that can be really helpful when creating a Google Spreadsheet is having a unified format to the entire document. A format that can assist in making the data in the spreadsheet easier to read is alternating colors for every row. This way if you have lots of columns per row you can easily see which data belongs to each row. The directions below explain how to set up formatting for two rows and then apply that formatting to the rest of the Google spreadsheet.
Creating tables with the textile formatting used by Redmine is fairly easy though it is not listed in the help documentation link. It has been useful to me to create tables specifically in the wiki informational pages. Typically within the Redmine wiki I like to keep things simple so below I will only describe a couple attributes related to tables within textile formatting.
Table Example: three rows, three columns
Most of the logging options for LiteSpeed web server are very basic and general however I wanted to detail them to help others make educated decisions when it comes to the logging configuration. There is one option I use outside of the normal log configurations which is configured in a tab other than the log tab under server configuration. Below I will explain all of the configuration options and provide examples of what I recommend for LiteSpeed.
The very first thing I do when configuring a new server is to modify the “Disable Initial Log Rotation” option from “Not Set” to Yes. The purpose of this option is to make the lsws log file directory a bit more manageable. The Disable Initial Log Rotation option will stop the error.log file from being rotated every time the server is restarted. If you are on a development server this might happen numerous times a day thus creating a mess in your log directory. Instead I only rotate the error.log file based on size as described in detail below.