> There are a number of ways to dump the data. CTRL-F5 is used > to import data. > Shift F7 presents the reports menu. Te top report is always > the built in short report. By default if you use this report > then it will export data from the current panel to a file on > disk, generally defaulting to the name > scratch.rep by default it exports "real fields". Fields on > a panel can > either be real or calculated fields.
You are of course correct, I had meant to say Shift-F7. > If you are editing a panels definition you must remove all > records, the easiest way to do this is to use the "Built in > Short report" to export all the data to the scratch.rep file, > remove all the data in the panel with > Alt-F5 (be careful NOT to empty the database completely), > make the changes to the data structure, and then import back > the scratch.rep using the > Ctrl-F5 import. One thing you should be aware of, is that > when you export the data it uses the EDIT order of the panel > for the ordinal positions of each data field in the export > file. The Edit Order can be readily changed from the Panel > definition screen Alt-F5, Alt-F5, and the 5 to change the > edit order. Why is this so important? Because the import I'm afraid that's what I'm having trouble with at the moment. I've exported all my data into csv files and am looking to import them into a new database for analysis. Unfortunately, it's unclear in what order the fields have been exported, and it does not appear to match the numbered order I see if I hit Alt-F3 twice. Hitting Alt-F5 twice doesn't bring me anywhere except the Multiple Remove dialog. Do you have any suggestions as to what I may be doing wrong? > Personally moving data from DP to another application I would > do it as an XML file, as the file can be self describing, and > you can tranform it readily if it is not quite right. Many > other products can import the XML directly, you need to check > out the schema. and create the DP report to accurately > reflect that schema. With DP you can always export data > according to a particular schema but you are totally > responsible for it, DP just treats it as text, it itself does > not have any built in concept of XML. But this gives you a > maximum amount of freedom. For instance if you follow the > schema defitions for say an Microsoft Access Database, you > could create an XML report that would export all data from > the DP application, and using the one file, import it into > Access 2003, or 2007 even creating the table structures, > indexes for you. Similarly for SQL Server or MSDE, and most > other modern DBMS will allow you to import data. I'm intimately familiar with working with XML, so this option is potentially attractive. How do you create new reports in DP? Is it possible to iterate over subpanel data within each main panel? - donald _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
