Phoca Forum

Hi Jan,
I'm wondering if there's a lot of code to change if I want to list the entries (in the backend admin area) by Name instead of Title. You see, I imported all of my testimonials from a CSV and they don't have titles. So in the backend admin area, it's all blank (nothing to click on to edit entries). Does this make sense? And is this possible to change?

no such option yet, but I will add it as a feature request list for the next version... (new column need to be done in html, new ordering behaviour for name need to be added, ...)

Jan

Hi Jan,
Two things - I wanted to let you know that I didn't receive the notification in my email that you replied to my post (strange, sometimes I get them, sometimes not)

Other thing: I somewhat overcame the problem by exporting all my entries to CSV and then copying everything in the username column over to the title column and reimporting. Now it shows clickable text for the backend admin area under the title column. Naturally doing this created a problem but I think I can easily overcome with your help:

In the front end, it's showing duplicate (since both name and title are the same) Joe Blow: Joe Blow

I believe this can be fixed by simply hiding either the name or title completely. But then I would also have to hide the input box for Name, and rename the caption for the input box for title, to Name! That way, the user thinks he is entering his name, but the script would treat it as the title, thus it would be visible in the backend.

If you go here:
http://216.120.239.151/testimonials

You can see the first entry for M. Marks. I edited his entry and deleted what was in the Name field. So his name is actually the title. I tested both and if either is missing, it simply aligns the one that is there to the left so that is great. I suppose I could export again and delete everything in the Name column, but that doesn't take care of new entries people will be making. Which is how I came up with the idea of altering the input form itself so that they enter their name and it gets stored as Title.

What do you think?

Two things - I wanted to let you know that I didn't receive the notification in my email that you replied to my post (strange, sometimes I get them, sometimes not)

yes, there is some confusing behaviour in phpbb, sometimes I get it, sometimes not

if I understand it good, names for old entries and titles for new entries... so new will work standard way...so then it should be ok...

Hi Jan, still not getting any notifications of your replies on the forum..
I don't understand your reply very well. I duplicated the name and title column in the SQL table. So now it shows Joe Smith: Joe Smith

Ideally what I would like to display is Name, Location such as Joe Smith, Las Vegas, NV in the title bar of each testimonial.. But then referencing those entries in the backend would be strange because if location was title, it was just have a bunch of locations listed to click on....

nofitications - try to see the user profil ?

maybe I still don't understand it 100%
for new entries you need bot fields - title and the name, for old you can e.g. delete the name, so only title will be displayed in the front (no duplicate data) and in backend title will be displayed in the list ...

Well, this time I got the notification in my email so maybe it's working again.
For the entries I've imported via CSV, maybe I can just delete the name field, and it will just display the title (which I've also set to name)
For new entries, I can just let the people decide what they want to put in the title field. Do you know the SQL command to run to delete the names from all the entries by any chance?

maybe you should not use delete but only SET parameter, something like:

UPDATE the table set names = '' ...

Thanks, I got everything working now. One last thing - on the front end display of the form, how can I change the caption for the field name to say "Name, Location:" (so that they will add their location too) ?