Closed

Match names in a csv file with contacts in a Salesforce Database & Create records

Bank deposit records in a csv file need to be imported into a Salesforce custom table called Debtors.

The Contact who made the deposit has to be identified before the Debtor record is saved.

The reference in the bank deposit record has to be matched with the contact name, alias and/or phone number. These are not always accurate and often have spelling errors

A sample file from the bank is attached.

Records with codes JCRTI, TCR15, JCR10, DEP01, TCR07 are to be imported

The date format needs to be changed to an acceptable SF format

Zulu time needsto be added to deal with the time zone in Australia so the imported date is not incorrect by one day,

A custom object debtor record needs to be created including information like amount, date, reference, code

The Contact who paid this amount needs to be identified by matching the name or phone number from columns F & G with contact records

If a definite match is not available the debtor record should be saved with Contact name "Unresolved"

Question - how will you create and test this code in my SF instance when we dont yet have a trusting relationship ie we dont want you to have administator rights

I look forward to your answers. This will be the first of many SF projects

Skills: Salesforce.com

See more: salesforce one, csv codes, create custom object salesforce, c&f bank, c and f bank, salesforce.c, bank codes, salesforce com database, sample test question, salesforce, salesforce test, my contacts, match, debtor, database australia, csv file, bank deposit, names contact information, salesforce object, table csv, question bank database, salesforce|, salesforce custom object, code create database record, csv table

About the Employer:
( 0 reviews ) Australia

Project ID: #4197267

13 freelancers are bidding on average $438 for this job

yurybondarau

I am salesforce certified developer with 2+ years of experience.

$300 USD in 3 days
(11 Reviews)
5.0
NishantBamb

Hello, Please refer your Inbox for my experiences with Salesforce and more details. Thank you.

$400 USD in 5 days
(15 Reviews)
4.7
funnyhoney

I would be happy to help you with this.

$600 USD in 25 days
(1 Review)
3.5
hafeez

Please review my private message

$400 USD in 5 days
(2 Reviews)
3.0
sirangi1989

Please find PMB for more details.

$400 USD in 5 days
(0 Reviews)
0.0
deepakgiria

Hi, check PM for more details.

$350 USD in 4 days
(0 Reviews)
0.0
snikolaev

I am salesforce certified developer located in USA San Jose CA. Hire me if you need to be done with this project with height quality

$750 USD in 14 days
(0 Reviews)
0.0
FINGERRPRINT

we can assist you

$300 USD in 5 days
(0 Reviews)
0.0
subramanyamsubu

Hi Rusell, Hope this message finds you well. I have a optmized dynamic tool in my hand which will check the data accuracy before importing them let's say an instance i have contact with the name ABC in SF databas More

$350 USD in 5 days
(0 Reviews)
0.0
salesforce123

Hi, I have rich experience in Salesforce, APEX and testing framework. My profile contains my experience information. Thanks.

$350 USD in 7 days
(0 Reviews)
0.0
sfdc2013

Hi Russel, I am having extensive experience in [url removed, login to view] (Certified). Apart from having hands on expertise in VF pages and Apex I have sound knowledge of Salesforce customization. I am very skilled to use data More

$500 USD in 3 days
(0 Reviews)
0.0
chandanburnwal

Hi, I have vast experience in Salesforce.com. As you mentioned you wouldnt like to give the administrator access to your environment we could set up a dummy developer org in which I could show you your requirement a More

$250 USD in 10 days
(0 Reviews)
0.0
qualifiedcoders

Hi, Salesforce Experts. We have read your [url removed, login to view] are interested in your [url removed, login to view] have completed 150+ big projects in last 5 years. Please check private message board for details.

$750 USD in 6 days
(0 Reviews)
0.0