None of the column headers match with the record attributes.

Hi there,

How weird is Outsystems!

Before i use Exceltorecordlist and it works fine.

Then i create a new other Exceltorecordlist in other function and it raises: 

None of the column headers match with the record attributes.

regards

brrrr wrote:

Hi there,

How weird is Outsystems!

Before i use Exceltorecordlist and it works fine.

Then i create a new other Exceltorecordlist in other function and it raises: 

None of the column headers match with the record attributes.

regards

Hi brrrr,

This error occurs when the excel column label get miss matched with the structure attribute label which is mapped with the ExceltoRecordList node. Please cross verify the Column header label and Structure attribute labels.

Hope this helps!


I love OutSystems...


Kind Regards,

Benjith Sam


Nah, the name of the header in Excel and name in structure does not have to be the same.

I can prove it.


The problem mostly because:

1. different attribute type, for example in Excel text, in structure date.

2. notorious bug of ExcelToRecordList: try delete the the ExcelToRecordList node and structure, then create new structure and drag a new ExcelToRecordList node to flow.

Solution

Hi Sam,

As told by others in this forum. It is because of the flaws in Outsystems (the chart tool is not perfect).

They workaround by deleting that widget and recreate. In my case it does not enough.

Here what makes the error:

#. I copy a module that contains the widget

#. Then i change the structure, say it MYNEWSTRUCTURE, (as it different from the source/original one)


Then the errors comes up.

# When i analyze, there is a value with the correct one should be:

ExcelToRecordListBulkDWH.Current.MYNEWSTRUCTURE.Number,

but OS just remove the MYNEWSTRUCTURE and give no error (What a pity!):

ExcelToRecordListBulkDWH.Current.Number


TO WORK AROUND:

# Delete the widget exceltorecordlist (if needed with its arrows in- out)

# Let it be different name with the source name

# change the rest after the widget to make sure (that is new structure is not deleted in a value)


regards



Solution

# In addition to this remove and copied magics in outsystems, 

# in BPT you should also be ware of the magic of this copied and deleted of widgets. 

# It has different meaning to copy or to create a new one !!!

# It is undocumented, and i hope OS create a complete holistics manual/book.

regards