Questions tagged [jitterbit]
The jitterbit tag has no usage guidance.
35 questions
0
votes
1
answer
1k
views
Duplicate Error on Upsert
I have created an operation in Jitterbit to run an upsert on two custom objects and one standard object: Lead, Project_c and ProjectLead_c
The ProjectLead object is just a junction object that relates ...
0
votes
0
answers
159
views
Dealing with failed records in an Upsert operation
With the help of responses to my previous posts I was finally successful in Upserting Contacts in Salesforce via Jitterbit using External Id. However two records failed. I am thinking these failed ...
- 871
0
votes
1
answer
299
views
External IDs and relationships not working correctly
I set up an external ID on a custom object
I set up a relationship on opportunities to reference that custom object
I upsert the custom object (including the external id)
I upsert the opportunities ...
- 1
1
vote
0
answers
237
views
Can Jitterbit (or any ETL tool) do field-by-field "insert null values" without using the bulk API?
I can see that when an ETL tool is using the Bulk API, there isn't a global "insert null values" setting and you have to explicitly set cells to #N/A to get them to overwrite to null.
That's nice, ...
- 1,257
1
vote
2
answers
1k
views
How can we skip the some records through SOQL
I am retrieving attachments through jitter bit SOQL query, but my all records are not retrieving through in the bulk so I have set the limit of 1000 but when I have download next 1000 records how can ...
1
vote
1
answer
247
views
Duplicate_Rule_Atomic or non Atomic
I have a question on duplicate rule.I am loading a list of account records in to my salesforce org using jitterbit and to eliminte the insertion of duplicate records I have a duplicate rule enabled on ...
- 11
0
votes
1
answer
44
views
Salesforce Release and Jitterbit Integration [closed]
What (if any) effects will a Salesforce Release eg. Spring 18 have on Jitterbit Integration?
- 25
1
vote
2
answers
662
views
Assigning owner to ContentNotes
I am trying to assign the OwnerId to ContentNote (Notes) using Data Loader on new inserts, however I get the following error:
Documents in a user's private library must always be owned by that user....
- 4,906
0
votes
0
answers
57
views
Examining A Data Load's Tentative Results Without Really Loading Data
Let's say I have a "Contact" object full of 50,000 records, 30,000 of which have a value in "MyExternalId__c."
And then I have a CSV file full of 10,000 records, all of which have a value in "...
- 1,257
0
votes
1
answer
132
views
Jitterbit in salesforce [closed]
I am using Jitterbit in salesforce but I don't know Jitterbit Script and have no idea how to use it and why we use it and what are the advantages of using script.
1
vote
0
answers
113
views
Scheduled Jitterbit Upsert
I have a couple different upserts built out in Jitterbit that are all supposed to be running nightly. Some of them are working and some of them are not. As far as I can tell they are set up the exact ...
- 1,057
1
vote
0
answers
988
views
Marketing Cloud tracking data into Sales Cloud and Analytics Cloud
I'm investigating ways to get Marketing Cloud tracking information into Analytics Cloud. Marketing Cloud Connect is installed, but all Marketing Activity is initiated and takes place in Marketing ...
0
votes
1
answer
685
views
SFTP connection from salesforce to Globalscape
I need to connect my salesforce instance to Globalscape(file transfer suite) using a SFTP conncetion to extract a flat file.
I am looking for a freeware so that I could automate the same through a ...
- 79
11
votes
1
answer
503
views
Why do some data loading tools work with professional edition?
When looking at the Salesforce edition comparison chart, it states that Integration via Web services API is only available if you pay for it.
Indeed, when I try to load data into my org using Apex ...
- 3,771
1
vote
1
answer
412
views
Can we use JitterBit Loader it import data into 2 related objects in a single load?
Can we use JitterBit Loader it import data into 2 related objects in a single load ?
Right now we are loading it twice using dataloader
Import parent object
Export Parent Object and update csv
...
- 375
1
vote
1
answer
99
views
What are the benefits of Jitterbit over Lightning Connector?
Jitterbit appears to be priced cheaper than Lightning Connector. Besides from that, are there any other benefits to using Jitterbit instead of Lightning Connector, in the context that you wish to ...
- 3,762
1
vote
0
answers
67
views
Duplicate prevention and Merge on Account
We have an integration with a legacy system and we use an Unique ExternalID to send personAccount upserts back and forth between salesforce and the legacy system using JItterbit.
However, that ...
- 11
0
votes
1
answer
176
views
Using Jitterbit for cooperative work
Our team started to work on integration Jitterbit with other our systems and we faced with such issue - how better to organize cooperative work in Jitterbit Studio on the same project for few ...
- 407
-3
votes
1
answer
323
views
Why is jitterbit cloud data loader requireing me to login to Jitterbit Harmony [closed]
I got a new work pc and was installing Jitterbit and I can't get past this screen. I don't want harmony and have never had to do this in the past.
- 143
2
votes
2
answers
11k
views
ADD or SUBTRACT hours from TODAY and YESTERDAY functions in soql
I have to run a load every 6 AM in the morning, so just wanted those records that have been updated or created since this time i.e yesterday 6 AM and today 6 AM. I was thinking to use a logic to add 6 ...
- 21
1
vote
1
answer
74
views
Need to Upsert Data Using Tool Batch Wise
I have order and contact object which have lookup from order to contact...I have Excel sheet which has order as well as contact information in it..I need to insert or upsert this excel sheet which ...
1
vote
1
answer
2k
views
Jitterbit - ORA-12504, TNS:listener was not given the SID in CONNECT_DATA
We're attempting to do upserts to Salesforce from a Lawson (Oracle) database, using Jitterbit. We are using the Oracle [JDBC] driver on the default port. We have the Jitterbit Agent running on Windows ...
- 6,441
1
vote
1
answer
1k
views
Setting up Salesforce HTTP Endpoint using Jitterbit
At the moment we are polling for any changes in Salesforce every 10 minutes or every hour depending on the operation. I want to essentially setup an HTTP Endpoint for Salesforce using Jitterbit. So ...
- 478
0
votes
1
answer
53
views
Migrate Datas to Salesforce Org without same namespace
I am using Jitterbit Harmony to migrate datas from one salesforce org to another org. Source org has no namespace but second one has namespaces(as xyz_customobject__c). In that situation, I must ...
- 31
1
vote
0
answers
61
views
Salesforce Data Migration Jitterbit Response Error
I have used Jitterbit Harmony to migrate datas. It works if I run operations by one by. But If I linked two operation on "on Success"(It means first operation is success, pass and run the second one), ...
- 31
2
votes
0
answers
201
views
Salesforce Data Migration
I need to push data from one salesforce org to another salesforce org. I have faced a problem while doing this. I used Jitterbit Harmony to migrate data between orgs. I downloaded and installed ...
- 31
0
votes
1
answer
393
views
Jitterbit doesn't allow me to log into Sandbox
I just downloaded Jitterbit for the first time, as I heard it's a great tool for loading data, so I wanted to learn it.
Unfortunately I cannot log in - I created a new project, and entered my ...
- 1,395
6
votes
1
answer
5k
views
Can I upsert PricebookEntry Records?
Is it possible to upsert PBE records? According to the API document, upsert is a supported function. Now that we can create custom fields on the PBE, I even added an external ID field, but I cannot ...
- 5,066
2
votes
1
answer
561
views
How do you find the Jitterbit Harmony Http HostedEndpoint SERVERNAME & PORT combination?
I'm sending an outbound message from SFDC to Jitterbit. The Jitterbit "NO-Cumentation"
http://support.jitterbit.com/documentation/How-to-Create-a-Hosted-HTTP-Endpoint
states:
... "the end-point ...
0
votes
1
answer
613
views
How to send a Salesforce workflow outbound message to trigger a jitterbit 8.1 (full version) operation
I am currently evaluating Jitterbit 8.1 (Full version, 30 day eval).
In need to query SFDC for 4 custom field values from Opportunity records where Stage pickval ="...".
Each record must be POSTed ...
0
votes
0
answers
871
views
can salesforce integrate to sql server using Jitterbit
I have never used Jitterbit and was wondering if Jitterbit can be automated to pull opportunity and related opportunity data and pushed into a sql server db? Is this possible using Jitterbit? I was ...
- 2,495
0
votes
1
answer
91
views
Will Data Loader for Salesforce 5.x End of life with Cload Data Loader 6.x 4/15/2015?
It was announced Data Loader 6.x will reach End of Life on April 15, 2015 and will cease to communicate with the Harmony Cloud. Causing existing operations to stop running.
We have still have jobs ...
- 141
5
votes
1
answer
7k
views
How to connect to Salesforce REST API without OAuth? How does Jitterbit do it?
So what I read everywhere is that, in order to connect to Salesforce via the API, you'll have to authenticate using OAuth.
But this involves creating a Connected App, which is 'cumbersome' for normal ...
- 3,491
1
vote
1
answer
628
views
Duplicates inserting from csv to salesforce through jitterbit data loader! [closed]
I am using free Jitterbit to load files (.csv) from SFTP into Salesforce (custom object). In FTP, xls files are fed and is converted into .csv file (via php) and that csv file is inserted into ...
- 931
2
votes
1
answer
2k
views
How to query multiple object query in jitterbit dataloader
I am using jitterbit dataloader want to integrate(send data from sql to salesforce) sql to salesforce.
In jitterbit i had quered one object(account) and able to send data from sql to salesforce.
But ...
- 1,181