I've got a record set of around 700 entries and I want to be able to have them uploaded to Matrix as easily as possible and they must be searchable. CSV asset was my first choice but since they cannot be searched it makes things difficult and I'd like to avoid having 700+ individual assets with the metadata attached as this is going to be very hard to manage.
Has anyone tried something similar or have a setup that is what I'm looking for?
Cheers
I'd stick it in a db table and use a db data source asset. As far as I know there isn't a nice way of doing it all in matrix.
[quote]
I'd stick it in a db table and use a db data source asset. As far as I know there isn't a nice way of doing it all in matrix.
[/quote]
Thanks for the reply and I'm sure your're onto something, but I can't say I've ever worked with that functionality within the system. I'm a little lost with the manuals site - any help?
[quote]
Thanks for the reply and I'm sure your're onto something, but I can't say I've ever worked with that functionality within the system. I'm a little lost with the manuals site - any help?
[/quote]
http://manuals.matrix.squizsuite.net/data/chapters/db-data-source/
Basically, fill out the database detail (name, username, password etc) on the details screen, and put a SQL query in the Query Builder screen.
Hope that helps.
[quote]
http://manuals.matrix.squizsuite.net/data/chapters/db-data-source/
Basically, fill out the database detail (name, username, password etc) on the details screen, and put a SQL query in the Query Builder screen.
Hope that helps.
[/quote]
Thanks