The Linux Page | Linux Geek

Creating a Trigger in Drupal

I have been wondering, for a while, how the triggers where generated in Drupal. I know that one can catch a message by writing a hook function and you have hundreds of those available. However, how are the triggers working?!

The fact is that triggers require you to write a function. The Core Trigger module has a set of specialized functions for the Core modules and it is limited to that. In other words, you cannot expect new modules to simply define an array and get the triggers to work (I was really wondering how could that really work?!)

read more...
CSV format
A quick CSV (Comma Separated Values) reference:

1.0) 1) Row separator
```
  \n   \r\n
```
In order to separate lines, use a newline character sequence.

Most loaders probably support the \r sequence too. (Especially on MacOS/X)
Summary

1.0) 1) Row separator
Back to summary
read more...
CVS and really large files

Yesterday, I got a nice little surprise...

I inadvertendly added two copies of an uncompressed MS-Access data in my CVS. The files were over 400Mb (about 434Mb if I'm correct.) This started okay, then slowly I could see my memory going banana.

Wow! It took a good 20min. to check-in. My CVS is on my computer, so it is not the transfer that's slow... The fact is, the allocated a buffer for the entire file! My computer was on its knees!

read more...
Dates in MS-Access & QODBC
Working with MS-Access and writing SQL queries to run via QODBC to get data from QuickBooks, I ran in a problem with dates.

I needed to sum the sub-total of all the rows for a given year. So that is pretty simple SQL1:
```
SELECT SUM(subtotal) FROM Invoice WHERE YEAR(TimeCreated) = YEAR(NOW())
```
That does not work. So I tried to generate the year in the macro code and sticked that to the statement:
- 1. Although at first I tried with BETWEEN, I simplify my samples here
read more...
Deleting a database in Synergration

Synergration AccessBooksRT is a tool we use to get a copy of QuickBooks tables in an MS-Access database.

It works great for our purpose and transformed some super sluggish forms into lightning fast forms. We still use QODBC for some of the work (updates) but 99% now goes through the database generated by Synergration instead.

read more...
Do you know how to pronounce Linux?

Yes.

I have been around a lot of people and there are many who heard of Linux but to not know how to pronounce that word. I never thought it was complicated, that's a latin word, right?

So... maybe it is not "Lie neex"... Think about the "i" later and see how Italians, Spanish and French people pronounce it... Yes! The right way! You got it!

Anyway... for those in doubt, there is a file you can listen to:

read more...
Drupal Module installed but not installed?!

Last night I found a problematic module... Specifically, it was XML Sitemap, but I do not think it was specific to that module.

The problem? I lost the XML Sitemap menu. I could not access it at all. So I decided to run the update.php code to see whether that would wake it up. Did not work. Then I tried going in the Modules list and disabling the modules. Did not work! Wow! I could not disable these modules!!! How weird...

read more...
Drupal SimpleMenu & Javascript errors

Somehow, once in a while, I just don't get my navigation menu at the top of my screen.

I use the Drupal SimpleMenu module. It works in most cases, yet you have to make sure that your theme include the print $closure before the closing body tag. Something like this:

read more...
Drupal & the No Error Reported

Let's start with my rant!

I like Drupal, in general. But like most PHP code bases, if an "error" (mistake) occurs, nothing is reported.

I spent hours trying to make one of my menu work (Note that the "menu" module is also called the "links" module.) It just did not want to go. In order to have the nice breadcrumb and other such features, you need to have menus with sub-sub-menus...

read more...
.dylib extension missing

The other day, I created the odbcpp library. When I tried to build it on my Mac OS/X 10.4 (Tiger) I got a problem with the dynamic libraries. Instead of a .dylib extension, I got... nothing at all! (this problem was also reported on 10.5) I was sure that it worked for me with other libraries I developed (such as my sswf library) and thus I decided that I was not going to be left alone. Well...

read more...

Check this out!

Having problems with your WYSIWYG editor adding empty paragraphs?
Got people randomly adding empty lines everywhere in your posts?
Using modules that add info at the bottom of the page?

We have your solution: MO Paragraph trimmer filter to automatically
remove empty paragraphs from your Drupal website pages.