268 replies to this topic

[kit]

Admin can add/edit/delete extra fields for customers and set up field name, field type (input field, textarea field) and field required status (true, false). Customers see extra fields when he create or edit own account.

If you have any queries, bug reports, praise or derision, don't hesitate.

[Viviennes]

Thanks for an outstanding contribution. I picked up two errors though and have one question.

In admin/includes/languages/english/customers.php and also in admin/includes/filename.php there should be no breaks after the line of code. (<br><br> should be removed.)

My question is: where can I alter the length of the heading for the extra field. I would like to use the field for a question and need to give an example answer, but my heading gets truncated.

If you could point me in the right direction it would be much appreciated.

[kit]

Viviennes, on Nov 8 2005, 11:26 PM, said:

My question is: where can I alter the length of the heading for the extra field. I would like to use the field for a question and need to give an example answer, but my heading gets truncated.

Please run sql query: "ALTER TABLE `extra_fields_info` CHANGE `fields_name` `fields_name` TEXT NOT NULL"

[chooch]

hi

this sounds like a really important mod.. if it can do what i think it does, i'll use it and thank the authors

is there a working demo or website that i can click the create_account.php link and se for myself what it does?

thanks

[Viviennes]

kit, on Nov 9 2005, 11:23 AM, said:

Please run sql query: "ALTER TABLE `extra_fields_info` CHANGE `fields_name` `fields_name` TEXT NOT NULL"

Hi Kit

Thank you. That fixed it perfectly.  

[queenkellee]

Hi There! I'm very excited to use this contribution!

..but of course i have an issue. i ran the install.sql, copied and changed all the files, and now in the admin side when i click on extra fields manager I see this:

----

Customers Extra fields  
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1

select ce.fields_id, ce.fields_size, ce.fields_input_type, ce.fields_required_status, cei.fields_name, ce.fields_status, ce.fields_input_type from extra_fields ce, extra_fields_info cei where cei.fields_id=ce.fields_id and cei.languages_id =1 limit -20, 20

[TEP STOP]

Fields Status Action

---

any ideas? not sure if it's a bug or an input error (read: typo). I've checked everything over, but then again...who knows...my eyes are starting to bug out a bit tonight.

Any and all help appreciated

-kellee

[queenkellee]

Still not fixed, more info:
I figured out what's triggering the error, but I'm a mysql/php beginner so i'm not sure what needs fixin here.

from admin/extrafields.php line 119:

$fields_query_raw = "select ce.fields_id, ce.fields_size, ce.fields_input_type, ce.fields_required_status, cei.fields_name, ce.fields_status, ce.fields_input_type from " . TABLE_EXTRA_FIELDS . " ce, " . TABLE_EXTRA_FIELDS_INFO . " cei where cei.fields_id=ce.fields_id and cei.languages_id =" . (int)$languages_id;

I'm sure at some point i will figure it out, but any advisement would be appreciated!

[queenkellee]

I found the problem: nothing to do with this contrib per say. Fix found here:

http://forums.oscommerce.com/index.php?s=&...ndpost&p=740617

[finrod]

Well I have a problem, or 3 of them. But I guess they are depending each other.
The first 2 problems occured when I installed this contrib. I couldn`t find

Quote

<tr>
      <td class="main"><b><?php echo CATEGORY_OPTIONS; ?></b></td>
</tr>

in the file catalog/create_acount.php an therefore wasn´t able to add the line

Quote

<?php echo tep_get_extra_fields($customer_id,$languages_id);?>

.
And in the file catalog/account_edit.php I couldn´t find

Quote

<tr>
                    <td class="main"><?php echo ENTRY_FAX_NUMBER; ?></td>
                    <td class="main"><?php echo tep_draw_input_field('fax', $account['customers_fax']) . ' ' . (tep_not_null(ENTRY_FAX_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_FAX_NUMBER_TEXT . '</span>': ''); ?></td>
                  </tr>
                </table></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>

so i couldn´t enter this:

Quote

<?php echo tep_get_extra_fields($customer_id, $languages_id)?>

. Adding the other lines were no problem, also in this 2 files.
And I guess as a result of these 2 errors i can´t find anywhere in the admin panel of my shop anything to add customer fields.
I hope anyone can help me! Thanks alot!

[kim333]

in "extra fields manager" getting following message/error
------------------------------------------------------------------
1146 - Table 'kmberly_kmberly333.TABLE_EXTRA_FIELDS' doesn't exist

select count(*) as total from TABLE_EXTRA_FIELDS ce, TABLE_EXTRA_FIELDS_INFO cei where cei.fields_id=ce.fields_id and cei.languages_id =1

[TEP STOP]

any help greatly appreciated. would very much like to get this working...soon
thanks kim
p.s. noob!!

[kit]

finrod, on Nov 17 2005, 08:29 AM, said:

Well I have a problem, or 3 of them. But I guess they are depending each other.
The first 2 problems occured when I installed this contrib. I couldn`t find

