This is the 20th day of my participation in the More text Challenge. For more details, see more text Challenge

[TOC]

I’ve covered a lot of PowerDesign articles by now. Remember a few posts back when I was bragging about how awesome PowerDesign was. So let’s review what we did before

  • Did we learn how to hack the Chinese PowerDesign
  • Adding oracle data sources
  • Add mysql data source
  • Database generation backwards (including forward loading)

Looking at the four articles above, some readers may think that this is enough, and yes, the four actions above are enough for us to use PowerDesign to manipulate the database. But our usual development needs us to write database specifications. I wrote this manual before I used PowerDesign, so it’s just copy and paste. This is the kind of repetitive thing programmers don’t do. Today let’s see how PowerDesign works with Word and Excel

Export in Word format

  • In our PDM to make our database model, this time we want to generate database documents, we can Report- >reports and then create a new export, when new
  • We need to select the export template (you’ll have to tell PowerDesign what the export looks like). Then report will appear on the right, and we can right click to export the format we want, or select the one at the top

  • We have several sets of templates embedded in PowerDesign when selecting templates

  • The built-in templates are sometimes not good enough for our needs, so we can customize them. On the right, we can select our custom template

  • And then we’re going to export, and I’m going to export by right clicking on the left menu bar.

  • Ps: In terms of how to customize a template, we are actually modifying it where the export option is configured at export time, and then exporting our modifications as our template

Export in HTML format

  • If you look closely at this article, you will notice that in the previous section we had the option to export Word. We chose RTF to export Word, and the other option was HTMl. The operation is the same for exporting Word and HTMl. There is no repetition here

Export to Excel format

  • It is also common to export Excel, because Excel itself is a Table, and it makes perfect sense to convert the Table of our data into an Excel Sheet. Now let’s see how do we import

All you need to do is Ctrl+Shift+X from user PowerDesign command

  • After opening the Command window, you can either copy the VBS script or open the VBS file directly. Like word templates, PowerDesign has a lot of VBS embedded in it

  • Remember the VBS embedded in PowerDesign. The default VBS may be used later

  • I wrote a script to export Excel and open our VBS directly

  • After you have opened your own VBS, you are ready to execute

  • Let’s take a look at the EXCEL we generated. In it, I set a TABLE as a SHEET, and the home page and each SHEET page can jump to each other.

Generate Table according to Excel import

  • An Excel import to generate a Table is the same as an Excel export using a Table(PDM). throughCtrl+Shift+XCall command to execute the written VBS. In the resource

This is the table.vbs script. You can import Excel to the table by changing the Excel address every time you execute it.

Download the template

  • template

conclusion

  • It’s the same old saying that if you want to do a good job, you have to sharpen your tools. We have a tool called PowerDesign that solves all of our problems with database design, database documentation, data synchronization, and so on. We can go on a date in the time we save.