La tabla nutricional, se carga en el campo observaciones del Sistema Alfa, para importarlo al software Itegra, debe cargar la siguiente consulta SQL en la opción “Importar”, desde base de datos.
SELECT LTRIM(IDARTICULO) AS IDARTICULO,DBO.FN_EXTRAERENGLON(1,OBSERVACIONES)
AS OBS,'1' AS RENG
FROM V_MA_ARTICULOS WHERE PESABLE = 1
UNION
SELECT LTRIM(IDARTICULO) AS IDARTICULO, DBO.FN_EXTRAERENGLON(2,OBSERVACIONES)
AS OBS, '2' AS RENG
FROM V_MA_ARTICULOS WHERE PESABLE = 1
UNION
SELECT LTRIM(IDARTICULO) AS IDARTICULO,DBO.FN_EXTRAERENGLON(3,OBSERVACIONES)
AS OBS,'3' AS RENG
FROM V_MA_ARTICULOS WHERE PESABLE = 1
UNION
SELECT LTRIM(IDARTICULO) AS IDARTICULO, DBO.FN_EXTRAERENGLON(4,OBSERVACIONES)
AS OBS, '4' AS RENG
FROM V_MA_ARTICULOS WHERE PESABLE = 1
UNION
SELECT LTRIM(IDARTICULO) AS IDARTICULO, DBO.FN_EXTRAERENGLON(5,OBSERVACIONES)
AS OBS, '5' AS RENG
FROM V_MA_ARTICULOS WHERE PESABLE = 1
UNION
SELECT LTRIM(IDARTICULO) AS IDARTICULO, DBO.FN_EXTRAERENGLON(6,OBSERVACIONES)
AS OBS, '6' AS RENG
FROM V_MA_ARTICULOS WHERE PESABLE = 1
UNION
SELECT LTRIM(IDARTICULO) AS IDARTICULO, DBO.FN_EXTRAERENGLON(7,OBSERVACIONES)
AS OBS, '7' AS RENG
FROM V_MA_ARTICULOS WHERE PESABLE = 1
UNION
SELECT LTRIM(IDARTICULO) AS IDARTICULO, DBO.FN_EXTRAERENGLON(8,OBSERVACIONES)
AS OBS, '8' AS RENG
FROM V_MA_ARTICULOS WHERE PESABLE = 1
UNION
SELECT LTRIM(IDARTICULO) AS IDARTICULO, DBO.FN_EXTRAERENGLON(9,OBSERVACIONES)
AS OBS, '9' AS RENG
FROM V_MA_ARTICULOS WHERE PESABLE = 1
UNION
SELECT LTRIM(IDARTICULO) AS IDARTICULO, DBO.FN_EXTRAERENGLON(10,OBSERVACIONES)
AS OBS, '10' AS RENG
FROM V_MA_ARTICULOS WHERE PESABLE = 1
Adjunto imagen.
Esto se debe, a que el software itegra toma como texto fijo renglones de 50 caracteres.
Previo a esto, también debe importarse los artículos, asociando el renglón al mismo código de articulo.