moving my directory to your plugin

  • Resolved moingaziyani

    (@moingaziyani)


    12 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’,’[email protected]’,’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’,’[email protected]’,’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’,’[email protected]’,’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

    https://www.ads-software.com/extend/plugins/business-directory-plugin/

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

    (@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.

    Thread Starter moingaziyani

    (@moingaziyani)

    hi,

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

    thanks for the help

    Plugin Author Business Directory Plugin

    (@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.