Exportar a cvs importar cvs

[sysme]

Pero también debes indicarnos que problema te está dando .. si sale algún error o algo

[Juan Hueso]

La verdad es que estoy intentándolo de todas formas y tampoco me funciona ni el de prueba, cuando le doy a finalizar importación me dice Ok ningún fallo pero no me importa nada haber si puedo configurarlo. Un saludo

[achica]

Haz capturas de pantalla del proceso, a ver si podemos descubrir lo que está pasando.

[sysme]

Juan ¿estás marcando la casilla de insertar cuando no se encuentre el campo clave?

[Juan Hueso]

Finalmente no pude pero casualmente me encontré una copia de seguridad antigua en otro ordenador y conseguí reemplazarla. De todos modos muchas gracias. Me cambie a otro programa que tiene fidelización para clientes y este espero algún día que lo implantéis. Un saludo

[adminfernando]

Hi Calaes,

The first thing to be careful about is how Excel handles .csv files, as it often modifies their format. To check this, open the generated file with Windows Notepad and verify that:

- It hasn't removed leading zeros from the ID fields. For example, if a product in the original .csv had ID 00010, check that Excel hasn't changed it to 10.
- Verify that the field separators have been respected, whether commas or semicolons.

Once you have verified the csv file, proceed to import it.

STEP 1 (First tab)

- Select the file
- Specify the field separators (comma or semicolon)
- Indicate whether the first line contains the field names
- Indicate whether the text values are enclosed in quotation marks

. You can check all of this by first opening the file with Windows Notepad.

STEP 2 (Second tab)

Here, the file is already open, and you need to select several things:

- Define which key field we want to use (ID, ADDITIONAL ID, or BARCODE)
- Define if the program should create products when the key field is not found
- Define if the stock value is imported and, if so, to which warehouse.

Finally, the fields from the file (file columns) will be loaded on the left, and on the right, you will have to link them to each field in the Sysme database. Logically, if the file is a Sysme export, the field names will be the same; therefore, link ID to ID, product to product, etc.

STEP 3

Here, you simply import and display the results (including errors).

Let me know.

not usefull at all

[adminfernando]

Good evening Oscar

Kindly asist with this matter