[SalesForce] How to remove extra column from csv of bulk api in JAVA

I am importing the data in to the salesforce using Bulk API. But I am facing this issues.

I am replacing the column header with the salesforce API name. But some of the heade which is not releted to the salesforce.

So how I can ignore or remove the column while importing the data using Bulk API. I am creating the temp file for the bulk data.

Please help me !!!!

Thank thank you in advance.

Piyush

Best Answer

The Bulk API allows a transformation spec to be defined for the upload process which is in itself a CSV file with these columns:

Salesforce Field - The Salesforce field you want to map to

Csv Header - The field in your import file you want to map

Value - A default value

Hint - Interpret Java format strings for date and time fields or define what is true using regular expressions for boolean fields

I suggest that you experiment with this mechanism to see if it allows columns to be dropped by simply not referencing them in the transformation spec. (My guess is that this will work but the documentation that I found says nothing on the subject and I have not tried it.)

Related Solutions

[SalesForce] Setting field value to Null when using Bulk API

Since this hasn't been responded to after having been posted for several weeks, it would appear that no one has a timely suggestion for you.

My suggestion would be pre-process your CSV files using a script that scans them for field entries containing blank values and inserts a "#N/A" if it finds one. You could do that separately or as part of some kind of "front end" processing by your Utility Tool. You may have some other way of doing that via Java, but I'd think a simple Bat file or VB Script would do the job for you without requiring much work on your part to create it.

[SalesForce] Exporting Data to CSV file via Bulk API

It looks like that's the debug trace file, traceLogs.txt. Unfortunately, the sample isn't very clear - bulkConnection.getQueryResultStream() returns the actual data as an input stream. You need to extend your code to

Create a CSV file
Get an output stream for the CSV file
Read data from the input stream returned by bulkConnection.getQueryResultStream() and write it to the output stream.

Once you have it all working, you will probably want to suppress creation of the trace file by changing

config.setTraceMessage(true);

config.setTraceMessage(false);

Best Answer

Related Solutions

[SalesForce] Setting field value to Null when using Bulk API

[SalesForce] Exporting Data to CSV file via Bulk API

Related Topic