Export data

[Lassel]

Hi
I recently installece Sugarcrm CE 6.0.
Now I am trying to export my contacts data. According to instruction there should be a export button on the Contacts home page.
I cant find anyone,, only a import button,

Is thera something I do wrong?

//lasse

[avadtechnologies]

Above your list of contacts, to the left of where it counts how many records you have selected is an "actions" button. Click on that button and export should be the last option. It is cumbersome and counter intuitive in my opinion but it is there.

The actions button is also located at the bottom of your list, in the same spot.

[Lassel]

Above your list of contacts, to the left of where it counts how many records you have selected is an "actions" button. Click on that button and export should be the last option. It is cumbersome and counter intuitive in my opinion but it is there.

The actions button is also located at the bottom of your list, in the same spot.

Tanks ,, found it.
I exported contacts to a csv file, that I imported to excel. It worked fine *smile*

The I exported calls and meetings. Importing the same way as contacts... resulted in a "mess",,, data was scrambled in excel,,, the "id" column sometimes contained regular text,, like descriptions and so on.....

Can this be a bug?

//lasse

[Lassel]

Is there no one that can verify that the export function, for calls, scrambles data????

//lasse

[Vens]

I have the same problem, while exporting, all the data is scrambled impossible to read like this with no disctinct columns:


0","c84010fb-22f4-d21c-2ae5-4b8334ac5e16","","Energy","","","","Générac","", "30510","France","","33466010111","0625990621","ht tp://www.homea.biz","","","","","","","","","","","5111 405f-e9ef-4971-8197-4b8357e480d7","vianney.froment@homea.biz","Homea", "Roy"

[davidboris]

Hello,

If you have your system List separator is set as semicolon ( ; ) and Sugar delimiter set to comma ( , ) you can change the delimiter for sugar from comma ( , ) to semicolon( ; ) through Admin > Locale Settings > Export Settings > Export Delimiter, set it to ( ; )

And then you can export and check the file in MS Excel with columns well separated.

[Vens]

Hi and thank for your help.

I did try what you proposed and I still get the same result...

My installation is standard, I did not install any extra modules

[davidboris]

Hello,

In what application you are trying to access the exported file?

[Vens]

just in the standard application: Sales - Accounts

[shailendra001]

Hi ,

After export , open your file in spreadsheet , separator options should be
separated by => comma or tab
Text delimiter => "

if i kept separated by option blank ( neither comma nor tab ) then i got the same format you ppl are reporting
Please find attached screen shot for better understanding

This may help
Regards
Shailendra