Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

CDR2Cloud allows the creation of Customer records one at time using the Create Customer feature or in bulk using the Bulk Load Customer feature. The Bulk Load Customer feature allows you to import large number of customer records from a {CSV} text file. The {CSV} file must contain a customer record on each line with customer data delimited (separated) by commas. 

 

Info
titleCSV File Format

 [custid],[fname],[lname],[cname],[street],[city],[state],[country],[zip],[tel],[tel2],[fax],[email],[email2],[taxcategory],[ratetable],[plan]

Info
titleCSV File Example

CustID,Fname,Lname,Cname,Street,City,State,Country,Zip,Tel,Tel2,Fax,Email,Email2,TaxCategory,RateTable,Plan

ABC12,Blair,Malet,Bollinger Mach Shp & Shipyard,209 Decker Dr,Philadelphia,PA,USA,19132,215-907-9111,,,bmalet@yahoo.com,,No Taxes,Demo Rates,NO PLAN
ABC13,Brock,Bolognia,Orinda News,4486 W O St #1,New York,NY,USA,10003,212-402-9216,,,bbolognia@yahoo.com,,No Taxes,Demo Rates,NO PLAN
ABC14,Lorrie,Nestle,Ballard Spahr Andrews,39 S 7th St,Tullahoma,TN,USA,37388,931-875-6644,,,lnestle@hotmail.com,,No Taxes,Demo Rates,NO PLAN
ABC15,Sabra,Uyetake,Lowy Limousine Service,98839 Hawthorne Blvd #6101,Columbia,SC,USA,29201,803-925-5213,,,sabra@uyetake.org,,No Taxes,Demo Rates,NO PLAN

 

Below is an explanation of the fields

FieldRequiredDescriptionNotes
CustID(error)Customer ID (User Defined) Customer ID from previous system. Not required.
Fname(tick)First Name Customers First Name.
Lname(tick)Last Name Customer Last Name.
Cname(tick)Company Name Customers Company Name (will appear on Invoices you send).
Street(tick)Street Address Street Address (will appear on Invoices you send).
City(tick)City City.
State(tick)Stare / Province State or Province.
Country(tick)Country Country. Must be Alpha-3-digit ISO Code (http://en.wikipedia.org/wiki/ISO_3166-1).
Zip(tick)Zip / Postal Code Zip or Postal Code.
Tel(tick)Telephone (Primary) Customers primary telephone number.
Tel2(error)Telephone #2 Customers secondary telephone number. Not required.
Fax(error)Fax # Customers fax number. Not required.
Email(tick)Email Address (Primary) Customers primary Email Address.
Email2(error)Email Address #2 Customers secondary Email Address.
TaxCategory(tick)Tax Category Name Name of Tax Category to which customer will be assigned. Tax Category must be created before {csv} Import.
RateTable(tick)Rate Table Name Name of Rate Table to which customer will be assigned.Tax Category must be created before {csv} Import
Plan(tick)Plan Name Name of Rate Table to which customer will be assigned.Rate Table must be created before {csv} Import
    

 

 

To Create a New Customer record please follow the steps below:

Steps

  1. Click the [Customers] menu button
    CDR2Cloud - Customer Menu Button

  2. Click the [Create Customer] menu link -button located at the top of the Customer module
    CDR2Cloud - Create Customer Menu

  3. In the [Create Customer] screen, enter the information for the new Customer record as follows:

    CDR2Cloud - Create Customer Screen

    Customer ID [UDF]optionalUser generated Customer ID. Every Customer record created is assigned a system generated Customer ID, however the Customer ID [UDF] field allows you to supply your Customer ID for this customer record.
    First NamemandatoryCustomers First Name
    Last NamemandatoryCustomers Last Name
    Company NamemandatoryCustomers Company Name
    StreetmandatoryCustomers Address Street
    Street2optionalCustomers Address Street (2nd line if applicable)
    CitymandatoryCustomers Address City
    Province/StatemandatoryCustomers Address Province or State
    Postal/Zip CodemandatoryCustomers Address Portal or Zip Code
    CountrymandatoryCustomers Address Country
    TelephonemandatoryCustomers Telephone Number
    Tel2optionalCustomers Telephone Number (other)
    Email (1)mandatoryCustomers Email Address
    Email (2)optionalCustomers Email Address (other)
    FaxoptionalCustomers Fax Number
  4. Click the [Create] button to save the new Customer record
Info
iconfalse
titleCUSTOMER TOPICS

Page Tree
rootCustomers
expandCollapseAlltrue
spacesCDR2CLOUD