Walter, The export file will sort the data field order based on the index you used when you export the data. The default setting is index 1.
The field number is automatically assigned by dp in the order when the field was initially created when designing the panel. When you view the .ste file, the field order displayed is the edit order, so if the edit order was changed after create, the fields will not be in sequential order when viewing the .ste file. When you exported the panel's data even selecting "all real fields", certain fields will not be exported. Calculated fields "::C" will not be exported and panel links (previously called "DOORS") are not exported but the panel assigns it a field number when created. So you may have a field count of 56 in the panel but DP sees only 34 fields as true data fields. You can export calculated fields as data fields by choosing "all display fields" but if you have hidden fields you want to include in the export, you should unhide them so they can be displayed fields and be included in the export. To double check the fields and the order of the data exported, I usually view the exported data file in wordpad or dos edit. Good luck. Ed. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter Hissink Sent: Sunday, August 05, 2007 7:46 AM To: [email protected] Subject: [Dataperf] Inconsistency between data export and .STE file I'm trying to convert a dataperfect application to MSSQL, but am encountering difficulties. First I do an export of a certain panel. Then I want to map the fields that are exported (through the built-in short reports to a DOS Delimited Text file, I exported all "Real" fields, so including the hidden ones) with help of the .STE file I made with Dpexp. But the order of the exported data isn't the same as the .STE file suggests. For example the first field in the export is suggested to be FIELD: 3 in the export file. Also the exported data has 34 fields, and the count in the .STE file goes up to 56 or something ?! If I have a DOS Delimited Text file, how can I determine which field is which with help of the .STE file ? Thanks for the help. Sincerely, Walter Hissink _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
