logo

Live Production Software Forums


Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
xaver  
#1 Posted : Friday, December 1, 2017 2:46:43 PM(UTC)
xaver

Rank: Advanced Member

Groups: Registered
Joined: 11/11/2016(UTC)
Posts: 378
Man
Location: Europe

Thanks: 23 times
Was thanked: 38 time(s) in 32 post(s)
Hello
i'm wondering if I can set only text in a csv as a datasource for Ttile/XAML

-0,88 is shown as -0,88 (it's OK)
1,12 is shon as 112 (should be 1,12)
1,10 is shon as 110 (should be 1,10)
1.10 is shown as 1,1 (should be 1.10)

how can I manage, that "," is "," and "." is "." (comma is comma and dot is dot) in Numbers?


in the CSV I have
"-0,88","1,12","1,10","1.10"
also öäüÖÄÜé and so on are wrong after import of a csv datasource

Numbers should be in the tilte as they are in the csv

any suggetions?
doggy  
#2 Posted : Friday, December 1, 2017 3:17:26 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,223
Belgium
Location: Belgium

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
Quote:
also öäüÖÄÜé and so on are wrong after import of a csv datasource


file has to be saved with UTF-8 encoding

Quote:
in the CSV I have
"-0,88","1,12","1,10","1.10"


i don't think you are allowed the quotes

Quote:
1.10 is shown as 1,1 (should be 1.10)


is related to your language settings
xaver  
#3 Posted : Friday, December 1, 2017 4:06:39 PM(UTC)
xaver

Rank: Advanced Member

Groups: Registered
Joined: 11/11/2016(UTC)
Posts: 378
Man
Location: Europe

Thanks: 23 times
Was thanked: 38 time(s) in 32 post(s)
Hi

the very first time, I imported the datasource, it works with the äöü and so on

the I saved the CSV (original generated with notepad) with Excel and the umlauts are wrong

from this moment, I can save they as I want, no success

quotes are not the problem
same issue with and without quotes
and I need the quotes because the seperator "," is also in the text

language setting is set to german and it's not possible to change beause other programs will only work with this settings.

Is there any chance to import numbers as text (like excel does it)?


xaver  
#4 Posted : Friday, December 1, 2017 4:12:59 PM(UTC)
xaver

Rank: Advanced Member

Groups: Registered
Joined: 11/11/2016(UTC)
Posts: 378
Man
Location: Europe

Thanks: 23 times
Was thanked: 38 time(s) in 32 post(s)
New Question

I have one title for names. If the name (with space inside) is longer then the field, I get two lines
is there any way, to truncate the name (like it is done if there is no space in the source)
Cpilcher  
#5 Posted : Friday, December 1, 2017 4:42:33 PM(UTC)
Cpilcher

Rank: Advanced Member

Groups: Registered
Joined: 8/3/2015(UTC)
Posts: 323
Location: Chicago, IL

Thanks: 22 times
Was thanked: 57 time(s) in 47 post(s)
I don’t do much with Datasources in vMix. But Notepad has a history of breaking other document lists by adding its own formatting. Notepad++ is a great editor that will respect your original formatting.
Users browsing this topic
Guest (3)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.