Discussion Forum: Thread 347099

 Author: macebobo View Messages Posted By macebobo
 Posted: Sep 21, 2023 14:36
 Subject: Mass update does not keep escaped XML
 Viewed: 90 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

macebobo (3216)

Location:  USA, Oregon
Member Since Contact Type Status
Apr 3, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: MacsBricks
Has anyone else been able to do mass updates with Brickstore that contains html
formatting?

I can not seem to get it to work, it pastes fine, it updates fine but it does
not render properly.

If I do the same syntax manually, it works fine, just not via mass update.

see image for example html (now included!)
 
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Sep 21, 2023 14:55
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 65 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, macebobo writes:
  Has anyone else been able to do mass updates with Brickstore that contains html
formatting?

I can not seem to get it to work, it pastes fine, it updates fine but it does
not render properly.

If I do the same syntax manually, it works fine, just not via mass update.

see image for example html (now included!)

Have you tried using & lt; and & gt; instead of the chevrons?
 Author: macebobo View Messages Posted By macebobo
 Posted: Sep 21, 2023 15:04
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 70 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

macebobo (3216)

Location:  USA, Oregon
Member Since Contact Type Status
Apr 3, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: MacsBricks
In Help, SylvainLS writes:
  Have you tried using & lt; and & gt; instead of the chevrons?

Yes, Brickstore does that on export.

However, I just noticed that it also escapes the ampersand & amp;. I wonder if
that is the issue. Deeper down the rabbit hole I go. I really do not want to
have to update my 6300+ lots manually. I am going to try the API next. Wish
me luck.
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Sep 21, 2023 15:09
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 51 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, macebobo writes:
  In Help, SylvainLS writes:
  Have you tried using & lt; and & gt; instead of the chevrons?

Yes, Brickstore does that on export.

However, I just noticed that it also escapes the ampersand & amp;. I wonder if
that is the issue. Deeper down the rabbit hole I go.

The rabbit hole of multiple-quoting.  You may actually need to quote more: &
amp;lt;

You need a background in Shell and/or Lisp to appreciate… or despair


   I really do not want to
have to update my 6300+ lots manually. I am going to try the API next. Wish
me luck.

Good luck!
 Author: macebobo View Messages Posted By macebobo
 Posted: Sep 21, 2023 15:31
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 69 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

macebobo (3216)

Location:  USA, Oregon
Member Since Contact Type Status
Apr 3, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: MacsBricks
In Help, SylvainLS writes:
  In Help, macebobo writes:
  However, I just noticed that it also escapes the ampersand & amp;. I wonder if
that is the issue. Deeper down the rabbit hole I go.

The rabbit hole of multiple-quoting.  You may actually need to quote more: &
amp;lt;

You need a background in Shell and/or Lisp to appreciate… or despair

Despair, definitely despair. I was a big CLI user before my stroke, now I do
not type fast enough to be efficient.

  
   I really do not want to
have to update my 6300+ lots manually. I am going to try the API next. Wish
me luck.

Good luck!

Thanks.
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Sep 21, 2023 16:43
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 53 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

1001bricks (55805)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 1001bricks
  
The rabbit hole of multiple-quoting.
  
The rabbit hole of multiple-quoting.
  
  
  
  
  
  
  

The rabbit hole of multiple-quoting.
  
  
The rabbit hole of
multiple-quoting.
  The rabbit hole of multiple-quoting.



Quote de porc?
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Sep 21, 2023 16:49
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 42 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, 1001bricks writes:
  
  
The rabbit hole of multiple-quoting.
  
The rabbit hole of multiple-quoting.
  
  
  
  
  
  
  

The rabbit hole of multiple-quoting.
  
  
The rabbit hole of
multiple-quoting.
  The rabbit hole of multiple-quoting.



Quote de porc?

Lapin.
Lapin compris?
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Sep 21, 2023 16:53
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 41 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

1001bricks (55805)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 1001bricks
In Help, SylvainLS writes:
  In Help, 1001bricks writes:
  
  
The rabbit hole of multiple-quoting.
  
The rabbit hole of multiple-quoting.
  
  
  
  
  
  
  

The rabbit hole of multiple-quoting.
  
  
The rabbit hole of
multiple-quoting.
  The rabbit hole of multiple-quoting.



Quote de porc?

Lapin.
Lapin compris?

