Announcement

Collapse
No announcement yet.

Importing custom fields larger than 250 char

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Jerry
    replied
    The function add_custom_field() line 178 of ImpExDatabase_350.php is where the field is created in the database, on line 218 its set to 250, you would have to increase that, or change CHAR(250) to mediumtext.

    Then if you are using the ImpEx functions for creating the fields and adding the custom data it will be fine.

    Leave a comment:


  • dkoepke
    replied
    Any ideas on this? I am held up on this project till I can get it resolved.

    Thanks,
    David

    Leave a comment:


  • dkoepke
    replied
    Importing from Snitz on MS Sql.

    Leave a comment:


  • Jerry
    replied
    What system are you importing from ?

    Leave a comment:


  • Steve Machol
    replied
    Nope sorry. I know nothing about MS SQL.

    Leave a comment:


  • dkoepke
    replied
    Ok I have been testing and testing with this. here is what I get.

    I get to a certian point and the next field I add to the select statement for the MS Sql read just breaks it. Doesn't matter what field as long as it is over 250 char, its breaks. The application doesn't error out what happens is I get the screen where it would start to display all the usernames scrolling, and it just sits there for a second with 0, then goes back to the import menu with no records imported. Also when i run profiler, it calls the first count and then the first select statement with nothing after that.

    Any ideas? Anything else I need to describe for you to help me?

    Thanks,
    David

    Leave a comment:


  • Steve Machol
    replied
    I don't know what to tell you then. Perhaps you could provide more details about the exact error you are getting.

    Leave a comment:


  • dkoepke
    replied
    Tried that, same results

    Leave a comment:


  • Steve Machol
    replied
    Try changing the description field in the profilefield table to mediumtext.

    Leave a comment:


  • dkoepke
    replied
    Forgive my ignorance and hope I don't sound strange... this is all new to me so I am learning as I go along.

    What I have after having created all the custom fields from within admincp users fields is the table profilefield has one record per custom field and the types are all over, input is for char that can be less than 250. Text area is for ones that are larger for 1000 char and select for the ones that I have defined as drop down lists.

    for userfields the field types are mediumtext on most and some are char250.

    What if anything do I need to change? Also the import program doesn't error out or provide any kind of feedback, just doesn't import anything when those fields are included in the code.???

    Thanks for your help.
    David

    Leave a comment:


  • Steve Machol
    replied
    Have you checked the database like I've asked? If so, what is the type for this field?

    Leave a comment:


  • dkoepke
    replied
    That's strange, because like I said when I created them through the admincp, it set them all to the correct length and made the profilefields all medium text, so... anything else you can think of?

    Leave a comment:


  • Steve Machol
    replied
    As I said you will need to edit these fields in the database directly to change this.

    Leave a comment:


  • dkoepke
    replied
    I used the admincp to add the custom fields and created them as 1000 char. The impex ignores them if they already exisited.

    Leave a comment:


  • Steve Machol
    replied
    Honestly I don't see how you could have done this since the profile fields are limited to 250 characters. You will need to edit these fields in the database directly to change this.

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X