Re: [gkornbluth] Multi Section Editor with List Options from another

Fri, 26 Oct 2012 16:45:15 -0700

Well I'm getting closer, based on your tips I modified the Section Editor for the Job Positions to be a Single Menu Type, and then created 6 records with Save & Copy:
Apprentice
Journeyman
Master
Foreman
Instructor
Management

Oddly enough, it is showing all the different Job Position Types, even though it's a Single Menu Type. CMSB still shows that there's 6 records there in the MYSQLDB, but there's no way to change them in CMSB.

So I'm close, I've got the drop down list that populates from another Menu Section. The thing I'm wanting to achieve is also showing a drop down selection list for each of the different Position Types selected.

For example the Company has a job site in Denver, and they need a full crew. So they'll hire 1 management person, 1 foreman, 3 Masters, 3 Journeymen, and 6 Apprentices.

So they'd go to the Job Site Section, create a new record in the Jobs Multi Section, fill out all the details, then select Apprentice, Journeyman, Master, Foreman, and Management. BUT they need to be able to specify 6 Apprentices, 3 Journeymen and Masters, and 1 Foreman and Management personnel.

Does that make sense?

I'm going to fiddle around and delete the Single Section Editor and make it a Multi with the Position Type as the Title, and a simple list for the quantity and see if I can get that to work.

[IMG]http://i50.tinypic.com/1h5irk.jpg[/IMG]

Re: [Rusty] Multi Section Editor with List Options from another

Fri, 26 Oct 2012 15:03:30 -0700

The Jobs Section - Down at the bottom where it says Job Positions, and it simply lists them all across in a single row/selection value, I would like to make it so that the list of check boxes is show, like in the next image down, and then if the check box was selected then a drop down with quantity desired would unhide.
[IMG]http://i50.tinypic.com/mc4w7k.jpg[/IMG]

The Positions Section - What I'm driving for, but I'd like to be able to fill the Jobs Section above with the options created below. And the issue is that for this single record there are multiple Type/Position options, but only one (associated) quantity option.
[IMG]http://i50.tinypic.com/zufomg.jpg[/IMG]

The Positions Job Type Editor
[IMG]http://i50.tinypic.com/15y839h.jpg[/IMG]

I honestly think that it's a waste of time (this go round) though it's certainly something that's entertaining to consider employing later on. And yes, I am personally aware that I can do this if I make forms on a site that would provide this kind of functionality. I'll stick with the simple way in the CMS by doing Field Label: Apprentice List - Drop Down Quantity.

Re: [gkornbluth] Multi Section Editor with List Options from another

Fri, 26 Oct 2012 14:50:07 -0700

Oh well I mean manually creating each Job Type as a Drop Down List Quantity (as hard coded) I would think there's got to be a way to pull the labels from a multi-selection list, and also have a specific accompanying quantity value for each item selected from said list.

Re: [gkornbluth] Multi Section Editor with List Options from another

Fri, 26 Oct 2012 14:31:14 -0700

Well that kind of worked.

While I was thinking of a another way to put it I came up with this.

The same way we have a Multi Section Editor where we create a schema for each record that will be created under that section editor, I want to also embed the ability (within CMSB) to setup another sub-section editor. So that within CMSB a company could add multiple jobs and specify the quantity for each. EG:

Company is logged in, goes to Job Section Editor, the fill out the info for that particular job site, and then could click "Add Job" (which I think would require a custom plugin/unique CMSB modding) or using a drop down/Check box select from a list of job types, and then using a drop down select the number of positions that need filled.

I'm starting to think that this is more of a PITA than necessary and I might just end up doing it with Drop Downs so that the Field Label for a the list is the Job Type Description, and then there's a drop down to select the number of employees for that Job Type.

The downside to hard coding it like that is that it's not as Dynamic.

Jerry,

Wasn't there a way in CMSB to Hide Dependant Fields unless the Parent/Primary was filled out?

Thanks again, I'm going to keep tinkering with this all weekend. I'll throw up screen caps in a minute to help clarify.

