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 Ecample

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 format of the {CSV} file is as follows

 

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