Good news ! Email Notifications for new content and comments

Submitted by Pierre_Admin on 2010/11/04 15:40
Good news IQ Users !
 
You can now subscribe to new posts and comments. To enable this,
  1. goto your My Account page
  2. A new tab is added: My notifications settings
  3. Specify your settings and click Save Settings
I've set this on a 15 minutes timer
 
You'll receive an email looking something like this:
[quote]
Greetings Pierre_Admin,

------------------------------------------------------------------------------
Recent comments - 1 new comment
------------------------------------------------------------------------------

1 new comment attached to Forums posted by reesd: forum slow
   1. Re: forum slow by Pierre_Admin
     http://www.sqlnotes.net/drupal5/index.php?q=node/1964#comment-8953

Trying to synchronize with external database.

Submitted by william_wicker on 2010/11/03 16:17
I've tried to adapt the supplied example to my own database situation, but I'm having no luck.
 
Here's my version of the SQLSynch.xml file: (connection string redacted for paranoia reasons)
 
<ConnectionString>Provider=SQLNCLI10;PWD=xxxx;UID=xxxx;DATABASE=xxxx;SERVER=xxxx\SQLEXPRESS
</ConnectionString>

<Password></Password>
<FieldMap>
[ID] VJS_PartNumber
[description] Item
[record_modified] VJS_DateModified
[mfg_name]ManufacturerName
[mfg_part_id]ManufacturerPartNum
-1 VJS_Parts
IMPORT VJS_SQLStatus
</FieldMap>
<Source>
SELECT ID, description, record_modified, mfg_name, mfg_part_id
FROM inventory_part
WHERE inactive = 0
and (record_modified > convert(datetime, '[DateUpdate]', 102))

</source>

auto-assign on ItemCreated (M)

Submitted by reesd on 2010/11/03 11:24
Can you put an auto-assign rule on ItemCreated? I tried the following auto-assignment rule on ItemCreated. This didn’t seem to do anything. I suspect because ItemCreated is special and auto-assignment rules do not fire for it.
AM:ItemDate=ItemCreated

PS, I wasn’t able to add a row equation to ItemCreated (Row Equation box will not allow me to type in it). Perhaps the auto-assign box should be disabled also?

Thanks,
d
 

when are row equations run?

Submitted by reesd on 2010/11/03 11:22
I seem to be missing something about when row equations are run. Let me walk through some things I tried, and perhaps someone can tell me why they didn’t work. Then I can update the row equations wiki page that I helped write in the first place :).

I created a new date field called ItemDate. I added the following to ItemDate and clicked recalculate. This did nothing. Perhaps because none of the items had this field (and therefore its row equation isn’t run)?
ItemDate = now()

So next I decided to add the Row Equation to another field I knew the items had, a text field I have called BatchArea. I hit recalculate. This did nothing either.
ItemDate = now()

So maybe I just am missing something with dates, so I tried this simple row equation in BatchArea. Hitting recalculate did nothing. Editing the batchArea field on an individual item did nothing either.
TaskID = 22

<SOLVED> Add-item dialog : "sync properties pane" option is not robust enough

Submitted by Armando on 2010/11/02 16:50
Context : Add-item dialog,  "sync properties pane" option is checked.
 
Problem : If there's an opened grid at the same time I'm editing the "just added" item ("add item" dialog is still opened) in the properties pane, the values there constantly revert to the one belonging to the item that has the focus in the current grid.
 
This is an old problem and it needs to be fixed for this feature to be useful and... Less dangerous. The focus should never revert to the grid, unless the user intentionally clicks in the grid or presses F9.

<SOLVED> Grid editing headaches

Submitted by william_wicker on 2010/11/02 15:21
I'm running 0.9.25C and have a few gripes about data entry into the grid. These are not fatal, but every time I hit one, I'm reminded that this is not yet commercial-duty software. In no particular order:
 
1) When caps lock is on and I begin entering data into a blank cell, the first letter is converted to lower case. llIKE THIS. Backspacing and retyping lets me get the all-caps I want. At first I thought this was an over-enthusiastic auto-capitalizer, but there is no corresponding auto-uppercasing of data entered in all lower case.
 
2) Pushing F2 to edit a highlighted cell puts the cursor in a random place. Actually, I think it's the place it was in the last cell edited. Putting the cursor all the way to one end or the other every time would be much better.
 
3) Clicking on text in a cell inconsistently either highlights the cell or enters text-editing mode.