x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 74 subscribers
  • Views 398 views
  • Users 0 members are here
Browse Forums
Announcements
106
topics
32
replies
General Discussion
6k
topics
18k
replies
Paul Daly

Import values to Selection List

Posted By

Hi All

Sorry another quick question -

If you setup a new field (type - selection) and
If you have a large number of values - is it possible to import these values into the Selection Lookup?

Thanks again,

Paul

  • 0
    Hi Paul,
    You can add values in selection list in following possible ways,
    1.Entering list values manually in lookup.
    In this you can enter list item values one by one in the lookup when we create a selection field.
    2.You can use SQL queries to enter the selection list items.To do this follow the steps given below:
    a. Get table Id of ‘Custom_Captions’ table from ‘Custom_Tables’ table.
    b. Select nextid value from ‘SQL_identity’ table by providing table id of step #a. Suppose this value is 10 then you can enter records from 10,11.. to desired number as mentioned in next step.
    c. Insert a new record in ‘Custom_Captions’ table with proper values and ‘capt_captionid’ field value with the value of step #b.
    d. Update ‘nextid’ value in ‘SQL_identity’ table against the table id returned in step #a. Suppose you entered records up to 15 then update this record with number 16.
    e. This will add selection list items to your selection field.
    3.You can implement your own custom import routine which will import all the values to the database.
    For this you need to prepare an excel sheet which will contain the columns as required in ‘Custom_captions’ table. Enter values in this excel sheet.Then create a js file which will contain the code to read excel sheet and enter values to Custom_Captions table.
    Hope this helps!
    Regards,
    Dinesh

*Community Hub is the new name for Sage City