Hi All,

@SnehalRana : I am facing same issue. have your found any solution.

Not able to upload the columns with Special characters. Email id and Date.

Any workaround?

Regards,

Hemant

Is this compatible with 5.3 ? thanks

Hi JPG079,

I've tested and also good with 5.3 version.

Best regards,

Alright, 

I used this as a basis for a broker that we needed but the current version didn't fulfill all of our requriements.  I've taken the opportunity to add in the features we needed and to add some of the stuff that was being asked for in the comments.

You can find the new version here:  https://github.com/paulk-k2dev/DataImporterServiceBroker.

New article here:  https://community.k2.com/t5/K2-blackpearl/Excel-CSV-Import-Service-Broker/ba-p/117170

Pull requests welcome.

Cheers.

@paulk 

Great stuff!  Pulled these from Paul's release notes.

Added support for CSV files.
Added non-bulk upload methods.
Added named worksheet selection for Excel files.
Added duplicate column handling for Excel files.
Added row header index to allow you to specify where the data in the Excel file starts.
Skip import of empty Excel rows.
Removed the A-ZZ column limitation – at the cost of allowing empty columns.

@Snehal, 

Try to rename the column names by excluding the special characters and update the table, SMO and excel file . Try to avoid using special characters in the columns as it causes issues when trying to compare the column from Excel to table through SMO.