I'm not doing this to make life difficult on myself, I would just like a good and easy way to ensure I can come up with totals:

Open Positions w/ Company ABC
2 Apprentice
3 Journeyman
1 Master

Then also list all the Openings:

20 Apprentice
30 Journeyman
10 Master etc.

Hope that makes sense.

Multi Section Editor with List Options from another

Fri, 26 Oct 2012 10:27:34 -0700

Hey guys, trying to do something a bit different here and I could use a hand getting it working.

I'm attempting to create a Multi Section that has list options populated from another Multi Section. And while I know a CMSB help/walkthrough has been covered for almost the same thing my implementation hasn't yet worked. And I believe it has to do with how I'm wanting to use that second Multi Section.

Overview of what I'm doing with the Membership Plugin:

User has two options:
Job Seeker
Job Lister (Company)

I want to set it up so that a Company can have multiple Jobs, and then also that Job can have multiple positions and each position a quantity.

So in terms of Multi Section editor population it is something like this.

A user (with the option of Company set in the User Accounts editor) can create
---a Job (in the Jobs Multi Section Editor)
---This Job will have a list of positions filled from another Multi Section Editor (which only contains a Position list and a Quantity list)
utsi
I would like within the CMS to be able for a user that's signed in as a Company to be able to create a Job Listing that pulls the position titles list from the other section editor and presents it as check boxes with an accompanying quantity drop down next to it.

However as I've typed this and thought about this out loud it it seems more and more like something that can be accomplished, however only outside of CMSB. EG: it can be done in php, with CMSB, but not actually done from within the confines of CMSB itself (like actually using the CMSB Section Editor).

The reason I want to do it this way is so that I can easily attribute for a User all the Jobs they have (via a list) and then also collectively for a User all the Positions and Number of Positions (eg: 5 entry level, 2 mid level, 1 management).

