Excel se party, driver aur truck import karein — 10 minute me
Do din ki typing das minute me. Import se pehle dikhta hai kya hoga, duplicate teen tareeke se pakde jaate hain, aur driver apne transporter se naam se jud jaata hai.
Jisne bhi naya software leke chhod diya, usse poochein. Software ki wajah se nahi chhoda. Assi party type karne baithne ki wajah se chhoda.
Naam, phone, GSTIN, address, credit days. Phir chalis transporter. Phir driver. Phir truck.
Ek bhi trip banane se pehle do din ka typing. Zyadatar log Sunday ko shuru karte hain, tees party tak pahunchte hain, aur dobara kabhi nahi kholte.
Kya badal jaata hai
Wo das minute, sach me
Ek shart, saaf-saaf: data kisi Excel me hona chahiye. Sirf register me hai toh ek baar type karna padega — aur wo kisi bhi software me karna padta.
Kya hoga, wo pehle dikhta hai
File upload karo aur kuch save nahi hota. Ye dikhta hai:
```
Already had 14 Rows in file 52
Will import 45 Already exist 3
Cannot import 2
After importing you will have 59 parties
```
Phir har dikkat, row number ke saath:
- Row 23 — Party name is empty
- Row 7 · Bharat Traders — matches an existing party by phone
- Row 31 · Shree Sai — repeated in this file (row 12)
Jab aap Import 45 parties dabate ho, tabhi kuch likha jaata hai.
Ye baat sunne me chhoti hai par hai badi. Jo software upload karte hi import kar deta hai, usi se log teen sau duplicate party bana lete hain — aur wapas jaane ka koi raasta nahi hota.
Aapki file saaf hone ki zarurat nahi
Kisi ki bhi Excel saaf nahi hoti. Ye sab pehle theek karne ki zarurat nahi:
Header ka naam bhi match hone ki zarurat nahi. `Party Name`, `NAME`, `Company Name`, `Firm Name` — sab chalte hain. `Mobile`, `Phone No`, `Contact No` bhi.
Galat GST row ko rokta nahi — wo andar aa jaati hai, bas note ke saath. Sirf naam khaali hone par row rukti hai.
Driver apne transporter se naam se judta hai
Yahi wo hissa hai jo poori dopahar bachaata hai.
Aapse koi ID nahi maangi jaati. Aap transporter ka naam likhte ho, waise hi jaise aap waise bhi likhte ho:
```
Driver Name Transporter Name
Ramesh Kumar Gold Transporters & Co
Suresh Yadav Highway Carriers
```
Import ke waqt link ban jaata hai. Bade-chhote akshar aur extra space se koi farak nahi.
Truck me do rishtey isi tarah — transporter aur owner driver.
Naam na mile toh row phir bhi aa jaati hai, bas wo link khaali rehta hai, aur preview me saaf likha aata hai. Ek galat naam se chalis truck nahi rukte.
Import ka order
1. Transporters
2. Drivers — inme transporter ka naam hai
3. Trucks — inme dono ke naam
4. Parties — kabhi bhi, ye kisi se nahi judti
Drivers pehle karoge toh transporter milega hi nahi.
Aur sab wapas nikal bhi sakte ho
Har list Excel ya CSV me export hoti hai, aur usme naam jaate hain, koi ID nahi.
Export karo, Excel me theek karo, wapas import kar do. Ya export karke chale jao — file kahin bhi kaam aayegi.
Ye keh dena zaroori hai, kyunki naya software lete waqt asli dar setup ka nahi hota. Dar ye hota hai ki data andar phans jaayega.
Das minute me kya nahi hoga
Data andar aa jaayega. Trip, bilty, payment aur ledger seekhne me isse zyada lagega — aur jo isse alag kahe, wo bech raha hai.
Par wo seekhne wali cheez hai, type karne wali nahi. Zyadatar log pehle hi din ek asli trip bana lete hain.
---
15 din free try karein — card ki zarurat nahi, aur aapki purani list minute me aa jaayegi.