Excellent Programming Tricks

Create Database Table Form WebSite (table) Through Excel (Spreadsheet) | sample


  1. Stop javaScript (Suppose Mozila) Paste about:config as a url or Ctrl + Shift + C.
  2. Toggle javaScript false.
  3. Search(If required) and copy table (id="resultTable") [outerHTML]
  4. Paste into  Notepad++
  5. Remove unnecessary field and build table tag format. In Replace tab paste "Find what" box <((?!table|thead|tbody|th|tr|td|/table|/thead|/tbody|/th|/tr|/td)[^>]+)> and replace empty (search mode: regular expression). Not working ohh! don't be crazy! Use <((?!table|thead|tbody|th|tr|td|/table|/thead|/tbody|/th|/tr|/td)[^>]*)>.
  6. Set column field automic if required. In Replace tab paste "Find find what" box [Suppose text is 'Ministry of Water Resources, Bangladesh Water Development Board (BWDB),'] and replace empty (search mode: normal) 
  7. Save as abc.html
  8. Open Excel file
    1. Click Data->Form Web ->New Web Query->Address box
    2. Paste http://localhost/abc.html
    3. Go
    4. Select table
    5. Import -> ok…
    6. Save as CSV file
  9. phpMyAdmin
    1. Import 
    2. Table created 
Critical Case
  1. Change date format
    1. Select all -> Format Cells
    2. Number->Category->Date->Custom->Type
    3. yyyy-mm-dd
    4. Ok
  2. Re name Database
    1. RENAME TABLE `table 3` TO `noa`;
  3. Set Column name and attributes
  4. Delete rows while ID is zero.


No comments:

Post a Comment


Authentic аnd Excellent

Website

HTML Template

Wordpress Theme

Database applications

OR

Application services?

Excellent Programming Tricks (EPT) || Iftekhar-IT || We develops the Web applications and the WordPress templates. || Excellent Programming Tricks (EPT)

© 2020 Blogger Theme by Iftekhar IT || Excellent Programming Tricks

Execllent Programming Tricks. Powered by Blogger.