Adding FileTypes and updating the database

Site
Web

Bring2mind Forums

Forums
Search Forum
Advanced SearchTopicsPosts

Forums > Document Exchange > User Interface

Adding FileTypes and updating the database

Last Post 11/22/2010 11:46 AM by Peter Donker. 3 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

Chrickel

New Member
Posts:44

11/12/2010 11:41 AM
Hi Peter, is there a way to auto-update the database after adding custom filetypes? By now I haven't found anything like this. Our workflow normally is to add a filetype AFTER noticing that its not yet recognized by DMX. After adding the filetype, I have to manually update the database like this: update DMX_Entries set EntryType = 'File.newfiletype" where OriginalFileName like '%.newextension' and PortalId = (ourportalid) Would be great to have that done in one sweep with adding the filetype. Cheers -Chris

Peter Donker

Veteran Member
Posts:4536

11/16/2010 6:23 PM
Hi Chris, Good point but this is not trivial. Indeed it should be possible to do this. I'll make a note of this. Peter

Chrickel

New Member
Posts:44

11/16/2010 6:27 PM
Hi Peter, maybe a (simple) trigger after insert/update could do the job? -Chris

Peter Donker

Veteran Member
Posts:4536

11/22/2010 11:46 AM
Hi Chris, Yes, that could be, but I can think of 3 reasons not to: 1. Triggers are to be avoided if possible (if something goes wrong the DB may become pretty locked) 2. Careful with automation. Some users may want more control. 3. Some repositories are huge. Processing ALL entries in DMX must be done carefully as you may get timeouts on larger installations. But I'm not saying that a trigger is not what I'll do. Just my first thoughts on this ... Peter

You are not authorized to post a reply.

Forums > Document Exchange > User Interface

About Bring2mind

Bring2mind is the company of Peter Donker, a DotNetNuke enthusiast who has been involved with the platform from the very beginning. At the same time as the market for modules emerged, he realized there was no good document management solution for the platform yet and he set about creating this. In part he based the module on his experience with other document management systems he used while working as a researcher. His module, Document Exchange, was an instant success and has since become the premier document management solution for DotNetNuke. In 2004 he created Bring2mind as a vehicle for the module and is one of the few successful businesses solely based on a DotNetNuke product.

Contact Info

Please note we are located in Europe. Business hours are weekdays between 9 AM and 6 PM local time (Central European Time) which corresponds to 3 AM and noon EST.