{"id":102,"date":"2011-05-23T17:50:21","date_gmt":"2011-05-23T17:50:21","guid":{"rendered":"http:\/\/www.software7.com.ar\/guias_y_tutoriales\/?p=102"},"modified":"2011-05-23T17:50:21","modified_gmt":"2011-05-23T17:50:21","slug":"asistente-de-importacion-listas-de-precios-en-dolares","status":"publish","type":"post","link":"https:\/\/gdssistemas.com.ar\/blog\/asistente-de-importacion-listas-de-precios-en-dolares\/","title":{"rendered":"Asistente de Importaci\u00f3n: listas de precios en d\u00f3lares"},"content":{"rendered":"<p><strong><span style=\"font-family: Calibri;\">Asistente de Importaci\u00f3n<\/span><\/strong><\/p>\n<p><strong><span style=\"font-family: Calibri;\">C\u00f3mo importar listas de precios con d\u00f3lares<\/span><\/strong><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-family: Calibri;\">Veremos como importar el siguiente formato de datos al programa ferreter\u00eda plus.<\/span><\/span><\/p>\n<p><span style=\"font-size: small; font-family: Calibri;\"> <a href=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/011.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-118\" title=\"importacion pantalla principal\" src=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/011.jpg\" alt=\"importacion pantalla principal\" width=\"399\" height=\"367\" srcset=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/011.jpg 399w, https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/011-300x276.jpg 300w, https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/011-326x300.jpg 326w\" sizes=\"auto, (max-width: 399px) 100vw, 399px\" \/><\/a><\/span><\/p>\n<p><span style=\"font-size: small; font-family: Calibri;\"><!--more--><\/span><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-family: Calibri;\">Lo primero que tenemos que hacer es dejar solamente los datos encolumnados, es decir tenemos que quitar los t\u00edtulos descriptivos que no forman parte de una columna de datos.<\/span><\/span><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-family: Calibri;\">Nos quedar\u00e1 algo como lo siguiente:<\/span><\/span><\/p>\n<p><span style=\"font-size: small; font-family: Calibri;\"> <a href=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/022.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-123\" title=\"02\" src=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/022.jpg\" alt=\"\" width=\"403\" height=\"240\" srcset=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/022.jpg 403w, https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/022-300x179.jpg 300w\" sizes=\"auto, (max-width: 403px) 100vw, 403px\" \/><\/a><a href=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/02.jpg\"><\/a><\/span><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-family: Calibri;\">Una vez que tenemos los datos perfectamente encolumnados tenemos que indicarle si la lista1 es en d\u00f3lares o no, por lo tanto tenemos que reemplazar el signo $ por \u201cNO\u201d y el de d\u00f3lares por \u201cSI\u201d.<\/span><\/span><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-family: Calibri;\">Qued\u00e1ndonos el archivo con el siguiente formato:<\/span><\/span><\/p>\n<p><span style=\"font-size: small; font-family: Calibri;\"> <a href=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/031.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-125\" title=\"03\" src=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/031.jpg\" alt=\"\" width=\"406\" height=\"240\" srcset=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/031.jpg 406w, https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/031-300x177.jpg 300w\" sizes=\"auto, (max-width: 406px) 100vw, 406px\" \/><\/a><a href=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/03.jpg\"><\/a><\/span><\/p>\n<p><span style=\"font-size: small; font-family: Calibri;\"> <\/span><span style=\"font-size: small;\"><span style=\"font-family: Calibri;\">Guardamos nuestro excel resultante como Archivo de Excel con formato compatible con Excel 97\/2003. <\/span><\/span><span style=\"font-size: small;\"><span style=\"font-family: Calibri;\">Vamos al programa ferreter\u00eda plus y abrimos el asistente de importaci\u00f3n.<\/span><\/span><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-family: Calibri;\">Los pasos para enlazar los campos e importar los art\u00edculos son los mismos que hacemos normalmente, solo que esta vez asociamos la columna que nos indica que la lista 1 est\u00e1 en d\u00f3lares. Recordemos que en esa columna debemos tener solamente la palabra NO o la palabra SI en el excel.<\/span><\/span><\/p>\n<p><span style=\"font-size: small;\"><span style=\"font-family: Calibri;\"><a href=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/041.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-126\" title=\"04\" src=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/041.jpg\" alt=\"\" width=\"360\" height=\"331\" srcset=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/041.jpg 360w, https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/041-300x276.jpg 300w, https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/041-326x300.jpg 326w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/a><a href=\"https:\/\/gdssistemas.com.ar\/blog\/wp-content\/uploads\/2011\/05\/04.jpg\"><\/a><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Asistente de Importaci\u00f3n C\u00f3mo importar listas de precios con d\u00f3lares Veremos como importar el siguiente formato de datos al programa ferreter\u00eda plus.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-102","post","type-post","status-publish","format-standard","hentry","category-sin-categoria"],"_links":{"self":[{"href":"https:\/\/gdssistemas.com.ar\/blog\/wp-json\/wp\/v2\/posts\/102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gdssistemas.com.ar\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gdssistemas.com.ar\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gdssistemas.com.ar\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gdssistemas.com.ar\/blog\/wp-json\/wp\/v2\/comments?post=102"}],"version-history":[{"count":0,"href":"https:\/\/gdssistemas.com.ar\/blog\/wp-json\/wp\/v2\/posts\/102\/revisions"}],"wp:attachment":[{"href":"https:\/\/gdssistemas.com.ar\/blog\/wp-json\/wp\/v2\/media?parent=102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gdssistemas.com.ar\/blog\/wp-json\/wp\/v2\/categories?post=102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gdssistemas.com.ar\/blog\/wp-json\/wp\/v2\/tags?post=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}