Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Hard to read and format Downloaded file from Campaign UI

Avatar

Avatar
Ignite 10
Level 4
asish_kumarp599
Level 4

Likes

37 likes

Total Posts

62 posts

Correct reply

8 solutions
Top badges earned
Ignite 10
Ignite 5
Ignite 3
Give Back 25
Give Back 10
View profile

Avatar
Ignite 10
Level 4
asish_kumarp599
Level 4

Likes

37 likes

Total Posts

62 posts

Correct reply

8 solutions
Top badges earned
Ignite 10
Ignite 5
Ignite 3
Give Back 25
Give Back 10
View profile
asish_kumarp599
Level 4

09-09-2020

When we download a file from campaign UI, it is downloaded to the local computer in a .txt file format. When we open the file it is very hard to read the data. Takes time to covert them to a csv file format to make it readable.

 

In windows machine after downloading the file & changing the extension to .csv, it opens the excel file with all the data in 1 column instead of separate columns for each header. 

 

We would like the enhancement to download the directly in .csv.

 

1 Comment

Avatar

Avatar
Give Back
Employee
tobiasdigital
Employee

Likes

0 likes

Total Posts

2 posts

Correct reply

1 solution
Top badges earned
Give Back
Establish
Affirm 1
View profile

Avatar
Give Back
Employee
tobiasdigital
Employee

Likes

0 likes

Total Posts

2 posts

Correct reply

1 solution
Top badges earned
Give Back
Establish
Affirm 1
View profile
tobiasdigital
Employee

10-09-2020

Hi Asish,

 

are you exporting the data through the "Extract file" activity? It has an "Output format" selection on the "File Structure" tab. Also you should provide a filename including the .csv extension. It will result in a file eg. "export_20200910_145954.csv" and it will contain the selected fields separated by comma (CSV = comma separated values).

 

When you double click  such file it is a client side (operating system level) setting which program automatically opens to read the file, eg. Excel. In Excel it again depends on your local settings if Excel is able to automatically split the CSV file into multiple columns. If you go to Windows Control Panel --> Regional Settings --> Date-, Time- and Number-settings --> Advanced you can change the list separator to a comma. This will enable Excel to distribute your CSV into multiple columns upon opening. 

 

Alternatively in Excel you can select the column containing all your fields and select Data --> Text to Column and it will guide you through a dialog where you can select the comma as separator. 

 

Does this help?

 

Cheers, Tobias