Then you'll be able to get into the database and edit it. Password: (this should have been given to you by whomever is administering the database) User Name: (this should have been given to you by whomever is administering the database) Host Name: (type in the domain name of the server you're connecting to, for example ) On the toolbar, click the upper left hand button, the "New Database" button. Warning about editing other tables in the Databse Editor: If you start editing your survey itself in the database (most of the other tables, like "Questions", and "SurveyPages" hold the data for your questionnaire), make sure that the Survey Editor is NOT open and that you are not editing something in both places - you could have some unexpected results if you use both at the same time - the Survey Editor does not reload data from the database as you edit it. For the best way to import your data without risking corruption, see the sections below about SAS and JMP. They have several bugs (or "features") which often fail to import data correctly. If you are using SAS or JMP, you should import directly to them in the documentation in that section. You can use the Import and Export buttons to import and export data from the database. Be careful about editing tables that you're unfamiliar with - typically, the only tables you'll be interested in editing by hand are "Answers" and "Users", unless you've specifically set up other tables for your survey. In this database editor, you can see all of the tables in the database and edit it (if you have security permissions to do so). Go into the "View" menu and check "Show Database Editor". Then, click the "Export to file." button, and follow the wizard through.Īlternatively, you can export and edit one table at a time. In the survey manager, select your survey, and then click "Edit Survey", and wait for the survey manager to launch.
Warning about importing/exporting data with returns in them ("long answer" questions)
#Sas jmp show unhidden columns how to
SAS: If you're using SAS for data analysis, you probably want to import your data this way, and not through any other technique.īacking up the database: How to back up a MySQL database to a text file. JMP: If you're using JMP for data analysis, you probably want to import your data this way, and not through any other technique. To a JSP Survey: How to set up your web survey, or a new web survey, to access the database. To Microsoft Access from a DSN file:Someone may have sent you a Microsoft Access database and a file that ends in ".dsn" that won't work on your machine. To Microsoft Access:If you're familiar with Microsoft Access, you may prefer it, despite its problems. It's not a great UI - but if you are familiar with SQL, this is a good program. MySQLCC is a GUI interface to a MySQL database.
To a spreadsheet from the Survey Editor: This is the simplest way to export, from the Survey Editor GUI.įrom MySQLCC:How to edit, view, and export data if you're using MySQL. The best format to export into is a Microsoft Excel spreadsheet, if you can use it. If you just want to export the data and view it elsewhere, use the Survey Editor. Then, click on the link below for them to get directions on how to import the data directly. Here are some ways of doing that.įirst, decide what program you're trying to get the data into - if you can go directly from the survey database to this program, it avoids certain problems that may come up. It's often not very easy to get your data into a Statistics program from a database, or to edit the data and monitor it while it's in the database.