Transferring ads from wordpress through phpmyadmin

[omid_firoznia]

Hi
I'm trying to transfer my ads from wordpress to osclass through phpmyadmin, what I want to Is about s_secret value ; I want to know can I put "NULL" for the values of "s_secret" in "oc_t_item" ?

[dev101]

s_secret is required.
You can do it like this:
https://stackoverflow.com/questions/16737910/generating-a-random-unique-8-character-string-using-mysql


However, that's not exactly recommended way to do it. Better export data in xml format and then use free xml importer plugin from Market, but plugin is a bit outdated for latest PHP 7.x version, there is a small fix you have to apply to use it (check my relatively recent forum posts). You have to provide proper xml format to do it right.

[dev101]

aforementioned fix:
https://forums.osclass.org/plugins-20/importing-images-with-ad-importer-free-addon/msg166933/#msg166933

(I see now you already know about this as you posted there)

[omid_firoznia]

Thanks a lot.

But from importer I've got to separate ads with pics and ads with out pictures, and also as I tested in my host each time I can import 350 ads.
That why I perfer do it through Sql.

[dev101]

Do it in your localhost or using php cli, then just upload database with data live.