Exporting to google spreadsheet

Start
Prev
1
Next
End

1

SimonAL
Topic Author
Offline
New Member

More

8 years 7 months ago #1470 by SimonAL

Exporting to google spreadsheet was created by SimonAL

Hi,

Using 2.6.5 f5

When Exporting data to Google SS i relized that some Terms were mixed up and corrupted.
I had a lot of groups, some of them were: Building, BuildingUI, BuildingUpgrades...

The terms in them were:
Building/Something
BuildingUI/SomethingElse
BuildingUpgrade/SomethingReallyDifferent

In the spredsheet i got terms like:
Something
I/SomethingElse
pgrade/SomethingReallyDifferent

Easy to see now but hard to spot them between 2000 terms

After some debugging I found out that you check the terms assigned to a group like this (LanguageSource_Export_CSV.cs):

if (string.IsNullOrEmpty(Category) || (Category==EmptyCategory && termData.Term.IndexOfAny(CategorySeparators)<0))
        Term = termData.Term;
else
	if (termData.Term.StartsWith(Category) && Category!=termData.Term)
		Term = termData.Term.Substring(Category.Length+1);
else
	continue;	// Term doesn't belong to this category

By using this check: if (termData.Term.StartsWith(Category) && Category!=termData.Term)
a mess happens because some groups starts with the same string... and we can see where the bug comes from...

I changed the script to: if (termData.Term.StartsWith(Category + @"/") && Category!=termData.Term)
and it works ok for now but I think this should be solved internally