automatic EXCEL to SQL import

[shacker]

Hello. I leave you excel in a program that allows the exportation of any query to a excel spreadsheet MYSQL. It is ideal for listings largos.Solo must fill out the form asks us qeu (has macros) and give START, the program creates a TXT with SQL then we should run it from phpmyadmin.

Remember that tables are Prestashop products and product_lang (there are more tables for the attributes).

Any doubt, consult!

XLS2SQL.xls

[exadra37]

I think that yor program make possible to transfer any excel list off products and prices to the database used by prestashop and this is the what i am looking for

Can you explain better how this work?

I don´t understand if i have to use one or the two programs that you provide and how it works, because i never worked with Excel :roll:



Your help will be very important for me.

Thanks in advance

[exadra37]

I just have understand how it works but is not work ok.

When you generate de txt file give this code to insert in SQL :

/* Created by XLS2SQL (2k4) */
USE prestashop;
INSERT INTO `ps_product` (`reference`,`price`) VALUES 
 ("AH1534",21,66),
 ("AH1535",20,79);

This code give error in insert the values in database, but if correct the "AH1534" to 'AH1534' and 21,66 to '21.66' it will work ok.

/* Created by XLS2SQL (2k4) */
USE prestashop;
INSERT INTO `ps_product` (`reference`,`price`) VALUES 
 ('AH1534','21.66'),
 ('AH1534','20.79');

[exadra37]

I just have fix the problem and improve the capacity and functionality of this program.

You can see in my topic http://www.prestashop.com/forums/viewthread/30904/portugues/programa_xls2sql__importa_dados_em_massa_do_excel_para_base_dados_sql/ .

I will make a topic soon in English.

The program is in English and Portuguese.

[chicl3t]

nao consigo fazer download :-(