Support » Plugin: Business Directory Plugin » moving my directory to your plugin

  • Resolved moingaziyani


    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.’,”,’’,’’,’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.’,”,’’,’’,’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’,”,’’,’’,’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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author businessdirectoryplugin


    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.


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

    thanks for the help

    Plugin Author businessdirectoryplugin


    You’re welcome. 🙂

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘moving my directory to your plugin’ is closed to new replies.