Service Accent - Database Utilities user manual
Contents
1. routine will overwrite exiting data if not used correctly This import routine is not to be used for importing data from other sources For external data import use the Data Import utility within Miracle Service Accent This import routine will only work if the data is formatted as exported from Miracle Service Accent When you select this option the following screen is displayed gt Database utilities c progra 1 accentdb Database utilities Preparing to import data Select which table ka import data to File name to read Ehe data From QA lt Previous Select which table to import data to Select which table to import data to p 15192 You need to specify which table you want to import Alerts data into Click on the drop down list next to Select Audit which table to import data to and scroll up and Categories down until you locate the required table You can Charges type the first letter of the table name to jump down SDITIBEDBRES the list if you know which table you require You Se ly import data f table at a ti Contract Histor can only import data from one table at a time Contracts Highlight the table by clicking once with the mouse File name to read the data from This is where the data will be read from By default the file will be called shorttablename csv and will be read from the same folder as your AccentDB database So for example if you were importing the contracts table2. MI RME NC FR MH_M3_RIMH Mi RMH MEP MH KB A MH WE d E 154012008 15 0H 2001 Adm 5 D D i D J D n 3 2 18012008 18400 0001 Admin 7 215112000 5 1 D i i E 3 1601001 18001 2001 Aden 8 2111000 5 D a D J D 0 8 i 15012001 14012081 Admin q 22 12000 5 1 D B 5 1601001 18002001 Admin 10 18015001 5 man n J D J D n 25 amp 16016001 18012001 Amn 11 14012001 5 14100 i D B TO 15012008 15 00 2001 Admin 12 21712000 5 Tb 755 a D o D 0 y 6 1601001 1500 01 Admin 14 202000 5 6000 T D i 0 110 S axo 2201 2001 Admin 15 1200 1 200 1 5 1X2 y 10 01032004 DULL Admn IE 011022001 5 1551 n a D J D 0 BEJ 11 01022004 OLD Admin 17 5 i D D D T3 12 OOOO HALA Admin 15 21012001 5 MI D a D o D n 14 13 020032001 00002001 Admin i 2340162001 amp Sir D i i 15 CARO OCO0 200 Ain X 24012001 5 BA n J D J D n 1B 15 05006001 10002001 Admin 2 5 D D i 1T IF MaA T II ON reni T1 h fi ri r1 ri A n n Database Utilities User Manual 8 Copyright 1999 2003 Vantage Computing Ltd All rights reserved Create Erase A Table Note This routine removes records from your database Please use with caution This option is used to create a blank table Effectively all information is deleted from any existing table and an empty table is created Before this option is run ensure that you have a backup of the table to be erased Database utilities Preparin
3. and your Miracle Service Accent was setup with the default settings the file name would be c program files accentdb contract csv This box is automatically completed when you select the table to import If you want to specify another Database Utilities User Manual 11 Copyright 1999 2003 Vantage Computing Ltd All rights reserved location manually enter the location remembering to type the full path and file name with csv extension otherwise the import will fail An example of the screen is shown below Database utilities c Aprogra TYaccentdb Database utilities Preparing to import data Select which table Eo import data to File name to read the data From ci progra 1accentdbicontact csv z Previous Mex Close To continue and import the data into the table click Next else click Previous to go back to the main dbutils screen The following screen will be shown while the import is progressing Database utilities c progra 1 accentdb Database utilities Import data From a C5V File Importing Alerts usl hit escape bo interrupt Database Utilities User Manual Copyright 1999 2003 Vantage Computing Ltd All rights reserved Align Keys Every record within the Miracle Service Accent database has a unique identifier called a key If your database is updated via Database Utilities frequently the keys table may become fr
4. the records after export very dangerous only use if advised to by your support provider Select Fields This is used to specify the fields that you want to export By default the export routine selects all fields Click Select fields if you want to only export certain fields The following screen will be displayed Select fields Available fields E elected fields E IN KEY IN CREATE DATE IM EDIT DATE IM EDIT LOGON Select fields E As all fields are selected by default E SUN firstly you have to deselect all fields Highlight all fields by clicking on the first field and hold the shift key while moving down with the down arrow key The screen will then appear as follows IN LOCATION DATE n To select the fields required highlight the field by clicking once with the mouse If you want to mE export more fields hold the control key while ror px clicking with the mouse VCi always recommends that when exporting data you always include the first field Selected fields Cancel Database Utilities User Manual 5 Copyright 1999 2003 Vantage Computing Ltd All rights reserved Once all the fields required are highlighted click on the gt button and these fields will be moved over to the Selected fields area Select fields EJ Available fields selected fields IN CREATE DATE IN EDIT DATE IN wTY START DATE E E Cancel Then click Ok to return to the export screen and
5. then click Next to proceed with the export of the selected fields Criteria This option is used to select data based on certain criteria So for example if you wanted to export all Inventory items that were installed on the 3 March 2003 you would use the criteria option When you click on criteria the following screen is displayed M Select export criteria Criteria Select pour criteria To create a selection criterion firstly click on the first drop down list to select the field you want to select on In our example we want the install date so we will select the IN INSTALL DATE Then in the next box select whether the install date Is or Is Not equal to a condition in our case it would be Is Then in the last box we need our statement which as we want to select an install date of 1 March 2003 we will enter 01 03 2003 the date should be entered in your regional format Database Utilities User Manual 6 Copyright 1999 2003 Vantage Computing Ltd All rights reserved ll Select export criteria Criteria Select your criteria IN INSTALL DATE gt fis gt 070372003 Click Add to finish the criteria ll Select export criteria Criteria IN INSTALL DATE 01703 2003 Select pour criteria If you want to add another selection criterion do the same as described previously When you click Add the criterion is added If you have more than one selection criteria each selection must be sati
6. Miracle Service Accent Database Utilities For Version 1 81 And Above Of Miracle Service Accent User Manual Copyright O Vantage Computing Ltd 2003 All rights reserved Last revision 3rd December 2003 By Peter Rushworth Database S icono 2 Starts Database UE a 2 Export a table40 CSV Tile teo uso he ah er A destine donnee tte 3 Create Erase A Tables ouo eti oe deme ne MEE A e M E CA E CIL nuit 9 Import Data From A CSV FIE c aos 11 ADIKE T 13 Zipa Table Or Your Database uiid os 14 UnA akabo 16 Appendix A Database Tables and Descriptions coocccoocccnocccoccccoccnnonnnonancnnoos 18 Database Utilities User Manual 1 Copyright O 1999 2003 Vantage Computing Ltd All rights reserved Database Utilities Note The version of database utilities described in this manual is applicable to version 1 81 of Miracle Service Accent and above Database utilities dbutils are a suite of programs that allow you to manipulate your data within Miracle Service Accent These are very powerful tools and should only be used with instructions from your support provider Misusing Database Utilities can result in loss or corruption of data within Miracle Service Accent Starting Database Utilities To start Database Utilities either click on Start Program Files Miracle Service Accent and then Database Utilities Or if this option is not visible open Windows Explorer and locate the file dbutils exe normally foun
7. agmented and will need to be re indexed This routine is used to perform keys maintenance and should be run whenever data has been imported using Database Utilities or if a table is restored from backup When you select this option the following screen will be displayed Database utilities f accentdb Database utilities Align keys Aligning keys Previous ext dose The process will run without any user intervention and when complete will return to the main database utilities main screen Note This routine will also reset your next invoice number next purchase order number and next job number to the one following the last one used Database Utilities User Manual 13 Copyright 1999 2003 Vantage Computing Ltd All rights reserved Zip a Table Or Your Database This option is used to compact your database tables into a smaller file for archiving or for sending to your support provider in the event of a problem You can either zip one table or the whole database When you select this option the following screen is displayed gt Database utilities c propra 1 accentdb Database utilities Preparing to zip a table ar database Select which table to zip File ip options Formatted saves your data in C5V Format C Raw saves your physical data Files z Previous Mext gt Close Select which table to zip You need to specify which table you want to zip Click th
8. alled tables Appendix 1 of this manual shows a list of all the tables and the type of data held within that table Select which table to export data from Select which table to export data from You need to tell Database Utilities which table you want to export the data from Click on the drop down list next to Select Alerts which table to export data from and ene scroll up and down until you locate the ategories l charges required table You can type the first letter Components of the table name to jump down the list if Contacts you know which table you require You can Contract History only export data from one table at a time Contracts Highlight the table by clicking once with the mouse Database Utilities User Manual 3 Copyright 1999 2003 Vantage Computing Ltd All rights reserved File name to save the data to This is where the data will be saved By default the file will be called its shorttablename csv and will be saved in the same folder as your AccentDB database So for example if you were exporting the contracts table and your Miracle Service Accent was setup with the default settings the file name would be c program files accentdb contract csv This box is automatically completed when you select the table to export If you want to specify another location manually enter the location Remember to type the full path and file name with csv extension otherwise the export will fail If the file name alr
9. and errors Database Utilities User Manual 18 Stores details of each separate Copyright 1999 2003 Vantage Computing Ltd All rights reserved stage of a service activity processed via the work control suite associated with jobs Used to store user developed specific forms to record additional information that Miracle Service Accent cannot store elsewhere Table Full Table Name Table Abbreviation STOCK HOLDINGS HOLDING BTR INVENTOR BTR INVLINE BTR INVOICE BTR LOAN BTR LOANS L MEMO BTR MEMOS M K K O METER BTR METERS MT METERHIS BTR METER HISTORY MH MOVEMENT BTR STOCK MOVEMENTS SM PL M E S E WN SE L V B E E PBOOK BTR PRICE BOOK PLINE BTR PORDER LINES PMSCHED BTR PM SCHEDULE P PORDER BTR PORDER REGION BTR REGIONS RESOURCE BTR RESOURCE SCHEDULE BTR SCHEDULE SERVICE BTR SERVICE TYPES Database Utilities User Manual Copyright 1999 2003 Vantage Computing Ltd All rights reserved SC R R S Comments Stores all current stock holdings by location including main engineer satellite and customer stoc k inventory item transactions header transactions knowledge base data Stores both internal and user definable key values Stores details of any loan transactions associated with service jobs Stores details of any notes associated with any table Used for metered inventory items only Stores current meter readings click charges and olanned mainte
10. ccent com and download the Miracle Service Accent Database Map Microsoft Windows 95 Windows 98 Windows NT Windows 2000 Windows XP Excel and BackOffice are trademarks or registered trademarks of Microsoft Corporation Service Accent is a trademark of Vantage Computing Ltd Miracle Service Accent is a joint trademark of Vantage Computing Ltd and Nextair Corporation Database Utilities User Manual 20 Copyright 1999 2003 Vantage Computing Ltd All rights reserved
11. d in c program files miracle service accent The following screen will be displayed when dbutils is run Database utilities c propra 1 accentdb Database utilities Select your options What do you want to do Export a table to a C5V file Create erase a table Import data From a CS File Align keys zip table or your database e ME Nm A Unzip a table Database Utilities User Manual 2 Copyright 1999 2003 Vantage Computing Ltd All rights reserved Export a table to a CSV file Note The data is not physically removed from your database when you export unless you specify otherwise It has effectively been copied and pasted into another location This routine is used to export data from Miracle Service Accent to a comma separated file CSV This csv file can then be opened with Microsoft Excel Notepad or similar programs The most popular use of the export is when your support provider requests that your data is sent to help in diagnosing a problem Click on the radio button next to Export a table to a csv file and then click next The following screen is then displayed 1 Database utilities c progra 1 accentdb Database utilities Preparing to export data Select which table to export data From File name to save the data to E E Delete the records that are exported after confirmation z Previous Close All the data within Miracle Service Accent is stored in files c
12. e drop down list next to the select which table to zip and scroll up and down until you locate the required table You can type the first letter of the table name to jump down Categories the list if you know which table you require Charges You can only zip data from one table at a time Components Highlight the table by clicking once with the Contacts a Contract Hiaba mouse lf you are zipping the whole of your database highlight All tables File This is where the data will be saved By default the file will be called shorttablename izh and will be saved in the same folder as your AccentDB database So for example if you were zipping the contracts table and your Miracle Service Accent was setup with the default settings the file name would be c program files accentdb contract lzh This box is automatically completed when you select the table to zip If you want to specify another location manually enter the location Remember to type the full path and file name with Izh extension otherwise the zip will fail If the file name already exists it will be over written without any warning So if you have previously zipped this table and use the same file name again it will be replaced with this version An example of the screen is shown on the next page Database Utilities User Manual 14 Copyright 1999 2003 Vantage Computing Ltd All rights reserved gt Database utilities c progra 1 accentdb Database utilities P
13. eady exists it will be over written without any warning So if you have previously exported this table and use the same file name again it will be replaced with this version An example of the screen is shown below Database utilities c progra 1 accentdb Database utilities Preparing to export data Select which Fable to export data From Contracts File name to save Ehe data to lesiprograe 11accentdbicontract csv Select Fields Delete the records that are exported after confirmation Criteria z Previous Next gt Close At this stage you could click next and all information in the table will be exported to the specified location Click previous to go back to the previous screen to select a different routine The following screen will be shown while the export is progressing Database utilities c propra 1 accentdb Database utilities Export a table to a CS File Exporting Contracts Bm hit escape to interrupt Database Utilities User Manual Copyright 1999 2003 Vantage Computing Ltd All rights reserved To stop the import at any point press the ESC key The export will terminate and advise how many records have been exported at the point of pressing escape After the export has completed a summary will show how many records were exported Also on the export you can select which fields you want to include you can enter a selection criteria and or you can delete
14. g to create a table Select which table to erase EE lt Previous If E From the drop down list select the table you wish to erase and click Next to continue You will be prompted to confirm that you want to erase the table selected Database utilities c progra 1 accentdb Database utilities Create erase a table Database Utilities 2 Please confirm that you want bo create the Alerts table Click Yes to confirm that you want to erase and re create the selected table Database Utilities User Manual 9 0 Copyright 1999 2003 Vantage Computing Ltd All rights reserved The following screen will be displayed which asks you to confirm the location of the table The system will default to the installation folder of your Miracle Service Accent database Confirm the physical location of the file Cancel Do not change the location of the table unless advised to by VCi Click OK to erase and create the table Database utilities Create erase a table The table has now been erased and created So in the example above the Alerts table will now be totally empty Database Utilities User Manual 10 Copyright 1999 2003 Vantage Computing Ltd All rights reserved Import Data From A CSV File Note This routine will over write any existing data within the table Please use with caution This option is used to import data into the Miracle Service Accent database Using the import
15. nance periodicit Used for metered inventory items only Contains a record of every meter reading transaction Holds a record of each stock transaction in double entry format workshop price matrices Contains the detail record s for each purchase order Stores date based planned maintenance schedules for both contracts and inventor Contains a header record for each purchase order Stores country area service region sales region and post code entries Used in conjunction with service jobs this table stores details of any additional resources associated with jobs Stores details of activities olanned via the visual scheduler Stores the rules and obligations associated with each type of service offering 19 Abbreviation SLINE BTR SORDER LINES Stores the relevant detail records for each sales order header SORDER BTR SORDER Stores a header record for each sales order document processed pa ror Rs l4 product oem emm AA setae ere of stock Items and other Services with completing a call remotel pam CNN eee applied Service Accent user _VAT BTR VAT CODES VA Stores VAT rates hand BTR 1 Stores warranty types offered to customers Lena BTR 22 Holds details of every service activity processed via the work control suite including open and closed calls pore NN a associated with jobs For a full description of the tables and the fields within each table please visit http www miracleservicea
16. omputing Ltd All rights reserved UnZip a Table This option is used to unzip unpack a previously zipped database file The following screen will be displayed Select file to unzip x Look in 53 AccentDB n ek ES Help HTML hy Recent 5 Logs Documents Recycle Bin Remote Gateway reports savedata gt Updates CY Users CDALERT LZH CIlCATEGOR LzH CYJEXTEND LzH CIITABLES LZH CI WORK LZH CD woRKEPART LZH My Network File name F Places Files of type Zipped files Cancel You will be prompted to specify the location of the zipped file the system defaults to the AccentDB folder and displays all the Izh files that are in that location Double click to select the file required The following screen will then be displayed Database utilities c progra 1 accentdb Database utilities Preparing to unzip a table or database Archive to unzip C Program Files 4ccentDB ALERT LZH lt Previous Database Utilities User Manual 16 Copyright 1999 2003 Vantage Computing Ltd All rights reserved After the unzip process has completed the following will be displayed Database Utilities y All Files within c program filestaccentdbial rt eh have been unzipped You may need to use Ehe Import option to import any CSV Files that may have been unzipped If the zipped file is formatted see section on zip options in Zip a table or databa
17. reparing to zip a table or database Select which table to zip a tables File c progra1accentdbitables zh rip options Formatted saves your data in CSY Format Raw saves your physical data Files z Previous Mex Close Zip Options There are two ways to zip the data the default is formatted 1 Formatted The data is firstly exported to csv files and then zipped This produces a smaller file but the process is slower 2 Raw The table files are zipped without first exporting to a csv file This produces a bigger file but the process is faster To continue and zip the data into the table click Next else click Previous to go back to the main dbutils screen The following screen will be shown while the zipping is progressing Database utilities c Mprogra TYaccentdb Es Database utilities To stop the zip process at any point press the ESC key and the zip process will terminate Do not use the file produced for any purpose as the data contained within the zip will not be complete Zip a table or vour database zipping Audit hit escape En interrupt After the table has been zipped an MS Dos PARES command prompt window will appear briefly as your data is compressed and then a confirmation message will be displayed as shown opposite Lad 2 1 The data has been zipped to c prograr 11accentdbcategorw lzh Database Utilities User Manual 15 Copyright 1999 2003 Vantage C
18. se the csv files will be extracted from the zip and placed in the nominated folder The csv files will then have to be imported into Miracle Service Accent using the import data option from database utilities If the data is raw not csv formatted the tables will be extracted from the zip and placed in the nominated folder AND WI LL OVERWRI TE the existing table files if present Database Utilities User Manual 17 Copyright 1999 2003 Vantage Computing Ltd All rights reserved Appendix A Database Tables and Descriptions Table Full Table Name Table Comments Abbreviation m BTR MEN AU Used to record job transactions a e g job logged assigned to engineer job on hold etc nu BTR CATEGORIES Stores common codes and categories found in the categories amp codes form on the admin menu internal overhead bands _ ican s o i both stock and inventory items for customer records associated with a contract information associated with the contract owner customer service purposes CUSTOMER BTR CUSTOMERS CU Contains information relating to all customers both sites and head office accounts defaults ENGINEER BTR ENGINEERS EN Contains details of engineers sub contractors and locational stores ESCALATE BTR ESCALATIONS Stores the rules required to escalate a service activity during its life cycle WORK EXTENSIONS Used to monitor system activity FAULT BTR WORK FAULTS such as user logins FORM BTR FORMS housekeeping runs
19. sfied otherwise the export will fail After entry of your criteria click Close to return to the previous screen and then click Next to start the export Delete the records that are export after confirmation p Note This routine removes records from your database Please use with E caution If you tick this box all records that are exported will be deleted after the export You will be prompted for confirmation before they are actually deleted Database Utilities A You have requested that these records are deleted From your database Please check that your data has been exported correctly then click OK to delete the records x Database Utilities User Manual 7 Copyright 1999 2003 Vantage Computing Ltd All rights reserved Before you click OK to delete the records please check the exported csv file and make sure the data has exported correctly You will not be able to get the records back if you have a corrupted csv file or made a mistake in selection the criteria The main use of this function is to extract and remove data from your database that you no longer require An example of a csv file Below is an example of how an export table will look when open in Microsoft Excel xcel METERHIS CS Y HE pe Gt bem root Forest Took ts es Heb pue Do at SU m A doses DT xu 0 przuysmxsscms Huemu A 2 iri A C a sm gd v x T E NE ite ce ie G H He ee M W mcer CREATE MH com TAMH EDT WH NE MH DATE hi REACH
Download Pdf Manuals
Related Search