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 67: | Line 66: | ||
= How to Use the Parameter File = | = How to Use the Parameter File = | ||
− | + | See: [[Configuration Files For Python]] | |
− | |||
− | |||
− | |||
You need a text editor suitable for .py files to manage the parameter file ( parameters.py ) | You need a text editor suitable for .py files to manage the parameter file ( parameters.py ) | ||
− | This includes | + | This includes most text editors. I particularity like: |
*notepad++ | *notepad++ | ||
Line 133: | Line 129: | ||
Save the file with a new name so it will not get overwritten the next time <Make Generic Input> is run. | Save the file with a new name so it will not get overwritten the next time <Make Generic Input> is run. | ||
+ | |||
Now we will edit the file for your new set of data. | Now we will edit the file for your new set of data. | ||
Line 152: | Line 149: | ||
+ | |||
+ | |||
Now for the input file <Browse...> to the file you just made. | Now for the input file <Browse...> to the file you just made. | ||
you can use the <Edit File> button to look at the file again if you wish. | you can use the <Edit File> button to look at the file again if you wish. | ||
Line 168: | Line 167: | ||
Your text editor should open with the output. | Your text editor should open with the output. | ||
− | = | + | = 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 ) | ||
+ | This list 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 194: | ||
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 225: | ||
</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 253: | ||
</pre> | </pre> | ||
− | + | === CSV === | |
<pre> | <pre> | ||
ROWID breed dog_name typical_weight | ROWID breed dog_name typical_weight | ||
Line 316: | Line 263: | ||
</pre> | </pre> | ||
− | + | === SQL === | |
− | |||
− | |||
− | + | === HTML === | |
== Output Content == | == Output Content == |