Questions tagged [data]

All Data related Queries

Filter by
Sorted by
Tagged with
-1
votes
1answer
20 views

I want to fill up/ populate a field of Project Manager, (me as Admin and with my other user's name user) for various projects. How can I do that?

I want to fill up/ populate a field of Project Manager, (me as Admin and with my other user's name user) for various projects. How can I do that? Is it called a Contact Lookup or something?
2
votes
1answer
32 views

Blob is not a Valid UTF-8 String - Only after “–” [duplicate]

I created a CSV parser that parses CSV's from static resources. I am returned with a Blob is not a Valid UTF-8 String error when parsing the character: "–" different from "-". The "–" is apparently ...
1
vote
1answer
21 views

Can't assign permission set to my user after installing Salesforce Data Mask!

After installing the Salesforce Data Mask managed package in my org I get the following error when trying to assign the permission set to my user: Can't assign permission set Data Mask to user ...
1
vote
2answers
26 views

Journey Data View

I just wanted to ask, if I have a journey that was created 6 months back, but I created a new version of the journey within 6 months, will the data view of journey give me the data for this journey or ...
-1
votes
1answer
45 views

LWC (Lightning Web Component) - Properly accessing Data and placing into Lightning Data Table

I have a custom APEX Class that returns two sets of data (Activities & Notes), I would like to individually access each of those arrays of data and place them into separate Lightning Data Tables. ...
0
votes
1answer
34 views

Return an Instance of a Class in a LWC (Lightning Web Component)

Below I am Trying to Return an Instance of a Class to a LWC JS to then handle and display to the End User. I am able to successfully call the Apex Class and Method and return data, but the data is ...
0
votes
0answers
15 views

If I intend to use Person Accounts but need to get contacts into Salesforce before this can be enabled, should I keep contacts 'private'?

I'd just like to understand the implications of this as we unfortunately need to hit an unmovable deadline and having contacts in the Salesforce or is necessary for our Marketing Cloud deadline (we're ...
0
votes
0answers
6 views

Deactivate Data Connector for Salesforce Google Sheets

I know this is somewhat of a reverse question, but it there a way to block Data Connector for Salesforce. Users can view their data in the platform, and have all the tools to manipulate it, but we don'...
0
votes
0answers
11 views

Append in query keeps re-adding same data

Below is my query, I have append selected in my automation and insert it into an FTP. I am querying data views. The problem is the same records keep being added every file creation (%%Year%%%%Month%%...
1
vote
1answer
17 views

Name field and FirstName & LastName for classic email templates

I've just noticed that the merge field for classic email templates for Opportunity Owner or Account Owner is something like {!Opportunity.OwnerFullName} and but the FullName field is not available to ...
0
votes
0answers
25 views

Running Total in the Dataflow

I am trying to use computerelative transformation to calculate running total and running into this error: Transform dim/mea not found in Edgemart My SAQL is case when previous('weeklymeasure') ==...
1
vote
2answers
55 views

Questions: Migrate data from one organization to another

I am in the process of planning out and executing how we're going to migrate data from one SF organization to another. I want to make sure I do this properly. Based on https://help.salesforce.com/...
2
votes
0answers
26 views

how to deduplicate millions of records of custom objects [closed]

In an org of a client we have about 170 million records of mostly custom objects, with some single custom objects having as much as 70 million records on their own. The problem is that for about 10 ...
2
votes
1answer
23 views

What effect does FOR UPDATE have on pending inserts?

FOR UPDATE will lock a row to prevent other clients from accessing it, as is well documented. Does FOR UPDATE have an effect on pending inserts from concurrent clients as well? For example, assume ...
0
votes
1answer
41 views

Updating Accounts without the ID

What would be the most efficient way to update an excel sheet with 400 accounts that do not have an ID nor external ID of accounts that exist in the system. There are about 40,000 accounts in ...
0
votes
0answers
24 views

Uploading speed to Salesforce Marketing Cloud SFTP

Is there anyway we can increase uploading speed to Salesforce Marketing Cloud SFTP SFTP? Our data size is quite huge and with current speed (maximum 2MB/sec) it's taking quite a lot of time to upload ...
2
votes
0answers
38 views

How to Set up Contacts in Marketing Cloud to populate records from Personalization Builder Data Extension

I worked on Personalization Builder and collected data about users based on collection codes set up on a demo webpage. The data is in the Standard Personalization Builder Data Extension. IGO_PROFILES ...
0
votes
0answers
22 views

Formatting data on a lightning component without using lightningrecordform

So, I am currently working on a call out to another service outside of Salesforce. I have made the call out and am successfully returning data from the service outside Salesforce. So, my question is ...
0
votes
0answers
16 views

how to Map Production Id in sandbox without saving the Production ID in sandbox record level

I am inserting a production record to the sandbox while inserting a record I wanted to map production and sandbox records without storing the key on record level. I am facing difficulties in mapping ...
3
votes
1answer
41 views

Using Salesforce as Single Source of Truth [closed]

From a software architecture perspective, are there major issues with using Salesforce as an application's single source of truth (as opposed to a traditional relational database like Postgres)? It ...
0
votes
1answer
20 views

Dataloader Command line error

I need to be able to run Data Loader from the command line (we need a scheduled import/export of data once per day). I created the conf file but get the error message below when I run the proccess.bat ...
0
votes
1answer
27 views

Outbound Email Message empty Attachment Related List

When sending an email, the person receiving it gets both the body text and the attachment being sent out along with it. So it sends out correctly. When I go into the activity history related list and ...
0
votes
1answer
20 views

Unravel table links

What are the relationship links (field names and any other tables used to link) between the four tables below: Account Opportunity Quote User Thanks you for any help
0
votes
0answers
73 views

How does Potential Duplicate Component and Duplicate Record Sets work?

TLDR: Can we retrieve duplicate records in 'View Duplicates' using Apex or SOQL. Details I am planning to create a list view with a column of 'View Duplicates' link or button. Similar to below image ...
1
vote
0answers
23 views

Providing a list of data to non-users securely [closed]

We have a requirement to send data to a list of people who are not users. This data is, and should be treated as, highly secure. These people are owed this data and are allowed to view it but it ...
2
votes
1answer
34 views

Trying to conserve data consumption using record Types?

So, I've been working on a Project where there is a very large volume of data that is kept and there is a relatively low amount of traffic, so it can afford more strain in terms of process/IO. I'd ...
0
votes
0answers
9 views

Salesforce CLI data tree command load Account with User lookup

I want to export and import an account record that has a custom field lookup to User table. I was able to do that with Account and Contact. But I am not able to get User- Account relationship.Is there ...
1
vote
1answer
55 views

Query to compare branches of a journey after a percentage split

I ran a journey where I used a decision split to separate the audience into 4 branches and then sent each branch the same series of emails with varying wait times in between sends. Now I want to ...
0
votes
0answers
38 views

Exceeded max length for one record data loader

How can I spot which record exceeds the limit shown by data loader when I try to insert the CSV in my 'to' salesforce environement? The same files export fine in my 'from' environment. I have tried ...
0
votes
0answers
14 views

In Classic, how can I track the productivity of my team cleaning up records?

Prereqs: Team of 6 employees @ 8/hours a day for 1-2 weeks 25,000-35,000 total records affected (Likely won't get to them all) Various issues -- missing address, missing phone number, "Unknown Last ...
0
votes
1answer
49 views

Help with the SOQL query on multiple objects

Need SOQL or SOSL query to return the Accounts Name having at least a Partner, and/or Contact and/or an Activity attached to it. So far i am able to get the account name where owner ID is '...
0
votes
0answers
16 views

how to restrict visibility of text field rows of values based on user's accountshare on a single record

I have requirement to create an alert everyday displaying list of calls submitted by users sharing same set of accounts over last 7 days. But the text field should display selective values for user ...
1
vote
1answer
231 views

Upserting records using SFDX CLI for a object with no External Id

Below are the available data related commands in CLI. If I want to insert records using SFDX CLI, how to do that? force:data:bulk:delete -- bulk delete records from a csv file force:data:bulk:...
0
votes
0answers
14 views

Migrating Quote object data between 2 SaleForce Orgs. AccountID giving error

I am attempting to migrate data (many objects) to a new SF org. I am using SQLServer as a staging area to map IDs and Talend as my ETL tool. When migrating the Quote object, I am getting an error ...
0
votes
0answers
16 views

Mask Data Based on Opportunity Team

I am wondering the approach to take on this.. The requirement is to have a certain opportunity type where the data is masked to everyone except the members of the opportunity team... We are thinking ...
0
votes
0answers
8 views

Global Report NO LONGER Global

I created a Global Report for all my users that was working just fine. In the last couple weeks, two of my users stopped getting the report. I went to log in as one of them to find out why they ...
1
vote
1answer
290 views

Marketing Cloud to s3

I have an s3 bucket I would like to transfer data to daily via automation. It currently doesn't look like there is a native way to transfer data into s3 via a file transfer activity. Has anyone had ...
1
vote
0answers
38 views

Client MID is now a PARENT MID, but Data Views do not recognize this

We recently added a BU under an existing MID, so now the MID is the "parent" to the newly created BU's MID. However, when we run a simple query and add ent. as a prefix the system does not recognize ...
0
votes
1answer
29 views

Optimal Data Load Speeds

We are currently attempting to load a large amount of data, and are currently using the BulkAPI, with chunk size of 200 and batches of 2000. Is there documentation anywhere that would outline the ...
0
votes
0answers
24 views

Customer Key Of The _PushTag Data View [duplicate]

Is there a customer key to the "_PushTag" data view? I need it for API uses and SSJS development.
0
votes
1answer
38 views

How can I update a parent record by comparing two date fields on parent and child record in Salesforce?

I have two objects namely Account Record and Purchase Record. My scenario is when I create a new Purchase record, it should check Purchase record field (Purchase.LastSODate) and update the Account ...
0
votes
0answers
22 views

Can I access the Message IDs inserted by Marketing Cloud's MTA to resolve SORBS blacklisting?

Our dedicated IP address has been blacklisted by SORBS twice now, and I'm looking to avoid repeat offenses. However, it's difficult to say what kind of behavior landed us on that blacklist. We don't ...
0
votes
1answer
748 views

Limits of API Calls to Salesforce

I want to send data daily to Salesforce. I am building a custom integration. I have tested with Postman the API Rest of Salesforce and it works well, but I have doubts the limits of integrations to ...
0
votes
0answers
9 views

How do I get my salesforce reporting snapshot to map the value from the source report to the correct object?

I am trying to map one piece of data into a new report through a data snapshot. The snapshot runs daily, and reports each day with the info I am looking for, but then additionally maps multiple blank ...
1
vote
1answer
42 views

Help with NOT in SOQL [duplicate]

I'm trying to query for records that do not contain LTD or LLP in the name and are also not assigned to a certain record type. I have tried just about every variation with parenthesis and AND/OR ...
0
votes
1answer
177 views

Access Token stopped working - Connection App problem - INVALID_SESSION_ID

I'm facing a problem with one of my Sandboxes. Today I noticed that Access Token received from Connected App doesn't work (Session expired or invalid - INVALID_SESSION_ID). It's weird because ...
1
vote
1answer
36 views

are data encrypted when it travels from Salesforce to an external system?

My question is how Salesforce encrypted data when it travels to an external system? or are not encrypted? I know that Salesforce use TLS between browser and Salesforce server, but what happen with the ...
0
votes
2answers
64 views

How can I cross-check a large csv file of email addresses against Salesforce data?

We use Salesforce Marketing Cloud and have thousands of records that don't appear to be in Salesforce. Hence, I want to delete these records so the two systems are in sync and we can save some money ...
0
votes
1answer
40 views

Why does Data Loader force a record update (last modified) with only the record ID?

I have seen this and I cannot find documentation as to why just updating with the record ID would force a record update as seen in the "Last Modified Date" field. It seem odd that "updating" the ...
1
vote
2answers
66 views

Variance Alerts for Triggered Emails - Marketing Cloud Email Studio

Within email studio we have a set of triggered emails. While we can go data extract s to see how many emails have been sent, it's often difficult to see if a the variance of a particular send from the ...

1
2 3 4 5
8