some problems to import from csv

More
9 years 7 months ago #2004 by Daniel
Hello,
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.

More
9 years 7 months ago #2011 by Paolo Bianchi
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 :whistle:

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"
:blush:

Please Log in to join the conversation.

More
9 years 7 months ago #2012 by Paolo Bianchi
also:

@vdPhp:Date()
does not work

but
@vdSql:NOW()

it's ok
Attachments:

Please Log in to join the conversation.

More
9 years 7 months ago - 9 years 7 months ago #2017 by Daniel
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.

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

Please Log in to join the conversation.

More
9 years 7 months ago #2018 by Paolo Bianchi
Hello Danish
I'm sorry but also:
@vdPhp:substr_replace("@vdLocal:25", "", 0, strrpos("@vdLocal:25", "/", -1)+1)
don't work. :silly: ... ( with or without " ) also "basename" and Data("Y-m-d") ... nothing... :blush:

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.

More
9 years 6 months ago #2043 by Paolo Bianchi
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

Please Log in to join the conversation.

Cron Job Starts