- #Openoffice base import data how to
- #Openoffice base import data serial number
- #Openoffice base import data update
#Openoffice base import data update
When importing data, key fields are helpful because when a form has one or more key fields you can easily update multiple existing records just by using the answer given to these fields.
#Openoffice base import data serial number
Serial Number fields in the data entry formĪ Key field can be used to uniquely identify a record. Tip: If the form uses a Serial Number field then this is the key of the form, you can recognize a Serial Number field by the grayed out ‘(Pending)’ text in the data entry form. If you don’t plan to update records that have been already added to ActivityInfo using your imported data, you can skip this step. One or more fields can be defined as ‘Key(s)’ during the form design phase so you can always ask the colleague who designed the form to point you to the Key field(s) used in the form. Understanding what Key fields are in ActivityInfo can unlock a lot of possibilities both in form design and data importing. For closed-ended questions, such as multiple and single selection fields or lists of answers coming from reference fields, you need to note down the exact names of the available answers as these need to be typed in the spreadsheet in exactly the same way.įinding the available answers in the data entry form in closed-ended questions This is very helpful for the spreadsheet preparation phase. Take a look at every field and note mentally, in a piece of paper or in a spreadsheet what kind of answer each field requires whether it is a required field and whether the answer required is open-ended or closed-ended. Whether it is you who designed the form or you are responsible for importing the data into that form, the first thing that you need to do is to navigate to the data entry form and take a close look at it. Each answer submitted to this form is called a record in ActivityInfo. This is the form that includes all the questions for which you need answers and it can be as long, short, simple or intricate, as you need. To collect data in ActivityInfo you need to design (or import) a data collection form. Step 1: A close look at the data collection form Then, if needed we will correct pending issues to ensure the data is imported correctly. a spreadsheet app (ActivityInfo supports the formats found in Excel, Open office, Libreoffice and Numbers)Īfter preparing the data in the spreadsheet app, we will use the ActivityInfo data importer to add them to the data collection form.to be invited to the form for which you need to do the importing with the respective permissions.This guide provides you with more examples and tips and can be read in combination with the User Manual.
#Openoffice base import data how to
Please note that in our User Manual you can find step-by-step instructions and videos on how to import records to forms and subforms. With this guide we want to share various tips and tricks to work fast and efficiently when importing your data. No matter what your case is, you can always import large lists of indicators and other data to ActivityInfo and work with complete datasets using the importer in the platform. Another interesting possibility that the ActivityInfo importer offers is that it can help you bring structure to your data and ensure that you have harmonized, validated records in place of messy spreadsheet files. In some cases, you might be collecting one-time data from partners or actors who are not ActivityInfo users and thus don’t have access to the system. For example, you might have a lot of data residing in files outside ActivityInfo which you need to add to the system to create a more comprehensive view of a programme. There are many cases when you might want to import data in ActivityInfo instead of manually fill in a data collection form. Another importing option you have in ActivityInfo is to import your existing data to the platform. In the past, we discussed how you can import your questionnaires into ActivityInfo. A complete guide to data importing in ActivityInfo
0 kommentar(er)
