<SOLVED> When an item is created,Properties pane shows content from the previous item.

Submitted by Armando on 2010/11/05 09:25
I don't know if you noticed that when you fixed the HTML pane problem. But I just realised that the properties pane has the same problem.
(also had a few crashes when rapidly closing opening the panes)
 
[Pierre : I think we need another version ASAP to only address these few potentially "dangerous" bugs]

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
Subscribe to