in the file catalog/create_acount.php an therefore wasn´t able to add the line
.
And in the file catalog/account_edit.php I couldn´t find
so i couldn´t enter this:
. Adding the other lines were no problem, also in this 2 files.
And I guess as a result of these 2 errors i can´t find anywhere in the admin panel of my shop anything to add customer fields.
I hope anyone can help me! Thanks alot!

Hi!
I think that you miss point 6 from installation instruction:
6. In admin/includes/database_tables.php
Add the following lines:
   define('TABLE_EXTRA_FIELDS','extra_fields');
   define('TABLE_EXTRA_FIELDS_INFO','extra_fields_info');
   define('TABLE_CUSTOMERS_TO_EXTRA_FIELDS','customers_to_extra_fields');
or you miss point 11:
11. In catalog/includes/database_tables.php
Add the following lines:
   define('TABLE_EXTRA_FIELDS','extra_fields');
   define('TABLE_EXTRA_FIELDS_INFO','extra_fields_info');
   define('TABLE_CUSTOMERS_TO_EXTRA_FIELDS','customers_to_extra_fields');
Check pleas these points and tell me result. If you have any
questions, don't hesitate - ask me.
Regards.
Marat.

[kim333]

  dear kit,

thanks for the info. you were right...there was something missing in 6 & 11! thought i'd been careful, but i guess not. it's working now & i'm very excited.

thanks for the contrib. it is fer sure needed!
kim    (2 thumbs up)

[amhazing]

queenkellee, on Nov 16 2005, 08:40 AM, said:

I found the problem: nothing to do with this contrib per say. Fix found here:

http://forums.oscommerce.com/index.php?s=&...ndpost&p=740617

Thanks for wrapping up your cross post - helped me solve an ongoing problem unrelated to the contrib

GREAT CONTRIB BY THE WAY KIT!!! Any plans for adding extra data types

regards,

HL

[queenkellee]

amhazing, on Nov 24 2005, 04:37 AM, said:

Thanks for wrapping up your cross post - helped me solve an ongoing problem unrelated to the contrib

No problemo. I always hate it when I'm having the same problem as someone else posted on the forum and there is no response.

BTW, the dev team JUST put up an updated download osCommerce 2.2 Milestone 2 Update 051113 a week or two ago on the main downloads page that fixes a number of bugs, including this one. If you are having any other buggy problems you may want to have a look at least at the bug fixes they did (noted in a file in the package) to save you some heartache.

[khynezu]

Hi,
Could someone pllease help me to insert this new fields in invoice ?

Thank's

[tman00]

Hi All,
Very nice contribution Kit! Thanks a lot.

I installed the extra fields contribution over an Admin contribution. when in the admin screen and i click on the extra fields manager link I get this error
"Access Denied  

No Right Permission Access
Please contact your Web Administrator to request
more access or if you found any problem. "

even though i have all the rights. I am not sure how to bypass this.

Any help would be appreciated.

Thanks in advance
-Tman

[kdeleon]

khynezu, on Dec 12 2005, 12:57 AM, said:

Hi,
Could someone pllease help me to insert this new fields in invoice ?

Thank's

I am with this person here.  Is there a way to make the added fields show up in the invoice and order screen?  Thanks!

[JSA]

kit,

Great Contribution!

I managed to follow your instructions, even though some of the php looked quite dodgy to a php-novice, and it worked first time.

I'm new to OSC and Contributions, so apologies if this isn't the right place for suggestions, however

I think you should update the Contribution to:
- remove the errorenous <br><br> from the package
- include a link back to this topic for ease and support

And a couple of suggested future features (f you have the time):
- example of how to include it in Invoices, etc.
- extending data types

Keep up the good work, it's appreciated.

Regards,
  Julian

[lupole]

I have installed this contribution and love it. It is just what I am looking for. But I was wondering if I could get the results to land in admin/customers/edit just under the newsletter box? I have tried to accomplish this but with no success. I have been able to get the questions to appear there. But I need the answers. Is this a possible?

Thanks

[Andyy]

Great Contribution

I found a bug that when multiple new fields are created and the Required Status is activated, the system increments all values.

ie I have 3 new fields and activated each with Required Status then placed 1 in each Minimum value.
the result was that the user was forced to add

1 character in field 1
2 characters in field 2
3 characters in field 3

It seams that the system is adding all the values together?

Andrew