Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
When import a excel sheet with empty cell (in database this column is a integer type), get
Problem: An error occurred in executing an Activity Class. Details: ???Incorrect integer value: '' for column 'CONTACT1' at row 1???
May I know this tool do not allow null value for integer? I test my database schema, column with integer type can be null
Hi Bhargav,
Is this plugin not compatible with 19.4 yet? I'm trying to use it in 19.4. When I executes the process, it completes successfully, but data doesn't seem to import into DB.
I tried both 'Import Excel to database' and 'Import CSV to database' with no success.
Not sure if anyone facing similar issues.
Hi,
Thanks for confirming - as far as I remember, I'd tried it both ways (i figured dictionary syntax wouldn't work but also didn't produce specific errors).
Also as a side note, Community doesn't seem to send any sort of notification of a reply here even though you had replied directly to me (this seems to hold true for any sort of comment activity within the App Market space).
Hi April. When I execute the excel import task in my work flow, it errors out with the above mentioned error. The error hints at the smart service not correctly reading the column names in the first row of the excel. Similar to trying to run this query on a DB: select "" from [table].
Hi johnh0011 - can you please provide some more context for when you're getting this error and what's not working?
Hi Vadivelan - this should work with any supported databases.
Is there an issue with the excel import smart service in 19.4? Was working fine in 18.2. I get the following error: ???ORA-01741: illegal zero-length identifier???