Editing Easy DB Help File
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 8: | Line 8: | ||
* Saves data to a sql lite database that you can use any way you wish. | * Saves data to a sql lite database that you can use any way you wish. | ||
* Highly configurable. | * Highly configurable. | ||
− | |||
= Download and Install = | = Download and Install = | ||
Line 170: | Line 169: | ||
== Report/Output Data == | == Report/Output Data == | ||
− | = | + | = Output = |
− | |||
− | + | == Output Formats == | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
When running a query ( you could call it a report ) there are a variety of formats to choose between ( not including which columns.... which is part of Output Content ). When you run a query the system tries to open the resulting file ( output is always to file, if you need printed output print the file ) in the approiapate viewer, often your text editor. | When running a query ( you could call it a report ) there are a variety of formats to choose between ( not including which columns.... which is part of Output Content ). When you run a query the system tries to open the resulting file ( output is always to file, if you need printed output print the file ) in the approiapate viewer, often your text editor. | ||
This list of formats may expand as I think of new options but as of now: | This list of formats may expand as I think of new options but as of now: | ||
− | + | === Table === | |
Table is an ASCII sort of spreadsheet, each record is on a single line, | characters separate the columns. Here is an example for the dogs scenario: | Table is an ASCII sort of spreadsheet, each record is on a single line, | characters separate the columns. Here is an example for the dogs scenario: | ||
Line 247: | Line 197: | ||
easy to import into most spreadsheets. | easy to import into most spreadsheets. | ||
− | + | === Input === | |
Input format makes the output look just like a cleaned up version of the input that would be necessary to input the data. One major difference is that the purpose is listed as export. This stops you from using it as input by mistake, you have to change the purpose to insert. | Input format makes the output look just like a cleaned up version of the input that would be necessary to input the data. One major difference is that the purpose is listed as export. This stops you from using it as input by mistake, you have to change the purpose to insert. | ||
Line 278: | Line 228: | ||
</pre> | </pre> | ||
− | + | === PyLog === | |
− | Here all the output is sent to the Python log file | + | Here all the output is sent to the Python log file. |
Line 306: | Line 256: | ||
</pre> | </pre> | ||
− | + | === CSV === | |
<pre> | <pre> | ||
ROWID breed dog_name typical_weight | ROWID breed dog_name typical_weight | ||
Line 316: | Line 266: | ||
</pre> | </pre> | ||
− | + | === SQL === | |
− | + | === HTML === | |
An HTML version of a table, much nicer to view than the ASCII version. | An HTML version of a table, much nicer to view than the ASCII version. |