CSV export issue

Thu Sep 17 04:53:20 BST 2020

Right after sending this I had the idea to check the XML file in
tellico's .tc file.  Maybe there are differences there that don't show
up when rendered in the application.

Unfortunately, that didn't seem to help much.  Here's the description
line for the Bonk 3 (the working one):

<description>Bonk's Big Adventure is the third instalment
in the side-scrolling platformer series. As in previous games, the
player assumes the role of a caveman named Bonk who headbutts his way
through various enemies in order to defeat King Drool. Familiar moves
include swinging on trees, bouncing off walls, breaking blocks and
climbing walls with his teeth. Compared to the previous games, he walks
and moves a little faster. Bonk has the new ability to
pick up red and blue candy power-ups that make him grow or shrink and
grab a flower copter. As always, there is plenty of platforming and
enemies to discover. The game consists of seven rounds, set in the
Dinosaur Kingdom, finished off with a boss. At the end of each stage, 16
smileys can be exchanged to play up to eight different bonus stages (2
smileys per stage needed). New level elements include ziplines and sewer
pipes. The game also features a cooperative multiplayer mode.</description>

Note the " " line breaks separating the paragraph.

Now for Bonk's Adventure (the broken one):

<description>Bonk's Adventure is a prehistoric platform
game where you are in control of a large bald headed caveman, guiding
him through the levels taking out all manner of strange prehistoric
creatures that get in your way including King Drools henchmen - all in
effort to free the captured/controlled residents of Moonland (bosses) -
including the Princess Za from King Drool attempted take
over. The game is not unlike other platform games of the
era. Though it's unique in that you can climb walls and swing on rope
with your teeth and your only method of attack is head butting enemies -
straight forward or dive bomb style. The game starts off with simplistic
point A to point B style, but focuses more on exploration in the later
stages, which include finding hidden bonus
areas. <SNIP></description>

Note that this is also separated by " ".

I'm at a loss here.

-- 
Jared

On 9/16/20 10:48 PM, Jared wrote:
> Hello.
>
> I've noticed an odd behavior with the CSV export functionality.  When
> exporting games with a multi-line description, the descriptions are
> *sometimes* split across multiple lines of the CSV file instead of
> being contained in a single field.
>
> Pardon the large amounts of text to follow, but I'm not sure how else
> to illustrate.
>
> As an example for Bonk 3, here's the description as shown in tellico:
>
> -----
>
> <i>Bonk's Big Adventure</i> is the third instalment in the
> side-scrolling platformer series. As in previous games, the player
> assumes the role of a caveman named Bonk who headbutts his way through
> various enemies in order to defeat King Drool. Familiar moves include
> swinging on trees, bouncing off walls, breaking blocks and climbing
> walls with his teeth. Compared to the previous games, he walks and
> moves a little faster.
>
> Bonk has the new ability to pick up red and blue candy power-ups that
> make him grow or shrink and grab a flower copter. As always, there is
> plenty of platforming and enemies to discover. The game consists of
> seven rounds, set in the Dinosaur Kingdom, finished off with a boss.
> At the end of each stage, 16 smileys can be exchanged to play up to
> eight different bonus stages (2 smileys per stage needed). New level
> elements include ziplines and sewer pipes. The game also features a
> cooperative multiplayer mode.
>
> -----
>
> When exported to CSV, the newlines are converted to <br/> and it's
> properly stored in a single field:
>
> -----
>
> Bonk 3: Bonk's Big Adventure|TurboGrafx-16|1993||A.I Co.,
> Ltd.|https://www.mobygames.com/game/turbo-grafx/bonk-3-bonks-big-adventure|Turbo
> Technologies, Inc.||Action; Arcade; Side View; Platform; 2D
> Scrolling|Never Owned|Not
> Started||Cartridge||1101168b25a6d1a378654d57babd0e9c.jpeg|<i>Bonk's
> Big Adventure</i> is the third instalment in the side-scrolling
> platformer series. As in previous games, the player assumes the role
> of a caveman named Bonk who headbutts his way through various enemies
> in order to defeat King Drool. Familiar moves include swinging on
> trees, bouncing off walls, breaking blocks and climbing walls with his
> teeth. Compared to the previous games, he walks and moves a little
> faster.<br/><br/>Bonk has the new ability to pick up red and blue
> candy power-ups that make him grow or shrink and grab a flower copter.
> As always, there is plenty of platforming and enemies to discover. The
> game consists of seven rounds, set in the Dinosaur Kingdom, finished
> off with a boss. At the end of each stage, 16 smileys can be exchanged
> to play up to eight different bonus stages (2 smileys per stage
> needed). New level elements include ziplines and sewer pipes. The game
> also features a cooperative multiplayer
> mode.|265|2020-01-31|2020-02-01 -----
>
> For Bonk's Adventure, however, we have the following description shown
> in Tellico:
>
> -----
>
> <i>Bonk's Adventure</i> is a prehistoric platform game where you are
> in control of a large bald headed caveman, guiding him through the
> levels taking out all manner of strange prehistoric creatures that get
> in your way including King Drools henchmen - all in effort to free the
> captured/controlled residents of Moonland (bosses) - including the
> Princess Za from King Drool attempted take over.
>
> The game is not unlike other platform games of the era. Though it's
> unique in that you can climb walls and swing on rope with your teeth
> and your only method of attack is head butting enemies - straight
> forward or dive bomb style. The game starts off with simplistic point
> A to point B style, but focuses more on exploration in the later
> stages, which include finding hidden bonus areas.
>
> <SNIP>
>
> -----
>
> And here's how it's exported presented in the CSV export:
>
> -----
>
> Bonk's Adventure|TurboGrafx-16|1989||Red Company Corporation; Atlus
> Co., Ltd.|http://www.mobygames.com/game/bonks-adventure|Hudson Soft
> Company, Ltd.||Action; Arcade; Side View; Platform; 2D Scrolling;
> Prehistoric|Never Owned|Not
> Started||Cartridge||c84f5000f3b65f35d895c6d08925aa2c.jpeg|"<i>Bonk's
> Adventure</i> is a prehistoric platform game where you are in control
> of a large bald headed caveman, guiding him through the levels taking
> out all manner of strange prehistoric creatures that get in your way
> including King Drools henchmen - all in effort to free the
> captured/controlled residents of Moonland (bosses) - including the
> Princess Za from King Drool attempted take over. The game is not
> unlike other platform games of the era. Though it's unique in that you
> can climb walls and swing on rope with your teeth and your only method
> of attack is head butting enemies - straight forward or dive bomb
> style. The game starts off with simplistic point A to point B style,
> but focuses more on exploration in the later stages, which include
> finding hidden bonus areas.
>
> <snip>
>
> -----
>
> Splitting the contents of a single record across multiple fields like
> that breaks importing and working with that CSV data in other
> applications.
>
> I have 2400 games total. I'm not sure how many include multiple
> paragraphs in the description, but it's a significant number. However,
> only a relative few are output in this format. I can't figure out what
> they have in common.
>
> Any ideas what's causing this?
>
> -- 
>
> Jared
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/tellico-users/attachments/20200916/67eec7e7/attachment-0001.htm>