CMS Builder

19 posts by 3 authors in: Forums > CMS Builder
Last Post: January 3, 2008   (RSS)

Hi there,



I have managed to setup cms builder on my pc to test, and I have some questions -

Firstly - is there a pdf manual available?

Second - the 'View website' option - what website? If I click it it goes to the root of the htdocs directory?

Next - I'm using the 'Jobs' section - where can I change the CSS styles for the data that is posted from the DB? Also, how can I change the horizontal dividing rule?

There will be lots more questions ( sorry!) but these will do for now :-)

cheers

Jim

Re: [jimbly2] CMS Builder

Hi,
'View Website' is changed in the Admin area. Login as Admin and under General Settings -

Admin > General Settings > 'View Website' URL

HTH,
Mickey

Re: [Michael Blake] CMS Builder

Thanks Mickey [:)] - found it and changed it!

Do you know how to add a hyperlink to text that's in a field?
I'm sure it's easy but I can't see it - I have a text field for a job description and there is a downloadable pdf that needs to be linked to it?

Thanks again and Happy New Year to you and yours

Jim

Re: [jimbly2] CMS Builder

By Dave - December 31, 2007

>Do you know how to add a hyperlink to text that's in a field?

You generally wouldn't add a hyperlink to a text field, the way you'd do that is to use a wysiwyg field (which has a link button) or use two fields, one for the text and one for the link. Then have have the view display the link around the text.

If that doesn't work for you let me know what you're trying to do and we'll help you out.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] CMS Builder

Hi Dave,



thanks for that - re: the horizontal rule - it appears between each of the job listings, but I can't see the <hr> tag in the code? I just wanted to make it red.

Also - on the hyperlink - I tried to use the wysiwyg bar to add a link but the link icon remained greyed out? I have to add a link to a downloadable pdf with each job ref.

(I reckon the wysiwyg bar could do with a tad more explanation btw! )

I have another challenge for you too :-) - in my job listing page I have navigation to 8 diff coountries and 9 diff job types.
What I'd like to do - rather than have to create a seperate table for each country / job type - can I make the links conditional and just use one table? So for example if I click on the 'Russian' jobs can I use a query something like ' list only jobs with 'Russia' in the location field'..? Does this make sense?

Thanks for your help and Happy New Tear

Jim

Re: [jimbly2] CMS Builder

By Dave - December 31, 2007

>I can't see the <hr> tag in the code?

It's in there. Search for "<hr" with whatever html editor you're using. That way you'll find it whether it's <hr> or <hr />. It's in the list viewer page.

>Also - on the hyperlink - I tried to use the wysiwyg bar to add a link but the link icon remained greyed out?

Try selecting the text you want to link. The button will appear once you select something.

>I have to add a link to a downloadable pdf with each job ref.

You can't upload files through the wysiwyg yet, but that feature has been requested. The way to do it is create an upload field for it. It will automatically display all your uploads (once you add the field the code generator will output an extra block that does that, just copy and paste it into your page).

Alternatively, we're releasing a new version this week that _does_ allow upload through the wysiwyg. So if you want to wait and use that you could do that.

>(I reckon the wysiwyg bar could do with a tad more explanation btw! )

I'll add this to the feature request list. Maybe we can have a help button on there by default that shows wysiwyg help.

>in my job listing page I have navigation to 8 diff countries and 9 diff job types.

It's not that hard to do custom searches. Do you care how the urls look? If the urls were like this would that work for you? (filename doesn't matter)

jobViewer.php (lists all jobs)
jobViewer.php?country=usa&type=administrative (lists administrative jobs in the usa)

Do you need anything more complicated than that?

Also, let me know what your country and jobType fields are called and I'll write up some code for you.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] CMS Builder

Hi Dave,



yep found the hr tag and changed that -

Re: the downloadable pdfs - I tried selecting the text but the link icon remained greyed out - am I doing something wrong?

>You can't upload files through the wysiwyg yet, but that feature has been requested. The way to do it is create an upload field for it. It will automatically display all your uploads (once you add the field the code generator will output an extra block that does that, just copy and paste it into your page).


Sorry - I don't quite understand this - I want people to be able to download the pdf - not upload one?

>It's not that hard to do custom searches. Do you care how the urls look? If the urls were like this would that work for you? (filename doesn't matter)

jobViewer.php (lists all jobs)
jobViewer.php?country=usa&type=administrative (lists administrative jobs in the usa)

Um - again - I'm being thick here - are you saying that if I have a link in the nav to the North American jobs, then a link:
jobViewer.php?country=usa&type=administrative - would query the DB and post the result?

Not sure what you mean by 'do I mind how the urls look' - do you mean this is what would appear in the location bar in the browser?
If so, then no I don't really care...

The country ( location) fields will be:

• Africa
• Bulgaria
• China
• Malaysia
• Russia
> South Africa
• Tanzania
• UK
• USA

Job fields:

• Business development
• Operations
• Commercial & legal

• Analyst
• Consultant
• Senior consultant
• Principal
• Graduate recruitment

• HR
• Finance
• Operations
• Marketing
• General administration
• Project administration
Software specialists

Thanks for all your help Dave -

best,

Jim

Re: [jimbly2] CMS Builder

By Dave - January 2, 2008

>tried selecting the text but the link icon remained greyed out - am I doing something wrong?

What browser are you using? Do any of the other wysiwyg buttons or features work? Try another brower and see if that makes a difference (a recent Firefox or IE)

>I want people to be able to download the pdf - not upload one?

Right, so you already have the pdf somewhere on the web, you can just put in the url to it. If not, you'll need to have an upload field so you can upload it first, and then link to it.

I'm going to do a separate post for the search instructions. I'm still working on that one. :)
Dave Edis - Senior Developer
interactivetools.com

Re: [jimbly2] CMS Builder

By Dave - January 2, 2008

Here's how to setup the job search. Create pulldowns (list fields) for "country" and "type" with the options you listed.

Then, update your 'jobList.php' file (or whatever you named that file).

Insert the following after this line "$options = array();"

// get page number and keywords
$pageNumber = @$FORM['page'] ? $FORM['page'] : 1;
$country = @$FORM['country'];
$type = @$FORM['type'];

// create custom where query
$where = "";
if ($country) { $where .= "country = '" .escapeMysqlString($country). "'"; }
if ($where && $type) { $where .= " AND "; }
if ($type) { $where .= "type = '" .escapeMysqlString($type). "'"; }


Then, update these two options:

$options['pageNum'] = $pageNumber;
$options['where'] = $where;


Finally, add this after the line with "getListRows(...)"

// update page links
$pageLink = "{$_SERVER['PHP_SELF']}?country=" .urlencode($country). "&type=" . urlencode($type);
$listDetails['prevPageLink'] = "{$pageLink}&page={$listDetails['prevPage']}";
$listDetails['nextPageLink'] = "{$pageLink}&page={$listDetails['nextPage']}";
$listDetails['firstPageLink'] = "{$pageLink}&page=1";
$listDetails['lastPageLink'] = "{$pageLink}&page={$listDetails['totalPages']}";


Give that a try and let me know how it works.
Dave Edis - Senior Developer
interactivetools.com