Load data from excel
Hi everybody,
I need to load data from excel to a class in cache, but this class has foreign key and property like AS ..... (other class). This class represent an item product that belongs to a line, the line blelongs a group and the group belongs a Category.
Example:
Property bdGrupo As Innova.CL.Core.BD.Operacion.Producto.Grupo; Property bdLineaPR As Innova.CL.Core.BD.Operacion.Producto.Linea [ Cardinality = parent, Inverse = bdProductoCH ]; Property bdCategoriaProducto As Innova.CL.Core.BD.Operacion.Producto.Mantenedor.CategoriaProducto; Property Portafolio As %Boolean [ InitialExpression = 1 ]; Property modelo As %String; Property alianzaObligatoria As %String; Property bdMembresia As Innova.CL.Core.BD.Operacion.Producto.Mantenedor.Membresia; Property bdAlianza As Innova.CL.Core.BD.Operacion.Producto.Alianza; Property bdMoneda As Innova.CL.Core.BD.Configuracion.Base.Moneda; Property bdMetrica As Innova.CL.Core.BD.Operacion.Producto.Mantenedor.Metrica; Property plazo As %String; Property precioLista As %Integer; Property Descripcion As %String(MAXLEN = 2500);
Someone has an example of a routine or method that loads data from CSV file with these characteristics.
Thanks a lot.
Jaqueline Krieger