Does anyone have a suggestion on how I can possibly create a printable report of all links in all categories, or even all links added since xx/xx/xxxx?
Great thanks! I was able to create this page as you said, but I can't get the toplist to work the way I need it to.
This is what the generator gave me <CONFIG>links,catid;title,50000,ascending;ascending,time > (UNIX_TIMESTAMP() - 86400*365),,6,0,0,0,,0,1,</CONFIG>
My first problem is that I tried adding type='regular' to the expression so that only regular categories are included, but it would not load when I did that. Instead I got a sql error. Let me know if you need to know what kind of error and I will recreate it.
My second problem is that in the toplist generator I told it that I wanted to sort by catid first and then title. Is there anyway, instead to sort by catname? It's not one of the choices listed in the toplist generator.
Shame I can't sort by catname, in which case is there some other field I could possibly use or create so that the links will sort by the categories alphabetically first? I know that the bulk edit page gives me an "order" field, if I number the categories using whatever that field is would I be able to sort by that? And will that then affect the way the rest of the site is laid out?
The priority (sort order) field isn't available to links either, only categories. There are no link fields that have anything about the category except the id number.
Comments on Printable reports
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Does anyone have a suggestion on how I can possibly create a printable report of all links in all categories, or even all links added since xx/xx/xxxx?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Make a toplist in a custom template. Call the page with usewrapper=no to suppress the wrapper.
Added since a date would tricky, but added in the last X days would just be the toplist condition time > UNIX_TIMESTAMP() - (86400 * X)
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Great thanks! I was able to create this page as you said, but I can't get the toplist to work the way I need it to.
This is what the generator gave me
<CONFIG>links,catid;title,50000,ascending;ascending,time > (UNIX_TIMESTAMP() - 86400*365),,6,0,0,0,,0,1,</CONFIG>
My first problem is that I tried adding type='regular' to the expression so that only regular categories are included, but it would not load when I did that. Instead I got a sql error. Let me know if you need to know what kind of error and I will recreate it.
My second problem is that in the toplist generator I told it that I wanted to sort by catid first and then title. Is there anyway, instead to sort by catname? It's not one of the choices listed in the toplist generator.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
To make it regular links, the condition would be time > (UNIX_TIMESTAMP() - 86400*365) AND type='regular'
There's no way to sort by category name.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Thanks, I was missing the "AND". It works now.
Shame I can't sort by catname, in which case is there some other field I could possibly use or create so that the links will sort by the categories alphabetically first? I know that the bulk edit page gives me an "order" field, if I number the categories using whatever that field is would I be able to sort by that? And will that then affect the way the rest of the site is laid out?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
The priority (sort order) field isn't available to links either, only categories. There are no link fields that have anything about the category except the id number.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Ok thanks that answered my question.