Published on 07/17/2018
Published by Devidas Danidhariya
Importing Excel Awesome Enterprise
If you are import data from excel file to costume post type or costume database table. Here is a quick reference guide to help you import.
This task divided in two part.
- Ticket generating
- Excel configuration
Part-1
- Create module in App. Add following code.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657[templates.add main][templates.html_output set=template.html/][ui.outer-block.main html={template.html} title="Data impoter"/][/templates.add]//** html logged in interaction ***//[templates.add html_output]<section role="import-lead"><div class="gap-8"></div><div class="container"><div class="row"><div class="col-md-12 col-lg-12 col-sm-12 col-12 text-center form-outer-layer "><h6 class="font-bold text-uppercase text-center">Required Fields for template in xlsx Sample</h6><div class="table-responsive"><table class="table table-bordered"><tr><th>App Id</th><th>Student Name</th><th>Email</th><th>Alternate Email</th><th>Mobile</th><th>Alternate Mobile</th><th>Date of Birth</th><th>Gender</th><th>State of Residence</th><th>Course Applied For</th><th>Year of Planned Admission</th><th>Applied On</th><th>Status </th><th>Preferred Time </th><th>Category</th><th>Comments</th></tr></table></div><div class="gap-3"></div><button class="btn btn-primary" axn=control.update control='main.sections.ticket-info' bind='click' route_ajax='[module.slug /].get_ticket' call_template='xlsx_output'> Get Ticket to Import Excle</button><div class="gap-3"></div><section role="ticket-info"></section></div></div></div></section>[/templates.add]//** Get Ticket **//[templates.add get_ticket][session_ticket.create set=module.ticket/][session_ticket.set_activity {module.ticket} app='{app.slug}' module='{module.slug}.{request.call_template}' /][date.create now date_format='Y-m-d H:i:s' set=template.dt /]<b>[template.dt]:</b> Ticket Is <b class="brand-fifth">[module.ticket/]</b>[/templates.add][templates.add xlsx_output]//*check permission and authentication*//[wp.signon username="{request.username}" password="{request.password}" set=template.x /]//* your get excel data in request var *//[aw2.get request.app_id set="module.app_id" /] //* data of A2 cell. make sure A1 cell name is app_id or app id *////* put your logic here *//[/templates.add]Part-2 (Excel setting)
here is sample attachment file.
Setting Tab
- Download .XLSM file.
- Go to excel setting tab in .xlsm file.
- Set username, Password and Ticket. This is your wp login creation.
Internal Tab
- Set URL in internal tab. The format of url is “{domain_name}/t”.(https://www.example.com/t)