Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Salesforce

201

Solutions

343

Contributors

Salesforce is a Platform as a Service (PaaS) for cloud-based customer resource management that includes components for case and task management, data management and a help desk system. It also includes systems for add-on applications written in Apex, a proprietary Java-like language, and systems for human resources management, employee training and performance management.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have looked all over and wondered if there was a page either on the Salesforce community or other that had the following questions answered above. I have the following problem. I have a TASK table created from another program where the data was exported cleanly to Excel and saved as CSV. I am trying desperately to import it into salesforce from the CSV attached. I am aware I can use the ACTIVITY table and I can use it I assume if this is not possible. I would think that the TASK table which is so close to what I need would accomodate this without having to create all new fields and having to go with the Table Name Change (from TASK to ACTIVITY Table)

I can see that there are DATA TYPES that designate the width of the field and others that do not. Is there a default width for a:
1. Picklist
2. Email
3. Lookup (User)       "What is the difference between number 3 & 4 ?"Is there a place I can find all of the answers. I have looked and must not be using the right search terms?4. Lookup (User,Calendar)
5. Phone
6. Reference

If there is a default width. Where do I find it.

I am desperate to find out if I can do the following:
1. Identify default widths of all DATA TYPES?
2. Can the widths be changed?
3. Can all DATA TYPES be imported to or is it just some of them?

My biggest problem is getting the right search terms in place to search so maybe the answers are out there. I have not been successful finding them. I have spent days searching....no exaggerations here either. Your help is appreciated.
0
Become an Android App Developer
LVL 11
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

I am confused. When I export from Excel into CSV and I open the format of any of the records in a column (see attached) all it says is the format is GENERAL. Okay that is fine but what is it. A string, a number or what. I am having a terrible time importing into Salesforce.com as I get errors on import. Not knowing or understanding what is being sent out and what needs to be pulled in it is confusing to know just what General is. I have searched for a solution as I would think there would be an answer to that. What is the GENERAL format and how do most programs accept that. I would think it would be a generic older format that is acceptable by most programs easily. Not knowing whether a column with only numbers in it or another column with alpha numeric is handed off so that other applications can determine what value is assigned string or number is a mystery. Can someone solve this for me. Is the data type determined coming from an Excel CSV in GENERAL format or is the application doing the import determining the data type....? Any help is greatly appreciated.
SF_Tasks_Data_CSV.csv
0
Hello,

We want to insert clients information into salseforce.
We have all the information in an SQL Server database.
We want to use ssis to update the data in SalesForce in a daily basis.

We don't want to purshase any toolkit or ready to use component.

Can I find any  step by step tutorial to do so ? I came across some tutorials suggesting webservice option, but It didn't work in my case because of my poor knowlege in Webservices.

Any help is apprecited.

Thanks
Salma
0
I am using parser.zapier.com to "attempt to parse an email but the data in the form isn't being recognized. Any ideas? I need to set up a mail forwarder, parse, then use zapier or equivivalent to add to salesforce.

form in email to forward
after. No Bob Smith

Capture2.PNG
0
Please provide me with instructions on how to use Sales Force to create contacts from all emails within a user's email account that extracts the contact's information (such as the contact's name, email address, phone number, address, fax number, etc.) using information that is extracted from each individual email.

This information is usually found at the bottom of the email within the sender's signature but can follow different variations as shown in these email signature examples.

I need to extract this information from each individual email and record it in a contact for each person who has emailed me.

How can Sales Force be used to do this?
0
NOT a FIELD LABEL. Can an existing default field name be renamed or do I have to create a custom field only...?

I ask because I need to change the TASK Table in Salesforce but there is no way to add a new Custom Field in the TASK Table in the Object Manager. See image.

Note the NEW custom field button is not available
If there is a way to do this please tell me how? Thank you.

Here in another table you can see a NEW custom field button is available. My problem is it looks like I am going to need to change the types and or names of some of the fields in the TAST Table in order for it to work.

New Button is available under CONTACT Table....Why not the TASK
0
Dear Experts

We have done various online integration website, online chat, facebook, and also other channels like CTI our marketing team would like to create campaign for every spend that they do on online and also offline like trade show etc,  we have following process
1) spend on various marketing activities in internet marketing like google Ad words, face book Ad campaign etc and also offline like trade show and bill boards, news paper, TV for a campaign
what would be best practice should we have to create campaign for each of the spend like google ad words X amount  and face book a separate campaign of y amount I mean should we have to create multiple campaigns for each activity or create one campaign as parent and make every activity spend as children for this , please suggest
0
I have two WSDLs that I would like to generate into apex classes using the "Generate from WSDL" button in Salesforce, but I'm getting an initial error that the schema is incorrect.

