Gurudwara Bulk Upload Guide

Overview

Use one main CSV for gurudwaras, and optional related CSV files for aliases, images, and Guru associations.

Main file: gurudwaras.csv

Header:

slug,name,type,summary,description,hero_image_url,address_line1,address_line2,city,region,country_code,country_name,postal_code,latitude,longitude,phone,email,website_url,published,is_active

Example:

gurdwara-bangla-sahib-new-delhi-india,Gurudwara Bangla Sahib,community,"Famous Gurudwara in Delhi","Long description here",https://example.com/bangla.jpg,Ashoka Road,,New Delhi,Delhi,IN,India,110001,28.626390,77.209210,+91-11-23340170,info@example.org,https://example.org,1,1

• slug must be unique, lowercase, and hyphen-separated.
• type must be historical or community.
• published and is_active must be 1 or 0.
• latitude and longitude must be numeric or blank.

Optional file: gurudwara_aliases.csv

gurudwara_slug,alias,is_primary,sort_order

gurdwara-bangla-sahib-new-delhi-india,Bangla Sahib,1,0
gurdwara-bangla-sahib-new-delhi-india,Gurudwara Sri Bangla Sahib,0,1

Optional file: gurudwara_images.csv

gurudwara_slug,image_url,alt_text,sort_order,is_primary

gurdwara-bangla-sahib-new-delhi-india,https://example.com/bangla-1.jpg,Front view,0,1
gurdwara-bangla-sahib-new-delhi-india,https://example.com/bangla-2.jpg,Sarovar view,1,0

Optional file: gurudwara_guru_eras.csv

gurudwara_slug,guru_era_id,association_note,sort_order

gurdwara-bangla-sahib-new-delhi-india,8,Associated with Guru Har Krishan Ji,0

CSV quality checklist

• Save files as UTF-8 CSV.
• Quote values that contain commas or newlines.
• Keep one header row only.
• No duplicate slugs in the main file.
• Avoid trailing spaces in key fields.

Import output expectation

These CSV files can be converted into SQL scripts with:

• INSERT statements for new records
• optional UPDATE/upsert statements for existing slugs
• related table inserts mapped by gurudwara_slug

Maintenance note

Whenever this format changes, update both Gurudwarabulkupload.md and Gurudwarabulkupload.php in the same change.