Osclass forums

Support forums => General help => 3.7.x => Topic started by: omid_firoznia on March 19, 2019, 12:41:16 pm

Title: Transferring ads from wordpress through phpmyadmin
Post by: omid_firoznia on March 19, 2019, 12:41:16 pm

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" ?

Title: Re: Transferring ads from wordpress through phpmyadmin
Post by: dev101 on March 19, 2019, 02:09:23 pm

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.

Title: Re: Transferring ads from wordpress through phpmyadmin
Post by: dev101 on March 19, 2019, 02:12:05 pm

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)

Title: Re: Transferring ads from wordpress through phpmyadmin
Post by: omid_firoznia on March 20, 2019, 09:42:30 am

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.

Title: Re: Transferring ads from wordpress through phpmyadmin
Post by: dev101 on March 20, 2019, 11:24:20 am

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