List Manager Forum

Load data from database tables

User moon_653 2012-08-11 15:28:00

Hello,

how can I load data from database tables into lists?

Best wishes,
Juergen

Moonsoft support 2012-08-11 18:11:38

Hello,
in order to load data you could.export your records to an excel file and save it with csv format. Then you could use csv import option at LM to load them all.
If you are looking to use a database table data as options to choose from at your list, then you can use option list field type, and then use sql option to write a valid query to the database. The two first fields of the result will be used as identifier and text for each option.
Hope this helps, regards

User moon_653 2012-08-11 19:31:03

Thanks for your fast response!

It would be nice to have the possibility to import the data directly (through sql statements) into a list.

Kind regards,
Juergen

Moonsoft support 2012-08-12 07:44:32

Hello,
yes, it could be an interesting feature. We've added it to the list of requests for next version of the extension.
Thank you, regards

...
Support/development 10 hours

Get a bigger amount of hours for more complex tasks and get a 10% discount

Buy now!
...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!