18 replies to this topic

[exadra37]

As I know from my other post's I found this program here in our forum http://www.prestasho...ewthread/19368/, but not working as it should with our database.

Without knowledge of Excel, let alone Visual Basic needed to spend about 15 hours a day from Monday 3 to date (3rd Fair 01h00m) and only stopped on Saturday afternoon and all Sunday ...

Greatly enhances the program level of operation and layout:

1. Now have boxes prompts for all possible operating errors.
2. Check box for operation of the START and CLEAR buttons.
3. Some fields have become mandatory to improve the functioning of the program.
4. The functionality of the Header parameter has to be selected by placing the word Yes or No.
5. Program in Multi-Language English / Portuguese.
6. Ability to name each worksheet of the program.
7. Increased the number of leaves available to work and eliminated the sheet Standard.
8. Added explanations to the operation of the program.
9. Increased the desktop screen.
10. I changed the position of the buttons START and CLEAR.
11. Etc.

Try and do not forget to say if you smile to results.

The program was modified in Excel 2007 and has not been tested in Excel 97-2003.

If you find any bugs or have any questions just put here wink

Attached Files

•  xls2sqlv2.0.jpg   180bytes   1556 downloads
•  XLS2SQv2.0 Excel97-2003.xls   184bytes   320 downloads
•  XLS2SQL - Original Version.xls   83bytes   213 downloads

[exadra37]

Pode encontrar o tópico original em Português na nossa comunidade em xls2sql em Português

Disfrute e não se esqueça de colocar o seu feedback :)

[shacker]

From 1255417858:

Pode encontrar o tópico original em Português na nossa comunidade em http://www.prestasho...base_dados_sql/

Disfrute e não se esqueça de colocar o seu feedback :)

Thanks for modify this tool. I upload in my site to share with the people.

[exadra37]

Don´t forget to let the credits for me and for the original developer :)

[shacker]

From 1255423051:

Don´t forget to let the credits for me and for the original developer :)

Sure, I am the original poster jaja

[exadra37]

From 1255423297:

From 1255423051:

Don´t forget to let the credits for me and for the original developer :)

Sure, I am the original poster jaja

:lol: off course you are :red:

I post and don´t recognize you has the owner off the topic where i find the program :P

Thanks

[VIXUS]

LOL kids... :)

[shacker]

From 1255423297:

From 1255423051:

Don´t forget to let the credits for me and for the original developer :)

Sure, I am the original poster jaja

Amazing job man!

[exadra37]

It take to many hours to do that program :ahhh:

Since we can´t duplicate categories in Prestashop i am trying to do in Excel unlimited categories at once :bug:

No more need to do that boring job of make many categories one by one in back office :)

[MicoX]

Good night

I am used your xls but.... how you import the decimal number? 1,56-> change to 1,00

I need your help

Thanks in advance

[exadra37]

Can you give me more details?

If you want, is better to give me the file, so that i use in my computer to see what is the problem.

Thanks

[MicoX]

Thanks for your replay. Sorry you don´t understand me. I´m spanish and my english is... well. XD
I have, in prestashop database, decimal prices.
The program converts them to text and insert it into phomyadmin converts it to integer.
For example, a price of 1,65 (o1.65, I tried both) it goes to .Txt as '1, 65 '('1 .65').
When taken as text, phpmyadmin (sqldbxadmin) converts to 1. Just put the whole.
How I can fix this in Excel 3000 rows? XD

Attached Files

•  sshot-13.png   30bytes   522 downloads
•  sshot-14.png   47bytes   480 downloads

[exadra37]

My program generate the file with the correct values (1,m65) but your problem is when you import the file to database and the 1.65 become 1 .... if the problem is this you must have a problem in the format in the fields off your database or you use the wrong iso code code when you import the file to database.

Send me the file by PM so that i can test.

[MicoX]

You were right.
The problem was the type of table.
Thanks for all.

[dt88]

I am hoping this still works, great concept, not sure why this isnt integrated into prestashop like it is in oscommerce, the ability to manuipulate existing data via sql. I have bought the quick update and the PrestaPricing modules and they dont do what I want

So if I can manuipulate all my data in one massive row (4000 products) on a spread sheet and drop it in

This will save me SO MUCH TIME.

Just incase I am wasting my time, someone stop me if this doesnt work anymore
I plan to use this for product import and manipulation for the following tables, let me know if i have forgotten something aswell

tables: ps_product, ps_product_lang, ps_product_sale, ps_image, ps_image_lang, ps_discount_quantity, ps_category_product

[Bruno Amaro]

Meu Amigo Exadra37 tem como vc enviar por meu email esse programa, pois tento enviar um produto pelo excel 2007, mas não to conseguindo, ja assistir varias aulas fiz varias pesquisas mas nao ta dando certo, ja transformei o arquivo em csv, e codifiquei o arquivo em iso 8859-1, por causa do acento, até ai blz, mas nao ta dando certo sempre da um erro, sabe me dizer por favor como resolver isso, eu quero enviar muitos produtos de uma só vez.
desde ja agradeço!
Bruno Amaro

[gianvi]

the link to download the programs are broken.
how to have have it ?

I'm develloping a complete prg for upload and i would like to test also this to see if i can add some more features.

[IeM]

Yes, the download link is down for me as well. I'm very interested in this or something like it.

Thanks

[darqor]

where can we download this tool?
thx