Color not replaced about scribusgenerator HOT 7 CLOSED

hello and thanks for the feedback.

I see the name of your dynamic color %VAR_color1% has a small case "c" in the SLA template, instead of the capital "C" used in the data and text frame... that may be part of the issue.

from scribusgenerator.

besides the above problem I did spot an issue with your data (CSV) file :

It seems to have been created/encoded in some way that did lead ScribusGenerator to break the reading/parsing of that data, prepending a \ufeff byte before the header line.

I'm looking into it now... but just so I can understand: how did you create this CSV file please ? (what software+OS+settings if any) ?

FYI (and my personal notes) the header of data file has been parsed into %VAR_\ufeffNumber;Bibnumber;Class;Col1% ... and that definitely will not work. likely related to BOM UTF-8/UTF-16: https://stackoverflow.com/questions/17912307/u-ufeff-in-python-string

from scribusgenerator.

indeed once both the (minorcase) name and CSV format issue are fixed the script works:
I create my CSV by using either LibreOffice, OpenOffice or GoogleDocsSheets, that all have native working export to CSV... contrary to MS Excel.

so I'm really interested in knowing how you created that CSV file... please
Colorbug_fixed.csv
Colorbug_fixed.sla.txt
;)

from scribusgenerator.

Turns out this encoding byte is not leading to any error, so I will disregard it unless you come back with contradictory information.

To get your original CSV data to work (after fixing color name) you just need to make sure to mention the proper "semicolon" separator character, instead of the default "comma":

have fun, and don't hesitate to share your work in the gallery : https://github.com/berteh/ScribusGenerator/wiki#gallery-of-examples--some-templates

from scribusgenerator.

Thanks for your quick response!

I used Excel (latest version I think) on Windows 11, with Swedish settings. The original csv file included some Swedish characters (å and ö), which I replaced in case that was the cause (Blue was Blå, and Green was Grön).

from scribusgenerator.

I got it working by just changing %VAR_color1% to %VAR_Color1%.

Sorry to take up your time with a typo. I am very thankful for your quick and friendly help!

from scribusgenerator.

great. by the way: sweedish characters should work without problems. I tested it in data and template at least... not in variables names yet, but it should be ok.

from scribusgenerator.