̽»¨¾«Ñ¡

HowÌýData Loader works

Data Loader automatically collects all answers from a nettskjema and creates a new, updated file with the responses. You will thus get an updated raw file in three different formats, i.e., an .xlxs, .csv and a .sav fileÌýevery hour. TheseÌýfiles areÌýstored in the project's storage area, sorted per nettskjema, with complete data sets exactly as they were filled into the forms.Ìý

Data Loader delivers the responses exactly as they are, without modifications. Further processing and analysis must be done with suitable software.

´¡³Ü³Ù´Ç³¾²¹³Ù¾±³¦Ìý³Ü±è»å²¹³Ù±ð²õ

Most projects are updated every hour. It might therefore take up to one hour before the results from a nettskjema are uploaded.

How to open the files

You will find theÌýfiles inÌýdata\durable\csvfiles,Ìýthree files for each nettskjema (.csv, .sav, .xlsx). The form ID is located in the file name with the prefixÌý¾±²Ô³Ù±ð°ù²Ô²¹±ô,Ìýfor instanceÌýinternal_69659.csv,Ìýinternal_69659.sav andÌýinternal_69659.xlsx

Data Loader also stores hidden directories in theÌý»å³Ü°ù²¹²ú±ô±ðÌýfolder: .decrypted, .handled andÌý.failed. Do not change these.

About the files:

• The files in theÌýcsvfiles folderÌýare updated as long as new responses are coming in from Nettskjema.ÌýThey are overwritten (updated with new responses)Ìýevery hour and should not be edited or moved.Ìý
• Since these files contain research data they must be stored in the same place throughout the project. Do not edit or move these files.Ìý
• TheÌýfiles can safely be copied to another directory for processing and analysis.Ìý
• The file format isÌýcoded with UTF-8. When importing into analysis software, use comma as delimiter and UTF-8 as encoding.

Upload data to STATA

1. Open STATA.
2. SelectÌýÌýFile >ÌýImport >ÌýText Data > delimited * >.csv
3. SelectÌýBrowse and locate the .csv file.
4. Select UTF–8 as text encoding. The rest of the preferences can be left untouched.Ìý
5. ClickÌýOK.

The data are now imported into STATA. You will find theÌýSTATA editorÌýunderÌýBrowse in the menu.

If you want to save the import command, right click itÌýunderÌýReview paneÌýand selectÌýSend selected to Do-file Editor.Ìý

Save theÌý.do fileÌýin the durable folder or in your workspace. The next time you want to import into STATA, right click theÌý.do fileÌýand selectÌýExecute (do). New responsesÌýfrom Nettskjema will be shown as new lines in the file.

Data Loader reports

Data Loader generates a report summarizing all data handled. You will find this in the durable folder as a text file you can open with Wordpad or Notepad.Ìý

The report shows how many nettskjemas that have been decrypted or processed and how many answers have been collected.Ìý0 failed/ 0 unanncounted signals that all data have been processed and the system works properly. In the report you will find all responsesÌýcollected up to the previous day.Ìý

Codebook and variables

• Forms belonging to the project must be coded with Nettskjema's codebook. This ensures an optimal workflow and correct import intoÌýSPSS, STATA, Excel andÌýR.Ìý
• You should name your own variables and avoid the automatic naming available in Nettskjema.Ìý
• A form might contain a maximum of 999 variables. The maximum number of questions is therefore 999.Ìý
• Variable names can contain a maximum of 60 characters. The first character must be a letter, you can then mix characters and numbers. The names must be unique within one form.Ìý
• Variable names can't be one of the reserved words inÌýSPSS:Ìý ALL, AND, BY, EQ, GE, GT, LE, LT, NE, NOT, OR, TO, or WITH.Ìý
  
• Variable names in the codebook can't contain these characters:Ìý

‘æ’, ’ø’, ’å’, ’;’, ’?’, ‘(’, ‘)’, ‘!’, ‘@’, ‘#’, ‘$’, ‘%’, ‘^’, 
‘*’, ‘+’, ‘=’, ‘[‘, ’]’, ‘<’, ‘>’, ‘~’, ‘`’, ‘|’, ‘-’, ‘.’, ‘:’

Start using Data Loader

Data Loader is a free supplement in TSD, as long as the demands above has been met. An admin in the TSD project can ask for activation of Dataloader and/or Filedecryptor by contacting TSD support. There must be at least one response registered in the project before Data Loader can be installed.

For projects that need advanced processing of Nettskjema responses we offer relational databases. A startup fee and a yearly fee are required. Contact us to discuss this solution.

See the TSD price list.

Contact TSD support.

Ìý