Setting Modify Date to a column from DBWalker

Post Reply
pcapel
Posts: 4
Joined: Tue Dec 04, 2007 3:07 pm

Setting Modify Date to a column from DBWalker

Post by pcapel »

I have a profile that uses DBWalker to index a table. I am trying to figure out how to get my date_modified column from the table into the Modify Date field for the search results. I have tried every combination of Additional Fields and Data from Fields that i can think of, but no luck. If anyone can help, it would be greatly appreciated.
User avatar
jason112
Site Admin
Posts: 347
Joined: Tue Oct 26, 2004 5:35 pm

Setting Modify Date to a column from DBWalker

Post by jason112 »

You don't need any profile walk settings to get this - the best way is to use an XSL on the DBWalker to make the data you want be the _real_ HTML modified date, and then the appliance will accept it as the modified date automatically.

See the default stylesheet for DBWalker, which gives examples for setting "keywords" and "description" meta tags; the difference is you'll be using <meta http-equiv="last-modified" ...> instead of <meta name="keywords" ....>
pcapel
Posts: 4
Joined: Tue Dec 04, 2007 3:07 pm

Setting Modify Date to a column from DBWalker

Post by pcapel »

Yes, i tried this method as well.

The resulting html looks like this:
<meta http-equiv="last-modified" content="2009-01-12 11:25:30.473">

However, when viewing the match info on the result, it looks like this:
Modified: 2009-01-14 10:58:15

Any thoughts?
pcapel
Posts: 4
Joined: Tue Dec 04, 2007 3:07 pm

Setting Modify Date to a column from DBWalker

Post by pcapel »

Ok, got it... turns out I can't have the milliseconds on the end of the date/time. It's working well without that there.

Thanks for the help.
User avatar
jason112
Site Admin
Posts: 347
Joined: Tue Oct 26, 2004 5:35 pm

Setting Modify Date to a column from DBWalker

Post by jason112 »

Post Reply