some problems to import from csv
9 years 6 months ago #2044
by Daniel
Thanks
Daniel
Replied by Daniel on topic some problems to import from csv
Hello Paolo,
Please share your FTP and back end login credentials via Contact us form. We'll look into it.
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.
- Paolo Bianchi
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
9 years 6 months ago #2046
by Paolo Bianchi
Replied by Paolo Bianchi on topic some problems to import from csv
Hello
I have just send.
I have just send.
Please Log in to join the conversation.
- Paolo Bianchi
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
9 years 6 months ago #2049
by Paolo Bianchi
Replied by Paolo Bianchi on topic some problems to import from csv
Thank you so much now works. 
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

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.
9 years 6 months ago - 9 years 6 months ago #2144
by Daniel
Thanks
Daniel
Replied by Daniel on topic some problems to import from csv
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.
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.
- Paolo Bianchi
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
9 years 4 months ago #2532
by Paolo Bianchi
Replied by Paolo Bianchi on topic some problems to import from csv
Hello
could you show me the syntax to export one field divided by 1000?
thank you so much
Paolo
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.
9 years 4 months ago #2549
by Daniel
Thanks
Daniel
Replied by Daniel on topic some problems to import from csv
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.
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.