Hello Michael and Brian, Interesting discussion. I am somewhat lost in the definition of XML. Is that the same as HTM or HTML? It suggests it's some kind of a mark-up language, but how does it differ from HTML?
Brian, keep this up and you'll replace Ralph as the DP guru!! :) Regards to all, Tony -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Hancock Sent: Wednesday, March 05, 2008 2:27 AM To: Dataperfect Users Discussion Group Subject: Re: [Dataperf] Code Page Hi Michael, The command "CHCP 437" will set the code page, but I am not sure that that will have any effect on the problem of your record delimiter and memo fields. Whenever I export data I use either WP format or XML. generally text file exports produce the sort of problems you refer to. Mind you I think Export data out in XML... and use a CDATA section for the memo fields. Yuio will need to create a Schema (actually the easiest way is to create the target tables in Access and then export a couple of records as XML, and use that nd the schema as a template for bringing data from DP. Creating XML in DP is a piece of cake. Another way of exporting the data so that you avoid the problem of embedded lines feeds is to create a report to do the export, and to format memo fields with the Print Mode Indicator of ;;Q... so you format for the output memo field might look something like A0A0;;Q The ;;Q converts embedded CR or CRLF to \n so the text The quick brown fox CRLF jumps over the laxy dog becomes The quick brown fox\njumpsover the lazy dog" which overcomes the record delimter problems. (Note that embedded "\"s become "\\") Once you get the data into Access it is relatively simple to search and replace \n to be a CRLF and \\ to be a \ Regards Brian ----- Original Message ----- From: Michael Iannantuoni To: Dataperfect Users Discussion Group Sent: Wednesday, March 05, 2008 6:36 PM Subject: Re: [Dataperf] Code Page Hi Brian, Thanks for the info about CHCP but I'm not sure what I need to set it to. It currently shows 850. The problem I had was exporting data from a very simple DataPerfect application to experiment with in Access. I use a delimited file export using | for field delimiter and ~ for record delimiter only to find that Access doesn't allow a record delimiter other that a HRt (!!!!! so much for memo fields in Access!!!) and that within the Windows environment, my | had changed to a Y with an acute accent. I seem to recall using Code Page 437 in the past so might experiment a little. Regards, Michael Brian Hancock wrote: Hi Michael, Although I have never had to change a code page from the default 457 on oz version of Windows , you can do it from the command window before running DP, eiher inteactively or in a batch file, or by setting it in the autoexec file for the MS-DOS shortcut. The utility to change Code page is CHCP, which if executed without a parameter returns the code page or if executed CHCP xxx set the code page to the parameter. When you set up a Shortcut to an MS-DOS program, within its Properties, from the Advanced Button on the Program tab, you can set the Config.sys and Autoexec.bat files. By default on WINNT and derivatives it will use two default files CONFIG.NT and AUTOEXEC.NT located in the Windows\System32 folder. You can either edit the Autoexec.NT file directly or if you only want to change the codepage (or other setting) for that instance you can specify a different autoexec which you have added the necessary CHCP xxx setting. Probably easiest is it to copy the original AUTOEXEC.NT edit the copy and seting the properties in the shortcut to use it instead. Regards Brian ----- Original Message ----- From: Michael Iannantuoni To: Dataperfect Mailing List Sent: Tuesday, March 04, 2008 8:11 PM Subject: [Dataperf] Code Page Can someone remind me where I set the Code Page for DataPerfect on a Windows XP system please. Thanks, Michael ------------------------------------------------------------------------ _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf -------------------------------------------------------------------------- _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf ---------------------------------------------------------------------------- _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.21.4/1310 - Release Date: 3/4/2008 8:35 AM
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
