PDBTools V0.60 Beta "READ ME" Document
PDBTools: Pronto DataBase Tools (PDBExport and PDBImport)
---------------------------------------------------------
Functionality:
--------------
PDBExport: Export Device Component Configuration and Codes from Factory or User DataBase
PDBImport: Import DEvice Component Configuration and Codes into the User Database
Purpose and Intent:
-------------------
This toolset is intended to give the user community the ability to export and import individual component information from/to the Pronto DataBase. It is hoped that this will result in a much more direct method of saving, editing, and importing individual device libraries. By using These tools, Device Information can be saved in dedicated export/import files and there is no need to export/import/manipulate whole system project files, entire user databases (V2), or Copy and Paste Hex Code strings into Pronto Edit. Just import a previously saved PDBEXPORT device file by using PDBIMPORT!
The Device Export format is in tab delimited format so it is user editable (MS Excel works well for this type of editing). Codes can be added, changed, and field content manipulated (be careful!). (Want to make those "DATABASE CODE" sequences visible in PEP? - Try changing the "IsRCSCode" field from "0" to "1" in your import file).
As these two tools are still under development, the first version(s) are in console format. This means you will have to run them under a command prompt from Windows. Open up a console prompt or run "CMD" from the run option on the Start Button....
Installation:
-------------
Three files are required for this toolset: PDBEXPORT.EXE, PDBIMPORT.EXE, and PDBTOOLS.INI. All three of these files should be extracted to the same directory. You must be in the diectory when these tools are run in order for PDBTOOLS.INI to be located. (IOW: "CD" into the directory which contains the tools before running them). PDBTools.INI contains user modifiable infomation on where to look for the actual Component DataBase File. (More on this later).
PDBEXPORT:
----------
Usage: PDBEXPORT {database} (brand} {model}
or: PDBExport USER *
Where {database} = "USER" or "FACTORY"
{brand} = Brand of Device to be Exported
{model} = Model of device to be Exported
or: {database} = "USER"
{brand} = "*" (To Dump Entire User Device Data into individual output files)
PDBExport will make no changes to your database(s)! It only retrieves data from them.
PDBExport will create an export file in the current directory which will be named
"{Brand}_{Model}.PDE" for each device it processes. To request an export file for a specific device, simply specify which database (USER or FACTORY), the brand of the device, and the model of the device.
Example: PDBEXPORT User DirecTV H20
The above example will create an export file named DirecTV_H20.PDE in the current directory.
If you wish to quickly export your entire user database simply run the following command:
Example: PDBEXPORT User *
The above example will create individual export files with all device and code definitions for each device in the user database. The files will be named as described above based on the Brand and Model information. Due to the size of the factory database, it was decided not to support a full dump at this time. (Although this could quite easily be added if the functionality is requested)
PDBIMPORT:
----------
Usage:PDBIMPORT {filename}
Where:{filename} = Name of file containg PDBExport data
PDBImport always imports data into the User Database (never the Factory Database). I would recommend that Pronto Edit be completely shut down when running import operations. If you are using PEP V1, the import results will be immediately visible/available once PEP is restarted, If you are using PEP V2, you must manually restart the "Pronto DataBase Service" before the import will be visible/available. (unlike Proto Edit Professional Version 1, Version 2 creates a "Pronto Data Server" service to run on your system and we must start/stop the service so it re-reads the database). Restarting the V2 DataBase service is very simple. It can either be done from the Administative "Services" Applet, or you can issue the following commands at the command prompt (Since this is where you are running the tools from anyway:
PEP V2 DataBase Service Restart Commands:Net Stop "Pronto Data Server"
Net Start "Pronto Data Server"
Compatilibility:
----------------
PDBTools are completely compatible with both version 1.X and Version 2 of the Pronto Edit Professional Databases. Although there are slight differences in the database formats, the export file format is prepared for V2 compliance. If PDBEXPORT is run against a V1 database, additional field data is appended (as NULL Values) to satisfy V2 requirements. If PDBIMPORT is being used to add data to a V1 database, then the additional field info is ignored.
PDBTOOLS.INI:
-------------
The PDBTOOLS.INI contains configuration information used by both utilities. Currently, it is used to identify the location of the ComponentDatabase.db file. This single file contains both the factory database (tables) and the user database (Tables). By default, this file is located in different directories depending on the PEP version and installation O/S (XP or Vista):
PEP2 (Vista) = C:\ProgramData\Philips\Common Database\ComponentDataBase.DB
PEP2 (XP) = C:\Documents and Settings\All Users\Application Data\Philips\Common Database\ComponentDataBase.DB
PEP1 (XP or Vista) = C:\Program Files\Common Files\Pronto\ComponentDatabase.DB
By default, the PDBToolset will search for the ComponentDatabase in the order listed above. It will use the first file it finds. If you are using both versions of PEP (V1 and V2) on your system, it is possible to make a very simple edit in PDBTOOLS.INI to force it to use a specific database instead of searching for one. The default "SEARCH=0" key in PDBTOOLS.INI tells the tools to search for the first DataBase it finds (as listed in the INI file). Setting "SEARCH" to some other value (1,2,3,etc) tells the tools to only use the respective database file. This is useful if you have both PEP1 and PEP2 on your system and want to specify which DB to use. Please read the comments in PDBTOOLS.INI for additional information.
Future:
-------
Although no support is provided for these tools, I welcome any and all constructive feedback. Any comments or suggestions should be sent directly to me via a message to "evanevery" on the
www.remotecentral.com message board. If the community finds these tools to be of value, the next step will be to move these functions into a complete GUI with additional functionality.