Business Directory Plugin
[resolved] moving my directory to your plugin (4 posts)

  1. moingaziyani
    Posted 3 years ago #

    INSERT INTO member_reg (id, user_id, password, company_name, compnay_logo, website, email, country, state, city, company_address, company_desc, products_imports, products_exports, reg_date, exp_date, membership, user_status, varify, legal_docs, mail_subscription) VALUES
    (19339,'19339','19339','SDL AUTO LTD.','','www.sdl-auto.com','info@sdl-auto.com','India','Haryana','','44th KM STONE, DELHI MATHURA ROAD, VILLAGE SIKRI (BALLABHGARH), FARIDABAD-121004 (HARYANA) INDIA','exporters','','Products','2013/01/23','0000-00-00',4,0,1,0,0),
    (19502,'19502','19502','NINGBO S.DERONS IMPORT&EXPORT CO.,LTD.','','www.sderons.com','office@sderons.com','China','Zhejiang','','4F,#81 YONGGANG ROAD,NINGBO,ZHEJIANG,CHINA. P.C. : 315040','exporters','','WZr electrode,WLa electrode,WP electrode WY electrode WRex.electrode,Cerium and W electrode,The mental Th and W electrode,W bar','2013/01/23','0000-00-00',4,0,1,0,0),
    (19503,'19503','19503','Shandong Zouping Jinhua Textile Co.,Ltd','','www.sdjhfz.com','sdjhfz@sdjhfz.com','China','Shandong','','NO.38, Daixi West Rd., Zouping county, Shandong, China','exporters','','yarn,sewing thread,embroidery thread,dyed yarn,spunlace,tarpaulin,others','2013/01/23','0000-00-00',4,0,1,0,0);

    the above is the my-sql query to insert into my directory ..i tried using csv file but it failed ...hence i had sent you my 3 query example ..can you please tell me how to change this above query into your data base table so that i can fire those query in database and result will get added into it

    if possible, please make a my-sql query for inserting one record in your table ..

    thanks in advance


  2. businessdirectoryplugin
    Plugin Author

    Posted 3 years ago #

    Hi moingaziyani,

    Inserting listings is not as simple as putting a single record into the database. Since we use custom post types, many tables are involved in the insert--metadata, users, post and categories. There's no simple query to provide.

    You're far better off trying the CSV mechanism. Can you tell me specifically what problems you ran into using it? That's going to save you a lot of time using it anyway.

  3. moingaziyani
    Posted 3 years ago #


    thanks for reply but now i found that csv files are working and everything is getting uploaded

    thanks for the help

  4. businessdirectoryplugin
    Plugin Author

    Posted 3 years ago #

    You're welcome. :)

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Business Directory Plugin
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic