How to use Plugin Fornatter CSV (Export)

What is your URL you want to export?

Sergey What is your URL you want to export? Hi, this is the Url. http://justloginindia.in/ i want to export this data to Excell/CSV format how to do it using formatter?

Can you please tell me?

Hello, make sure you have enabled/published the CSV formatter plugin.
Your Cobalt section list URL should be visible in your menuItem parameter... Or copy it from your frontend link, if you have disabled SEF URLs.

Usually the cobalt none-SEF URL looks like this (including my example placeholder ID and menuItem ID) index.php?option=com_cobalt&view=records&section_id=99:your-section-title&Itemid=999

If you append the formatter it looks like this:
index.php?option=com_cobalt&view=records&section_id=99:your-section-title&Itemid=999&formatter=csv

That link could be used anywhere...:
You might create a manual link inside the Section description textarea.
You might create it inside a custom-HTML module and template position.
You might even create a J! menuitem of type System Link -> URL (little headsup: Joomla does not allow : in the link input field. You might have to change that "separator" in Cobalt's global config)

If you want to use a SEF URL link directly... remember to exchange the & with ?
index.php/your-section-name/items/99-your-section-title?formatter=csv

Hope this helps.

Hi, Thanks.

This is my weebsite http://justloginindia.in/

I am using Default record list template. and CSV formatter plugin is enabled.

1. I am showing the Record List on home page. you can see the records there but it has not generated the link like 'index.php?option=com_cobalt&view=records&section_id=99:your-section-title&Itemid=999' as you mentioned?

2. if switch to Record List template to Blog then on front end it link to Titles, When i click on title i.e. go to full view it shows me the link 'index.php?option=com_cobalt&view=records&section_id=99:your-section-title&Itemid=999' as you mentioned. on this i used &formatter=csv and press enter. I recieved the message "No CSV for Article view." please see the video. https://drive.google.com/open?id=1dV7UCWBrVW_1TCvz8EhWnAEtBG5l-jxk

3. What i want is complete list of record in CSV/excell sheet?

thank you

If you mean your homepage http://justloginindia.in/ , then you can use URL http://justloginindia.in/?formatter=csv& ;limit=1000. But enealbe CSV plugin.

Hi, thanks for your quick reply.

The plugin is Enabled.

I tried what you said but nothing happens. hust page refreshed and nothing happen. you can try on that

illusioninfotech you can try on that

I did.

What is section ID of that homepage?

this likn works

Hi, thanks

1. The link you gave me works but why my domain not showing like "index.php/component/cobalt/items/1-no-title-1526898294?Itemid=101" link like this. it there any option i disabled.
2. I thought CSV format means in excell sheet, but its displaying the data there itself. its very difficult to put that data in Excell.
3. is there any way i get the section item data in Excell sheet. Please, its very important for me to do this.

illusioninfotech Hi, thanks

1. The link you gave me works but why my domain not showing like "index.php/component/cobalt/items/1-no-title-1526898294?Itemid=101" link like this. it there any option i disabled.
2. I thought CSV format means in excell sheet, but its displaying the data there itself. its very difficult to put that data in Excell.
3. is there any way i get the section item data in Excell sheet. Please, its very important for me to do this.

Hi is there any chance of happening this?

Just save that data as .csv file extension and open with Excell.

Sergey Just save that data as .csv file extension and open with Excell.

BTW, is there any way to "force" the download of the file?
Currently it seem to open in a new browser window (at least in Safari).

Sergey Just save that data as .csv file extension and open with Excell.

Save the data as .csv file means 1. copy the data from Browser itself by Ctrl+v and paste in excel? becuase i tried that way, but whole copies in a single column and as per the columns in the forms? 2. or Save the browser page? to .csv?

illusioninfotech or Save the browser page? to .csv?

Terms might depend on the browser, but you can "right-click" the link and choose "save linked file as...".

Or you can choose "save as..." in browser file menu. Choose "as page source...". For instance, SAFARI does offer 2 formats. Web-Archive or page source. The latter is saved as .txt file.

Both should result in a .txt file.
You can rename it to .csv, but you don't have to.

I've added to CSV formatter parameter to force to download it and open in Excel.