some problems to import from csv

More
9 years 6 months ago #2044 by Daniel
Hello Paolo,

Please share your FTP and back end login credentials via Contact us form. We'll look into it.

Thanks
Daniel

Please Log in to join the conversation.

More
9 years 6 months ago #2046 by Paolo Bianchi
Hello
I have just send.

Please Log in to join the conversation.

More
9 years 6 months ago #2049 by Paolo Bianchi
Thank you so much now works. :woohoo:
I checked the command differences and noticed the quotes

from
vdPhp: substr_replace ("@ vdLocal: 1" -3)vdLocal: 0vdLocal: 2 / @ vdLocal: 3 R @ vdLocal: 5
to
vdPhp: substr_replace ("@ vdLocal: 1", "", -3). "-vdLocal: 0 -vdLocal: 2 / @ vdLocal: 3 R @ vdLocal: 5"

To understand how to set the controls, how can I write this correctly?

@vdSql:SELECT `manufacturer_id` FROM `estesa_jshopping_manufacturers` WHERE concat(`name_it-IT`, " ZO") = "@vdLocal:1" OR concat(`name_it-IT`, " WI") = "@vdLocal:1"

thanks again
Paul

Please Log in to join the conversation.

More
9 years 6 months ago - 9 years 6 months ago #2144 by Daniel
Hello Paolo,
As stated earlier, You can not write Database queries with this keyword ( only functions can be used ). However for a workaround to your Problem, Please contact our Sales team via Contact us form, They'll look into it.

Thanks
Daniel
Last edit: 9 years 6 months ago by Daniel.

Please Log in to join the conversation.

More
9 years 4 months ago #2532 by Paolo Bianchi
Hello
could you show me the syntax to export one field divided by 1000?

thank you so much
Paolo

Please Log in to join the conversation.

More
9 years 4 months ago #2549 by Daniel
Hello Paolo,

Please download the latest package. and use the following: @vdPhp:(@vdLocal:column/1000)

Please note to Install the new version you would need to uninstall the previous one.

Thanks
Daniel

Please Log in to join the conversation.

Cron Job Starts