Upsert SDL Mapping not working on Required Fields

[Dave Eckblad]

I've a CSV file with column titles:
"Account Name","Company Number","Company Code","Ship Company Address
1","Shipping City","Shipping State","Shipping Zip","Shipping Country"

My .SDL is:
"Account Name"=Name
"Company Number"=Labware_Account_Number__c
"Company Code"=Account_Code__c
"Ship Company Address 1"=ShippingStreet
"Shipping City"=ShippingCity
"Shipping State"=ShippingState
"Shipping Zip"=ShippingPostalCode
"Shipping Country"=ShippingCountry

When running the .bat, I get this error for each row in the CSV:
2012-05-11 13:57:52,193 ERROR [accountUpsert] client.PartnerClient
processResult (PartnerClient.java:434) - Error code
is:MISSING_ARGUMENT
2012-05-11 13:57:52,194 ERROR [accountUpsert] client.PartnerClient
processResult (PartnerClient.java:435) - Error
message:Labware_Account_Number__c not specified

If I change the .csv column header to...:
"Account Name","Labware_Account_Number__c","Company Code","Ship
Company Address 1","Shipping City","Shipping State","Shipping
Zip","Shipping Country"

... And the .SDL to...:
"Account Name"=Name
Labware_Account_Number__c=Labware_Account_Number__c
"Company Code"=Account_Code__c
"Ship Company Address 1"=ShippingStreet
"Shipping City"=ShippingCity
"Shipping State"=ShippingState
"Shipping Zip"=ShippingPostalCode
"Shipping Country"=ShippingCountry

I then get this error for each record:
2012-05-11 14:04:42,432 ERROR [accountUpsert] client.PartnerClient
processResult (PartnerClient.java:434) - Error code
is:REQUIRED_FIELD_MISSING
2012-05-11 14:04:42,434 ERROR [accountUpsert] client.PartnerClient
processResult (PartnerClient.java:435) - Error message:Required fields
are missing: [Name]

If I then change the .csv column header to:
"Name","Labware_Account_Number__c","Company Code","Ship Company
Address 1","Shipping City","Shipping State","Shipping Zip","Shipping
Country"

And the .SDL to:
"Name"=Name
Labware_Account_Number__c=Labware_Account_Number__c
"Company Code"=Account_Code__c
"Ship Company Address 1"=ShippingStreet
"Shipping City"=ShippingCity
"Shipping State"=ShippingState
"Shipping Zip"=ShippingPostalCode
"Shipping Country"=ShippingCountry

... it works.

So, I'm wondering where I might be wrong in my syntax. The input .csv
headers can't be modified in the final solution.

I'm using DataLoader v24 and Cliq 2.2.0

[theswami]

I think it may have a problem with white spaces in the CSV column names.  Try using underscores instead of spaces in the CSV column names.