We have this required/question:
when we receive an excel we need to attribute the meaning of the columns 1, 2, 3 ect dynamically through a configuration table
Example:
Xls: (receive)
Code Service Agent Code POD Fiscal Code/VAT old Subject type Code ateco VAT
AGENTE 01 IT001E49627769 01351380447 Persona fisica
column 1 represents the Code Service (defined with a "cdse" field)
column 2 represents the Name Agent (defined with a "raage" field)
column 3 represents the Code Pod (defined with a "cdpod" field)
column 4 represents the Fiscal Code/VAT number (defined with a "fisiva" field)
column 5 represents the subject type (defined with a field "tysub")
column 6 represents the code Ateco (defined with a field "cdate")
column 7 represents the code VAT (defined with a field "cdvat")
in the configuration table we would have:
ORDERES FIELD
1 #cdse
2 #raage
3 #cdpod
4 #fisiva
5 #tysub
6 #cdate
7 #cdvat
When reading the excel we have generic fields which, according to the order, will be automatically associated with #cdse and #raage….
In such a way that if another customer reverses the position of the fields in his file xls, just change the order field in the configuration table.
Example:
Xls: (receive)
Code Service Subject type Fiscal Code/VAT Hold Code ateco VAT Agent Code POD
Persona fisica 01351380447 AGENTE 01 IT001E49627769
ORDERES FIELD
1 #cdse
6 #raage
7 #cdpod
3 #fisiva
2 #tysub
4 #cdate
5 #cdvat
We have how development Visual Lansa, but if there's even a solution with the integrator, it's okay.
Thanks for your help.