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

 The first line in the CSC file must contain the colum  header labels

Below is an explanation of the fields

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

 

 

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