This broker provides an easy way to bulk upload an Excel spreadsheet with a 2D table of values (with header) into a SmartObject
Excel Import Service Broker
- Nintex Partner
Hi All,
Not able to upload the columns with Special characters. Email id and Date.
Any workaround?
Regards,
Hemant
- Nintex Partner
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.
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.
+1We are using this and have couple of questions regarding the data import. We have few columns in Excel file which as special characters such as "/", "&" and of course date field. When I tried using this in my application it brings NULL records for all those fields.
Any suggestions or work around for these fields?
@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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.