Please help us help you and fill where relevant:
LimeSurvey version: [6.8]
Own server or LimeSurvey Cloud:Cloud
Survey theme/template:
==================
Hello Team,

You are doing well

I had some external data i would like import these data in the server and then retrieved that data from data file and show in the survey on basis of id

Is it possible to do that

Common, Raj, you are here for a while now. This is answered at least on a weekly basis. A quick search in the forum should bring up several posts with solutions.

But anyway, here a few hints how you could approach this:

1. Given that you say you want to upload this data to the server, I think your best bet is a token based (closed) survey. Limesurvey gives you the possibility to create custom attributes in the token/participant table, besides the standard ones (like name, email, etc). So you can create specific custom attributes and then upload the data via CSV into the token table.

Then you can referrence the data from these custom attribute fields from within the survey, by using something like {TOKEN:ATTRIBUTE_1} for example.

Some more information here (ignore the part of INSERTANS, it might still work, but I wouldn't use it anymore, in your case it is also competely irrelevant, you should look at the TOKEN part).

Also have a look here about survey participants:
www.limesurvey.org/manual/Survey_participants

And specifically here:
www.limesurvey.org/manual/Survey_participants#Manage_attributes

Thanks for your response

It's i open accessed mode survey with some specific data like Name ,Gender,Age like etc will retrive from external file and show in the data table

is it possible with lime survey

Well, if it is an open access mode survey, how will you connect name, gender, age, etc. with the respective respondent?

You will need to give us a little bit more information here.

I had some external data i would like import these data in the server and then retrieved that data from data file and show in the survey on basis of id

My first question is answered now. Open or closed: Closed.

Now to your "external data". What kind?
Flat file? csv, json, ...,  or what?
Database?

"Based on id". Which id? Does the respondent enter an id? Or what do you imagine?

As @holch: Please, more information.

Joffm

In the meantime you may read this and study this library
[url] forums.limesurvey.org/forum/can-i-do-thi...insert-text-from-csv [/url]

It's a opened survey and external data is csv file format and in that file a unique id present in it, when respondent enter that unique in the survey then that id related answer will be pre filled in the respectively ,data may be pre filed into Multiple short text question or may any individual type question

Solution : Replace token by ID and use TOKEN:ATTRIBUTE_X for default value.

BUT : if with only one ID you can get all user information : i hope this ID are really complex !! More than 15 characters, not only numeric.

We really need more information here !

Hi,
you are always a bit vague.

As I couild imagine a scenario to do this:

• The respondent enters an id.
• There may be some matching data in the csv file or not.
• If there are data you display them and the respondent may change them (e.g. if he changed his address)
• If not you display empty fields.

This you can do with the library "Papaparse" that I showed already.
With a file like this
 
you get
 

or
 
 

And now you can preset each question type by an equation with the these results.
Or do ALL respondents have matching data in the file?
In this case you ought to run a closed survey with the Id as token and the data as additional attributes.
Which is much more straightforwaed.


 

Hi,

I had tried the same seems i may missed some step so that i can get the result please can you on it

Also attached the lss and csv file for the same

Hi,
you didn't follow the instructions in the shown link.
There you saw
 
But in your lss you did not load the library.

Second: I would avoid apostrophs, just "RespondentName"

 

Joffm

I saw that your file is ANSI coded, but the script is utf-8. You should adapt this.

 

Thanks Joffm for your guidance

it's strange behaviours I had follow your step but i could not succussed for pulling data either i may missed somethings so that i can not retrieve the data

I am using lime survey could version 

Again i attached the same please look into this

Question:
"/lime6/upload/surveys/629548/files/test2.csv"
Is this your correct path?
I really doubt.

An easy way to find out your path is to use the wizard to insert an image.
Then you will see something like this in your question text And you see your path to the image; if you uploaded to "files", you have to change this.

Joffm