some problems to import from csv
9 years 7 months ago #2004
by Daniel
Thanks
Daniel
Replied by Daniel on topic some problems to import from csv
Hello,
We sent you a reply on that email. Login credentials you sent aren't working, Please check and revert back.
We sent you a reply on that email. Login credentials you sent aren't working, Please check and revert back.
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 7 months ago #2011
by Paolo Bianchi
Replied by Paolo Bianchi on topic some problems to import from csv
Hello
I realized what was the import problem of empty columns, I set the "CSV Column Enclosure" with "Semicolon" rather than with "Double Quote."
I'm sorry
But ...
I checked the result of the function:
> @vdPhp:substr_replace($a, "", 0, strrpos($a, "/", -1)+1)
that you have shown me
(adjusted in)
> @vdPhp:substr_replace(@vdLocal:25, "", 0, strrpos(@vdLocal:25, "/", -1)+1)
unfortunately it does not work and the result in the table is:
> @vdPhp:substr_replace( extras.tyre-energy.de/pic_9870g.jpg , "", 0, strrpos( extras.tyre-energy.de/pic_9870g.jpg , "/", -1)+1)
I also tried this command
> @vdPhp:substr(@vdLocal:1, -3) @vdLocal:0 @vdLocal:2/@vdLocal:3 R@vdLocal:5
and this "query"
> @vdSql:SELECT `manufacturer_id` FROM `wfhkz_jshopping_manufacturers` WHERE concat(`name_it-IT`, " ZO") = "@vdLocal:1" OR concat(`name_it-IT`, " WI") = "@vdLocal:1"
but it only seems to work "vdLocal"
I realized what was the import problem of empty columns, I set the "CSV Column Enclosure" with "Semicolon" rather than with "Double Quote."
I'm sorry

But ...
I checked the result of the function:
> @vdPhp:substr_replace($a, "", 0, strrpos($a, "/", -1)+1)
that you have shown me
(adjusted in)
> @vdPhp:substr_replace(@vdLocal:25, "", 0, strrpos(@vdLocal:25, "/", -1)+1)
unfortunately it does not work and the result in the table is:
> @vdPhp:substr_replace( extras.tyre-energy.de/pic_9870g.jpg , "", 0, strrpos( extras.tyre-energy.de/pic_9870g.jpg , "/", -1)+1)
I also tried this command
> @vdPhp:substr(@vdLocal:1, -3) @vdLocal:0 @vdLocal:2/@vdLocal:3 R@vdLocal:5
and this "query"
> @vdSql:SELECT `manufacturer_id` FROM `wfhkz_jshopping_manufacturers` WHERE concat(`name_it-IT`, " ZO") = "@vdLocal:1" OR concat(`name_it-IT`, " WI") = "@vdLocal:1"
but it only seems to work "vdLocal"

Please Log in to join the conversation.
- Paolo Bianchi
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
9 years 7 months ago #2012
by Paolo Bianchi
Replied by Paolo Bianchi on topic some problems to import from csv
also:
@vdPhp:Date()
does not work
but
@vdSql:NOW()
it's ok
@vdPhp:Date()
does not work
but
@vdSql:NOW()
it's ok
Please Log in to join the conversation.
9 years 7 months ago - 9 years 7 months ago #2017
by Daniel
Thanks
Daniel
Replied by Daniel on topic some problems to import from csv
Hello Paolo,
1. You need to pass some parameter in date() function e.g. @vdPhp:Date('Y-m-d')
2. For @vdPhp:substr_replace(@vdLocal:25, "", 0, strrpos(@vdLocal:25, "/", -1)+1) either you can use @vdPhp:basename("@vdLocal:25") or need to make a little change in the previous function as shown below:
@vdPhp:substr_replace("@vdLocal:25", "", 0, strrpos("@vdLocal:25", "/", -1)+1)
would recommend to use basename
3. With @vdSql you can write query only functions can be used.
1. You need to pass some parameter in date() function e.g. @vdPhp:Date('Y-m-d')
2. For @vdPhp:substr_replace(@vdLocal:25, "", 0, strrpos(@vdLocal:25, "/", -1)+1) either you can use @vdPhp:basename("@vdLocal:25") or need to make a little change in the previous function as shown below:
@vdPhp:substr_replace("@vdLocal:25", "", 0, strrpos("@vdLocal:25", "/", -1)+1)
would recommend to use basename
3. With @vdSql you can write query only functions can be used.
Thanks
Daniel
Last edit: 9 years 7 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 7 months ago #2018
by Paolo Bianchi
Replied by Paolo Bianchi on topic some problems to import from csv
Hello Danish
I'm sorry but also:
@vdPhp:substr_replace("@vdLocal:25", "", 0, strrpos("@vdLocal:25", "/", -1)+1)
don't work.
... ( with or without " ) also "basename" and Data("Y-m-d") ... nothing... 
Please use the login credenzial that I have send you and verify my configuration and profiles.
why importation is incorrect? I don't understand it.
Thank you so much.
I'm sorry but also:
@vdPhp:substr_replace("@vdLocal:25", "", 0, strrpos("@vdLocal:25", "/", -1)+1)
don't work.


Please use the login credenzial that I have send you and verify my configuration and profiles.
why importation is incorrect? I don't understand it.
Thank you so much.

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 #2043
by Paolo Bianchi
Replied by Paolo Bianchi on topic some problems to import from csv
Hello Danish
I am waiting for a response from a few days.
The suggestions you gave me did not work and I do not know how to do.
Please check why and put myself in a position to be able to use your product when I can not use.
thanks
Paul
I am waiting for a response from a few days.
The suggestions you gave me did not work and I do not know how to do.
Please check why and put myself in a position to be able to use your product when I can not use.
thanks
Paul
Please Log in to join the conversation.