LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: bsmith

This BRAINScript can be placed inside of a filter to convert an export from SF.com into a format that can be loaded into Act!

Note: the node can be setup with a parameter to more easily populate the Salesperson column. To do this:

1. Click Declare Parameters (top left corner of the node)
2. Add a new parameter called salespe title as prefix,
firstname as "Forename",
lastname as "Surname",
businessStreet as "address1",
businessStreet2 as "address2",
businessStreet3 as "address3",
businesspostalcode as "postcode",
businessState as "county",
businesscountry as "country",
businessfax as fax,
businessphone as Switchboard,
mobilepent,
homestreet,
homestreet2,
homestreet3,
homepostalcode, otherstate,
othercountry,
assistantsphone,
businessphone2,
callback,
companymainphone,
homefax,
homephone,
homephone2,
isdn,
otherfax,
otherphone,
carphone,
pager,
primaryphone,
radiophone,
ttytddphone,
telex,
account,
anniversary,
assistantsname,
billinginformation,
birthday,
businessaddresspobox,
categories,
children,
directoryserver,
emailtype,
emaildisplayname,
email2address,
email2type,
email2displayname,
email3address,
email3type,
email3displayname,
gender,
governmentidnumber,
hobby,
homeaddresspobox,
initials,
internetfreebusy,
keywords,
language1,
location,
managersname,
mileage,
notes,
officelocation,
organizationalidnumber,
otheraddresspobox,
priority,
private,
profession,
referredby,
sensitivity,
spouse,
user1,
user2,
user3,
user4[/code:1]