Tip's to migrate data into Opportunity Line Item object in salesforce

To load data into Opportunity Line Item(OLI) Object in salesforce using CLI or GUI Apex data loader or any data migration tool few things important to take care at the time of data migration into OLI.

1. TotalPrice field is nullable, but you cannot set both TotalPrice and UnitPrice to null in the same Insert,update and Upsert call.
2. UnitPrice field or TotalPrice is required. You cannot specify both.
3. If you specify Discount and Quantity, UnitPrice field or TotalPrice is required.
4. At the time of data migration if you found Error "FIELD_INTEGRITY_EXCEPTION:field integrity exception: PricebookEntryId, unknown (versions 3.0 and higher must specify pricebook entry id; others must specify product id)Error fields: PricebookEntryId unknown". It's means that either PricebookEntryId fields contain null value or ProductId there in PriceBookEntry Object related to this PriceBookEntryID is incorrect.
5. At the time of data migration if you found Error "FIELD_INTEGRITY_EXCEPTION:field integrity exception: unknown, unknown (versions 3.0 and higher must specify pricebook entry id; others must specify product id)Error fields: unknown unknown". It's means that either PricebookEntryId fields contain null value.

Salesforce Data Migration tool for Non-technical Person.

Its make simple to automate the data loading process in salesforce from any legacy system. Entire tool generated based on Data Migration requirement to automate the data loading process.

Feature:
-It’s making possible to load data from any data base to salesforce.(tested on mysql,Oracle and MS SQL)
-Tool is developed in such a way that any non-technical person who would not have knowledge of data loader able to do data migration.
-Handle mapping of Polymorphic fields automatically for example Whoid and Whatid.
-Able to handle complex dependency loads for example PriceBookentry.
-The process defined in tool very well, and is good for non-technical.
-A nice GUI front end.

Salesforce Java Tool for Bulk data load from database

Features

Java application tool for handling data loading of what and who id fields for example,either a contact or a lead can be the parent of a Task and Event object.In other words, the WhoId field of a task or event can contain the ID of either a contact or a lead.

Java Application tool configure directly to any Database to upload data into salesforce org.

Entire Data loading process is automated by java application tool.

Help

If you experience any problems mapping relationships for polymorphic fields like What/who id , please let me know! I'm glad to help.

If you want to reach me, my email is priyadhiraj@gmail.com.

Thanks!

Automation Tool for Salesforce Data Loader Command Line Interface

System Overview

The Salesforce Data Loader Command Line Interface (CLI) is a powerful tool for automating business processes, and integrating Salesforce with other systems. However, writing process-conf and database-conf to configuring the CLI is daunting, especially for first-time users. Automation Tool is the solution!

Automation Tool provides a simple wizard to create directory structures and generate configuration files i.e. process-conf.xml and database-conf.xml with complete code for the Salesforce Data Loader Command Line Interface. You can spend hours or days or some time week to write process-conf and database-conf files manually, or use Automation tool and you will have a working process and database conf file in less than 5 minutes. After creating a CLI configuration file, you can reference the Data Loader documentation and make adjustments as needed.

Features

Main features of Automation Tool include:
1.Generate process-conf and database-conf files.
2.Write SOQL statements (for Insert, Update, Upsert , Delete and Exports) - no need to know how to write SOQL.
3.Write SQL statement (for to and from a relational database, such as Oracle or SQL Server, that has a standard JDBC driver)-no need to know how to write SQL.
4.Configure Data Loader to write directly to Databases.
5.Automatically configure SDL file.
6.Quickly configure scheduled exports/updates/insert/upsert for your Salesforce Org
7.Text and graphical interface
8.Handles all the tricky stuff:
a.Creates a process-conf.xml
b.Creates a database-conf.xml
c.Validates your username/password, queries, and entity names (avoids case- sensitivity issues)
d.Creates a bat file which can be scheduled on Windows using Windows Scheduler.
9.Written in Java - Tested on Windows!

Help

If you experience any problems writing process-conf and database-conf files, please let me know! I'm glad to help.

If you want to reach me, my email is priyadhiraj@gmail.com.

Thanks!