Ca vient des newsgroups FR...
Quand tu quotes comme un cochon, tu quote de porc quoi
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Sep 21, 2023 17:00
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 57 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, 1001bricks writes:
  […]
  Lapin.
Lapin compris?

Ca vient des newsgroups FR...
Quand tu quotes comme un cochon, tu quote de porc quoi

Oui, il a ben compris, mais rabbit = lapin et https://www.youtube.com/watch?v=m9XzRrAqfZA
 Author: wildchicken13 View Messages Posted By wildchicken13
 Posted: Sep 22, 2023 00:04
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 66 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

wildchicken13 (893)

Location:  USA, Illinois
Member Since Contact Type Status
Aug 11, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Wild Chicken
In Help, SylvainLS writes:
  Oui, il a ben compris, mais rabbit = lapin et https://www.youtube.com/watch?v=m9XzRrAqfZA


Le porc confit?
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Sep 22, 2023 11:22
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 60 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, wildchicken13 writes:
  In Help, SylvainLS writes:
  Oui, il a ben compris, mais rabbit = lapin et https://www.youtube.com/watch?v=m9XzRrAqfZA


Le porc confit?



You know how we call a fight between ducks?  Un conflit de canards
 Author: peregrinator View Messages Posted By peregrinator
 Posted: Sep 21, 2023 19:42
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 65 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

peregrinator (1106)

Location:  USA, New Jersey
Member Since Contact Type Status
Jan 21, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Faber Family Bricks
In Help, SylvainLS writes:
  The rabbit hole of multiple-quoting.  You may actually need to quote more: &
amp;lt;

Now I think that might be backwards. It's could be escaping everything in
between the XML tags and saving the escaped characters to the database.

So < might be escaped as < when saved to the DB.
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Sep 21, 2023 20:29
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 44 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, peregrinator writes:
  In Help, SylvainLS writes:
  The rabbit hole of multiple-quoting.  You may actually need to quote more: &
amp;lt;

Now I think that might be backwards. It's could be escaping everything in
between the XML tags and saving the escaped characters to the database.

So & lt; might be escaped as & amp;lt; when saved to the DB.

There’s two possibilities:
1. the entities are resolved (that is, & xx; is replaced by the character it
codes for),
2. the special characters are replaced by entities,
and that in muliple places:
1. BrickStore,
2. the API service,
3. the database.

The problem is there’s no quasiquote/unquote in HTML.  So if “do nothing” doesn’t
work, the only thing we can do is “quote more”
 Author: macebobo View Messages Posted By macebobo
 Posted: Sep 21, 2023 23:02
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 57 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

macebobo (3216)

Location:  USA, Oregon
Member Since Contact Type Status
Apr 3, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: MacsBricks
In Help, SylvainLS writes:
  In Help, peregrinator writes:
  In Help, SylvainLS writes:
  The rabbit hole of multiple-quoting.  You may actually need to quote more: &
amp;lt;

Now I think that might be backwards. It's could be escaping everything in
between the XML tags and saving the escaped characters to the database.

So & lt; might be escaped as & amp;lt; when saved to the DB.

There’s two possibilities:
1. the entities are resolved (that is, & xx; is replaced by the character it
codes for),
2. the special characters are replaced by entities,
and that in muliple places:
1. BrickStore,
2. the API service,
3. the database.

The problem is there’s no quasiquote/unquote in HTML.  So if “do nothing” doesn’t
work, the only thing we can do is “quote more”

I tried quoting more, I tried quoting less, I tried literal quotes (" at
the start and end, and I even tried to enter it as !CDATA[]] since those sounded
like less time and typing. No success.

If anyone has anymore ideas, I am game, tomorrow, after I attempt the API fresh
in the morning.

Thank you all for the ideas to try. I'll keep you posted.

Over and out,
John
 Author: macebobo View Messages Posted By macebobo
 Posted: Sep 25, 2023 16:26
 Subject: Re: Mass update does not keep escaped XML
 Viewed: 46 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

macebobo (3216)

Location:  USA, Oregon
Member Since Contact Type Status
Apr 3, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: MacsBricks
In Technical Issues, macebobo writes:
  Has anyone else been able to do mass updates with Brickstore that contains html
formatting?

I can not seem to get it to work, it pastes fine, it updates fine but it does
not render properly.

If I do the same syntax manually, it works fine, just not via mass update.

see image for example html (now included!)

Update: The only way I was able to get this to work was through the API.

But that breaks my backup solution!

Still progress at 2 steps forward and one step back.