Гость
08 Апр 2014 07:40

Hi!

Just browsing JED and found Cobalt and I was wondering if this can help me with my problem.

I have a few DBs in CSV format with different data (Name, Value, Adress, Date, Type etc) about companies.

I'm looking for something that can help me show this data for each company (like a directory where all companies have a "profile") but to also mix the whole-data like:

  • to sum up all the values (ex: monthly sales) for all companies that exist in my db, based on their location (say one city) or activity or both
  • to actually run al sorts of SQL queries and display them in frontside of my website.

Thank you and I hope I made myself clear about my intention.

Best wishes!


Sergey
Total posts: 13,748
08 Апр 2014 08:38

You want import CSV or use those files as live data source?

Cobalt has CSV import but very basic. You have to check if you can import your files there. But if you can then you can run all sorts of SQL queries and get any information you need.

Download free version of Cobalt, setup your type and section and try to import. If you it is successful then you can do it. Company proile. Distand search of companies, etc...

But some of your task will require custom templates where you can run SQL queries.


Гость
08 Апр 2014 09:14

Ok.

Thanks.. I'll try and see what happens.

Best wishes

Работает на Cobalt