Dears,
kindly help in writing VBA code to produce XSD for the below requirement. I have two columns one is having data element name and another column is defined hierarchy. Both columns are availble as excel data.
<tbody>
</tbody>
kindly help in writing VBA code to produce XSD for the below requirement. I have two columns one is having data element name and another column is defined hierarchy. Both columns are availble as excel data.
Schema DE Name | Hierarchy |
NSM-VEHICLEPASSINFORMATION | NSM-VEHICLEPASSINFORMATION |
gatePassNumber | ELEMENT(VEHICLEPASSINFORMATION) |
gatePassGenerationDateTime | ELEMENT(VEHICLEPASSINFORMATION) |
gatePassStatus | ELEMENT(VEHICLEPASSINFORMATION) |
tripType | ELEMENT(VEHICLEPASSINFORMATION) |
totalTrips | ELEMENT(VEHICLEPASSINFORMATION) |
entryCustomsStationCode | ELEMENT(VEHICLEPASSINFORMATION) |
exitCustomsStationCode | ELEMENT(VEHICLEPASSINFORMATION) |
transporterName | ELEMENT(VEHICLEPASSINFORMATION) |
transporterCode | ELEMENT(VEHICLEPASSINFORMATION) |
vehiclePlateNumber | ELEMENT(VEHICLEPASSINFORMATION) |
driverName | ELEMENT(VEHICLEPASSINFORMATION) |
driverIC | ELEMENT(VEHICLEPASSINFORMATION) |
GATEPASSDETAILS | CHILD(NSM-VEHICLEPASSINFORMATION) |
GATEPASSDETAIL | CHILD(GATEPASSDETAILS) |
tripNumber | ELEMENT(GATEPASSDETAIL) |
tripStatus | ELEMENT(GATEPASSDETAIL) |
ENTRY | CHILD(GATEPASSDETAIL) |
containerNumber | ELEMENT(ENTRY) |
expectedEntryDateTime | ELEMENT(ENTRY) |
DECLARATIONS | CHILD(ENTRY) |
DECLARATION | CHILD(DECLARATIONS) |
declarationNumber | ELEMENT(DECLARATION) |
BLAWBNumber | ELEMENT(DECLARATION) |
ITEMS | CHILD(DECLARATION) |
ITEM | CHILD(ITEMS) |
HSCode | ELEMENT(ITEM) |
quantity | ELEMENT(ITEM) |
quantityUOM | ELEMENT(ITEM) |
CONTAINERS | CHILD(DECLARATION) |
CONTAINER | CHILD(CONTAINERS) |
containerNumber | ELEMENT(CONTAINER) |
EXIT | CHILD(GATEPASSDETAIL) |
containerNumber | ELEMENT(EXIT) |
expectedExitDateTime | ELEMENT(EXIT) |
DECLARATIONS | CHILD(EXIT) |
DECLARATION | CHILD(DECLARATIONS) |
declarationNumber | ELEMENT(DECLARATION) |
BLAWBNumber | ELEMENT(DECLARATION) |
ITEMS | CHILD(DECLARATION) |
ITEM | CHILD(ITEMS) |
HSCode | ELEMENT(ITEM) |
quantity | ELEMENT(ITEM) |
quantityUOM | ELEMENT(ITEM) |
CONTAINERS | CHILD(DECLARATION) |
CONTAINER | CHILD(CONTAINERS) |
containerNumber | ELEMENT(CONTAINER) |
<tbody>
</tbody>