{"id":6337,"date":"2019-04-09T15:37:14","date_gmt":"2019-04-09T18:37:14","guid":{"rendered":"http:\/\/www.alfagestion.com.ar\/ag\/?p=6337"},"modified":"2019-04-09T15:37:14","modified_gmt":"2019-04-09T18:37:14","slug":"como-importar-datos-a-itegra","status":"publish","type":"post","link":"https:\/\/www.alfagestion.com.ar\/ag\/como-importar-datos-a-itegra\/","title":{"rendered":"COMO IMPORTAR DATOS A ITEGRA"},"content":{"rendered":"<p><span style=\"font-size:12pt\">EJECUTAMOS EL ITEGRA COMO ADMINISTRADOR<br \/>\n<\/span><\/p>\n<p>(<span style=\"background-color:yellow\">Click derecho-Ejecutar como Administrador<\/span>)\n<\/p>\n<p>Luego nos vamos a\n<\/p>\n<p><span style=\"background-color:yellow\">Archivo-Importar-Desde Base de Datos<\/span>\n\t<\/p>\n<p>\n\t\t<img decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2019\/04\/040919_1837_COMOIMPORTA1.png\" alt=\"\" data-recalc-dims=\"1\"\/>\n\t<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2019\/04\/040919_1837_COMOIMPORTA2.png\" alt=\"\" data-recalc-dims=\"1\"\/>\n\t<\/p>\n<p>Le damos a Guardar y Salir.\n<\/p>\n<p>Por \u00faltimo nos vamos a\n<\/p>\n<p><span style=\"background-color:yellow\">Mantenimiento-Transmitir Novedades<\/span>\n\t<\/p>\n<p>Para que importe los datos de la base a la balanza kretz.\n<\/p>\n<p>\n\t\t<img decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2019\/04\/040919_1837_COMOIMPORTA3.png\" alt=\"\" data-recalc-dims=\"1\"\/><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Compartir:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/como-importar-datos-a-itegra\/?share=email\" target=\"_blank\" title=\"Haz clic para enviar por correo electr\u00f3nico a un amigo\"><span>Correo electr\u00f3nico<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/como-importar-datos-a-itegra\/\" target=\"_blank\" title=\"Haz clic para imprimir\"><span>Imprimir<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>EJECUTAMOS EL ITEGRA COMO ADMINISTRADOR (Click derecho-Ejecutar como Administrador) Luego nos vamos a Archivo-Importar-Desde Base de Datos Le damos a Guardar y Salir. Por \u00faltimo nos vamos a Mantenimiento-Transmitir Novedades Para que importe los datos de la base a la &hellip; <a class=\"kt-excerpt-readmore\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/como-importar-datos-a-itegra\/\" aria-label=\"COMO IMPORTAR DATOS A ITEGRA\">Leer m&aacute;s<\/a><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Compartir:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/como-importar-datos-a-itegra\/?share=email\" target=\"_blank\" title=\"Haz clic para enviar por correo electr\u00f3nico a un amigo\"><span>Correo electr\u00f3nico<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/como-importar-datos-a-itegra\/\" target=\"_blank\" title=\"Haz clic para imprimir\"><span>Imprimir<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":424,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","spay_email":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[1],"tags":[],"class_list":["post-6337","post","type-post","status-publish","format-standard","hentry","category-faq"],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9eJDz-1Ed","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":4776,"url":"https:\/\/www.alfagestion.com.ar\/ag\/configurar-balanza-kretz-report-nx-lcd\/","url_meta":{"origin":6337,"position":0},"title":"CONFIGURAR BALANZA KRETZ REPORT NX LCD","date":"30 abril 2017","format":false,"excerpt":"ARA CONFIGURAR LA RED, DESDE LA BALANZA BALANZA 1 192.168.0.50 PUERTO 1001 SOFTWARE ITEGRA LINK DEL MANUAL\u00a0\u00a0 2- DAR DE ALTA LA EMPRESA DESDE EL MENU MANTENIMIENTO - EMPRESA \u00a0 3- CONFIGURAR EL FORMATO DEL CODIGO DE BARRA \/ ARCHIVOS - CONFIGURACI\u00d3N\u00a0- C\u00d3DIGOS\u00a0DE BARRA 4- CONFIGURAR EL FORMATO DEL CODIGO\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2017\/04\/33.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":7428,"url":"https:\/\/www.alfagestion.com.ar\/ag\/enviar-tabla-nutricional-a-balanza-kretz\/","url_meta":{"origin":6337,"position":1},"title":"Enviar tabla nutricional a balanza Kretz","date":"3 enero 2020","format":false,"excerpt":"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\u00f3n \"Importar\", desde base de datos. \u00a0 SELECT\u00a0LTRIM(IDARTICULO)\u00a0AS IDARTICULO,DBO.FN_EXTRAERENGLON(1,OBSERVACIONES) AS OBS,'1'\u00a0AS RENG FROM V_MA_ARTICULOS WHERE PESABLE = 1 UNION SELECT\u00a0LTRIM(IDARTICULO)\u00a0AS IDARTICULO,\u00a0DBO.FN_EXTRAERENGLON(2,OBSERVACIONES) AS OBS,\u00a0'2'\u00a0AS RENG FROM\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8226,"url":"https:\/\/www.alfagestion.com.ar\/ag\/configurar-puerto-com-en-balanzas-kretz\/","url_meta":{"origin":6337,"position":2},"title":"Configurar Puerto Com en Balanzas Kretz","date":"7 abril 2021","format":false,"excerpt":"Averiguar en que puerto \"com\" esta conectada la balanza, en este caso es una Kretz ECO, por puerto USB. Lo primero es abrir las propiedades del equipo, ir a Administrador de Dispositivos. (ver imagen) Luego, abrir la secci\u00f3n \"Puertos\" y ver que puerto ha sido detectado por Windows, si detecta\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2021\/04\/image-2.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":9706,"url":"https:\/\/www.alfagestion.com.ar\/ag\/balanza-kretz-agregar-un-digito-al-precio\/","url_meta":{"origin":6337,"position":3},"title":"BALANZA KRETZ-AGREGAR UN DIGITO AL PRECIO","date":"11 agosto 2023","format":false,"excerpt":"Con los constantes aumentos de precio e inflacion, la cantidad de decimales previsto por algunas balanzas fueron superadas, causando que el codigo de barra no salga impreso en la etiqueta, como se muestra en la siguiente imagen.. En el caso de las balanzas Kretz Reports, realizamos los siguientes cambios para\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2023\/08\/image-3.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1121,"url":"https:\/\/www.alfagestion.com.ar\/ag\/como-importar-datos-de-clientes\/","url_meta":{"origin":6337,"position":4},"title":"Como importar datos de clientes","date":"4 abril 2011","format":false,"excerpt":"Los datos principales y obligatorios para poder importar datos de clientes son: Condici\u00f3n de I.V.A (Consumidor Final, Responsable Inscripto, Excento, etc.) Motivo de Venta Condici\u00f3n de Venta (Contado, Cuenta Corriente, etc.) Tipo de Documento (C.U.I.L , D.N.I , etc. ) N\u00famero de Documento Raz\u00f3n Social Domicilio, C\u00f3digo Postal, Tel\u00e9fono, Localidad,\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":169,"url":"https:\/\/www.alfagestion.com.ar\/ag\/como-importar-un-reporte-a-excel%e2%80%a6\/","url_meta":{"origin":6337,"position":5},"title":"Como exportar un reporte a  Excel\u2026","date":"12 agosto 2009","format":false,"excerpt":"Primer paso cargamos el reporte que queremos ver (en el ejemplo cargue un reporte de ventas como modelo) Luego vamos a\u2026 \u00a0 2) Una vez que se genero el reporte vemos dentro del mismo por pantalla la siguiente opci\u00f3n: \u00a0 3) Elegimos el archivo en el cual queremos exportar, en\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/6337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/users\/424"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/comments?post=6337"}],"version-history":[{"count":1,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/6337\/revisions"}],"predecessor-version":[{"id":6338,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/6337\/revisions\/6338"}],"wp:attachment":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/media?parent=6337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/categories?post=6337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/tags?post=6337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}