Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

Import a List of Categories
Last Post 12/03/2010 10:17 PM by Peter Donker. 1 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
robj
New Member
New Member
Posts:1


--
12/02/2010 9:24 PM
We are migrating from a rudimentary, manual system to DMX. The issue we face is that there's a lot of upfront manual work that we would need to accomplish before we can fully use the built-in DMX tools. Is there a way to create a 400+ category list by importing an excel document? Any SQL gurus out there know a solution?

Thanks,
Rob
Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
12/03/2010 10:17 PM
Hi Rob,

If you can somehow generate the SQL it is not so complex. The DMX_Categories are what holds the "tree" with IDs, Parent ID, Vieworder and PortalID. Then in DMX_ShortTexts you add the record for each category with ObjectId=CategoryId, TypeKey="CAT" and SubTypeKey="NAME". That's it. That should bring them up in DMX.

Peter
You are not authorized to post a reply.