Download Breezing Forms User Manual
Transcript
Users Guide Crosstec/Breezing Forms 4. Using Breezingforms 4.1. Managing Records Here on the manage forms page is where you come to see all of the forms submitted to the database. From here you can view, export and even check payment and download times of a form. PDF, CSV and XML Buttons: Allows you to create files of the selected records All Form, Viewed, exported and Achieved Buttons : Allow you to switch the view of the records to the corresponding button to see if the items were used or not for the selected buttons. 4.1.1. Manage Errors/Issues You May Receive CSV Exports Aren't Opening Correctly I am trying to export records from within BreezingForms to Excel in CSV format, but when the file opens, the columns aren't formatted correctly. How can I fix it? If you are using Excel 2003, you should use the semicolon ( ; ) as the separator. If you are using 2007, you should use the comma ( , ) as a separator. During the export, instead of opening the file in Excel immediately, choose the option to save it instead. Once saved, go to the file directory where you stored it and rename the file from FILENAME.csv to FILENAME.txt. Then open the TXT file in Excel. When you try to open it, you should see a Text Import Wizard dialog box. The fields should be completed as follows: Choose the file type: DELIMITED (not Fixed Width) Start Import at Row 1 Click NEXT Delimiter should be ; or , depending on which you entered in the configuration Text qualifier should be " unless you have changed it Click NEXT You can choose format for each column if you'd like to use it, then click FINISH. Your data should now open in column form. 31