Advertisement:

Author Topic: Transferring ads from wordpress through phpmyadmin  (Read 643 times)

omid_firoznia

  • Newbie
  • *
  • Posts: 37
Transferring ads from wordpress through phpmyadmin
« 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" ?

dev101

  • Osclass Hero
  • Hero Member
  • *
  • Posts: 2182
  • osclass.work
Re: Transferring ads from wordpress through phpmyadmin
« Reply #1 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.

dev101

  • Osclass Hero
  • Hero Member
  • *
  • Posts: 2182
  • osclass.work
Re: Transferring ads from wordpress through phpmyadmin
« Reply #2 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)

omid_firoznia

  • Newbie
  • *
  • Posts: 37
Re: Transferring ads from wordpress through phpmyadmin
« Reply #3 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.

dev101

  • Osclass Hero
  • Hero Member
  • *
  • Posts: 2182
  • osclass.work
Re: Transferring ads from wordpress through phpmyadmin
« Reply #4 on: March 20, 2019, 11:24:20 am »
Do it in your localhost or using php cli, then just upload database with data live.