Re: CF-Based Content Management Systems
Definitely Mura. When I first tried it, it took me about 15 or 20 minutes to get up and running, and most of that time was setting up the database twice (fudged it the first time). regards, larry -- Larry C. Lyons web: http://www.lyonsmorris.com/lyons LinkedIn: http://www.linkedin.com/in/larryclyons -- The real problem is not whether machines think but whether men do. - B. F. Skinner - >Hands down... >http://www.getmura.com/ > >Good afternoon everyone, > >I just got off of the phone with a client that is considering using a >content management system (CMS) to manage her Web site. The developer she >hired to redesign her pages suggested using an Adobe product to insure that >the CMS is robust and to be sure all features are accessible by disabled >site visitors and managers. She also wishes to include a site blog as well. >I believe there is CF blogging software and would appreciate some >recommendations and sources for obtaining CF cms and blogging packages. >Thanks in advance for your assistance. > >Peter Donahue ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331887 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF-Based Content Management Systems
On Thu, Mar 18, 2010 at 6:46 PM, Dave Watts wrote: > >> I've never used farcry but I know it is the best CFCMS out there. > > How can you possibly know that? ESP? -- To dwell is to garden. Martin Heidegger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331880 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF-Based Content Management Systems
> I've never used farcry but I know it is the best CFCMS out there. How can you possibly know that? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331875 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF-Based Content Management Systems
> I just got off of the phone with a client that is considering using a > content management system (CMS) to manage her Web site. The developer she > hired to redesign her pages suggested using an Adobe product to insure that > the CMS is robust and to be sure all features are accessible by disabled > site visitors and managers. She also wishes to include a site blog as well. > I believe there is CF blogging software and would appreciate some > recommendations and sources for obtaining CF cms and blogging packages. > Thanks in advance for your assistance. Adobe doesn't make any CF CMS. There are many third-party CF CMS products, though. Some, like Far Cry, provide you with additional language commands that you can use to build your CMS. Others, like CommonSpot, provide you with an "out of the box" template mechanism that you can modify for your CMS. Some are free, others are pretty expensive. So, you'll want to figure out how much time you want to spend customizing the CMS, and/or how much money you want to spend on canned functionality. You can certainly build 508-compliant CMSs with any of these tools, but you will be responsible for that yourself in most cases. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsit ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331874 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF-Based Content Management Systems
What? You guys have never heard of iMIS before. Talk about overhead. They moved it onto a .NET platform recently and it was really too much overhead. I've never used farcry but I know it is the best CFCMS out there. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331870 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF-Based Content Management Systems
I guess FarCry is the biggest, meanest CF-CMS-machine out there, but also the most overhead. Mura can do a lot for you, but might also be overkill. Why not see of BlogCFC or MangoBlog can do the thing your client wishes? Anything Adobe might also mean "as long as it's a CFML-product", so anything that runs on Railo as well is a good option. Try to see how small you can start before falling into the overloaded CF-CMS's. And if you can specify more, might I also suggest our small, but excellent Onlinebase CMS? It's a SAAS app, situated on servers in the Netherlands and England, but available for all our customers whereever in the world they might be ;-) Sebastiaan Naafs - van Dijk http://onlinebase.nl/ _ Nye Windows 7: PCen som passer for deg. Finn ut mer. http://windows.microsoft.com/shop ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF-Based Content Management Systems
Peter Donahue wrote: > > Good afternoon everyone, > > I just got off of the phone with a client that is considering using a > content management system (CMS) to manage her Web site. The developer she > hired to redesign her pages suggested using an Adobe product to insure that > the CMS is robust and to be sure all features are accessible by disabled > site visitors and managers. She also wishes to include a site blog as well. > I believe there is CF blogging software and would appreciate some > recommendations and sources for obtaining CF cms and blogging packages. > Thanks in advance for your assistance. I can't speak to the CF tools part of your question, but is sounds like they want something 508 compliant. You would need to do some analysis of the packages to see how they meet the accessibility regulations. Writing for the disabled isn't something a lot of prepackaged systems do well. -- http://www.linkedin.com/pub/roger-austin/8/a4/60 http://twitter.com/RogerTheGeek http://www.misshunt.com/ Home of the Clean/Dirty Magnet http://www.ncdevcon.com/ TACFUG 2010 Conference in North Carolina ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF-Based Content Management Systems
You can't go wrong with Farcry as well. -Original Message- From: Jake Churchill [mailto:reyna...@gmail.com] Sent: Thursday, March 18, 2010 4:42 PM To: cf-talk Subject: Re: CF-Based Content Management Systems Definitely go with Farcry. http://www.farcrycms.org. There is a blogging plugin for it as well. -Jake On Thu, Mar 18, 2010 at 3:29 PM, Peter Donahue wrote: > > Good afternoon everyone, > >I just got off of the phone with a client that is considering using > a content management system (CMS) to manage her Web site. The > developer she hired to redesign her pages suggested using an Adobe > product to insure that the CMS is robust and to be sure all features > are accessible by disabled site visitors and managers. She also wishes to include a site blog as well. > I believe there is CF blogging software and would appreciate some > recommendations and sources for obtaining CF cms and blogging packages. > Thanks in advance for your assistance. > > Peter Donahue > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF-Based Content Management Systems
Hands down... http://www.getmura.com/ -Original Message- From: Peter Donahue [mailto:pdonah...@sbcglobal.net] Sent: Thursday, March 18, 2010 4:30 PM To: cf-talk Subject: CF-Based Content Management Systems Good afternoon everyone, I just got off of the phone with a client that is considering using a content management system (CMS) to manage her Web site. The developer she hired to redesign her pages suggested using an Adobe product to insure that the CMS is robust and to be sure all features are accessible by disabled site visitors and managers. She also wishes to include a site blog as well. I believe there is CF blogging software and would appreciate some recommendations and sources for obtaining CF cms and blogging packages. Thanks in advance for your assistance. Peter Donahue ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF-Based Content Management Systems
Definitely go with Farcry. http://www.farcrycms.org. There is a blogging plugin for it as well. -Jake On Thu, Mar 18, 2010 at 3:29 PM, Peter Donahue wrote: > > Good afternoon everyone, > >I just got off of the phone with a client that is considering using a > content management system (CMS) to manage her Web site. The developer she > hired to redesign her pages suggested using an Adobe product to insure that > the CMS is robust and to be sure all features are accessible by disabled > site visitors and managers. She also wishes to include a site blog as well. > I believe there is CF blogging software and would appreciate some > recommendations and sources for obtaining CF cms and blogging packages. > Thanks in advance for your assistance. > > Peter Donahue > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331865 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF-Based Content Management Systems
Good afternoon everyone, I just got off of the phone with a client that is considering using a content management system (CMS) to manage her Web site. The developer she hired to redesign her pages suggested using an Adobe product to insure that the CMS is robust and to be sure all features are accessible by disabled site visitors and managers. She also wishes to include a site blog as well. I believe there is CF blogging software and would appreciate some recommendations and sources for obtaining CF cms and blogging packages. Thanks in advance for your assistance. Peter Donahue ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Advertisment Content Management - problem with random image
Ok I think I fixed it. I forgot to ORDER BY newID() Thank you. > New Problem. A have advertisements but want to assign them to > different pages. I guess im just new to it all and lack the thinking. > > > Im trying to set it all up to where you can put it in three locations > if you want. Im using ORs but the ORs stop the query once it finds > something. So if I have an AD that is assigned to All News and one > assigned to Local Events.. It will only pull the first with All News. > > > Anyone help me. Newbie question. > > > > > SELECT top 1 * > FROM dbo.banner_trans > WHERE (page_location = 'All News') > OR (page_location2 = 'All News') > OR (page_location3 = 'All News') > OR(page_location = 'Every Page') > OR (page_location2 = 'Every Page') > OR (page_location3 = 'Every Page') > OR(page_location = 'Local Events') > OR (page_location2 = 'Local Events') > OR (page_location3 = 'Local Events') > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Advertisment Content Management - problem with random image
New Problem. A have advertisements but want to assign them to different pages. I guess im just new to it all and lack the thinking. Im trying to set it all up to where you can put it in three locations if you want. Im using ORs but the ORs stop the query once it finds something. So if I have an AD that is assigned to All News and one assigned to Local Events.. It will only pull the first with All News. Anyone help me. Newbie question. SELECT top 1 * FROM dbo.banner_trans WHERE (page_location = 'All News') OR (page_location2 = 'All News') OR (page_location3 = 'All News') OR (page_location = 'Every Page') OR (page_location2 = 'Every Page') OR (page_location3 = 'Every Page') OR (page_location = 'Local Events') OR (page_location2 = 'Local Events') OR (page_location3 = 'Local Events') ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Advertisment Content Management - problem with random image
Ah yes that will be because there is another variable somewhere in the request with the name ADID and it was using that instead of the one coming from your query. Thats why you should always scope your variables, unless there is a specific reason not to. If you scope them, the function isnt left to make up its own mind whether it'll use request.ADID, URL.ADID, form.ADID, application.ADID, session.ADID, client.ADID or variables.ADID or another ADID that might have strayed into the request somewhere. As you've discovered, debugging errors like that are really hard, because there's no error message thrown and its quite possible you might not even recognise that there IS an error for some time. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Dec 10, 2008 at 4:31 AM, Sin Tec <[EMAIL PROTECTED]> wrote: > It was pulling in the wrong ADID when showing an image... I had to put > #GetAds.ADID# in the Where instead of just #ADID#. > > > > > UPDATE dbo.banner_left > SET views = #add# > WHERE ADID = #GetAds.ADID# > > > > It seems to be working now. Thank you so much for all your help. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Advertisment Content Management - problem with random image
It was pulling in the wrong ADID when showing an image... I had to put #GetAds.ADID# in the Where instead of just #ADID#. UPDATE dbo.banner_left SET views = #add# WHERE ADID = #GetAds.ADID# It seems to be working now. Thank you so much for all your help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Advertisment Content Management - problem with random image
I would have thought the counting of views wouldnt have anything to do with how the banner is selected. They are two different db transactions. Are you sure that .val(GetADs.views) is giving you a numeric value? Are you sure that incrementvalue(val(GetADs.views)) is giving you a value 1 greater than the number of views? If you are getting those values right, your query should work to update the views number in the table. I would just be certain that the elements are giving you the values you think they should be . I would be checking with CFDUMPs to make sure that val(GetADs.views) and incrementvalue(val(GetADs.views)) are showing the results you are expecting. I dont know how your GetAds query would be drawing data from the wrong record. I notice that your GetADs has datasource="#Green#" and the other query has datasource="Brooke". Could that be a source of the error? Do you have two different datasources? HTH Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Dec 9, 2008 at 9:06 AM, Sin Tec <[EMAIL PROTECTED]> wrote: > I tried Mikes code: > > SELECT top 1 * > FROM dbo.banner_left > ORDER BY newID() > > > works great for the random but it screws up the views. > > > > UPDATE dbo.banner_left > SET views = #add# > WHERE ADID = #ADID# > > > It either doesnt count it or it will pull the views from another record puts > it in that record. :( > > I will try working with Isaacs code but im not to fond of the delay in the > delete. > > Thank you guys for all your help > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Advertisment Content Management - problem with random image
Tried Isaac's and it doesnt count any of the views. SELECT * from dbo.banner_left SELECT * FROM getCachedAds WHERE ADID = #ADID# ORDER BY ADID UPDATE dbo.banner_left SET views = #add# WHERE ADID = #ADID# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Advertisment Content Management - problem with random image
I tried Mikes code: SELECT top 1 * FROM dbo.banner_left ORDER BY newID() works great for the random but it screws up the views. UPDATE dbo.banner_left SET views = #add# WHERE ADID = #ADID# It either doesnt count it or it will pull the views from another record puts it in that record. :( I will try working with Isaacs code but im not to fond of the delay in the delete. Thank you guys for all your help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Advertisment Content Management - problem with random image
> Yea you're right Ike. Story of my life - I relax for once and make > a smart-alec comment and it whips around and bites me. Yer lucky you added the "my dad can beat up your dad" comment at the end, otherwise I might not have picked up on the fact that you were jokin' around. :) > But in my own defence, mine takes less typing! LOL . Works for me. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316293 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Advertisment Content Management - problem with random image
Yea you're right Ike. Story of my life - I relax for once and make a smart-alec comment and it whips around and bites me. But in my own defence, mine takes less typing! LOL . Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Dec 4, 2008 at 5:50 PM, s. isaac dealey <[EMAIL PROTECTED]> wrote: > Mike Kear said: >> Ike, your query will still attempt to select records that have been >> deleted The original problem was that the keys werent sequential >> if some records have been deleted. That's going to happen as ads are >> removed. Using the technique I use, it selects a random record >> from the records that exist in the table, whether sequential or not. > > Umm... nope... non-sequential keys won't be an issue with the solution I > posted because I used a randrange against the number of records in the > query and then fetched the ID from that record using array-notation, so > the ID is guaranteed to be in that query when it performs the 2nd fetch. > >> Ike, your solution requires two trips to the database, mine requires >> one. So . my dad can beat your dad . nyah nyah nyah !! > > Heh... you need to get your eyes checked. The 2nd query is a query of > query. :) > > The only real issue he might have with it is that he might want to see > ads removed immediately when he deletes them in his app and that code > won't remove them right away, it'll wait until the following day. And > that actually means that my code would be making a LOT fewer trips to > the database in total (1 per day instead of 1 per request). ;) But he > could of course reduce the cache duration and have the changes show up > every hour or so if he didn't want to either throw away all the cache or > produce a more complicated solution for invalidating the cache. > > > -- > s. isaac dealey ^ new epoch > isn't it time for a change? > ph: 781.769.0723 > > http://onTap.riaforge.org/blog > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Advertisment Content Management - problem with random image
Mike Kear said: > Ike, your query will still attempt to select records that have been > deleted The original problem was that the keys werent sequential > if some records have been deleted. That's going to happen as ads are > removed. Using the technique I use, it selects a random record > from the records that exist in the table, whether sequential or not. Umm... nope... non-sequential keys won't be an issue with the solution I posted because I used a randrange against the number of records in the query and then fetched the ID from that record using array-notation, so the ID is guaranteed to be in that query when it performs the 2nd fetch. > Ike, your solution requires two trips to the database, mine requires > one. So . my dad can beat your dad . nyah nyah nyah !! Heh... you need to get your eyes checked. The 2nd query is a query of query. :) The only real issue he might have with it is that he might want to see ads removed immediately when he deletes them in his app and that code won't remove them right away, it'll wait until the following day. And that actually means that my code would be making a LOT fewer trips to the database in total (1 per day instead of 1 per request). ;) But he could of course reduce the cache duration and have the changes show up every hour or so if he didn't want to either throw away all the cache or produce a more complicated solution for invalidating the cache. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Advertisment Content Management - problem with random image
Ike, your query will still attempt to select records that have been deleted The original problem was that the keys werent sequential if some records have been deleted. That's going to happen as ads are removed. Using the technique I use, it selects a random record from the records that exist in the table, whether sequential or not. IN fact if you had 4 ads on the page, you could randomly select 4 of them with this: SELECT top 4 * FROM dbo.banner_left WHERE lastdisplay <'whatever' ORDER BY newID() Ike, your solution requires two trips to the database, mine requires one. So . my dad can beat your dad . nyah nyah nyah !! Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Dec 4, 2008 at 3:38 PM, s. isaac dealey <[EMAIL PROTECTED]> wrote: > Here's my suggested modification > > > cachedwithin="#CreateTimeSpan(1,0,0,0)#"> >SELECT * dbo.banner_left > > > > > > > > SELECT * > FROM getCachedAds > WHERE ADID = #ADID# > ORDER BY ADID > > > Not sure why there even was an order by in that query originally, since > it will only return one record anyway. Probably won't affect performance, > but you may as well drop the order by. > > hth, > ike > > -- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Advertisment Content Management - problem with random image
slight correction - i had a redundancy - you dont need "maxrows="1" as well as SELECT top 1 so the query would be better written as SELECT top 1 * FROM dbo.banner_left WHERE lastdisplay <'whatever' ORDER BY newID() That way you're suing SQLServer's inbuilt randomiser, doing the whole thing in a single query. I use this all over the place. I have some sites where i have a random image displayed in teh header, and a couple of others where i have a random quotablequote displayed, another where i have a random joke appear. All use this same technique and it's quick as a flash and rock solid. All you have is a query, with a single record, then you have ColdFusion display it. That's all there is to it. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316233 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Advertisment Content Management - problem with random image
Here's my suggested modification SELECT * dbo.banner_left SELECT * FROM getCachedAds WHERE ADID = #ADID# ORDER BY ADID Not sure why there even was an order by in that query originally, since it will only return one record anyway. Probably won't affect performance, but you may as well drop the order by. hth, ike -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316232 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Advertisment Content Management - problem with random image
> > I am using a varent from sparty2809 on http://tutorial323.easycfm.com/ > > It works great but was created for ACCESS and uses an autonumber > > datatype. Its great when you just keep adding advertisments but when > > you delete one there is now a gap in the +one ADID (int - identity > > specification). When the RandRage counts the MAX ADIDs and then picks > > a ad. If it hit the number that was deleted it just shows.. nothing. > > This is a code breaker for me i cant have gaps. > > Could you convert your query data into an array? > > Then get a randRange() using the arraylen(). > > Then refer to your array with the randRange number. My recommendation would be a little different... ... do your thing ... The problem with converting to an array is that it can be a fair amount of overhead (query to array-of-structs is what I'm envisioning here) when the query itself actually comes with features that make it really easy to use natively as well as being very mechanically efficient. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Advertisment Content Management - problem with random image
Why not select out of the database using a random selection of the indexes that are there? Then you never have to worry about gaps. They dont matter. SELECT top 1 * FROM dbo.banner_left ORDER BY newID() That will select a random record from the table banner_left Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Dec 4, 2008 at 3:12 PM, Will Tomlinson <[EMAIL PROTECTED]> wrote: >> I am using a varent from sparty2809 on http://tutorial323.easycfm.com/ >> It works great but was created for ACCESS and uses an autonumber >> datatype. Its great when you just keep adding advertisments but when >> you delete one there is now a gap in the +one ADID (int - identity >> specification). When the RandRage counts the MAX ADIDs and then picks >> a ad. If it hit the number that was deleted it just shows.. nothing. >> This is a code breaker for me i cant have gaps. > > > Could you convert your query data into an array? > > Then get a randRange() using the arraylen(). > > Then refer to your array with the randRange number. > > Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Advertisment Content Management - problem with random image
> I am using a varent from sparty2809 on http://tutorial323.easycfm.com/ > It works great but was created for ACCESS and uses an autonumber > datatype. Its great when you just keep adding advertisments but when > you delete one there is now a gap in the +one ADID (int - identity > specification). When the RandRage counts the MAX ADIDs and then picks > a ad. If it hit the number that was deleted it just shows.. nothing. > This is a code breaker for me i cant have gaps. Could you convert your query data into an array? Then get a randRange() using the arraylen(). Then refer to your array with the randRange number. Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Advertisment Content Management - problem with random image
I am using a varent from sparty2809 on http://tutorial323.easycfm.com/ It works great but was created for ACCESS and uses an autonumber datatype. Its great when you just keep adding advertisments but when you delete one there is now a gap in the +one ADID (int - identity specification). When the RandRage counts the MAX ADIDs and then picks a ad. If it hit the number that was deleted it just shows.. nothing. This is a code breaker for me i cant have gaps. ADID (int) w/ identity specification +1 //id CompanyName (text) //name of banner DatePosted (text) //date posted HREF (varchar) //link IMGSRC (varchar) //image source Views (int) //# of views Clicks (int) //# of clicks Type (Text) //flash or image SELECT Max(ADID) as MaxAD FROM dbo.banner_left SELECT * FROM dbo.banner_left WHERE ADID = #ADID# ORDER BY ADID UPDATE dbo.banner_left SET views = #add# WHERE ADID = #ADID# http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0"; width="120" height="600"> http://www.macromedia.com/go/getflashplayer"; type="application/x-shockwave-flash" width="120" height="600"> I can use the rest of the code. Where do i start from here? Thank you. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion Content Management Systems
Hi Ron, I responded last night and this afternoon but it did not save - so I will try one more time. We purchased ShadoCMS/ZoomFlex mostly to do Flex development and use the generated code from ZoomFlex to drive the server-side functions CRUD etc. The generated code all follow the MVC framework. I used the system to build the schema and the database to a MSSQL 2005 database -- pretty easy to create a package of data classes and define all their properties (Fields). Modification to the schema can be made and it will be reflected in the SQL database. The system can do so much and be customized but truthfully I have not gotten that far yet, but touches of it with templates and such. There is a whole system included to manage your content contributor and their access. The people at Straker are quite helpful. Ask for an online demo! Download the system and play with the demo and the system. Read the marketing and help docs -- lot of stuff. I am planning on adding the Multi-Language module soon. This system has more available than one would expect from SEO to custom controls like Country combobox. Good luck, Arnold > I am looking for a ColdFusion based CMS for a fairly large corporation. > After shopping around I have come across a product called ShadoCMS. I > have not heard much mention of them within the community, and I was > hoping someone might have some experience with the product. It looks > like a pretty nice system. Does anyone have any experience with the > product that would be willing to comment good, bad or indifferent > > Thank you > > Ron Gowen ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion Content Management Systems
I am looking for a ColdFusion based CMS for a fairly large corporation. After shopping around I have come across a product called ShadoCMS. I have not heard much mention of them within the community, and I was hoping someone might have some experience with the product. It looks like a pretty nice system. Does anyone have any experience with the product that would be willing to comment good, bad or indifferent Thank you Ron Gowen ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284980 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multi-language Content Management
Hi Mike, Our ShadoCMS (www.straker.co.nz) has comprehensive Multi-language support which enables client to run sites (very easily)in many sites and has integration with third party (human) translation management systems. We use a parallel multi-lingual architecture which makes it significantly easier to maintain many languages. For an example look at www.newzealand.com/travel which runs 7 languages in parallel. Gran > We are developing our site to include translations into Hebrew, > Japanese, Russian, German, and later into French, and Spanish. > > Our pages are all static in so far as once written the content will > not change except maybe to correct some typos or prices. > > The pages have many pop-ups. Please take a look at our site to better > understand what we are doing. www.facsimile-editions.com > > We are looking for a system whereby translators can key in the > translations remotely and their translations are then incorporated > into the site with little or no further intervention on our part. You > will also see that there are many formatting changes (i.e bold, italic, > hyperlinks etc) > > We are a very small publishing company trying to expand into new > unknown markets and are looking for a cost-effective straight forward > solution. Can anyone recomend anything? > > Thanks, Mike ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274657 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multi-language Content Management
> We are developing our site to include translations into Hebrew, > Japanese, Russian, German, and later into French, and Spanish. > > Our pages are all static in so far as once written the content will > not change except maybe to correct some typos or prices. > > The pages have many pop-ups. Please take a look at our site to better > understand what we are doing. www.facsimile-editions.com > > We are looking for a system whereby translators can key in the > translations remotely and their translations are then incorporated > into the site with little or no further intervention on our part. You > will also see that there are many formatting changes (i.e bold, italic, > hyperlinks etc) > > We are a very small publishing company trying to expand into new > unknown markets and are looking for a cost-effective straight forward > solution. Can anyone recomend anything? > > Thanks, Mike ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274656 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multi-language Content Management
We are developing our site to include translations into Hebrew, Japanese, Russian, German, and later into French, and Spanish. Our pages are all static in so far as once written the content will not change except maybe to correct some typos or prices. The pages have many pop-ups. Please take a look at our site to better understand what we are doing. www.facsimile-editions.com We are looking for a system whereby translators can key in the translations remotely and their translations are then incorporated into the site with little or no further intervention on our part. You will also see that there are many formatting changes (i.e bold, italic, hyperlinks etc) We are a very small publishing company trying to expand into new unknown markets and are looking for a cost-effective straight forward solution. Can anyone recomend anything? Thanks, Mike ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Content Management Open Source
I found it http://www.gerorama.com/gerobase/ It was in CF talk list on 1/6/2007. Boy I am getting old. I can't remember anything very long. -Original Message- From: David Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 16, 2007 1:30 AM To: CF-Talk Subject: Content Management Open Source Hello, I seem to remember reading about a new CMS that was open source for Cold Fusion, but for the life me I can't remember what or where I read about it. I think I remember that it supported CF 7 features or some of them. It was not fare cry or Speck CMS Any help would be great. David ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:25 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Content Management Open Source
Hello, I seem to remember reading about a new CMS that was open source for Cold Fusion, but for the life me I can't remember what or where I read about it. I think I remember that it supported CF 7 features or some of them. It was not fare cry or Speck CMS Any help would be great. David ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:24 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple Content Management
If your application is built on the Plum Framework, you'd have the Plum CMS available to you, and everything is free of charge: http://www.productivityenhancement.com/plum/WhatPlumCanDo.cfm This won't be an option if you're trying to integrate it into an existing site that uses another framework, though. If your team can all access the same LAN then you can use Macromedia's RoboHelp, which is a *phenomenal* tool. You can build and maintain an entire library using RoboHelp, and some companies use it to build all the information they make available on their intranet. We use RoboHelp to create both the compiled .CHM help file in Plum and the online version using the same source files. Really slick. A third suggestion would be Macromedia's Contribute, which is another phenomenal tool. Take a good look at all three. Hope this helps. Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# & ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 - Original Message - From: "Ben Rogers" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, January 07, 2005 11:47 AM Subject: SOT: Simple Content Management > We need a tool to collect and organize information in order to build > documentation for a project in a collaborative fashion. > > We've actually used blogs in the past to document the installation of > software and such. A blog won't work in this case, however, as we need to be > able organize information in a hierarchical fashion, not chronological. > > Wiki's are interesting and would probably work technically speaking. > However, I think it will be too difficult to teach everyone how to use a > Wiki. Also, a Wiki is a little too free form. We need to define the > structure and let people provide the content. > > Does such a tool exist? We don't really care whether or not it's written in > ColdFusion. It needs to run on Windows, however. I think we're looking for > something Web based, but that's not a requirement (we have admin access to > desktops and can install software). > > Ben Rogers > http://www.c4.net > v.508.240.0051 > f.508.240.0057 > > > ~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189817 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple Content Management
www.opensourcecms.com maintains a bunch of default installs of various solutions you can play with - mostly php/mysql. /t >-Original Message- >From: Ben Rogers [mailto:[EMAIL PROTECTED] >Sent: Friday, January 07, 2005 5:47 PM >To: CF-Talk >Subject: SOT: Simple Content Management > >We need a tool to collect and organize information in order to build >documentation for a project in a collaborative fashion. > >We've actually used blogs in the past to document the installation of >software and such. A blog won't work in this case, however, as >we need to be >able organize information in a hierarchical fashion, not chronological. > >Wiki's are interesting and would probably work technically speaking. >However, I think it will be too difficult to teach everyone >how to use a >Wiki. Also, a Wiki is a little too free form. We need to define the >structure and let people provide the content. > >Does such a tool exist? We don't really care whether or not >it's written in >ColdFusion. It needs to run on Windows, however. I think we're >looking for >something Web based, but that's not a requirement (we have >admin access to >desktops and can install software). > >Ben Rogers >http://www.c4.net >v.508.240.0051 >f.508.240.0057 > > > ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189799 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Simple Content Management
This one is free and has an installer. You can be up in a couple of minutes: http://mysecretbase.com/CMLite_Home.cfm version 4 of the for-pay version is hitting RC3 today; the last before release. Has Team Review (approval workflow) among many other items. -- --mattRobertson-- President, Janitor MSB Web Systems mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SOT: Simple Content Management
We need a tool to collect and organize information in order to build documentation for a project in a collaborative fashion. We've actually used blogs in the past to document the installation of software and such. A blog won't work in this case, however, as we need to be able organize information in a hierarchical fashion, not chronological. Wiki's are interesting and would probably work technically speaking. However, I think it will be too difficult to teach everyone how to use a Wiki. Also, a Wiki is a little too free form. We need to define the structure and let people provide the content. Does such a tool exist? We don't really care whether or not it's written in ColdFusion. It needs to run on Windows, however. I think we're looking for something Web based, but that's not a requirement (we have admin access to desktops and can install software). Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189660 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Content Management System (CMS) Wishlist (making a cms multlingual)
> Don't you hate site that return you to the root but in the other language? frankly i've found hardly anybody works thru a website that way. normal folks come in, set their locale/language (or better yet their locale/language is silently delivered to them) & navigate thru the site. a good app remembers their locale/language (its called "locale/language stickiness") for this & subsequent sessions. it also has a prominently displayed manual way to swap locale/language. staying on the same page is just "nice", hardly required. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist (making a cms multlingual)
> Any ideas on what relationship the &ArticleAction=language parameter is > doing to perform the translation ? same table, same ID, different language. probably just sets the new language as the opposite of the current language (as least that's how we did thai\english sites). it also doesn't appear to work so well [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist (making a cms multlingual)
I think it depends on your business rules (rather than technology) The point I was trying to get across is that the user should not be limited to a repository of just that language as there might NOT be translations of that particular content (brand guidelines, Templates?) and the content should not need to be replicated (if it is the same across all languages) MD On Mon, 20 Sep 2004 18:38:54 +0700, Paul Hastings <[EMAIL PROTECTED]> wrote: > > It should never happen, that a spanish website gets english content by > > itself because the spanish version is missing. So if the spanish version > > of a pdf is missing, throw an error, not get the english version :-) You > > might give the client bad information. > > here here. > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist (making a cms multlingual)
> It should never happen, that a spanish website gets english content by > itself because the spanish version is missing. So if the spanish version > of a pdf is missing, throw an error, not get the english version :-) You > might give the client bad information. here here. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist (making a cms multlingual)
Content libraries in my system are not content items. It is a structurized way of sorting content, under categories and by meta labels. In my case, each language has it's own Content Library because the category labels could be multilingual as well. It is a bit hard to explain, but see it as a windows explorer view where the maps are the categories and the files within the content. It should never happen, that a spanish website gets english content by itself because the spanish version is missing. So if the spanish version of a pdf is missing, throw an error, not get the english version :-) You might give the client bad information. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist (making a cms multlingual)
> 1) Content library, this should be a content item and assigned either > to multiple languages or a single language (e.g. english and spanish > versions both link to the english download as there is only one... > which we can then separate, or it defaults to english PDF if there is > no spanish version) well i would say that there ought to be a a spanish one. english defaults to the rest of the world isn't probably going to hurt that much (unless maybe you're selling stuff), but what about the other way around? suppose you have a website in thai that deals with setting up a business in thailand. in theory you have an english page but all it contains is the title, etc., in english w/the rest of the keep-you-out-jail and lower-your-taxes info in thai. wouldn't that suck if you couldn't read thai? > 2)Depends what files.. if they are site images, then split them up as > images/EN , images/ES etc have one default language so if you dont > find a resource you can default to the english (for example) so not to > get broken links and errors again i'd stump for "must have". if your client locale uses right-to-left writing system (arabic,hebrew for example) and you fell back on en_US graphics, you'd confuse the heck out of folks trying to navigate your site (if you used graphics for navigation). > 3) Accounts.. same repository.. add a preference for language i would suggest locale instead, CMS isn't just text content, you'll need date/numeric/curency formating for sure. > 4) Workflow.. you should have workflow templates that you can use that i'd stump for "one workflow to rule them all". in theory i would have one site, same structure, same content (different languages), etc. websites that call themselves teh same name but offer different content, navigation, etc., per locale/language are for the birds. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist (making a cms multlingual)
I think I mentioned this in a previous post.. If you are using an idea of one table row per language idea you have a root table that defines an article (no matter what language and/or version) with the ID: ContentID, Type 5, Article A join table that defines the link to the content ContentID, ItemID, Lang 5,1, EN 5,2,CY 5,4,FR Then you have the Item table along the lines of ItemID, Title, Content 1, A title in English, Some content 2, A title in Welsh, some content in welsh 3, A title in english, not related to content 5 4, A title en Francaise, the content in french Then you create some method (function or whatever programming language you use) that gets the content e,g, getContent(id, type, language) the id passed in gets ALL language versions of that via the join table, the type (if required) gets all articles (there might be differetn content associated with this item) and the language to get that version only Hope that helps MD On Mon, 20 Sep 2004 12:04:46 +0100, Ian Vaughan <[EMAIL PROTECTED]> wrote: > > Quote > "Sounds to me that a single article can have translations (a standard > way of dealing with content)" > > How would this look from the backend though ? How would your table / > tables be set up so a single article can have translations ??? > > cym/wel cy are the ISO codes for Welsh > > > > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: 20 September 2004 12:02 > To: CF-Talk > Subject: Re: Content Management System (CMS) Wishlist (making a cms > multlingual) > > > Sounds to me that a single article can have translations (a standard > way of dealing with content) > > I come from a coldfusion background so I am used to the idea of > Structs in which the content of something can be in english and > accessed such as > > content.EN or content.FR or content.Welsh (whats the ISO code for > Welsh?) > > MD > > On Mon, 20 Sep 2004 11:48:58 +0100, Ian Vaughan > <[EMAIL PROTECTED]> wrote: > > If you look at the following example website > > > > http://www.allwalesunit.gov.uk/index.cfm?articleid=5 > > > > and click on the Cymraeg link at the top of the page, which loads up > the > > Welsh translation of the site. > > > > If you hold the cursor over the link you will see > > > > > http://www.allwalesunit.gov.uk/index.cfm?articleid=5&ArticleAction=langu > > age and vice verser from welsh to english. > > > > Any ideas on what relationship the &ArticleAction=language parameter > is > > doing to perform the translation ? > > > > As each article whether it is English or Welsh has the same articleid > > ??? > > > > Any ideas ? > > > > > > > > From: Mark Drew [mailto:[EMAIL PROTECTED] > > Sent: 20 September 2004 10:39 > > To: CF-Talk > > Subject: Re: Content Management System (CMS) Wishlist (making a cms > > multlingual) > > > > > > Depends on your requirements (or the clients!) > > 1) Content library, this should be a content item and assigned either > > to multiple languages or a single language (e.g. english and spanish > > versions both link to the english download as there is only one... > > which we can then separate, or it defaults to english PDF if there is > > no spanish version) > > 2)Depends what files.. if they are site images, then split them up as > > images/EN , images/ES etc have one default language so if you dont > > find a resource you can default to the english (for example) so not to > > get broken links and errors > > 3) Accounts.. same repository.. add a preference for language > > 4) Workflow.. you should have workflow templates that you can use that > > are held in the same place.. if you need something special add a > > "Workflow for ES content" concept (with the right translation of > > course! and make it available to users that are meant to use that > > workflow > > 5) Template Libraries.. I would guess the same here.. are templates > > available to all or to only languages? if they are available per > > language tag it as so > > > > Hope that helps > > > > On Mon, 20 Sep 2004 11:10:16 +0200, Micha Schopman > > <[EMAIL PROTECTED]> wrote: > > > And does someone separate content library, file folders, accounts, > > > workflow, approval queues, template libraries, etc. per language, or > > do > > > all languages in the system use the same libraries? > > > > > > Micha Schopman > > > Software Engineer > > > Modern Media, Databankweg 12 M, 3821 AL Amersfoort > > > Tel 033-4535377, Fax 033-4535388 > > > KvK Amersfoort 39081679, Rabo 39.48.05.380 > > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist (making a cms multlingual)
- Original Message - From: "Ian Vaughan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 20, 2004 3:46 PM Subject: RE: Content Management System (CMS) Wishlist (making a cms multlingual) > If for instance you have the following example table containing Press > Releases in English it depends on the way the whole app is designed. if each locale is structured the same way (i would stump that it should be) & each "skin" the app displays for a particular user is governed by some high level logic, then no there is no need for a language ID. the app assembles each page by pulling content from the db/cache. that way things can get re-used though you'd surprised how little that actually happens for really global apps. on the other hand, if you're app has more "java-style logic" then yes you'd have to add a locale (or language if you can get away with it, en_US isn't the same as en_GB) tag. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist (making a cms multlingual)
Quote "Sounds to me that a single article can have translations (a standard way of dealing with content)" How would this look from the backend though ? How would your table / tables be set up so a single article can have translations ??? cym/wel cy are the ISO codes for Welsh From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 20 September 2004 12:02 To: CF-Talk Subject: Re: Content Management System (CMS) Wishlist (making a cms multlingual) Sounds to me that a single article can have translations (a standard way of dealing with content) I come from a coldfusion background so I am used to the idea of Structs in which the content of something can be in english and accessed such as content.EN or content.FR or content.Welsh (whats the ISO code for Welsh?) MD On Mon, 20 Sep 2004 11:48:58 +0100, Ian Vaughan <[EMAIL PROTECTED]> wrote: > If you look at the following example website > > http://www.allwalesunit.gov.uk/index.cfm?articleid=5 > > and click on the Cymraeg link at the top of the page, which loads up the > Welsh translation of the site. > > If you hold the cursor over the link you will see > > http://www.allwalesunit.gov.uk/index.cfm?articleid=5&ArticleAction=langu > age and vice verser from welsh to english. > > Any ideas on what relationship the &ArticleAction=language parameter is > doing to perform the translation ? > > As each article whether it is English or Welsh has the same articleid > ??? > > Any ideas ? > > > > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: 20 September 2004 10:39 > To: CF-Talk > Subject: Re: Content Management System (CMS) Wishlist (making a cms > multlingual) > > > Depends on your requirements (or the clients!) > 1) Content library, this should be a content item and assigned either > to multiple languages or a single language (e.g. english and spanish > versions both link to the english download as there is only one... > which we can then separate, or it defaults to english PDF if there is > no spanish version) > 2)Depends what files.. if they are site images, then split them up as > images/EN , images/ES etc have one default language so if you dont > find a resource you can default to the english (for example) so not to > get broken links and errors > 3) Accounts.. same repository.. add a preference for language > 4) Workflow.. you should have workflow templates that you can use that > are held in the same place.. if you need something special add a > "Workflow for ES content" concept (with the right translation of > course! and make it available to users that are meant to use that > workflow > 5) Template Libraries.. I would guess the same here.. are templates > available to all or to only languages? if they are available per > language tag it as so > > Hope that helps > > On Mon, 20 Sep 2004 11:10:16 +0200, Micha Schopman > <[EMAIL PROTECTED]> wrote: > > And does someone separate content library, file folders, accounts, > > workflow, approval queues, template libraries, etc. per language, or > do > > all languages in the system use the same libraries? > > > > Micha Schopman > > Software Engineer > > Modern Media, Databankweg 12 M, 3821 AL Amersfoort > > Tel 033-4535377, Fax 033-4535388 > > KvK Amersfoort 39081679, Rabo 39.48.05.380 > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist (making a cms multlingual)
I think it's important that they have the same articleID cause when you go from a page in a language to another language you want to stay on the same page.. Don't you hate site that return you to the root but in the other language? Pat _ From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: September 20, 2004 06:49 To: CF-Talk Subject: RE: Content Management System (CMS) Wishlist (making a cms multlingual) If you look at the following example website http://www.allwalesunit.gov.uk/index.cfm?articleid=5 and click on the Cymraeg link at the top of the page, which loads up the Welsh translation of the site. If you hold the cursor over the link you will see http://www.allwalesunit.gov.uk/index.cfm?articleid=5&ArticleAction=langu age and vice verser from welsh to english. Any ideas on what relationship the &ArticleAction=language parameter is doing to perform the translation ? As each article whether it is English or Welsh has the same articleid ??? Any ideas ? From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 20 September 2004 10:39 To: CF-Talk Subject: Re: Content Management System (CMS) Wishlist (making a cms multlingual) Depends on your requirements (or the clients!) 1) Content library, this should be a content item and assigned either to multiple languages or a single language (e.g. english and spanish versions both link to the english download as there is only one... which we can then separate, or it defaults to english PDF if there is no spanish version) 2)Depends what files.. if they are site images, then split them up as images/EN , images/ES etc have one default language so if you dont find a resource you can default to the english (for example) so not to get broken links and errors 3) Accounts.. same repository.. add a preference for language 4) Workflow.. you should have workflow templates that you can use that are held in the same place.. if you need something special add a "Workflow for ES content" concept (with the right translation of course! and make it available to users that are meant to use that workflow 5) Template Libraries.. I would guess the same here.. are templates available to all or to only languages? if they are available per language tag it as so Hope that helps On Mon, 20 Sep 2004 11:10:16 +0200, Micha Schopman <[EMAIL PROTECTED]> wrote: > And does someone separate content library, file folders, accounts, > workflow, approval queues, template libraries, etc. per language, or do > all languages in the system use the same libraries? > > Micha Schopman > Software Engineer > Modern Media, Databankweg 12 M, 3821 AL Amersfoort > Tel 033-4535377, Fax 033-4535388 > KvK Amersfoort 39081679, Rabo 39.48.05.380 > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist (making a cms multlingual)
Sounds to me that a single article can have translations (a standard way of dealing with content) I come from a coldfusion background so I am used to the idea of Structs in which the content of something can be in english and accessed such as content.EN or content.FR or content.Welsh (whats the ISO code for Welsh?) MD On Mon, 20 Sep 2004 11:48:58 +0100, Ian Vaughan <[EMAIL PROTECTED]> wrote: > If you look at the following example website > > http://www.allwalesunit.gov.uk/index.cfm?articleid=5 > > and click on the Cymraeg link at the top of the page, which loads up the > Welsh translation of the site. > > If you hold the cursor over the link you will see > > http://www.allwalesunit.gov.uk/index.cfm?articleid=5&ArticleAction=langu > age and vice verser from welsh to english. > > Any ideas on what relationship the &ArticleAction=language parameter is > doing to perform the translation ? > > As each article whether it is English or Welsh has the same articleid > ??? > > Any ideas ? > > > > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: 20 September 2004 10:39 > To: CF-Talk > Subject: Re: Content Management System (CMS) Wishlist (making a cms > multlingual) > > > Depends on your requirements (or the clients!) > 1) Content library, this should be a content item and assigned either > to multiple languages or a single language (e.g. english and spanish > versions both link to the english download as there is only one... > which we can then separate, or it defaults to english PDF if there is > no spanish version) > 2)Depends what files.. if they are site images, then split them up as > images/EN , images/ES etc have one default language so if you dont > find a resource you can default to the english (for example) so not to > get broken links and errors > 3) Accounts.. same repository.. add a preference for language > 4) Workflow.. you should have workflow templates that you can use that > are held in the same place.. if you need something special add a > "Workflow for ES content" concept (with the right translation of > course! and make it available to users that are meant to use that > workflow > 5) Template Libraries.. I would guess the same here.. are templates > available to all or to only languages? if they are available per > language tag it as so > > Hope that helps > > On Mon, 20 Sep 2004 11:10:16 +0200, Micha Schopman > <[EMAIL PROTECTED]> wrote: > > And does someone separate content library, file folders, accounts, > > workflow, approval queues, template libraries, etc. per language, or > do > > all languages in the system use the same libraries? > > > > Micha Schopman > > Software Engineer > > Modern Media, Databankweg 12 M, 3821 AL Amersfoort > > Tel 033-4535377, Fax 033-4535388 > > KvK Amersfoort 39081679, Rabo 39.48.05.380 > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist (making a cms multlingual)
If you look at the following example website http://www.allwalesunit.gov.uk/index.cfm?articleid=5 and click on the Cymraeg link at the top of the page, which loads up the Welsh translation of the site. If you hold the cursor over the link you will see http://www.allwalesunit.gov.uk/index.cfm?articleid=5&ArticleAction=langu age and vice verser from welsh to english. Any ideas on what relationship the &ArticleAction=language parameter is doing to perform the translation ? As each article whether it is English or Welsh has the same articleid ??? Any ideas ? From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 20 September 2004 10:39 To: CF-Talk Subject: Re: Content Management System (CMS) Wishlist (making a cms multlingual) Depends on your requirements (or the clients!) 1) Content library, this should be a content item and assigned either to multiple languages or a single language (e.g. english and spanish versions both link to the english download as there is only one... which we can then separate, or it defaults to english PDF if there is no spanish version) 2)Depends what files.. if they are site images, then split them up as images/EN , images/ES etc have one default language so if you dont find a resource you can default to the english (for example) so not to get broken links and errors 3) Accounts.. same repository.. add a preference for language 4) Workflow.. you should have workflow templates that you can use that are held in the same place.. if you need something special add a "Workflow for ES content" concept (with the right translation of course! and make it available to users that are meant to use that workflow 5) Template Libraries.. I would guess the same here.. are templates available to all or to only languages? if they are available per language tag it as so Hope that helps On Mon, 20 Sep 2004 11:10:16 +0200, Micha Schopman <[EMAIL PROTECTED]> wrote: > And does someone separate content library, file folders, accounts, > workflow, approval queues, template libraries, etc. per language, or do > all languages in the system use the same libraries? > > Micha Schopman > Software Engineer > Modern Media, Databankweg 12 M, 3821 AL Amersfoort > Tel 033-4535377, Fax 033-4535388 > KvK Amersfoort 39081679, Rabo 39.48.05.380 > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist (making a cms multlingual)
Depends on your requirements (or the clients!) 1) Content library, this should be a content item and assigned either to multiple languages or a single language (e.g. english and spanish versions both link to the english download as there is only one... which we can then separate, or it defaults to english PDF if there is no spanish version) 2)Depends what files.. if they are site images, then split them up as images/EN , images/ES etc have one default language so if you dont find a resource you can default to the english (for example) so not to get broken links and errors 3) Accounts.. same repository.. add a preference for language 4) Workflow.. you should have workflow templates that you can use that are held in the same place.. if you need something special add a "Workflow for ES content" concept (with the right translation of course! and make it available to users that are meant to use that workflow 5) Template Libraries.. I would guess the same here.. are templates available to all or to only languages? if they are available per language tag it as so Hope that helps On Mon, 20 Sep 2004 11:10:16 +0200, Micha Schopman <[EMAIL PROTECTED]> wrote: > And does someone separate content library, file folders, accounts, > workflow, approval queues, template libraries, etc. per language, or do > all languages in the system use the same libraries? > > Micha Schopman > Software Engineer > Modern Media, Databankweg 12 M, 3821 AL Amersfoort > Tel 033-4535377, Fax 033-4535388 > KvK Amersfoort 39081679, Rabo 39.48.05.380 > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist (making a cms multlingual)
And does someone separate content library, file folders, accounts, workflow, approval queues, template libraries, etc. per language, or do all languages in the system use the same libraries? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist (making a cms multlingual)
I think you need to do it another way, by adding a "content" table that defines the content and groups it, e,g, ContentID, Content Type, Then you have a relationship to another table which is the join of press releases so you group them all as one: contentID, PRID This has now linked it to a lot of press releases that can be in different languages (and versions) and you get the latest for that language for the content ID so you have the root contentId as the unique identifier for a content and you then can associate it with another version. Sorry if its a bit mixed up but I am still waking up! MD On Mon, 20 Sep 2004 09:46:04 +0100, Ian Vaughan <[EMAIL PROTECTED]> wrote: > If for instance you have the following example table containing Press > Releases in English > > PRID > PRTITLE > PRSUMMARY > PRBODY > PRPUBLISHDATE > PROWNER > > How would you make this multilingual ? > > Would you create other tables for French, Italian etc ?? > > or would you just add a PRLANGUAGE field to the above table ? > > And how would the relationship between the PRID's for example work for > different languages ? > > > > From: Paul Hastings [mailto:[EMAIL PROTECTED] > Sent: 17 September 2004 16:16 > To: CF-Talk > Subject: Re: Content Management System (CMS) Wishlist > > > for multilingual content = not just creating a separate branche for > > other languages. > > yeah that was the first thing folks suggested when we started discussing > this for farcry. i'm not for that technique (1 new language = 1 new > site). > we'll see how this plays out w/farcry. > > > Creating a system being able to handle multilingual content, on object > > bases, is not a simple task. > > perhaps but i've known it to be done ;-) > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist (making a cms multlingual)
If for instance you have the following example table containing Press Releases in English PRID PRTITLE PRSUMMARY PRBODY PRPUBLISHDATE PROWNER How would you make this multilingual ? Would you create other tables for French, Italian etc ?? or would you just add a PRLANGUAGE field to the above table ? And how would the relationship between the PRID's for example work for different languages ? From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 17 September 2004 16:16 To: CF-Talk Subject: Re: Content Management System (CMS) Wishlist > for multilingual content = not just creating a separate branche for > other languages. yeah that was the first thing folks suggested when we started discussing this for farcry. i'm not for that technique (1 new language = 1 new site). we'll see how this plays out w/farcry. > Creating a system being able to handle multilingual content, on object > bases, is not a simple task. perhaps but i've known it to be done ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist
The issues with object based content management are for example, - do you create a totally separate content repository based on that perticulair language? Or do all languages select content out of the same bin. So all languages get mixed. - do all languages have the same account? Or are accounts based on language? - Idem for... approval queue, files, workflow designer, general settings, etc.. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
What features are useful and which a waste of time? Depends on your target market for the solution. The requirements for corporate/enterprise are different to SME and membership based organizations. Johan www.assetnow.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
I guess they still use seperate branches, according to some of the screenshots shown on the website. One of the screenshots show a treeview, and on top a dropdown box with "english" in it. My guess is changing this box changes the branch. >Well that's the million dollar question, when I asked and basically need >to create a duplicate site, I can't recall if there was any facility to >keep them in sync, they may have been. > >It may have moved on since then. > >Kola > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist
Well that's the million dollar question, when I asked and basically need to create a duplicate site, I can't recall if there was any facility to keep them in sync, they may have been. It may have moved on since then. Kola -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: 17 September 2004 17:30 To: CF-Talk Subject: Re: Content Management System (CMS) Wishlist How does one manage multilingual content in ShadoMX, I am interested in this specific feature. Do you have screens showing how it works? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
How does one manage multilingual content in ShadoMX, I am interested in this specific feature. Do you have screens showing how it works? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist
> Ideally I'd want to work with a > language aware system such that I can change languages in > the cms to see the alternative version of the content in a > different language. ShadoMX has multilanguage support at object level, so you only have one site tree etc and can define multiple translations for a single content container. Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist
Paul Micha summed up exactly what I was referring to when I meant decent. Most CMS systems approach this by creating a separate branch or mirror site as you mentioned. I would be interested to see how farcry handles this. Ideally I'd want to work with a language aware system such that I can change languages in the cms to see the alternative version of the content in a different language. Kola -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 17 September 2004 16:16 To: CF-Talk Subject: Re: Content Management System (CMS) Wishlist > for multilingual content = not just creating a separate branche for > other languages. yeah that was the first thing folks suggested when we started discussing this for farcry. i'm not for that technique (1 new language = 1 new site). we'll see how this plays out w/farcry. > Creating a system being able to handle multilingual content, on object > bases, is not a simple task. perhaps but i've known it to be done ;-) _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
I have seen it in spectra just using Structs but the issue here is that you should get away from one record = one bit of content.. if you are doing versioning you will have an object that is a content and then another table with the versions and languages .. MD On Fri, 17 Sep 2004 22:15:33 +0700, Paul Hastings <[EMAIL PROTECTED]> wrote: > > for multilingual content = not just creating a separate branche for > > other languages. > > yeah that was the first thing folks suggested when we started discussing > this for farcry. i'm not for that technique (1 new language = 1 new site). > we'll see how this plays out w/farcry. > > > Creating a system being able to handle multilingual content, on object > > bases, is not a simple task. > > perhaps but i've known it to be done ;-) > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist
I would suggest you set up a simple frame for the system first, .. if you want to implement all the mentioned features you may kiss you summer vacation goodbye. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist
Including workflow editors, dynamic authoring rules on department and role and user level, and versioning of objects? .. I don't know how long it took you but It took me 3 months work in the evening hours. It is very difficult. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
> for multilingual content = not just creating a separate branche for > other languages. yeah that was the first thing folks suggested when we started discussing this for farcry. i'm not for that technique (1 new language = 1 new site). we'll see how this plays out w/farcry. > Creating a system being able to handle multilingual content, on object > bases, is not a simple task. perhaps but i've known it to be done ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
Tuesday's fine :) Also the other things that are requested are: 1) selective workflow (not everyone needs to follow it) 2) Dated publishing (make live on .. until) 3) Preview of content... in site content.. 4) Site Versioning and Content Versioning 5) Content check out and check in 6) Management of non site content, e.g. emails and errors 7) Site Reporting and Statistics 8) User management and Roles 9) Search engine tracking 10) Live site metrics (how many users online, how many people read this content) 11) Coffee and Tea (white , one sugar) Regards Mark Drew On Sat, 18 Sep 2004 00:56:27 +1000, Mike Kear <[EMAIL PROTECTED]> wrote: > Piece of cake Mark! Might not get it done tonight. Will Monday do? > > Thanks a lot for your comments. Given me food for thought. > > Cheers > Mike Kear > > Cheers > Mike Kear > Windsor, NSW, Australia > AFP Webworks > http://afpwebworks.com > .com,.net,.org domains from AUD$20/Year > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
My case for creating one is this I want to understand intimately the workings of one. Every time in the past i've tried to get into the inner workings of an application, I've ended up saying "to hell with it, I can make one myself". It's not a lower cost way ot doing it, definitely, but I want to do my own, because it's a mountain I want to climb. whenever I look at the insides of a CMS, there's heaps I dont understand.. Why did htey do that? what is that field in the database for? why did they do it that way around? So in order to fully understand the issues i'm building my own. For example, there are half a dozen ways to control the display of approved and non-approved content, and to make sure that a rollback is always possible and an audit trail is there for changes. It took me ages to figure out how the first one i examined was working. So I set to and made my own. Now I understand why that first one did it they way they did, and understand how much better theirs was than my own effort. It's my way of learning. I reckon CMS is the future for the next few years in web develoment, and there are precious few ready for XHTML. So there are opportunities for me. Thats my business case for doing it. And aside from all that. I wanna. SO there! Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
I just had to dev one of these monsters up. One thing my company wanted was workflow for adding content. As in, Jimmy can add content, then Sammy and Sally have to approve it before its live. Of course Sammy and Sally want to know exactly what changed too, can't depend on them actually reading you know :) Doug - Original Message - From: Mike Kear <[EMAIL PROTECTED]> Date: Sat, 18 Sep 2004 00:56:27 +1000 Subject: Re: Content Management System (CMS) Wishlist To: CF-Talk <[EMAIL PROTECTED]> Piece of cake Mark! Might not get it done tonight. Will Monday do? Thanks a lot for your comments. Given me food for thought. Cheers Mike Kear Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist
Multilingual, as in frontend support is still quite unique. Only bigger vendors in the medium, or enterprise level markets have builtin support for multilingual content = not just creating a separate branche for other languages. Creating a system being able to handle multilingual content, on object bases, is not a simple task. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
You Could always start with the Old Spectra OPen Source :-) Or FarCry As starting points as these have the engines to build with Cheers BK - Original Message - From: Kola Oyedeji <[EMAIL PROTECTED]> Date: Fri, 17 Sep 2004 15:49:11 +0100 Subject: RE: Content Management System (CMS) Wishlist To: CF-Talk <[EMAIL PROTECTED]> Mike Most CMS systems I have come across have the same or similar functionality so picking anyone off the shelf - commonspot, farcry, ShadoMX should give you an idea of common functionality - one thing which is still lacking in many of the cms systems I have come across is *decent* support for multilingual content. I believe the latest version of farcry may support this but I haven't played with it yet. Oh yeh. and I would avoid re-inventing the wheel and look at existing solutions unless you have a strong business case for creating one. Regards, Kola -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 17 September 2004 15:23 To: CF-Talk Subject: Content Management System (CMS) Wishlist I'm currently doing a spec for a new CMS I'm building for my own use. (I'll think about making it available commercially later). I'm making it for CFMX, and all the presentation stuff is going to be in CSS. The CMS will output valid XHTML and because no layout code wiill be in the output from the CMS, the look of hte site will entirely be in the CSS Style sheets (see the Zen Garden project to get an idea of what you can do with CSS! http://www.csszengarden.com/ ) Can I pick the collective brain of this list again for a wish list while I'm building the specs ... What features do you wish were in the CMS you're using or have looked at, that arent there now? What things are in the CMS you use, that you never use and think are a waste of time? -- Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
> which is still lacking in many of the cms systems I have come across is > *decent* support for multilingual content. I believe the latest version > of farcry may support this but I haven't played with it yet. define "decent". as a first step last year i guess, we made it unicode compliant. the next "phase" was making the backend i18n (that bits done), currently in the l10n stage of that. it should have an alarming number of languages for the admin fairly soon. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
Piece of cake Mark! Might not get it done tonight. Will Monday do? Thanks a lot for your comments. Given me food for thought. Cheers Mike Kear Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Content Management System (CMS) Wishlist
Mike Most CMS systems I have come across have the same or similar functionality so picking anyone off the shelf - commonspot, farcry, ShadoMX should give you an idea of common functionality - one thing which is still lacking in many of the cms systems I have come across is *decent* support for multilingual content. I believe the latest version of farcry may support this but I haven't played with it yet. Oh yeh. and I would avoid re-inventing the wheel and look at existing solutions unless you have a strong business case for creating one. Regards, Kola -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 17 September 2004 15:23 To: CF-Talk Subject: Content Management System (CMS) Wishlist I'm currently doing a spec for a new CMS I'm building for my own use. (I'll think about making it available commercially later). I'm making it for CFMX, and all the presentation stuff is going to be in CSS. The CMS will output valid XHTML and because no layout code wiill be in the output from the CMS, the look of hte site will entirely be in the CSS Style sheets (see the Zen Garden project to get an idea of what you can do with CSS! http://www.csszengarden.com/ ) Can I pick the collective brain of this list again for a wish list while I'm building the specs ... What features do you wish were in the CMS you're using or have looked at, that arent there now? What things are in the CMS you use, that you never use and think are a waste of time? -- Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Content Management System (CMS) Wishlist
Ohh many things i could add here.. but want to finish before nightfall! 1) Have you seen Aura (used by FarCry?) That is CSS and what have you. 2) Output content in XML and then apply a stylesheet to it? 3) Assetmanagement for images and documents and flash etc 4) Search engine 5) EASY type creation.. I created a CMS that you define types using XML as the markup. that just said what form elements made up your content item.. I then used .cfm display methods (as they are a bit more dynamic than XSLT transforms) 6) link management and short links 7) multilingual .. how you do this on an item or page is up to you 8) ability to change site sturcture, add remove items easily 9) Publishing to static HTML if required (like blogger) both local and via FTP 10) Emailable updates (I send an email to a special email account to add content) thats a start :) Regards Mark Drew On Sat, 18 Sep 2004 00:23:27 +1000, Mike Kear <[EMAIL PROTECTED]> wrote: > I'm currently doing a spec for a new CMS I'm building for my own use. > (I'll think about making it available commercially later). > > I'm making it for CFMX, and all the presentation stuff is going to be > in CSS. The CMS will output valid XHTML and because no layout code > wiill be in the output from the CMS, the look of hte site will > entirely be in the CSS Style sheets (see the Zen Garden project to get > an idea of what you can do with CSS! http://www.csszengarden.com/ ) > > Can I pick the collective brain of this list again for a wish list > while I'm building the specs ... > > What features do you wish were in the CMS you're using or have looked > at, that arent there now? > > What things are in the CMS you use, that you never use and think are a > waste of time? > > -- > Cheers > Mike Kear > Windsor, NSW, Australia > AFP Webworks > http://afpwebworks.com > .com,.net,.org domains from AUD$20/Year > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Content Management System (CMS) Wishlist
I'm currently doing a spec for a new CMS I'm building for my own use. (I'll think about making it available commercially later). I'm making it for CFMX, and all the presentation stuff is going to be in CSS. The CMS will output valid XHTML and because no layout code wiill be in the output from the CMS, the look of hte site will entirely be in the CSS Style sheets (see the Zen Garden project to get an idea of what you can do with CSS! http://www.csszengarden.com/ ) Can I pick the collective brain of this list again for a wish list while I'm building the specs ... What features do you wish were in the CMS you're using or have looked at, that arent there now? What things are in the CMS you use, that you never use and think are a waste of time? -- Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Homepage content management
- Original Message - From: Hugo Ahlenius <[EMAIL PROTECTED]> Date: Mon, 23 Aug 2004 08:54:15 +0200 > Does anyone know if FarCry runs on BD? FarCry CMS does *not* run on BD at the moment. However, there is an enthusiastic group who are keen to make that a reality. I think they're currently a bit side tracked so I'm not sure what the current status of the BD port is. Certainly you'd get a better response on farcry-dev (http://farcry.daemon.com.au/go/support/mailing-lists). -- geoff http://www.daemon.com.au/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Homepage content management
Does anyone know if FarCry runs on BD? - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - Original Message From: "Geoff Bowers" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 23, 2004 02:56 Subject: Re: Homepage content management | - Original Message - || From: Peter Tilbrook <[EMAIL PROTECTED]> || FarCry? || http://farcry.daemon.com.au/ || It's a bitch to install though and out of the question if hosted on || an ISP without access to > mappings. It seems good but gave up on || it due to installation complexity on a standalone > box even. | | Pete, that's unfortunate. Generally I can install the product within | 5minutes -- but admittedly I'm used to it :) You should try the | farcry-dev list, plenty of folks on there with a myriad of install | environments that can offer lots of help. Standalone box installation | is generally very straight forward. | | Currently you can deploy to linux, windows and OSX; with support for | MS SQL, Oracle, Postgresql and mySQL. | | With regard to ISP hosting -- it's true FarCry requires the assistance | of the ISP. It requires the installation of a shared code library for | all farcry apps within a CFMX instance, which sits under a single CF | Mapping. The only real issue here is providing a service for multiple | shared hosters who want to use FarCry (ie. its difficult to have | multiple versions of the farcry shared library running under one | instance). | | That said there are already several CF hosters who have taken on | FarCry and provide it as a standard hosting option for their clients. | Just post to the farcry-dev list asking for hosters ;) | | -- geoff | http://farcry.daemon.com.au/ | On the road via GMail. | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Homepage content management
- Original Message - > From: Peter Tilbrook <[EMAIL PROTECTED]> > FarCry? > http://farcry.daemon.com.au/ > It's a bitch to install though and out of the question if hosted on an ISP without access to > mappings. It seems good but gave up on it due to installation complexity on a standalone > box even. Pete, that's unfortunate. Generally I can install the product within 5minutes -- but admittedly I'm used to it :) You should try the farcry-dev list, plenty of folks on there with a myriad of install environments that can offer lots of help. Standalone box installation is generally very straight forward. Currently you can deploy to linux, windows and OSX; with support for MS SQL, Oracle, Postgresql and mySQL. With regard to ISP hosting -- it's true FarCry requires the assistance of the ISP. It requires the installation of a shared code library for all farcry apps within a CFMX instance, which sits under a single CF Mapping. The only real issue here is providing a service for multiple shared hosters who want to use FarCry (ie. its difficult to have multiple versions of the farcry shared library running under one instance). That said there are already several CF hosters who have taken on FarCry and provide it as a standard hosting option for their clients. Just post to the farcry-dev list asking for hosters ;) -- geoff http://farcry.daemon.com.au/ On the road via GMail. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Homepage content management
I agree, ActivEdit is a great piece of software I used when I built a couple of websites for clients. if you want to go free of something else this is a great site to get a list of almost all TTW WYSIWYG Editors. http://www.bris.ac.uk/is/projects/cms/ttw/ttw.html Jim Louis Best Meetings, Inc >we use ActivEdit from cfdev.com. I'd prefer to use fckeditor (see >sourceforge), but we had some issues regarding the spell checking with it. >Both work fine for this in CF. > > >DK > >-Original Message- >From: Donna French [mailto:[EMAIL PROTECTED] >Sent: Wednesday, August 11, 2004 1:57 PM >To: CF-Talk >Subject: Homepage content management > > >I need to find a solution already written in CF or get some ideas from >you all on an easy way to allow non-programmers to update the company's >web site homepage? > >Thank you, > > >Donna French > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Homepage content management
FarCry? http://farcry.daemon.com.au/ It's a bitch to install though and out of the question if hosted on an ISP without access to mappings. It seems good but gave up on it due to installation complexity on a standalone box even. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Homepage content management
we use ActivEdit from cfdev.com. I'd prefer to use fckeditor (see sourceforge), but we had some issues regarding the spell checking with it. Both work fine for this in CF. DK -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 1:57 PM To: CF-Talk Subject: Homepage content management I need to find a solution already written in CF or get some ideas from you all on an easy way to allow non-programmers to update the company's web site homepage? Thank you, Donna French _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Homepage content management
On Aug 11, 2004, at 1:57 PM, Donna French wrote: > I need to find a solution already written in CF or get some ideas from > you all on an easy way to allow non-programmers to update the company's > web site homepage? Macromedia Contribute 3? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 "Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Homepage content management
I need to find a solution already written in CF or get some ideas from you all on an easy way to allow non-programmers to update the company's web site homepage? Thank you, Donna French [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Farcry Content Management 6.1 Standard
David Brown wrote: > We are looking to upgrade to CF MX (6.1) from CF 5.0 professional. > We are also considering using FarCry CMS. Does anyone know if Farcry > will work with CF MX 6.1 standard or do we need enterprise version? The team behind FarCry (http://farcry.daemon.com.au/) have worked very hard to ensure that the solution runs on CFMX Standard. For the frugal, we also support the mySQL database platform for content storage, and there are a number of hosts offering very economical FarCry shared-hosting including: http://www.austiger.com.au/ http://www.fasthit.net/ Best regards, -- geoff http://www.daemon.com.au/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Farcry Content Management 6.1 Standard
It runs on both. _ From: David Brown [mailto:[EMAIL PROTECTED] Sent: 02 April 2004 16:39 To: CF-Talk Subject: Farcry Content Management 6.1 Standard We are looking to upgrade to CF MX (6.1) from CF 5.0 professional. We are also considering using FarCry CMS. Does anyone know if Farcry will work with CF MX 6.1 standard or do we need enterprise version? David - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Friday, April 02, 2004 10:17 AM Subject: RE: Managment Well, I am sure there are loads of DLL's which do that (not specific for CF and probably reside with Windows already) _ From: Joshua Tipton [mailto:[EMAIL PROTECTED] Sent: 02 April 2004 15:20 To: CF-Talk Subject: Managment Does anyone know of a component or dll built for cf that would allow one to monitor services on network servers? _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Farcry Content Management 6.1 Standard
We are looking to upgrade to CF MX (6.1) from CF 5.0 professional. We are also considering using FarCry CMS. Does anyone know if Farcry will work with CF MX 6.1 standard or do we need enterprise version? David - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Friday, April 02, 2004 10:17 AM Subject: RE: Managment Well, I am sure there are loads of DLL's which do that (not specific for CF and probably reside with Windows already) _ From: Joshua Tipton [mailto:[EMAIL PROTECTED] Sent: 02 April 2004 15:20 To: CF-Talk Subject: Managment Does anyone know of a component or dll built for cf that would allow one to monitor services on network servers? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: content management system db schema
Daniel Farmer wrote: > Does anyone have a database schema that they could share with me for > a content management system for a small to medium size website? > > I just need direction on how to go about setting up the tables etc... > for links, content...etc It'll be a fair bit of work to take a generic schema and write the administration interface for a CMS. Definitely worth having a look at the FarCry opensource community for an almost instant solution. If there is too much functionality in there, you can always turn off unwanted features in the configuration. -- geoff http://farcry.daemon.com.au/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: content management system db schema
I seem to recall a content management database schema at http://www.databaseanswers.com . Not sure how useful it is, but should be a start. I think it's under "database models". Christian -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: 09 February 2004 17:27 To: CF-Talk Subject: content management system db schema Does anyone have a database schema that they could share with me for a content management system for a small to medium size website? I just need direction on how to go about setting up the tables etc... for links, content...etc ~~ Daniel Farmer Coldfusion Developer / Sales / Producer 613.284.1684 ~~ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: content management system db schema
FarCry is open source, and (if I remember correctly) actually has a place you can go view the DB schema it uses right in the online admin area. Probably more complex than you need for a small-medium site, but it might be worth a look. Cheers, barneyb > -Original Message- > From: Daniel Farmer [mailto:[EMAIL PROTECTED] > Sent: Monday, February 09, 2004 2:27 PM > To: CF-Talk > Subject: content management system db schema > > Does anyone have a database schema that they could share with > me for a content management system for a small to medium size website? > > I just need direction on how to go about setting up the > tables etc... for links, content...etc > > > > ~~ > Daniel Farmer > Coldfusion Developer / Sales / Producer > 613.284.1684 > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
content management system db schema
Does anyone have a database schema that they could share with me for a content management system for a small to medium size website? I just need direction on how to go about setting up the tables etc... for links, content...etc ~~ Daniel Farmer Coldfusion Developer / Sales / Producer 613.284.1684 ~~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Macromedia.com - What Content Management System does it us e ?
I think they used the atomz search engine but have replaced it with google recently. Philipp Cielen -- cielen.com From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 5:21 PM To: CF-Talk I believe there's some atomz in there too: http://www.atomz.com/ > It uses a few.Spectra, RIA apps, ColdFusion custom > built, Broadvision... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Macromedia.com - What Content Management System does it us e ?
I believe there's some atomz in there too: http://www.atomz.com/ > It uses a few.Spectra, RIA apps, ColdFusion custom > built, Broadvision... > -Original Message- > From: Ian Vaughan > [mailto:[EMAIL PROTECTED] > Sent: 07 October 2003 14:49 > To: CF-Talk > Subject: OT Macromedia.com - What Content Management > System does it use ? > Hi > Does any body know what cms Macromedia are using to manage > their site, from > the url's it is not Coldfusion based. > Any body have any ideas Interwoven, Stellent, ??? > Ian > _ > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Macromedia.com - What Content Management System does it us e ?
It uses a few.Spectra, RIA apps, ColdFusion custom built, Broadvision... -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 14:49 To: CF-Talk Subject: OT Macromedia.com - What Content Management System does it use ? Hi Does any body know what cms Macromedia are using to manage their site, from the url's it is not Coldfusion based. Any body have any ideas Interwoven, Stellent, ??? Ian _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT Macromedia.com - What Content Management System does it use ?
Hi Does any body know what cms Macromedia are using to manage their site, from the url's it is not Coldfusion based. Any body have any ideas Interwoven, Stellent, ??? Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Content Management Systems - a short list...
I would install CFMX 6.1 from the get go on a new server - Calvin - Original Message - From: "Brian Meloche" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 14, 2003 3:29 PM Subject: Content Management Systems - a short list... > Geoff: > > I am very happy you replied!!! > > I have been very interested in FarCry, and have checked out the website several times, and even played around in the demo. I joined the FarCry-dev list as well, and saw your e-mail last night about this post. > > I wasn't sure if FarCry's open source version came fully featured, even with the demo. It seems that it is. Other than the support, can you point out what the differences are between the purchased version and the open source version? I have been a little unclear about what you don't get in the open source version. > > In our piece of sh... CMS, because of security concerns, the CMS exists on a different server than the public website. On the caching issue, what happens in the event of a CMS change? How do you trigger that a new version of a page has been published? How would/do you do it if the website exists on a different server than the CMS? > > CFMX shouldn't be a problem. We just got a new development server TODAY for a new project, and we have a new license of CFMX for J2EE and JRun (which I will upgrade to MX Enterprise 6.1 as soon as it's installed). We will have a chance to get the server up and running and the content in place in time for January, when we might be ready to upgrade the production servers to MX. > > As soon as the server's up, FarCry's going on it. Thanks again. > > >Brian, > > > >>I would be interested in hearing opinions on some good CF-based CMSs. > > > >>I need to develop a short list so that I can evaluate a few systems. > > > >I couldn't help weighing in with some real information about FarCry. > >It's open source so this is strictly not a sales pitch -- just some > >healthy evangelising. > > > >>Here are my requirements: > >>Permissions > >>Workflow > >>Images and documents stored in Database, but are published to website. > > > > > >Permissions, oh yes -- great security model (LDAP, JDBC/ODBC, > >ActiveDirectory/NT Domain or all at once), use the roles that come > >with the solution or define your own. Restrict publishing to one > >branch or other of the site and more. > > > >Workflow -- yes. Plus versioning, archiving and rollback. > > > >Images in the db? No. we store an object for each image with > >captions, and other metadata but the image itself is on the file > >system. > > > >>Static pages that can be stored in Database - allow versioning. > >>DB should act as a STORAGE mechanism and NOT DYNAMIC, in most cases > >>(This is not how the existing system works). > > > >Not sure what you mean by this. FarCry will serve dynamically from the > >db or you can activate caching which will effectively prevent this. > >But its not generating flat HTML files. > > > >>Oracle 8i/9i - DB maintenance available OUTSIDE of system (Isn't this > > > >>an issue with NQCONTENT?) > > > >We support Oracle -- though our installer doesn't install to Oracle > >you need to import the schema. This should be added soon (open source > >effort -- you might lend a hand :) > > > >>CF5 preferred; CFMX Enterprise possible (we'd have to upgrade; there > > > >>may be COM object issues if we do) > > > >Sorry. CFMX only. It's all CFC based. > > > >>EASY TO USE for the USERS!!! (CMS users have to be able to use the > >>admin, not fight with it every time they want to do something.) > > > >Yep. Plus there is a great thumping user guide and admin guide you > >can print out. > >http://farcry.daemon.com.au/go/users > > > >>Uses stylesheets > >>I should be able to make CMS and site interface changes, if needed. > > > >Hell even have a Breeze presentation on this for FarCry! > >http://daemoninternet.mmalliance.breezecentral.com/p99348887/ > > > >>Simple URLs! - e.g. http://www.easynavigate.com/section/page.cfm > > > >>(our current CMS does not do this and that is the single biggest > >>complaint from the executives) > > > >Oh yep. We have the FriendlyURL servlet integrated as an optional > >plug-in you just turn it on. Works magic in Google. > > > >>RELATIVELY EASY TO GET UP AND RUNNING > >>Relatively easy to customize, if necessary >
Content Management Systems - a short list...
Brian, >I would be interested in hearing opinions on some good CF-based CMSs. >I need to develop a short list so that I can evaluate a few systems. I couldn't help weighing in with some real information about FarCry. It's open source so this is strictly not a sales pitch -- just some healthy evangelising. >Here are my requirements: >Permissions >Workflow >Images and documents stored in Database, but are published to website. Permissions, oh yes -- great security model (LDAP, JDBC/ODBC, ActiveDirectory/NT Domain or all at once), use the roles that come with the solution or define your own. Restrict publishing to one branch or other of the site and more. Workflow -- yes. Plus versioning, archiving and rollback. Images in the db? No. we store an object for each image with captions, and other metadata but the image itself is on the file system. >Static pages that can be stored in Database - allow versioning. >DB should act as a STORAGE mechanism and NOT DYNAMIC, in most cases >(This is not how the existing system works). Not sure what you mean by this. FarCry will serve dynamically from the db or you can activate caching which will effectively prevent this. But its not generating flat HTML files. >Oracle 8i/9i - DB maintenance available OUTSIDE of system (Isn't this >an issue with NQCONTENT?) We support Oracle -- though our installer doesn't install to Oracle you need to import the schema. This should be added soon (open source effort -- you might lend a hand :) >CF5 preferred; CFMX Enterprise possible (we'd have to upgrade; there >may be COM object issues if we do) Sorry. CFMX only. It's all CFC based. >EASY TO USE for the USERS!!! (CMS users have to be able to use the >admin, not fight with it every time they want to do something.) Yep. Plus there is a great thumping user guide and admin guide you can print out. http://farcry.daemon.com.au/go/users >Uses stylesheets >I should be able to make CMS and site interface changes, if needed. Hell even have a Breeze presentation on this for FarCry! http://daemoninternet.mmalliance.breezecentral.com/p99348887/ >Simple URLs! - e.g. http://www.easynavigate.com/section/page.cfm >(our current CMS does not do this and that is the single biggest >complaint from the executives) Oh yep. We have the FriendlyURL servlet integrated as an optional plug-in you just turn it on. Works magic in Google. >RELATIVELY EASY TO GET UP AND RUNNING >Relatively easy to customize, if necessary I think the record installation time is within 3minutes. Sometimes we get bored and race each other :) >I can elaborate more if needed. Join our busy, busy developers lists: http://farcry.daemon.com.au/go/support/mailing-lists >Here are a list of CF-based systems that I know of... >FarCry - Open Source - inspired by Spectra (CFMX based - more of a >framework than a finished system?) Inspired by Spectra. Not sure I'd say that. We have a similar COAPI approach to the treatment of content. But I like to think peoples experience will be a little more exciting. Yep. It is a totally finished system. It works straight out of the box. You can demo the product here (as long as some enterprising person hasn't broken it -- if so, should reset in a couple of hours): http://demo.daemon.com.au/ Yes it is a framework within which you can build and extend -- BUT I stress again, you don't need to do anything to it to get it humming along. In fact first thing people want to do is just change the look and feel. >Spectra - Allaire/Macromedia, now Open Source (framework) Um sort of. Has anyone actually seen the source? >There may be others I don't know of... >Are there any open source CMSs that are CF-based that are ready to go, >out of the box? For something like FarCry, how quickly can it be >configured so that an existing CMS can be converted, users, >permissions, workflow and content? Real quick is the answer. But don't take my word for it. Join the developers list and ask the growing host of folks out there launching new websites. -- geoff http://farcry.daemon.com.au/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Content Management Systems - a short list...
Geoff: I am very happy you replied!!! I have been very interested in FarCry, and have checked out the website several times, and even played around in the demo. I joined the FarCry-dev list as well, and saw your e-mail last night about this post. I wasn't sure if FarCry's open source version came fully featured, even with the demo. It seems that it is. Other than the support, can you point out what the differences are between the purchased version and the open source version? I have been a little unclear about what you don't get in the open source version. In our piece of sh... CMS, because of security concerns, the CMS exists on a different server than the public website. On the caching issue, what happens in the event of a CMS change? How do you trigger that a new version of a page has been published? How would/do you do it if the website exists on a different server than the CMS? CFMX shouldn't be a problem. We just got a new development server TODAY for a new project, and we have a new license of CFMX for J2EE and JRun (which I will upgrade to MX Enterprise 6.1 as soon as it's installed). We will have a chance to get the server up and running and the content in place in time for January, when we might be ready to upgrade the production servers to MX. As soon as the server's up, FarCry's going on it. Thanks again. >Brian, > >>I would be interested in hearing opinions on some good CF-based CMSs. > >>I need to develop a short list so that I can evaluate a few systems. > >I couldn't help weighing in with some real information about FarCry. >It's open source so this is strictly not a sales pitch -- just some >healthy evangelising. > >>Here are my requirements: >>Permissions >>Workflow >>Images and documents stored in Database, but are published to website. > > >Permissions, oh yes -- great security model (LDAP, JDBC/ODBC, >ActiveDirectory/NT Domain or all at once), use the roles that come >with the solution or define your own. Restrict publishing to one >branch or other of the site and more. > >Workflow -- yes. Plus versioning, archiving and rollback. > >Images in the db? No. we store an object for each image with >captions, and other metadata but the image itself is on the file >system. > >>Static pages that can be stored in Database - allow versioning. >>DB should act as a STORAGE mechanism and NOT DYNAMIC, in most cases >>(This is not how the existing system works). > >Not sure what you mean by this. FarCry will serve dynamically from the >db or you can activate caching which will effectively prevent this. >But its not generating flat HTML files. > >>Oracle 8i/9i - DB maintenance available OUTSIDE of system (Isn't this > >>an issue with NQCONTENT?) > >We support Oracle -- though our installer doesn't install to Oracle >you need to import the schema. This should be added soon (open source >effort -- you might lend a hand :) > >>CF5 preferred; CFMX Enterprise possible (we'd have to upgrade; there > >>may be COM object issues if we do) > >Sorry. CFMX only. It's all CFC based. > >>EASY TO USE for the USERS!!! (CMS users have to be able to use the >>admin, not fight with it every time they want to do something.) > >Yep. Plus there is a great thumping user guide and admin guide you >can print out. >http://farcry.daemon.com.au/go/users > >>Uses stylesheets >>I should be able to make CMS and site interface changes, if needed. > >Hell even have a Breeze presentation on this for FarCry! >http://daemoninternet.mmalliance.breezecentral.com/p99348887/ > >>Simple URLs! - e.g. http://www.easynavigate.com/section/page.cfm > >>(our current CMS does not do this and that is the single biggest >>complaint from the executives) > >Oh yep. We have the FriendlyURL servlet integrated as an optional >plug-in you just turn it on. Works magic in Google. > >>RELATIVELY EASY TO GET UP AND RUNNING >>Relatively easy to customize, if necessary > >I think the record installation time is within 3minutes. Sometimes we >get bored and race each other :) > >>I can elaborate more if needed. > >Join our busy, busy developers lists: >http://farcry.daemon.com.au/go/support/mailing-lists > >>Here are a list of CF-based systems that I know of... >>FarCry - Open Source - inspired by Spectra (CFMX based - more of a >>framework than a finished system?) > >Inspired by Spectra. Not sure I'd say that. We have a similar COAPI >approach to the treatment of content. But I like to think peoples >experience will be a little more exciting. > >Yep. It is a totally finished system. It works straight out of the >box. You can demo the product here (as long as some enterprising >person hasn't broken it -- if so, should reset in a couple of hours): >http://demo.daemon.com.au/ > >Yes it is a framework within which you can build and extend -- BUT I >stress again, you don't need to do anything to it to get it humming >along. In fact first thing people want to do is just change the look
RE: Content Management Systems - a short list...
Brian, We have an enterprise version, but that is not as cut and dry pricing as the hosted. The Enterprise version handles DB updates as well. Some of our larger clients running this system are: http://www.akingump.com http://www.venable.com http://www.munsch.com - j james curran technical director nylon technology [EMAIL PROTECTED] 212-691-1134 -Original Message- From: Brian Meloche [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 3:57 AM To: CF-Talk Subject: Content Management Systems - a short list... This looks interesting - but is there any non-shared hosting option? That's all I saw on the site, and that puts it out of the game. This is not an option for us. >Hello, > > >http://www.editingmadeeasy.com > > >This product is geared for most small businesses. It provides the >flexibility of site updates, enforces business rules, and is completely >software independent. It does not require *anything* other than FTP on >the webserver serving the site to be edited. > >The current version does not support versioning, but that is in the >works. > >- j > >james curran >technical director >nylon technology >[EMAIL PROTECTED] >212-691-1134 > > > >-Original Message- >From: Brian Meloche [mailto:[EMAIL PROTECTED] >Sent: Thursday, July 31, 2003 12:52 PM >To: CF-Talk >Subject: Content Management Systems - a short list... > > >Dave, thanks for the reply. CommonSpot and Site Executive seem to be >pretty common recommendations. I know both were covered in recent CFDJ >articles, as well as a few other systems (NQContent and Ektron). Time >to dig out my old issues! :-) > >>Most CMSs don't actually store the images themselves in the database, >>but rather just where the images are stored on the filesystem. > >True. Ours stores images on the file system, but documents are stored >in the database. Both have led to many problems. See below. > >>> DB should act as a STORAGE mechanism and NOT DYNAMIC, in most cases >>> (This is not how the existing system works). >> >>I'm not sure what you mean by this. > >I would like the actual content to be static on the web server. It >would be managed from the system. Versions would be stored in the >database and published to the server via FTP or CFFILE, so that the >content would exist statically. > >Right now, almost all of the content on the website is served up >dynamically from the database. This leads to a complete collapse of >the website when the database goes down. This seems pointless, since >most of the content doesn't change much. If the content was published >statically, but stored in the database for management purposes, that >would eliminate this problem. Only dynamic pages would be affected by >the database going down. > >>> Oracle 8i/9i - DB maintenance available OUTSIDE of system (Isn't >>> this an issue with NQCONTENT?) >> >>I'm not exactly sure what you mean by this, either. > >I took a look at NQCONTENT while at Devcon, and read its review in >CFDJ. The problem with it, if I remember correctly, is you have to >surrender database maintenance to the CMS. In other words, the DBAs >and I couldn't use Oracle software, SQLPlus, TOAD or SQL Navigator to >maintain the database. It's set up almost like you would use >PHPMyAdmin to manage a MySQL database online (just an example - I know >there are MySQL clients - I like MySQLCC, and have had good experiences >with it so far). If anyone's used NQCONTENT out there, and can >prove/disprove this, I would love to hear from you in this thread! > >>CommonSpot meets all these requirements, and I think Site Executive >>does too. CommonSpot uses a pretty simple browser-based interface for >>managing content, but you need to run Windows/IE to get the most out of >>this, I think. > >Windows and IE 6 are the standards here. There are many versions of >Windows in use here, but everyone runs IE 6, so this shouldn't be a >problem. > >>> RELATIVELY EASY TO GET UP AND RUNNING >>> Relatively easy to customize, if necessary >> >>CommonSpot is pretty easy to get up and running. However, I think that >>these two goals are opposed, to a certain degree. In general, it seems >>to me that the easier it is to get started, the harder it is to >>customize. Systems like Spectra (and FarCry also, I assume) are very >>customizable, since they're really more like toolsets than >>applications. > >I realize that. I would like something that would allow both, if >possible. Of course, I am a customization wizard :-), so I am not too >worried
Content Management Systems - a short list...
Isaac: I have seen from your postings that you have Tapestry CMS, but I haven't seen all that much about it. You can contact me on or off list. I would be curious to see a demo, if you have one. >Wish I could say that I'm not a sales person... :) Well that's not >true -- I say that all the time, just not in this context. :) I am >however a developer. > >> DB should act as a STORAGE mechanism and NOT DYNAMIC, in >> most cases (This is not how the existing system works). > >Tapestry does work this way. It allows dynamic content when desirable >or necessary, i.e. rotating banners, etc. but it writes the rest of >the content to file which eliminates all that overhead of grautitous >runtime page assembly (GRUPA - not my term)... I'm working on >versioning currently as well as Oracle support -- hopefully it will >work on both SQL Server and Oracle with largely the same codebase soon >(excepting stored procedures of course)... Permissions and worlfklow >have been written. The workflow component needs updating to be >compatible with the new version I'm releasing hopefully soon, the big >upgrade that broke it being managing multiple content languages. Easy >to use for the users is something you'd have to judge for yourself -- >the interface is designed specifically for the purpose of being >customized, so how easy it is for the users probably has a lot to do >with what kind of forms you give them to enter their content. It does >use the soEditor wysiwyg html editing tool by default. Works on CF5... >As to db maintenance available outside of system are you talking about >backing up the db or editing records in the tables? ... backing up >isn't an issue (outside of the fact that it writes a lot of stuff to >file, so if you restore a backup you may have to do a bit of work to >synch up those files). Editing records outside of the system is >another story -- I wouldn't recommend it. Installs in about 5 minutes >without a single line of programming, though "relatively easy to get >up and running" will of course depend on what kind of content you need >to manage -- you have to build the forms for your users to manage that >content. It's OO which helps make it a little easier if you know how >to write good methods. And I'd like to think it's easy to customize -- >especially thanks to the add/remove components wizard... > >Anyway... I hope that answers most of your questions without seeming >like an overt sales pitch. :) > >Let me know if you'd like to see a demo. > > >s. isaac dealey972-490-6624 > >new epoch http://www.turnkey.to > >lead architect, tapestry cms http://products.turnkey.to > >tapestry api is opensource http://www.turnkey.to/tapi > >team macromedia volunteer http://www.macromedia.com/go/team > >certified advanced coldfusion 5 developer >http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > >> I would be interested in hearing opinions on some good >> CF-based CMSs. I need to develop a short list so that I >> can evaluate a few systems. > >> If you could pick one... which one? And why? Any >> experience with one system or another? > >> We have a CMS here, which is the biggest piece of... well, >> let's just say that I may finally win the battle that this >> system needs a replacement. I would upgrade the existing >> system, but I think that will take too many man hours to >> fix the flaws in the system and... right now, I am a >> one-man development team. > >> Here are my requirements: > >> Permissions >> Workflow >> Images and documents stored in Database, but are published >> to website. >> Static pages that can be stored in Database - allow >> versioning. >> DB should act as a STORAGE mechanism and NOT DYNAMIC, in >> most cases (This is not how the existing system works). >> Oracle 8i/9i - DB maintenance available OUTSIDE of system >> (Isn't this an issue with NQCONTENT?) >> CF5 preferred; CFMX Enterprise possible (we'd have to >> upgrade; there may be COM object issues if we do) >> EASY TO USE for the USERS!!! (CMS users have to be able >> to use the admin, not fight with it every time they want >> to do something.) >> Uses stylesheets >> I should be able to make CMS and site interface changes, >> if needed. >> Simple URLs! - e.g. >> http://www.easynavigate.com/section/page.cfm (our current >> CMS does not do this and that is the single biggest >> complaint from the executives) >> RELATIVELY EASY TO GET UP AND RUNNING >> Relatively easy to customize, if necessary > >> I can elaborate more if needed. > >> Here are a list of CF-based systems that I know of... > >> Ektron - CMS 100/200/300 & eMPower (I am not sure what the >> differences are between CMS 300 and eMPower - I didn't >> find that very clear from their website) >> PaperThin - Common Spot Server >> NetQuest - NQContent >> Systems Alliance - Site Executive >> FarCry - Open Source - inspired by Spectra (CFMX based - >> more of a framework than a f