Method Community

 

Importing from Excel

Last post 04-22-2013 4:28 PM by Method_Jason. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-22-2013 4:06 PM

    • Juliet
    • Top 500 Contributor
    • Joined on 04-22-2013
    • Toronto, Ontario
    • Posts 7

    Importing from Excel

    Hi,

    I am just starting out as a new user - I want to import information from excel files - I watched the webinar which I think is based on an older version of Method but I got the general idea. My only question after watching the webinar is around the absence of data in a field - for instance one of the fields needed is phone number but for some of the leads I am importing I may not have a phone number. Is this going to cause an issue during the import. For the example of 3 customers all the fields were populated with data but that is an ideal scenario.

    Thanks,

    Juliet

    Juliet

    Juliet Morris
    Business Development Manager
    juliet@velvetsunrise.ca

    Velvet Sunrise Coffee Roasters
    Web Site | Twitter | Facebook
    905.205.0783 | 8-100 Ringwood Drive, Stouffville, ON
    Velvet Sunrise works holistically with independent cafes and businesses that are motivated to improve their taste quality and consistency of product, improve their marketing and brand recognition, reduce cost and waste, while increasing sales, efficiency and profit.
  • 04-22-2013 4:28 PM In reply to

    Re: Importing from Excel

    Answer

    Hi Juliet, 

    This is perfect - We actually JUST made some brand new video tutorials for importing! Click here to find them. You may leave some fields blank without any issues as long as they are not marked as a required fieldTo check this, go to Customize>Tables/Fields and click on Edit Fields... beside the table you are importing to. There is a column on this screen that will tell you which fields in the table are requiredIn your case, the Phone field in the Customer table is not required by default. 

    Hope you enjoy the new videos! 

    - Jason

    Need more help? Ask us about Method consulting services

    Jason Masina
    Community Support Specialist
    Method Integration Inc.
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400
    Fax: 416.640.6027
    E-mail: j.masina@methodintegration.com
Page 1 of 1 (2 items)