Scribus Forums

Scribus => General Discussion => Topic started by: GnKnG on November 21, 2020, 09:44:29 PM

Title: How many fields is too many for a scribusgenerator .csv?
Post by: GnKnG on November 21, 2020, 09:44:29 PM
Well I was curious - will it fail at say 255 fields or at maybe 32kb row size perhaps ??? ...and to answer myself:

IDK- but quite a lot!!! :) > over 2000 fields with fairly verbose headers, and at least 32k per row ....

thus a well prepared mega-csv (where constructing the header becomes a non-trivial logistical text-challenge) can be used to pick and populate from large amounts of mixed data/content directly into graphically editable templates 'direct' from database-generated .csv- very nice job indeed Scribus + Generator team:) 

Title: Re: How many fields is too many for a scribusgenerator .csv?
Post by: dragonfly on November 21, 2020, 09:54:07 PM
I drew the same conclusion when first trying ScribusGenerator. It can be used in multiple levels of abstraction where the VAR table in csv can hold links to large text blocks held in backend database. Thus custom documents can be created "on the fly".  Can also link to GoogleSheets  through Python API.
There is another approach I tried. It is to use VAR notation to embed PHP snippets and the document (as XML with PHP clips embedded by ScribusGenerator) is then parsed in PHP server, to spit out XML>SLA file.
Title: Re: How many fields is too many for a scribusgenerator .csv?
Post by: GnKnG on November 21, 2020, 10:05:52 PM
 :D - good thinking - i have just been musing on a layered approach for text/image/caption heavy documents > maybe one script first sets out VARs for a second script ... or maybe a final single line (looooong row) from which final alterations can be pulled from > i expect performance to become pretty poor with images, but using small/medium text blocks  speed of .sla generation seems impressive.