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