Method Community

 

Customer Import Error

Last post 03-15-2012 2:22 PM by Method_Valbon. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 03-15-2012 9:38 AM

    Customer Import Error

     

    I am a new user to Method and I am having trouble importing my contacts. I am getting the following error message:

    ERROR:Value '379xxxxxxx003', which you tried to insert into column 'AmexNumber1' of type Integer could not be interpreted as an Integer.
    AmexNumber1 is a custom field that I added to the customer screen. Can someone please help me with this so that I can update my customer list.

     

  • 03-15-2012 9:54 AM In reply to

    Re: Customer Import Error

    Answer

    jnairn -

    First, I edited your post.  We don't want that number in a public forum :).

    Now, the reason you are seeing that is because of the type of field you chose.  An integer is too small to hold that value as a number (see http://en.wikipedia.org/wiki/Integer_overflow if you are interested).

    You'd be better off just making the number a text field.  So just delete the field and recreate it.  Give it a size of 255 characters just to make sure it can handle my next point...

    Finally, best practice is to encrypt any sensitive data that you are going to store raw credit card numbers in Method.  If you are going to be storing sensitive data, you should loop though your data and update it using the encrypt action to make it unreadable, and then right before using it run the decrypt action to make it readable again.

    Paul 

  • 03-15-2012 10:10 AM In reply to

    Re: Customer Import Error

    Thanks for the response and for the "heads up". But I had already edited the number, it wasn't a "real" number. I'm smarter than that :).

     

    I will give this a try and let you know if it works. Thank you!!!

  • 03-15-2012 10:20 AM In reply to

    Re: Customer Import Error

    Can you explain how to encrypt and decrypt data in method, please?

     

     

  • 03-15-2012 10:31 AM In reply to

    Re: Customer Import Error

    Hi there,

    In Method there is an action Encrypt/Decrypt Field/Object. This action allows you to either encrypts the value so that it is unreadable, or decrypts a previously encrypted value to be readable again. If the encryption/decryption fails, the original value will be returned.

    I believe what Paul was suggesting was to use the Start Loop Through Table action and the Encrypt action to go through all existing records you need to encrypt first and then decrypt each of them individually as they are needed or used.

    Hope this helps.

    Need more help? Ask us about Method consulting services.

    Valbon Shabani
    Director of Education
    Method Integration Inc.
    Toll Free: 1.888.925.6238 ext. 715
    Local and overseas: 416.847.0400 ext. 715
    Fax: 416.640.6027
    E-mail: valbon@method.me
    Website: http://www.linkedin.com/in/valbon
  • 03-15-2012 12:25 PM In reply to

    Re: Customer Import Error

    Thank you. Where do I locate these actions?

  • 03-15-2012 2:22 PM In reply to

    Re: Customer Import Error

    Oh wow! You're missing all the best parts of Method. I'm going to provide you with two links.

    1. Community Webinars. Scroll down to the section on 'Customization and find 'Introduction to Actions - Level 1'

    2. Method Help Center where you'll also find references to our Actions & Objects.

    Need more help? Ask us about Method consulting services.

    Valbon Shabani
    Director of Education
    Method Integration Inc.
    Toll Free: 1.888.925.6238 ext. 715
    Local and overseas: 416.847.0400 ext. 715
    Fax: 416.640.6027
    E-mail: valbon@method.me
    Website: http://www.linkedin.com/in/valbon
Page 1 of 1 (7 items)