Import excel to DB

Hi Thoufiq,

I think you must have given values in values in "New Columns" and "New Columns Values" input fields.

I got above error when I gave them. You need not give the values of those fields. You use them only if your table has extra columns other than the ones in your excel sheet and you want to fill those columns in the table with these values.

Thanks,
Neelima

Hi Neelima,

I don't have any values in "New Columns" and "New Columns Values" input fields, still getting this error. Are you aware of any other constraints ??

Thanks ,
Thofuiq

Hi,

I have used this plugin by just mentioning the value of "Number Of Columns To Read In Row" field other than mandatory inputs and it worked for me.

Thanks,
J. Neelima

Hi Thoufiq - any chance there is an empty column that the plug in may be interpreting as needing a value ?

Hi Paul,

That was my initial thought , but the same happen to work fine in my another development server. So am guessing the issue is with server .

Did you get the solution?

Agreed with Paul, there must be an empty column in your sheet, most probably at the end. Did you tested with the same excel on the other server?

I suggest to open the excel file with notepad and check for an additional comma at the end of each row, it happens sometimes when you manipulate the file manually.

Hi Thoufiq,

you can use the below readExcelSheet function of Excel Tool plugins like this:

load(
local!recordSets: readExcelSheet(
excelDocument: ri!document,
sheetNumber: 0,
startRow: 2,
numberOfColumns: 0 /*reading all columns*/
).result.values,
local!count: count(
local!recordSets
),
a!forEach(
items: 1 + enumerate(
local!count
),
expression: load(
local!data: split(
joinarray(
local!recordSets[fv!item],
"; "
),
"; "
),
'type!{urn:com:appian:types:DTP}DTP_CustomerDetails'(
FirstName: local!data[1],
LastName: local!data[2],
Address: local!data[3],
Phone_Number: local!data[4]
)
)
)
)

another way...

load(
  local!recordSets: readExcelSheet(
    excelDocument: ri!document,
    sheetNumber: 0,
    startRow: 2,
    numberOfColumns: 0/*reading all columns*/
  ).result.values,
  
  a!forEach(
    items: local!recordSets,
    expression: {
      'type!{urn:com:appian:types:DTP}DTP_CustomerDetails'(
        FirstName: fv!item[1],
        LastName: fv!item[2],
        Address: fv!item[3],
        Phone_Number: fv!item[4]
      )
    }
  )
  
)

Hi Thoufiq

Did you find out why you were getting that particular error? I am having the same issue.