Unsupported schema type: {http://www.w3.org/2001/XMLSchema}anyType

Open in new window


I have limited knowledge of working with WSDL files and wanted to see if this is an error that can be fixed or if the WSDL cannot be converted to an apex class due to types that are simply not supported in the apex language.

If so, are there other alternatives to create the apex class/methods needed? Or, is it just a manual process?

I've attached the two WSDL files saved as flat files.

Thanks for any help.
SSOws.txt
OLRws.txt
0
Dear Experts

We are using sales force automation sales force.com for the marketing, sales and customer support with multi channel integrations  like CTI, online chat, web2lead, face book, etc and campaign management , lead routing auto and manual , email
 marketing , opportunity management, activity management I have done the implementation and my designation is VP Sales force automation, I would like to prepare the detailed job description and provide to the management ,  sales force administration, and training please list the detailed job description so that this will be very much helpful, thanks in advance.
0
I have a long text field in Salesforce form and using Regex to validate the duplicate entries.

For example my entries are - TESTP1, TESTP2, TESTP1,

I need a regex to identify the duplicate value TESTP1.

I need to use one regex expression to have this validated.
0
Receive 1:1 tech help
LVL 11
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Hi All,

I am having issues with testing my amazon echo Salesforce integration. I currently have two features that I need to app to do. First to search an account in the system and next to insert a custom object record into the system. I am able to query a record from the system without any issues. However I am unable to insert a custom object record into the system. I have the app set up that it should come back with any errors that happen during the insert process. When I try to run the process I run into the issue that the app says that the record was created in the system but when I look at the system I don't see the record. I have tried everything I can think of but I can't seem to find a solution. Has anyone ever run into a similar issue? If you have can you point me in the right direction so I can test to make sure everything is working correctly.

Thank you,
Dan
0
My nonprofit organization in Los Angeles is ready to migrate our current Microsoft Access database to the Salesforce and NPSP platform. I have received SOWs from three Salesforce recommended implementers, and, while I'm certain they all are very competent I don't want to break my budget for this project. Can anyone recommend an alternative company that would be able to handle this migration?  No de-duping or data cleaning is necessary as these processes have been completed.
0
 Dim path_original As String = "C:\Booking Number\Accounts\Epicor Invoices\Source\"
    Dim path_error As String = "C:\Booking Number\Accounts\Epicor Invoices\Error\"
    Dim path_success As String = "C:\Booking Number\Accounts\Epicor Invoices\Completed\"

    Dim parentId
    Dim directoryName As New DirectoryInfo(path_original)
    Dim dirFileName As IO.FileInfo() = directoryName.GetFiles()
    Dim fsize = dirFileName.Length
    'Console.WriteLine(fsize)
    If (fsize > 0) Then
        Dim dirReadFileName As IO.FileInfo
        Dim logFileName As String = String.Format("log{0}.txt", Now.ToString("MMddyyyy_hhmmss"))
        Using w As StreamWriter = File.AppendText("C:\Booking Number\Accounts\Epicor Invoices\logs\" + logFileName)
            Dim sobj As SFDC.SforceService = New SFDC.SforceService
            Try
                Dim lr As SFDC.LoginResult = sobj.login("username", "password")
                sobj.SessionHeaderValue = New SFDC.SessionHeader
                sobj.SessionHeaderValue.sessionId = lr.sessionId
                sobj.Url = lr.serverUrl
                'Dim sobject As WebReference.sObject = New WebReference.sObject
                Console.WriteLine(sobj.Url)
            Catch ex As Exception
                Console.WriteLine(ex.Message)
            End Try
            For Each dirReadFileName In dirFileName
                Try
                    Dim attachment As SFDC.Attachment = New SFDC.Attachment
                    Dim filenames = 

Open in new window

0
Dear Experts,

We are running a ADFS Server 2012 R2 in combination with the Azure Microsoft multi-factor authentication Server. (It's the on-premise version of the MFA server).

We use these both servers to authenticate our users to salesforce. Right now, we say that all unregistered devices and all users coming from an external source must go through the MFA server.

Please see the screenshot attached.

The location tag isn’t working at all. So, my first question is, where can I define what the internal source is? I would like to include the internal IP-range to it.

Please note, that we are using the ADFS without a web application proxy.

My second question is, how can I register devices to adfs. Because we mainly connect to salesforce from our RDS servers. If I cloud register the rds servers to adfs, then I don’t care about the location tag.  


Thanks SGTA14
0
I am actually trying to implement text-to-speech conversion in Salesforce by hitting a third-party api.

When i send the request through Postman, i get back the proper response in .wav format. However, I'm not being able to handle this reponse programatically in salesforce end, as I am not able to store the response in any audio object.

Any assistance would be greatly appreciated.

Thanks in advance.
Abhishek.
0
I've attempted unsuccessfully to upload a file from apex code to my AWS S3 instance.  I receive the following error:

The request signature we calculated does not match the signature you provided. Check your key and signing method.

I've confirmed that both the Key and Secret are correct (tested successfully requesting a url for an existing file in the bucket), so I'm assuming the issue must be the way I am forming the signature for this particular request:

 String formattednow = System.now().formatGmt('EEE, dd MMM yyyy HH:mm:ss Z');

  String stringToSign = 'PUT\n\n' + 'application/pdf' + '\n'+formattednow+'\n/'+ 'bucketname' +'/'+ 'testFile.pdf';     

  Blob file = Blob.toPDF('Testing string to pdf.');

  HttpRequest req = new HttpRequest(); 

  String signature = make_sig(stringtosign);

  req.setMethod('PUT');
  req.setHeader('Authorization', 'AWS ' + awsKey.Key__c + ':' + signature);
  req.setHeader('Content-Type','application/pdf');
  req.setHeader('Content-Length',String.valueOf(file.size())  );
  req.setHeader('Date', formattednow);
  req.setEndpoint('https://s3.amazonaws.com/' );   
  req.setBody( EncodingUtil.base64Encode(file) );

  Http http = new Http();
  HTTPResponse res = http.send(req);

Open in new window


Where am I going wrong? Any help will be greatly appreciated!  A fix using AWS Signature V4 would also work.

P.S. The make_sig function:
	private static String make_sig(string canonicalBuffer) {
		String macUrl ;
		String signingKey = EncodingUtil.base64Encode(Blob.valueOf(awsKey.Secret__c));
		Blob mac = Crypto.generateMac('HMacSHA1', blob.valueof(canonicalBuffer),blob.valueof(awsKey.Secret__c)); 
		macUrl = EncodingUtil.base64Encode(mac);
		return macUrl;
	}

Open in new window

0
I am a network engineer who has been tasked with rolling out a backup service for our Salesforce account and have been looking at three vendors with the assistance of our (non-IT) salesforce administrator.  This is a system that he will administer; I'm just involved to do the due diligence.

His preference is Spanning, although he also likes Backupify.  Between the two, he's stated that he'd be completely okay with either product.  We've also looked at OwnBackup.  Our salesforce admin says he could certainly "live with" OwnBackup and I shouldn't refrain from choosing them if I thought they were better, but he likes the other two better.

The sales reps from all three vendors have stated that their product is the only one that will restore all data (including metadata, related records, etc.), and that using one of the others may potentially result in significant disruption to our environment in the event of a problem.

For my part, I am only concerned with three things.  First, we need an indefinite retention period.  My team isn't yet certain what our legal requirements will be in that regard (the company is expanding rapidly, and adding offices nationwide), and we'd prefer to not have to worry about it.  Second, we want to ensure that any data transmission is encrypted (obviously).  Third, we want to ensure that any restoration actually works.  Normally, I wouldn't bother saying that third point as it would seem obvious, but each of these vendors is saying that this is not …
1

Salesforce

201

Solutions

343

Contributors

Salesforce is a Platform as a Service (PaaS) for cloud-based customer resource management that includes components for case and task management, data management and a help desk system. It also includes systems for add-on applications written in Apex, a proprietary Java-like language, and systems for human resources management, employee training and performance management.

Top Experts In
Salesforce
<
Monthly
>