18 questions
Best practices
0
votes
0
replies
61
views
PostgreSQL creating a bookstore or library database with reference tables
I'm creating a bookstore / library style database, and I wanted to get some feedback on my tables. I've made a previous version without reference tables, and now I'm trying to separate out the authors ...
0
votes
1
answer
539
views
Parsing an ONIX xml with conditions using Python lxml
I am trying to extract some information from an ONIX XML format file using Python lxml parser.
Among other things, the part I am interested in in the document looks like this:
<?xml version="1....
0
votes
0
answers
67
views
Nokogiri versions 1.10.5 and higher give a false positive validation against ONIX XSD
Nokogiri's versions 1.10.5 and later produces different validation errors to version 1.10.4 against the ONIX v2.1 and v3 XSDs, and I can't find any commits in that release and the changed dependencies ...
1
vote
1
answer
646
views
XSLT (1.0) How to preserve html tags when wrapping element value in a CDATA tag
I have an XML with Text elements that can include tagged text and depending on the elements attribute value i know if the content is CDATA encapsulated or XHTML.
As i cannot have/create any child ...
1
vote
2
answers
179
views
Using a SSIS XML Source store relative xml elements
Using a SSIS XML Source I would like to read the following XML
<Stock>
<OnHand>1</OnHand>
<Proximity>xx</Proximity>
<Reserved>2</Reserved>
<...
1
vote
1
answer
220
views
Deserializing relative path XML
In C# I would like to deserialize some Xml where the relative location is important. The following Xml is from a book standard called Onix:
<Stock>
<OnHand>1</OnHand>
<...
0
votes
1
answer
483
views
Bulk filter & parse ONIX data (XML) in Excel
I have 3000 ONIX-style xml URLs with book metadata.
I would like to filter a few nodes out of these files and parse them into Excel rows in a single worksheet.
This is an example of a XML-path:
http:/...
1
vote
0
answers
437
views
JAXB Custom Bindings to generate Constants
I'm generating Java classes from a xsd file provided by a 3rd party (the ONIX XML file XSD to be precise). The schema defines quite a few types, that have a shortname and a refname attribute. ...
1
vote
3
answers
1k
views
Onix files connected to Shopify or Wordpress [help]
What is the best system or method to bulk upload onix data into either a wordpress website or the shopify platform. I use the accumen book software to manage the onix files and I'm looking to feed ...
4
votes
2
answers
10k
views
How to split XML file into smaller files using Powershell
I have large XML files ("ONIX" standard) I'd like to split. Basic structure is:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE ONIXmessage SYSTEM "http://www.editeur.org/onix/2.1/short/...
1
vote
2
answers
2k
views
How to convert ONIX xml Short tag-names into Reference tag-names?
My XML Short tag file
<product>
<a001>CRITICAL-62258</a001
><a002>01</a002>
<productidentifier>
<b221>03</b221>
<b244>9781911106050</b244&...
2
votes
1
answer
2k
views
Matching on namespace during xsl transform
I have a document of which the root element defines a namespace, when I write a xsl to transform I don't see any elements matched.
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www....
1
vote
1
answer
407
views
PHP XML Feed - How to print value of specific child within parent. Parent has same name as other nodes
I'm trying to figure out how to grab and print a specific IDValue in the code below, but the number and order of ProductIdentifier nodes varies per Product, so I can't always get the correct value by ...
1
vote
1
answer
757
views
Validating xml against the Onix 2.1 dtd with dotNet
I'm trying to validate an XML feed against the ONIX 2.1 dtd. When I load the generated XML file into XMLSpy and validate against the DTD, it tells me that the feed is valid.
When I try to validate ...
2
votes
1
answer
944
views
Classes generated from XSD does not work with XmlSerializer
I need to read some XML files that follow the ONIX standard
See: http://www.editeur.org/93/Release-3.0-Downloads/
To do this i downloaded the ONIX 3.0 XSD:
http://www.editeur.org/files/ONIX%203/...