nte_conv Benutzerhandbuch
Contents
1. Name BlindcopyTo An 85 Adresse Adresse Betreff Datum Don t remove Parameters through Comparison Autosave Default NOS A Files MES If you want to change a parameters position within the output sequence you may select this parameter and press the position button nte conv eng pdf Hi Page 11 of 45 NTE CONV User Manual V0 8 Output Sequence EE A Dialog appears you may give new position within a valid range of the sequence Hove current Element Mame Please enter a new Position 1 2 o o Abbrechen In this example ist from 1 to 2 After pressing the OK button the position is changed Output Sequence 3 5 Delete parameters from Output Sequence If you want to move a parameter back to the available parameters field on the left side you may do this by selecting the parameter and press the arrow with the left direction button E selection be done windows like with lt SHIFT gt amp lt STRG gt 3 6 Adding new parameters While the first scanning process NTE CONV only collects the parameters witch are within the first dataset If parameters are missing in the first set you may add these by clicking on the new button D If this button is not activ click in the right field one time A input dialog appears Hew Parameter E2. followed by your prefered path in the target field Example d office nte conv eng pdf Page 34 of 45 NTE CONV User Manual V0 8 nte_cony exe Properties General Shortcut CS nle cony exe Target type Application T arget location Disc Target xMDCPP nte convsDiscsnte conv exe Start in WHOSTAHOST DNXENEPPAnte con Disc Shortcut key None Bun Normal window Eind Target Change Icon es zm The next time you start NTE CONV though this link the file dialog starts in d office Open o Look in C3 Office Al es Files of type Notes Export Text Files tut Cancel 6 6 2 Startup file e Create link to NTE CONV see description above e Copy this link to your windows Send to path The WinNT path is C windows profile Your Profile Send_to Win98 path is C Windows Sent_to Win2k and WinXP path is C Documents and Settings Your Profile Send_to The Vista und Windows 7 path is C Users Your Profile AppData Roaming Microsoft Windows SendTo nte_conv_eng pdf Page 35 of 45 NTE CONV User Manual V0 8 e f you have exported a Notes text file you only have to click with your right mouse button on it and choose under Send your created link example tte Send To corny nte_conv_eng pdf Page 36 of 45 NTE CONV User Manual V0 8 7 Details 7 1 Structure of the Lotus
3. My experience shows that Structured Text is the most reliable but there are not many programs who could use this kind of data format Because often have to export Notes databases and make their contents useable for other scripts or programs I ve deceided to program NTE CONV NIE CONV is able to read the Notes databases and convert them to CSV or XML files Depending on what you want there are lots of options which would effect the chosen output format 1 2 Licence NTE CONV is FREEWARE This means that you are allowed to use this program for private or commercial use You may distibute this program in the internet or on any electronical media CD DVD etc But you aren t allowed to sell this program THIS SOFTWARE IS PROVIDED BY THE PROJECT AND CONTRIBUTORS AS IS AND ANY EXPRESS OR IMPLIED WARRANTIES INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED IN NO EVENT SHALL THE PROJECT OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT INDIRECT INCIDENTAL SPECIAL EXEMPLARY OR CONSEQUENTIAL DAMAGES INCLUDING BUT NOT LIMITED TO PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES LOSS OF USE DATA OR PROFITS OR BUSINESS INTERRUPTION HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY WHETHER IN CONTRACT STRICT LIABILITY OR TORT INCLUDING NEGLIGENCE OR OTHERWISE ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE
4. 2 2 option formular a Options Validation e EZ dt Standard Options Validation File Location 63 CS Format Options Save Header w Add Quotation Marks Suppress empty Records Use Semicolon as Separator Use Separator jw Collect unbounded Lines as Text 150 8859 1 ASCH 0 Handling Encoding ASCII 0 Handling Delete ASCII 0 e Replace by CA LF f Replace by ASCII File Prescan Options Scan only 1st Record Faster f Scan all records may find more parameter 150859 ML Stylesheet Handling E All Elements e Selected Elements Common Options From SendTo CopyTo BlindlopyT a IMetFrom INetSendTo IMerBlindCapyTao Subject jw Try to extract Names Cut Strings after 1st Slash All except selected Elements The different options are described in chapter 5 3 to 5 6 2 3 parameter fields Available Parameters Output Sequence SiltPrincipal SLangPrincipal Mailer MessageID SRevisions SRFSaveInfa StorageTo SUpdatedBy AltFrom DefaultMailSaveOptrions deldate delTmpEncrypt delTmplmportance delTmpREeturnBEsceipt delTmpSidgn Encrypt EnterBlindCopytTo Example INetFrom In the left field you see the available parameters of a Notes file If you have selected parameters and transfer them to the right field the paramet
5. If a Notes parameter does not match with this guideline the characters are replaced by underscores Example gt FILE To take care of the most non english special characters NTE CONV uses the ISO 8859 1 characterset If your XML parser or your stylesheet processor can not read ISO 8859 1 charactersets you may change the encoding attribute in the headline of the XML to UTF 8 or UTF 7 nte_conv_eng pdf Page 32 of 45 NTE CONV User Manual V0 8 6 Misc Functions 6 1 Saving the the output sequence sourcename nos After each conversion NTE CONV stores the selected output sequence for each sourcefile in a file named sourcefile nos After you read the sourcefile again NTE CONV knows the output parameters and its sequence by reading this nos file 6 2 Saving the options in sourcename nof The selected options are also stored for each sourcefile before you start the conversion or when you exit NTE CONV This file is named sourcefile nof Nte Option File 6 3 Loading the options from sourcename nof If you want to load the options from a different option file you may press the Load Options button 6 4 Validierung der NTE CONV Einstellungen If NTE CONV CMD should validate the selected options before running the conversion you may press the Validate Options button The validation runs several checks only on the NOF file This means that some faults could not be detected
6. CSV files The are not lots of possibilities to create valid CSV files The basic rule is that each parameter is separated by a unique character This separator is comma or semicolon You may write the names of the parameters in the first line of a file or you may set the values in quotation marks Example Address City Country Firstname Name Tel Anystreet 1ly USAs George Clooney 01 23451 89876 Heather Graham Graham 7 3 Structure of the XML files XML files are more complex as CSV files are You may store params as elements or attributes the values may be stored as element context or attribut values Since V2 0 0 NTE CONV writes the parameters in four diffenrent modes see 5 6 11 Example for Mode 1 lt xml version 1 0 encoding ISO 8859 1 standalone yes gt lt fileExport from c Nexample txt to c example xml gt lt record gt lt Firstname gt George lt Firstname gt lt Name gt Clooney lt Name gt lt Address gt AnyStreet 1 lt Address gt City gt Coumbrv2oUusA Countrzy nte conv eng pdf Page 38 of 45 NTE CONV User Manual V0 8 lt Tel gt 01 23451 89876 lt Tel gt lt record gt lt record gt lt Firstname gt Heather lt Firstname gt lt Name gt Graham lt Name gt lt Address gt lt Address gt lt Country lt Country Tel lt Substituted El ment gt lt record gt e TqleExpott o ce 7 4 Tran
7. Frefis URI Export Record Number as f Comment Attribute Collect unbounded Lines as Made fo Elements with Element Context Encoding 150 8859 1 Stylesheet Handling Use Stylesheet m J Because of very complex XML options all options below are described with examples The example file is given in the NTE CONV package and named YexampleNexample txt The contents of the example file Name Clooney Firstname George Address AnyStreet 1 Country USA Tels 401 23451 89876 Tel 01 12345 67890 lt Notes dataset separator Name Graham Firstname Heather lt Notes dataset separator Name Picard Firstname Jean Luc Address Room next to the bridge of the USS Enterprise nte_conv_eng pdf Page 24 of 45 NTE CONV User Manual V0 8 Cit Country Properties He s the Captain of the lt ASCII 0 gt 055 Enterprise Notes dataset separator If only parts of the files are shown the previous and following lines are replaces by three dots Name Graham 5 6 1 Field Record Key Default empty With this option you choose a parameter which is used as a element ID Since V2 0 0 the key is printed as key_name and the key value is printed as key_ value Example Select Country from the example file Record bi output lt Pecore key name Country key lt record gt If you wa
8. Notes Structured Text Export Format Notes Structured Text Format is ASCII format where a parameter is followed by colon two spaces and its value The datasets are divided by ASCII 12 dez 09 hex this is the ASCII Escape Sequence for a new page ASCII 0 characters are used as line separators a dump of the example file which is used in the examples above Name Clooney Firstname George Address AnyStreet 1 CX ER Country USA Tels 02245709010 Tels O1 12345 678 90 Properties Name Graham Firstname Heather Address City Country Properties Name Picard Firstname Jean Luc Address Room next to the bridge of the USS Enterprise EE EE Properties He s the Captain of Enterprise This is the hexdump Name Clooney Firstname Geor ged Address An yStreet 1 1 Jmcountry US Ad Tel 01 234 51 89876 Tel 01 12345 678902 Properties AR ARM amer Graham JBEFirstname He ather BgAddress nte conv eng pdf Page 37 of 45 NTE CONV User Manual V0 8 JECity d Coun try JEProperti 9 Name Picards Firstna me Jean Lucs A ddress Room ne xt to the bridge of the USS Ente rprised City 2 MCountry 4 Pro perties He s t he Captain of th e USS Enterpris l J g Legend OD CR gt Carridge Return OA LF gt Line Feed 00 ASCII 0 gt next line 7 2 Structure of the NTE CONV
9. You must not use the software if you don t agree to these terms 1 3 Contact For futher details don t hesitate to get in contact with me Jens G deke Please use the contact sheet on my homepage which you ll find under the following link http www goedeke net kontakt eng html You may look for updates on my homepage http www goedeke net nte conv eng html 1 4 FAQ The only question that reaches me periodicly is 1 4 4 How could convert exported mail content The Lotus Notes exports RTF Rich Text Format fields without parameter name in structured text export files Since Version 2 0 0 you can fetch this unbounded lines with the nte conv eng pdf Page 4 of 45 NTE CONV User Manual V0 8 option Collect Unbounded Lines as This option is available for CSV see 5 4 5 and XML Exports see 5 6 10 For the special use case Import Notes mail exports into Outlook you may download the manual from my homepage http www goedeke net nte_conv notes2outlook en Zip nte_conv_eng pdf Page 5 of 45 NTE CONV User Manual V0 8 2 The Main GUI MA Lotus Motes Text Export Converter 2 2 0 Freeware c 1999 2007 Jens Godeke Options Destination File XML Format e gt Load Notes Exportlile ES Load Options Convert and Save CSV Format SN Edit Options _ ded Save Options Cose Available Parameters Output Sequence 3A ltPrincipal L
10. local name gt po Stade xsl for each SE lt Dann die Werte Kontext des ersten Record in die Zieltabelle schreiben Hinweis Nachfolgende Abarbeitung des Knotens record wuerde wegen niedriger Prioritaet den ersten Datensatz auslassen da dieser schon hier behandelt wird gt lt tr gt lt xsl for each select gt lt td gt lt xsl value of select 7 gt lt noch einen Zeilenabschluss lt br gt einfuegen sonst werden leere Elemente nicht in die Tabelle geschrieben gt lt xsl element name br lt xsl for each gt lt tr gt lt xsl template gt lt Alle weiteren Datensaetze auslesen und deren Werte in die Tabelle schreiben gt lt xsl template match record gt lt tr gt lt xsl for each select gt lt td gt lt xsl value of select gt lt noch einen Zeilenabschluss lt br gt einfuegen sonst werden leere Elemente nicht in die Tabelle geschrieben gt lt xsl element name br lt td gt lt xsl for each gt LIE nte conv eng pdf Page 40 of 45 NTE CONV User Manual V0 8 lt xsl template gt lt xsl stylesheet gt this generates lt html gt lt head gt lt meta http equiv Content Type content text html charset ISO 8859 1 lt head gt lt body gt lt table border 1 width 100 cellspacing 2 cellpadding 2 gt lt tr gt lt td gt lt b gt Firstname lt b gt lt td
11. marks a extended to double quotation marks this is defined in the csv spec Example 1 Hello Hugh is extended to Hello Ww Hugh Ww Example 2 Option deactivated nte conv eng pdf Page 21 of 45 NTE CONV User Manual V0 8 Firstname Name Address City Country George Clooney AnyStreet 1 USA Heather Graham Option activated Firstname Name Address City Country George Clooney AnyStreet 1 USA Heather Graham ms Ww us 5 4 3 Option Suppress empty Records Default Deactivated If this option is activated records were suppressed if all parameters have no values 5 4 4 Option Use as Separator Default Use Semicolon as Separator Diese Option selects whether the separator is a comma or a semicolon Example Option Use Semicolon as Separator Firstname Name Address City Country George Clooney AnyStreet 1 USA Heather Graham Option Use Comma as Separator Firstname Name Address City Country George Clooney AnyStreet 1 USA Heather Graham 5 4 5 Option Collect unbounded Lines as There is a new feature included in 2 2 0 Its the same feature which is included since 2 0 0 for XML but know it s also available for CSV export This option allows you to collect all lines of a dataset which are not signed by an identifier All violett lines are collected in the following example Name Picard Firstname Jean Luc Addre
12. you may refer to the homepage http www goedeke net nte_conv_eng html nte_conv_eng pdf Page 45 of 45
13. NTE CONV User Manual V0 8 Lotus Notes Text Export Converter NTE CONV User Manual NTE CONV Version V2 2 2 1 Lotus Notes is a registered trademark of IBM Corporation nte conv eng pdf Page 1 of 45 NTE CONV User Manual V0 8 Contents ANTE CONV EE 4 e EE EE EE eege 4 er 4 EES 4 EE 4 1l p n E EES 4 INE EE 6 AT 6 IUE EEN H re Oh ne 7 LA be 8 SS EE 8 TUE TEO 8 3a DELETE A MANUAL ADDEDEPAR eee ee Ee 13 Re EE 13 Jo SE EE 21 5 4 1 Option Save EIBOEIBE I esu eec 21 nte_conv_eng pdf Page 2 of 45 NTE CONV User Manual V0 8 7 1 STRUCTURE OF THE LOTUS NOTES STRUCTURED TEXT EXPORT FORMAT eee 37 EE CIN EEN 38 E ee Wee ER SE RI KT Er 38 7 4 TRANSFORMATION OF A XML FILE WITH A XSLT 6 5 2 39 RELEASE EE 43 ene BEE 44 Ee 44 EE 45 nte_conv_eng pdf Page 3 of 45 NTE CONV User Manual V0 8 1 NTE CONV 1 1 Purpose Lotus Notes Databases can be exported in different formats
14. ame Attachment is used Hint The output of the collected lines are depending on what you have selected in the ASCII 0 Handling option If you have selected Delete ASCII 0 all line feeds are suppressed in the output 5 6 11 Option Since V2 0 0 NTE CONV supports 4 different XML modes for the output file 1 Elements with Element Context classic mode of the previous versions 2 Elements with Attributes 3 Attributes with Element Context 4 Attributes with Attribute Context See an example for each mode 5 6 11 1 Elements with Element Context lt record gt lt Firstname gt George lt Firstname gt lt Name gt Clooney lt Name gt lt Address gt AnyStreet 1 lt Address gt Se lt Country gt USA lt Country gt lt Properties gt lt Tel gt 01 12345 67890 lt Tel gt lt record gt nte_conv_eng pdf Page 29 of 45 NTE CONV User Manual V0 8 ee 5 6 11 2 Elements with Attributes lt record gt lt Firstname value George gt Name value Clooney gt lt Address value AnyStreet 1 gt City value gt Country value USA Properties value Tel value 01 12345 67890 lt gt 5 6 11 3 Attributes with Element Context lt record gt lt item name Firstname gt George lt item gt lt item name Name gt Clooney lt item gt lt item name Address gt AnyStreet 1 lt item gt lt item name City gt lt item name Countr
15. angfr incipal Hailer jMessageID Revisions 3RFSaveInfo a4S5torageTo UpdaetedBy AltFrom oom Yon DefauirHaiisSaveoptions deldate delTmpEncrypt SCC Adresse de lTmp Importance delTmpReturnReceipt dei TmpSign 3ub je Betreff Encrypt EnterBlindCopyTo gt Dat um Adresse Farer Example Don t remove Parameters through Comparison IetFrom efr nif Senfus ia F Autosave Defauk NOS amp NOF Files Ad Save Seance Parameters counted sn Parameters Eound substituted Parameters suppressed Records written Records suppressed Conversion time sec Conversion of conv 2html csv was successful 2 1 The button field e l WML Format gt gt Load Notes Exportlile Load Ophons Format o Femme The buttons and their meanings are listed below Load Notes Exportfile Loads an exported Notes file Edit Options Opens the Option formular e Validate Options Check whether the options are ok or not e Load Options Load options from a different option file e Save Options Save options to a different option file e Convert and Save Converts and saves the Notes file in the chosen target format e Close Program ends nte_conv_eng pdf Page 6 of 45 NTE CONV User Manual V0 8
16. as a hourglass After you see the statistic information the conversion is done If you double click on the Information field a transfer dialog appears nte conv eng pdf Page 16 of 45 NTE CONV User Manual V0 8 3 Copy content to clipboard No Cancel If you press Yes the information is copied to the windows clipboard nte_conv_eng pdf Page 17 of 45 NTE CONV User Manual V0 8 5 The Options To give you the possibility for a most flexible conversion a lot of options are available Options SML Standard Options Validation CS Format Options W Save Header x w Add Quotation Marks 9 Suppress empty Records Validation File Location Use Semicolon as Separator Use Separator ASCII 0 Handling Collect unbounded Lines as Tent Encoding 150 9859 1 ASCII 0 Handling Delete ASCII 0 e Replace by CA LF f Replace by ASCII File Prescan Options Scan only 1st Record Faster f Scan all records may find more parameter 1 Elements with Element Contest E Common v From Try to extract Name v SendTo v Lut Strings after 1st Slash BlindCopyTo Stylesheet Handling IMetFrom INetSendTo All Elements e Selected Elements INetCopyTo e All except selected Elements Geen 5 1 Destination File Type Destination File Ce ML Format CS Format M Options Dep
17. ater This can be done by clicking the Export Menu item from the main menu File After that you have to give a filename for the textfile hsperfdata jgoedeke a DFZBOC tmp DFIC CE tmp ixosodma a DF3D2C tmp DFC7E6 tmp E C 6092 6 DFSADO tmp el DFDF3C tmp wBE DF6779 tmp DFECD amp tmp E DF2590 tmp DFBFE4 Emp DFEF14 tmp n DFZ69D tmp el DFC7BS tmp el DFFECZ tmp E D ateiname filename E port Dateityp Structured Text Abbrechen Hilte D EZ Choose a filename with a txt extension see example above The export format must be Structured Text After that you may select whether you export all or only the selected items of you Notes DB Structured Text Export All documents Selected documents Default character set Intemational 8 Unicode Form feed Character code 12 wards at 999 characters per line The dataset separator must be Form feed or Character code 12 this is set by default so don t change it The position of the word wrap should be about 10000 if you use textfields nte conv eng pdf Page 9 of 45 NTE CONV User Manual V0 8 The export process starts by clicking the Button 3 2 load process Now you are able to load and scan the file you ve exported a few seconds before Just press the Load Notes Ex
18. e g if a specified record key does not exist in the source file This kind of fault is only detected in the conversion process 6 5 Saving the output sequence to any file If you want to use a output sequence file for more than one source file you may save the current output sequence to a file with a specific name This is only useful when you re using the command line converter NTE CONV CMD 6 66 Commandline parameters Since V1 7 0 NTE CONV supports commandline paramters The syntax conv Dper paubname tilename You may use this parameters effectively by creating a link to NTE CONV e Therefore you have to click with your right mousebutton conv exe and choose Create link or how this is named in your english version of windows nte conv eng pdf Page 33 of 45 NTE CONV User Manual V0 8 _ example description tet Historie nte conv Gs nte con za Bpen 13 Winzip d E nte conw i 3 Supero Search nte conv BaEdis Send To k Cut Create Shortcut Delete Rename Properties e Rename the link from nte conv exe to nte conv or whatever makes more sense than its original link name 6 6 1 Initial Path With the option i pathname you may select a path in which NIE CONV starts its file dialog after you start NTE CONV e Create a link to NTE CONV see description above e Edit the properties of the link and append a
19. e_conv_eng pdf Page 43 of 45 NTE CONV User Manual V0 8 9 conv cmd 9 1 Usage Syntax nee Conv S SOURCE p norsOPTIFrONEIBLEb enuossOUTPULSBEOUBENCE ISC TARGET v sp or to validate an option file hee conv omo val OPT TONE TE pex SOURCE A exported structured text file OPTIONFILE option file Default is SOURCE file with nof extension OUTPUTSEQUENCE output seq file Default is SOURCE file with nos extension target file Default is SOURCE file with nof extension Verbose mode Validation mode Show Process lt don t use this option if you re redirecting output to a file If only the source file is given NTE CONV CMD requires a NOS siehe Fehler Referenz nicht gefunden and NOF siehe Fehler Referenz nicht gefunden file with the same name except the file extension and the same path as the source file The target file name is build by source file path source file name extension XML or CSV depending on what s selected in the NOF file If you want to create or modify a NOF or NOS file by a text editor and not NTE CONV the formats are described in the following chapter nte conv eng pdf Page 44 of 45 NTE CONV User Manual V0 8 10 Examples Would you like to know how to import Lotus Notes Mail and or Lotus Notes Contacts into MS Outlook Then you may download the following zip Archive http www goedeke net nte_conv notes2outlook en Zip For other examples
20. ending on which File Type you have selected a group of options is enabled to change 5 2 File Prescan Since the first release in 1999 had to decide whether to scan only the 1 record of an export file or the complete export file Assuming that the most important parameters were included in the first record and knowing that the PCs where not the fastest in scanning huge export files had chosen the first option Now based on a change request of a user and with the background of much faster PCs decide to switch to the second option 5 2 1 Scan only 1 Record This is the old method which scans only the first record to fetch the available parameters 5 2 2 Scan all records This is the new default method which scans all records for available parameters The message box is telling you which parameters are found in which record For example nte_conv_eng pdf Page 18 of 45 NTE CONV User Manual V0 8 New Record 2 detected New Record 3 detected Adding new Parameter In Reply To Adding new Parameter SAltNameLanguageTags Adding new Parameter SStorageCc Adding new Parameter S StorageBcc Adding new Parameter AltCopyTo Adding new Parameter InheritedReplyTo Adding new Parameter InheritedFrom Adding new Parameter InheritedAltFrom Adding new Parameter InheritedFromDomain While there is no new parameter found in record 2 there are 9 new parameters in record 3 5 3 Common Options Common Optio
21. ers are removed from the left field gt Adresse Adresse Adresse Betreff Datum Save Sequence Don t remove Parameters through Comparison Autosave Default NOS amp NOF Files The right field shows the parameters and the output sequence you want to write to the output file nte_conv_eng pdf Page 7 of 45 NTE CONV User Manual V0 8 2 4 The example field Since version 2 0 0 shows an example for each parameter you select on of the parameter fields The example is stored while NTE CONV scans your source file s first record Example Firstname George 2 5 The status field Status field shows what is doing while you read convert save a file Current Sourcetile D Fine conv example example txt 2 6 The info field Since version 2 0 0 NTE CONV s converting module is extracted from the main programme to a command line executable which is called NTE CONV CMD The output of NTE CONV CMD and some other information is shown in the info field Lines read 720230 Parameters counted 670176 Parameters found 824555 Parameters substituted 0 gParemetera suppressed i 345621 Ipecords vritten 5444 Records suppressed Conversion tine aec 1 nte conv eng pdf Page 8 of 45 NTE CONV User Manual V0 8 3 Conversion Preparation 3 1 Exporting a Notes DB First you have to export the Notes DB you want to convert l
22. gt lt td gt lt b gt Name lt b gt lt td gt lt td gt lt b gt Address lt b gt lt td gt lt td gt lt b gt Ciaty lt b gt lt td gt lt Ed gt lt b gt Countey lt be lt td gt lt td gt lt b gt Tel lt b gt lt td gt lt tr gt lt tr gt lt td gt George lt br gt lt td gt lt td gt Clooney lt br gt lt td gt lt td gt AnyStreet 1 lt br gt lt td gt tdoebr td lt td gt USA lt br gt lt td gt lt td gt 01 23451 89876 lt br gt lt td gt lt tr gt lt td gt Heather lt br gt lt td gt lt td gt Graham lt br gt lt td gt td br td lt td gt lt br gt lt td gt lt pd gt lt bro lt lt td gt lt br gt lt td gt lt tr gt lt table gt lt body gt lt html gt The result viewed with a HTML browser nte_conv_eng pdf Page 41 of 45 NTE CONV User Manual V0 8 Firstname Name Address City Country Tel George Clooney AnyStreet 1 USA H 01 23451 89876 nte conv eng pdf Page 42 of 45 NTE CONV User Manual V0 8 8 Release Notes NTE_CONV 2 2 2 New option File see 5 2 NTE CONV 2 2 1 Error corrections NTE_CONV 2 0 0 gt V2 2 0 New Features of release 2 2 0 are Alias support refer to chapter 3 9 CSV Option Collect unbounded lines refer to chapter 5 4 5 The calling of the default browser found in some of the help menu items has been optimized so that the internet explorer works as well nt
23. ifier instead of the original name In this example the former field Address is exported as My Address This feature can be used to generate more acurate export files which can be imported into programs that have strict naming conventions nte_conv_eng pdf Page 14 of 45 NTE CONV User Manual V0 8 4 Convert and save file First you have to choose whether you want to convert the Notes file to a CSV or XML file Destination File Ce ML Format CS Format M Options What ever you choose here its options are enabled the options formular There are several options which you may change by pressing the Edit Options Button from the Button field These options are described in Chapter 5 After your settings have been selected you may start the conversion Normally NTE CONV generates an option file and an Output sequence file NOS for each source file If you want to create only temporary and NOS files you may uncheck the option Default NOS amp Files E Be sil Don t remove Parameters through Comparison Autosave Default NOS amp Files Save Dialog appears where you have to choose an output file 21 Save example Al m example rl al example wmd al examples xml m example3 xml al example4 xml File name Save as type KML Files Cancel The extention
24. ions Example Option deactivated record lt Firstname gt George lt Firstname gt lt Name gt Clooney lt Name gt lt Address gt AnyStreet 1 lt Address gt SCIT UTE Country USA Country Te1H01 23451 989576 Tel lt record gt Option activated lt record gt lt Firstname gt George lt Firstname gt lt Name gt Clooney lt Name gt lt Address gt AnyStreet 1 lt Address gt XCI City gt lt Country gt USA lt Country gt lt Tel gt 01 23451 89876 lt Tel gt lt 1 gt 401 12345 67890 lt 1 gt EE nte_conv_eng pdf Page 26 of 45 NTE CONV User Manual V0 8 5 6 5 Option Substitude missing with empty Elements Default deactivated If parameters are missing in datasets this option decides whether empty elements are placed in the output record or not The options Ignore Elements with empty Values and Substitude missing with empty Elements are excluding each other If one of these options are checked the other option is disabled Example parameter Tel is not available in the currect dataset Option activated record lt Firstname gt Heather lt Firstname gt lt Name gt Graham lt Name gt lt Address gt lt Address gt arp SE 1 gt lee 5ubhstiruted Element gt lt record gt Option deactivated lt record gt lt Firstname gt Heather lt Firstname gt lt Name gt Graham lt Name gt lt Address gt lt Address gt
25. l elements Now you are able to select the elements which should be modified by the two common functions Here are the different selection modes e All Elements The chosen functions work with all elements e Selected Elements The chosen functions work only with the selected elements in the right list e All except selected Elements The chosen functions work with all elements except the selected elements in the right list nte_conv_eng pdf Page 20 of 45 NTE CONV User Manual V0 8 5 4 CSV Options The following options are only available if CSV format is selected in the main GUI LS Format Options Save Header Add Quotation Marks W Suppress empty Records f Use Semicolon as Separator C Use Comma as Separator Colect unbounded Lines as Body Encoding 150 9859 1 ei ASCII Handling C Delete ASCII D t Replace by CA LF f Replace by ASCII Space 32 5 4 1 Option Save Header Default Activated The first line of the output CSV file is represented by the parameter names Example Option is activated Firstname Name Address City Country George Clooney AnyStreet 1 USA Heather Graham Option is deactivated George Clooney AnyStreet 1 USA Heather Graham 5 4 2 Option Add Quotation Marks Default Deactivated All parameter values including the header if Header option is activated are embraced by Quotation Marks Since version 2 0 0 single quotation
26. lt City gt lt City gt sScoumtrv Countsy lt gt 5 6 6 Option ASCII 0 Handling Default Delete ASCII 0 In Notes Structured Text format files the lines of textfields are not separated by but with ASCII 0 characters With this option you decide which character replaces the ASCII 0 character or if new elements are created 5 6 6 1 Option Delete ASCII 0 All ASCII 0 characters are deleted Example lt record gt lt Record number 3 gt lt Name gt Picard lt Name gt Properties He amp apos s the Captain of the USS Enterprise lt Properties gt lt record gt nte_conv_eng pdf Page 27 of 45 NTE CONV User Manual V0 8 5 6 6 2 Option Replace by CR LF All ASCII 0 characters are replaced by CR LF Example lt record gt lt Record number 3 gt lt Name gt Picard lt Name gt Properties He amp apos s the Captain of the USS Enterprise lt Properties gt record 5 6 6 3 Option Create new Elements Each ASCII 0 character creates a new Element Example record Record number 3 gt lt Name gt Picard lt Name gt lt Properties gt He amp apos s the Captain of the lt Properties gt lt Properties gt USS Enterprise lt Properties gt lt record gt 5 6 7 Option Export Record Number With this options you select whether the current dataset number is written in the output file
27. ns Tru to extract Names Cut Strings after 1st Slash All Elements f Selected Elements All escept selected Elements Both filter work similar but there are small differences sometimes Notes stores Names with their department company and so on 5 3 1 Option Try to extract Names Is a parameter separated in object segments this filter extracts the first item of any object Example from CN George Clooney OU Ambulance O Chicago Memorial gt George Clooney is extracted gt The first item within an equal sign and a slash is extracted Is the parameter a list field all first items of each objects are extracted from CN Jean Luc Picard OU USS Enterprise CN Worf OU USS Enterprise gt Jean Luc Picard Wort is extracted 5 3 2 Option Cut Strings after 1 Slash The difference to the to extract Names option is that the first item does not have equal sign From George Clooney OU Ambulance O Chicago Memorial nte conv eng pdf Page 19 of 45 NTE CONV User Manual V0 8 gt George Clooney is extracted Is the parameter a list field all first items of each objects are extracted From Jean Luc Picard OU USS Enterprise Worf OU USS Enterprise gt Jean Luc Worf is extracted 5 3 3 Element Selection New with 1 8 0 With the former versions of NTE CONV the functions Try to extract Names and Cut Strings after 1 Slash were executed on al
28. nt to delete a selected record key click on the trash bin button If no Record Key is selected no attribute appears in the record output 5 6 2 Option Ignore Records with empty Key Values Default deactivated If this option is activated you have chosen a record key and the parameter does not exist or it does not have a value the output of the whole record dataset is suppressed 5 6 3 Option Ignore Elements with empty Values Default deactivated If this option is activated and a parameter has no value the element output is suppressed The options Ignore Elements with empty Values and Substitude missing with empty Elements are excluding each other If one of these options are checked the other option is disabled Example Option deactivated lt record gt lt Firstname gt Heather lt Firstname gt lt Name gt Graham lt Name gt lt Address gt lt Address gt nte_conv_eng pdf Page 25 of 45 NTE CONV User Manual V0 8 54 le oa Pe 1b lt Country gt lt Country gt lt record gt Option activated lt record gt lt Firstname gt Heather lt Firstname gt lt Name gt Graham lt Name gt lt record gt 5 6 4 Option Allow multiple Element Occurrence Default deactivated If parameters appear in a Notes file more than one times this option decides if only the first appearance is send to output or all appearances are send to output This is done in dependency to the other opt
29. nter a Parameter M arme ee Abbrechen nte conv eng pdf Page 12 of 45 NTE CONV User Manual V0 8 After giving a parameter name and pressing the button checks whether the parameter exists in one of the both fields or not ve option Don t remove Parameters through Comparison is activated now Don t remove Parameters through Comparison This is a protection option cause normaly all non existing parameters are removed when you load the exported file again This option disables the removing function 3 Renaming a manual added parameter Click on a manual added parameter The edit button is activated Press this button to change the name of the parameter 3 8 Delete a manual added parameter Click on a manual added parameter The delete button 1 activated Press this button to delete the parameter 3 9 Alias Usage A new feature is included in NTE CONV V2 2 0 Output Sequence CUI Addr To enter an alias you have to select a parameter in this screenshot it s Address After that you have to press the Si button in order to get a dialog called Change Parameter Change Parameter Enter Parameter Name The given Alias is shown in the field called Alias E Sequence Address nte conv eng pdf Page 13 of 45 NTE CONV User Manual V0 8 While you do the conversion into CSV or XML format the alias is written as field intent
30. nto the output file 5 6 14 2 Option XML Schema Definition XSD A XML document that refers to a XSD file is called Instance With this option you are able to place XSD references in the output file 5 6 14 3 Option Document Type Definition DTD To include a reference to a DTD file you choose this option 5 6 14 4 Option XML Validation Location With this option you are able to include DTD XSD information into the output file Validation File Location amp Embed Absolute Path Filename only You may use the button right to the edit field to search for a special DTD or XSD file NTE CONV would scan the DTD XSD file for the applied schema namespace and include this information into the output file 5 6 14 5 Option Embed With this option you decide whether the full path Absolute Path or only its filename Filename only is included into the output file The path separators backslash are replaced by slashes 5 6 15 Option Namespace http You may enter the a namespace and its URI nte_conv_eng pdf Page 31 of 45 NTE CONV User Manual V0 8 Advice The namespace is filled automatically if you have chosen the XSD file by the filebrowser see 5 6 14 4 Validation File Lacation Embed Absolute Path only 5 Automatic XML Errorcorrection XML Elements must start with a character or an underscore
31. of the output file is depending on which file format you have selected before Press the Save button to start the conversion process nte conv eng pdf Page 15 of 45 NTE CONV User Manual V0 8 The Information field shows the information NTE CONV CMD generates Example output i FE aE ae dd aE AE FE ea aaa aaa aaa aaa aaa aaa aaa aaa aaa aaa NTE CONV V1 2 0 Freeware c Jens Goedeke 2005 2007 it tat He Ht AE ae He TE AE He A FE ae AE Reading NOF file lt D cpp nte_ conv example example nof gt gt Ready Reading NOS file lt D cpp nte_ conv example example nos gt gt 4 Parameters amp 1 Aliases found Output format 2 GSV Separator Semicolon Print header Yes Quotation marks Yes Empty records Suppress Source Encoding ISO 8859 1 Target Encoding ISO 8859 1 ASCII 0 handling Line collecting Extract names Space ASCII 32 Yes Name Body No Cut names S No Converting lt conv example example txt gt to lt conv example example csv gt Working Done Statistics Lines read 2 27 Parameters counted 9 12 Parameters found 3 12 Parameters substituted 0 Parameters suppressed 0 Records written d Records suppressed k 0 Conversion time sec 0 While NTE CONV CMD runs the cursor is shown
32. or not Further you may select if the dataset number should be written if it is done as a XML attribute or a XML comment 5 6 8 Option Comment Default activated Option activated lt record gt lt record number 2 gt lt Firstname gt Heather lt Firstname gt lt record 5 6 9 Option Attribute Option activated lt record number 2 gt lt Firstname gt Heather lt Firstname gt lt record gt nte_conv_eng pdf Page 28 of 45 NTE CONV User Manual V0 8 5 6 10 Option Collect unbounded Lines as With the final version 2 0 0 comes an option that allows you to collect all lines of a dataset that are not signed by an identifier All violett lines are collected in the following example Name Picard Firstname Jean Luc Address Room next to the bridge of the USS Enterprise Picard was born on Earth in 2305 to Maurice Picard and Yvette Gessard Picard Maurice was a tradition bound French vintner who opposed Jean Luc s ambitions of voyaging among the stars COURTEY Properties He s the Captain of the USS Enterprise The result is if you name the element test lt test gt Picard was born on Earth in 2305 to Maurice Picard and Yvette Gessard Picard Maurice was a tradition bound French vintner who opposed Jean Luc amp apos s ambitions of voyaging among the stars lt test gt collected gt you don t givetype a name for the element the default element n
33. portfile button on the main GUI of NTE CONV Lotus Notes Text Export Converter File Options Help 2 Load Notes Exporttile A file dialog appears Look in example EN 21 B e Ie3 Em File name Jexample tet Files of type Notes Export Text files txt Cancel Select the exported file and press Open After that a scan process on the first dataset of the Notes file starts All parameters of the first dataset are collected and shown in the left part of the parameter field Available Parameters Firstname Marie nte conv eng pdf Page 10 of 45 NTE CONV User Manual V0 8 3 3 Selection of parameters You may select the parameters you want to convert by clicking on them Windows like selecting with lt Shift gt amp lt CTRL gt is also possible Available Parameters Firstname Name EA By clicking on the red arrow see above you move the parameters to the output sequence field on the right side Available Parameters s ltPrincipal SLangPrincipal Mailer MessageID Revisions SRFSaveInfo StoarageTo UpdatedBy lltFrom DefaultMailSaveOptions deldate delTmpEncrypt HelTmplmportance idelTmpReturnEeceipt delTmpSiun Encrvpt EnterBlindcCaopyTo Example INetFrom 3 4 Changing the Output Sequence Output Sequence From SendTa An Name
34. racter in the output file or if the ASCII 0 character is deleted Since V2 0 0 ASCII 0 characters can be replaced by too If ASCII 10 LF 13 CR or CR LF is selected the option Add Quotation Marks is automatically checked Hint Excel prefers ASCII 10 LF as ASCII 0 replacement 5 5 Automatic CSV Error Correction To avoid errors in CSV files there s a kind of protection mechanism If you have chosen Use Comma as Separator and a parameter consists of commas example Riker William T the commas are replaced by semicolons if Quotation Marks is deactivated Example Option Use Comma as Separator Add Quotation Marks Riker William T gt Riker William T Option Use Comma as Separator ohne Add Quotation Marks Riker William gt Riker William T The Option Use Semicolon as Separator is handled the same way but vice versa nte conv eng pdf Page 23 of 45 NTE CONV User Manual V0 8 5 6 XML Options ML Standard Options ML Validation Record Pe bi f Mone standalone ignore Records with empty Values C XML Schema Definition SD lgnare Elements with empty Values C Document Definition Allow multiple Element Occurence validation File Location Substitude missing with empty Elements e ASCII Handling e e Delete ASCII 0 e Replace by LH LF Create new Elements Use Namespace
35. sformation of a XML file with a XSLT processor In 1999 the W3C org created a transformation language for XML A derived special part of this language is XSLT See a universal XSLT script for transformating any NTE CONV XML file with a constant number of parameters in its records into HTML tables lt xml version 1 0 gt lt xsl stylesheet version 1 0 xmins xsl http www w3 org 1999 XSL Transform gt xsl output method html encoding ISO 8859 1 indent yes gt lt Universal XSLT script to convert all datasets of a NTE CONV exported XML file into HTML 09 29 2002 by Jens Goedeke gt lt Wurzelknoten abarbeiten HTML Grundlagen in Zieldatei schreiben gt lt xsl template match gt lt html gt lt head gt lt head gt lt body gt lt xsl apply templates gt lt body gt lt html gt lt xsl template gt l fileExport Knoten Tabellenrahmen schreiben gt lt xsl template match fileExport gt table border 1 width 100 cellspacing 2 cellpadding 2 gt lt xsl apply templates gt lt table gt lt xsl template gt nte_conv_eng pdf Page 39 of 45 NTE CONV User Manual V0 8 lt erstes verfuegbares Record auslesen gt lt xsl template match record position 1 gt lt Erst die Parameterbezeichner Elementnamen in die Zieltabelle schreiben mex lt tr gt lt xsl for each select gt lt td gt lt b gt lt xsl value of select
36. ss Room next to the bridge of the USS Enterprise Picard was born on Earth in 2305 to Maurice Picard and Yvette Gessard Picard Maurice was a tradition bound French vintner who opposed Jean Luc s ambitions of voyaging among the stars Cia Country Properties He s the Captain of the USS Enterprise nte_conv_eng pdf Page 22 of 45 NTE CONV User Manual V0 8 The result is if you have chosen Body as the element name My Address City Country Firstname Body Anystreet hh YY E VOSA George LAJ yv yv II yv 2 Heather Room next to the bridge of the USS Enterprise Jean Luc Picard was born on Earth in 2305 to Maurice Picard If you don t type a name for the element the default element name Attachment is used Hint The output of the collected lines are depending on what you have selected in the ASCII O Handling option If you have selected Delete ASCII 0 all line feeds are suppressed in the output 5 4 6 Option Encoding Since V2 0 0 the file encoding can be selected If the encoding of the source file differs from the selected encoding a automatic conversion is done 5 4 7 Option ASCII 0 Handling Default Delete ASCII 0 In Notes Structured Text format files the lines of textfields are not separated by but by ASCII 0 characters With this option you decide which character replaces the ASCII 0 cha
37. y gt USA lt item gt lt item name Properties gt lt item name Tel gt 01 12345 67890 lt item gt lt 5 6 11 4 Attributes with Attribute Context lt record gt lt item name Firstname value George gt lt item name Name value Clooney lt item name Address value AnyStreet 1 gt lt item name City value gt lt item name Country value USA gt lt item name Properties value lt item name Tel value 01 12345 67890 record 5 6 12 Option Encoding Since V2 0 0 the file encoding can be selected If the encoding of the source file differs from the selected encoding a automatic conversion is done nte conv eng pdf Page 30 of 45 NTE CONV User Manual V0 8 5 6 13 Option XML Stylesheet Handling Since V2 0 0 NTE CONV supports XSL embedding AML Stylesheet Handling C cpp nte_conv example example e 5 6 14 The XML Validation Options After the W3C Organisation has presented the DTD successor XSD XML Schema Definition it was to foresee that XSD would suppress the DTD s in a short time decided to have a close view on XSDL XML Schema Design Language and implement some of its propabilities Since V2 0 0 DTD support is also supported Who don t cares about XML validation should go ahead at chapter 5 7 5 6 14 1 Option None standalone Default These option takes care of that no information about XSD files is written i
Download Pdf Manuals
Related Search