And of all the times in the past when I just hammered my way through things and finally got it/a way around it, the time I would just rather pay to have it fixed and done my server is down... Sadface :(

Re: [Jason] Input Date From Membership Signup Form

Fri, 08 Apr 2011 06:51:42 -0700

Interesting, now the results simply give me the leading zero.

Option Value: 01 - Label: December
Option Value: 02 - Label: December
Option Value: 03 - Label: December
Option Value: 04 - Label: December
Option Value: 05 - Label: December
Option Value: 06 - Label: December
Option Value: 07 - Label: December
Option Value: 08 - Label: December
Option Value: 09 - Label: December
Option Value: 10 - Label: December
Option Value: 11 - Label: December
Option Value: 12 - Label: December

I wonder why the month in numeric form is working but the label isn't.

Re: [gkornbluth] Show/Hide Dependant Fields Implementation

Wed, 06 Apr 2011 06:36:44 -0700

Yeah, I hear you there.

// For each section and list field, copy this block
// Fields will start hidden if they appear in any "fields to show" list 
$GLOBALS['SHOWHIDE_DEPENDANT_FIELDS_CONFIG']['the_section_editor']['list_field_name'] = array(
// list option   => fields to show
  ''             => array(), // show these fields when the topmost '

Any particular reason that on CMSB v2.07 that the Month would be populating nothing but December as the Label?

          
          Option Value:  -  Descriptor:

Gives me this:

Option Value: 1 - Descriptor: December
Option Value: 2 - Descriptor: December
Option Value: 3 - Descriptor: December
Option Value: 4 - Descriptor: December
Option Value: 5 - Descriptor: December
Option Value: 6 - Descriptor: December
Option Value: 7 - Descriptor: December
Option Value: 8 - Descriptor: December
Option Value: 9 - Descriptor: December
Option Value: 10 - Descriptor: December
Option Value: 11 - Descriptor: December
Option Value: 12 - Descriptor: December

So I can tell the foreach is working properly, but for some reason it's displaying the month improperly.

CSV Import - Error - Import File Doesn't Exist

Wed, 16 Mar 2011 17:15:45 -0700

Using the CSV Import plugin. Getting an error:

Import file doesn't exist!

I know the import file exists, I checked via FTP & ssh and the file is there.

AND the Live Preview shows me my data.

Full Disclosure.. I previously had issues with "Upload Directory Doesn't Exist!"

Re: [Rusty] ERROR "Upload Directory Doesn't Exist" - tried everything with no resolution

Wed, 16 Mar 2011 17:06:07 -0700

Problem solved. Turned out to be a discrepancy between the following:

Program Directory: '/nfs/c04/h01/mnt/#####/domains/dev-beta.com/html/admin/'
and the
Uploads Directory: '/nfs/c04/h04/mnt/#####/domains/dev-beta.com/html/admin/uploads/'

Unbeknownst to me the path somehow changed. I have no clue, as I don't tinker with those settings. *shrugs* Got it fixed after I changed it to match the program directory.

Re: [meg] ERROR "Upload Directory Doesn't Exist" - tried everything with no resolution

Wed, 16 Mar 2011 16:07:33 -0700

Do we have any idea how this was resolved? One of my servers is on MediaTemple and today when I tried to do a CSV import I get the error:

Upload directory '/nfs/c04/h04/mnt/#####/domains/dev-beta.com/html/admin/uploads/' doesn't exist!

Checked permissions and all the the rest, all were set ok. Can't wrap my head around it.

Re: [Jason] more fav lists

Tue, 01 Mar 2011 16:28:31 -0800

What I want to do sort and filter for a users particular favorites without having to hard code it in the head of the page.

eg:

// load matching records
    list($favoriteRecords, $favoriteMetaData) = getRecords(array(
      'tableName'     => 'items', // update this with your table or tag name
    //  'perPage'       => '10',
      'where'         => " num IN ($favoriteNumsQuery) ",
      'loadCreatedBy' => false,
      'allowSearch'   => false,
    ));

However I'm curious to see if we can do something similar to this:

## ?orderBy=title">Sort by Last Name /\ | ?orderBy=title DESC">\/

    ## Sort by First Name /\ | \/ 

    ## Sort by Email /\ | \/

Right now I want to figure out how to sort a list page, showing items, and sort them so that the favorites come up first or last (DESC obviously)

From what I see if I do it like this:

?createdByUserNum=$CURRENT_USER['num'] is going to show just the documents (if any) created by that particular user, not necessarily showing me documents created by an admin, but favorited by the current user.

I hope this helps/makes sense.

Re: [Jason] more fav lists

Sun, 27 Feb 2011 06:59:51 -0800

Is there a way to filter results from a list page to ONLY show items currently in the Favorites table??

I know we can do:

howevever this:

View Favorites

just shows me records actually created by that user, not ones in their favorites.

Re: [Jason] Using List values between records

Sun, 27 Feb 2011 03:37:51 -0800

Hi Kenny,

Just to refresh, the problem you're encountering is when you're outputting a list value, you getting a number instead of the label? Is that right?

If you're using CMS Builder 2.04 or higher, you can use the label pseudo field like this:

Hope this helps.

YAY THIS IS EXACTLY WHAT I WAS LOOKING FOR!!

I was trying to figure out how to echo the LABEL for a list field, instead of the actual value. In my case it's a height field, and although the value is in metric, I have the labels set to show both the metric amount and the standard amount. Absolutely simple and perfect. YAY!

Keyword spamming: display multi list drop down select value instead of label name unit

Re: [Jason] Question About Sub Categories and Filtering / Sorting via URL

Fri, 25 Feb 2011 15:45:29 -0800

Thanks so much Jason, I'll give that a try! For some reason looking at that now, it looks so familiar, and I can't figure out why I didn't try that earlier. Probably a mental block from too much caffeine.

Question About Sub Categories and Filtering / Sorting via URL

Thu, 24 Feb 2011 17:18:06 -0800

I ask because I'm not sure how to phrase my searching on this one.

This is an example.

Section Editor, List Page for Blog, with blog.php as list view, and blog-detail.php as detail view.
Within the Blog Section Editor I have a Field Label, and Field Name of "Category", with a Field Type of "List" displayed as "Check Boxes (Multi Value)" with the List Options as "Get options from database (Advanced )".

This list or check boxes pulls its values from another Section Editor, list page with "Blog Categories" and the only thing it has is a Title text field.

So.. the Blog Section Editor, populates the Category Check Boxes from the Blog Categories Section Table Name, with the Title for the Label and the Values.
Let's say the categories are News, Sports, & Weather.

I realized late last night that I don't know how to properly filter the sub categories. I know I can filter them if I manually code in Checkboxes as News, Sports, and Weather, however I really like the idea of being able to provide dynamic category population and filtering.

For example, hard coded check boxes filter just fine with this bit of code:

This works for hard-coded, non-dynamic checkboxes

// load records
  list($blogRecords, $blogMetaData) = getRecords(array(
    'tableName'   => 'blog',
	'where' => 'news',
    'perPage'     => '5',
    'allowSearch' => '0',
  ));

This works for hard-coded, non-dynamic checkboxes

However if the Category check boxes are populated via the database from another table, it doesn't seem to work. I did find a few posts that I think were talking about trying to do more or less the same idea with the old Article Manager, but I'm not sure.

Does anyone have ideas where to start on this?

I enabled MySQL Debugging and this bit of code I was trying just tells me that "No Records were found"

This doesn't work, where I'm trying to filter by dynamically populated subcategory
(By dynamically populated, I mean the options in the section editor, not the filtering bit, I have no problem making that hard coded to a page)

 // load records
  list($blogRecords, $blogMetaData) = getRecords(array(
    'tableName'   => 'blog',
	'where' => 'category = news',
    'perPage'     => '5',
    'allowSearch' => '0',
  ));

This doesn't work, where I'm trying to filter by dynamically populated subcategory

[font size=4]And secondly....
I know there is a way to perform simple searching / filtering / sorting via URL, but for the life of me can't remember how to do it.

I want to try and do the easy way of not having to make a hard coded section that declares the 'where' => 'category = news', and parse it with a URL search.

I have done this before, but for the life of me can't remember how to get it to work. It was something like this:

http://www.mysite.com/blog.php?category=news and since it was a link, when the user clicked on it, it auto-magically filtered all the blog posts with News sub category checked. It is quicker and easier than having to hard code the loading of records.

That being said, anyone remember how to do it properly? And does anyone see any reasons why I wouldn't want to do things that way?

Thanks in advance, I really love this CMS..., and the amazing support we have in the small community of coders & IAT staff.

Re: [Rusty] 3 coloumns listing + some more...

Thu, 17 Feb 2011 09:18:06 -0800

One other thing When working with a List Page, how can you go about incorporating CMS FOREACH to set it up to make let's say a 3x3 grid, 3 rows of 3. Obviously some kind of counter would be necessary, to increment for each of the 9 records, and we can use the above code to force it to a new row...

Re: [Jason] 3 coloumns listing + some more...

Thu, 17 Feb 2011 09:11:17 -0800

I want to know why putting this within a foreach to list records (w/ a limit of 3 set within the table query) this works:

THIS WORKS

THIS WORKS

Properly assigning DIV "one_third" to the first two div's, and then "plan_box last" to the third and final div.

But this:

while ( $counter <= 1 ) {
	echo "

";
	 $counter = $counter + 1;
} 	echo "

";
?>

makes all kinds of mumbo jumbo madness, doing what I want, but three times for each item listed within the FOREACH:

It's not that I don't love the fact that I finally hammered this out, however, I just wish I knew what was going on with the % where it's checking to see if $maxCols is equal to zero. I see the IF statement, I see the @ sign (to suppress errors/warnings) I see the counter, but to me it seems backwards. Someone care to fill me in on the steps that are happening there?

BTW that works awesome, and will be very useful for defining custom CSS for the last item in a particular list (when used within a FOREACH).

Keywords I used to search. php counter auto increment list foreach multiple columns limit

Re: [Deborah] inclusion of list field causes error in admin

Wed, 16 Feb 2011 19:17:27 -0800

It's not just you I'm having the exact same problem.

I have 2 section editors, 1 for the Blog, and 1 for Featured Image.

Featured Image is setup with only a Title field (descriptor) and an Upload field (for the image)

Blog is configured just like a regular blog would be, and I have a List Field, Displayed as Pulldown List (Single Item Menu List). List options are pulled from the Database, calling up the featured_image Section Tablename, using the IMG for values, and the title for Labels.

I want to be able to have the functionality to create a blog post and when doing so select a single item from a drop down list choosing the image I would like to show.

I'm getting two crazy errors :D

First error: rears its ugly head when I actually go to view the Blog section, none of the Blog Post Titles are showing up. (modify & erase still do)

Second error: rears its head when I modify a post, at the very top I get the following:

Warning: Cannot modify header information - headers already sent by (output started at /public_html/admin/lib/menus/header.php:13) in
 /public_html/admin/lib/database_functions.php on line 606 There was an error creating the list field. MySQL Error: Unknown column 'img' in 'field list'

Also the record creation fields, stops rendering based upon the location of the "Featured Image" list. If it's at the bottom of the page, all the rest of the record creation fields (like to create a new blog post) will appear, and then it stops rendering past that. If it's first, above title, nothing else will show past that.

EDIT

I think it stems from CMS Building not knowing how to handle the image. What I wanted to do is that if "Image 1" was selected that the file upload URL for "Image 1" would be passed to the "featured_image" variable.

I'm currently experimenting with how to pull the image upload url into the specific blog post based upon list selection within cmsb.

Re: [Dave] Error connecting to MySQL!

Tue, 15 Feb 2011 23:46:05 -0800

Any idea where to find this detailed info in cPanel? I'm having the exact same problem, with the exact same error:

Error connecting to MySQL:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Transitioning to another hosting service. All the DB names and configurations are correct.

Things done so far.

Double Checked the server name via phpMyAdmin, I have it set, as listed in phpMyAdmin to localhost.
Double Checked the mySQL Database, Username, & Password. (check in phpMyAdmin to see that my DB created successfully)

I have tried the following for my hostname:

localhost
127.0.0.1
the IP Address of my server, and I've spent the last 2 hours googling the error...

Re: [Rusty] CSV Import - Multi-Item List Field Workaround

Fri, 11 Feb 2011 10:48:29 -0800

Nevermind, I came to the answer myself. Trial and error :D

the mySql Plugin works great. I was able to update the Table field "permission" by dumping in the Tab Separated values and it took to the checkboxes no problem. Going to try the Drop Down List now... Just wanted to be able to visually see the entire list at once, to make sure that the scrolling action to see the entire list didn't screw it up and somehow un-select a bunch of the options.

Thanks for the help!!

PS. Is there an easy way to modify how many "Rows" or options are shown by default with a Multi-Select Drop Down list?

I know we can manually spec a height for a text input box etc from advanced options..

Re: [ross] CSV Import - Multi-Item List Field Workaround

Fri, 11 Feb 2011 10:04:24 -0800

Hi Rusty

I am not quite sure I understand the problem but it sounds like you are trying to import or export a field that is basically a list of values separated by commas (CSV). Does that sound right? Maybe you could give me a sample of the data you are working with.

On the other hand, if you are looking for a way to update the values in one field for all records in a table, you can always do it using the MySQL console plugin (free)

http://www.interactivetools.com/add-ons/detail.php?MySQL-Console-1011

That lets you run SQL right on your database. Make sure to always have backups before doing anything with this plugin :).

I have a section editor, where I have the basic outline/structure for mutliple items.

One of the fields in that section editor is labeled "Permission" and it is a multi-item list field (mutli-select drop down menu). This allows the admin to limit what pages on the site itself that a logged in viewer will have access to view. The permission field labels are pulled from the User Accounts Full Name field, and the permission field values are pulled from the User Accounts UserNum.

What I'm attempting to do is to import, via the CSV Import plugin, default "Permission" values, so that the admin won't have to sift through hundreds of files, going through and selecting all the users for each and every record.

I exported a few of the records, using the CSV Export plugin, just to see how the exported fields looked. And I tried to import a CSV with the same type of formatting, and got no where.

So what I'm trying to discern is, short of ME having to go into phpMyAdmin and manually pasting the permissions, if there is a way to set the "permission" values on ALL the records in that associated table.

Attached is the CSV Export..., and the way I had formatted my last CSV to try to CSV Import. All the fields except the permissions are getting properly imported.
I've tried calling Permission, all of the following and it just won't take: "permission" , "permission:labels", "permission:values" Obviously when I tried to import the permission lables, I replaced the UserNum with the FullName values.

When I would try to import the numerical UserNum values into the Permission field, it does get imported however what happens is that it's listed as "Previous selection (no longer in list)"

I took a look at the mySql Console plugin, I just don't know enough yet on how to duplicate the values for one record, and update/insert them across the rest of the records in that table. More reading to do.

From what I can see the Example provided:
UPDATE cms_exampleTable SET field='value';

So since my table is called forms, I would cahnge it look like this:
UPDATE cms_forms SET permission='84, 9, 10, 11, 69, 73, 35, 27, 64, 16, 34, 42, 37, 45, 60, 15, 28, 77, 25, 79, 38, 2, 23, 40, 3, 31, 80, 62, 65, 59, 70, 19, 24, 54, 36, 8, 78, 13, 1, 33, 17, 76, 56, 44, 43, 41, 7, 55, 21, ';

Or will I need to put it in as a Tab Separated like this:
84 9 10 11 69 73 35 27 64 16 34 42 37 45 60 15 28 77 25 79 38

Re: [Rusty] CSV Import - Multi-Item List Field Workaround

Wed, 09 Feb 2011 15:14:06 -0800

I know I can manually go through and edit each record individually, is there a simple way to replace the field for ALL the records in a table?

Right now I've only got about 100 records in the table, enough to be a pain but not impossible to do by hand, but I will have many many more.

I'm looking for an easy way to replace/update the values for a multi-item list field across the entire table.

Re: [Jason] Membership Filter

Wed, 09 Feb 2011 14:40:53 -0800

Hi Rusty,

I think you're first attempt was actually the closest. If I understand correctly, you have a section called forms and in each record you want to have a multi-value list that is populated from the accounts table. When you're selecting your forms records, you want to make sure that the current user is selected for all the records returned. Is that right?

In that case, we don't have to worry about creating arrays. In CMS Builder, multi-value lists are stored as a tab (\t) separated string. That means, we know that if our current user number is in the list it would be in the form \tNUM\t regardless of how many other elements are there. We can put this directly in the WHERE clause using LIKE.

Give this a try:

list($formsRecords, $formsMetaData) = getRecords(array( 'tableName' => 'forms', 'where' => "permissions LIKE '%\t".intval($CURRENT_USER['num'])."\t%'", 'loadCreatedBy' => false, 'allowSearch' => false, ));

This will look for records where the permissions string has the current user number with a tab character on either side. The % signs mean that any other number of characters can appear on either side of the string.

Hope this helps.

That more than helped, that worked EXACTLY how I wanted it to. Thanks for your assistance, and the guiding hand.

CSV Import - Multi-Item List Field Workaround

Wed, 09 Feb 2011 14:38:38 -0800

So, since the CSV Import currently doesn't have any way to handle Multi-Item List Fields what are the work arounds?

I've already tried every combination of configuring my CSV file, formatting it to look just like the CSV Export, and was saddened to see that it just wouldn't work.

In terms of the work around, the first thought I had was...

1. Go to phpMyAdmin
2. Go to my Datbase
3. Go to my Field that I'm trying to Import data into
4. Figure out a way to paste the same values for the Multi-Item List Field into all the records

Again this isn't a true work around since it's appending the exact same values to a series of records in a table, but it's easier than requiring my admin to go through and check HUNDREDS and HUNDREDS of values by hand.

Thoughts, Suggestions?