I have 4 Excel sheets like:
First (35) Records: State Code | State Name
Second (650) Records: State Code | District Code | District Name
Third (6500) Records: State Code | District Code | Block Code | Block Name
Fourth (650000) Records:
State Code | District Code | Block Code | Village Code | Village Name
I want to upload from Excel sheet based on State Code or sequence hierarchical records to taxonomy.
Adding them one by one is very difficult task.
I have a module for Excel import, but matching of record of parent is necessary like : State -> District -> Block -> Village in taxonomy
So how to upload these records to taxonomy (with no headache)?