Date Created query
3 posts by 2 authors in: Forums > CMS Builder
Last Post: November 11, 2010 (RSS)
By steve_e - November 11, 2010
Hi -
I've just begun the long tortuous process of converting legacy articles on my website from Article Manager to CMS - somewhere between one and two hundred.
I've just run into one issue - I'd like the dates of the original articles to be reflected in the new CMSB articles, so their list pages show them in the same date order.
In AM changing the creation date wasn't a problem as they were by default editable. In CMSB they are system fields. Can you recommend the best way to do this? I initially decided to create a new field with today's date as the default value and manually change the old ones, then sort them by this field. But is there a reason I should be thinking about changing the system field instead?
Regards, Steve.
I've just begun the long tortuous process of converting legacy articles on my website from Article Manager to CMS - somewhere between one and two hundred.
I've just run into one issue - I'd like the dates of the original articles to be reflected in the new CMSB articles, so their list pages show them in the same date order.
In AM changing the creation date wasn't a problem as they were by default editable. In CMSB they are system fields. Can you recommend the best way to do this? I initially decided to create a new field with today's date as the default value and manually change the old ones, then sort them by this field. But is there a reason I should be thinking about changing the system field instead?
Regards, Steve.
Re: [steve_e] Date Created query
By Chris - November 11, 2010
Hi Steve,
Your approach is good, and exactly the approach I'd take too.
If, after you're finished importing your articles, you really wanted to end up without the extra date field, you could use an SQL Statement to copy your custom date field to the createdDate field, then get rid of your custom date field. If that's something you're interested in, please post your Table Name (including prefix) and the name of your custom date field.
I hope this helps! Please let me know if you have any questions.
Your approach is good, and exactly the approach I'd take too.
If, after you're finished importing your articles, you really wanted to end up without the extra date field, you could use an SQL Statement to copy your custom date field to the createdDate field, then get rid of your custom date field. If that's something you're interested in, please post your Table Name (including prefix) and the name of your custom date field.
I hope this helps! Please let me know if you have any questions.
All the best,
Chris
Chris
Re: [chris] Date Created query
By steve_e - November 11, 2010
Thanks Chris, I'll let you know if I need further help!
Regards,
Steve
Regards,
Steve