Simpel import csv with pipes

[Jan Campschroer]

Hello, 

I want to import a 'csv' file in EDG. The separator however isn't a comma ',' but a pipe '|'.

The import triples should be related to the imported structure:

Every row has to become in instance of class Row, localname of the URI is the rownumber in the file.

Every value V (a string in the import file between |)  in column C in a row N has to become a triple:

  :rowN  :columnC "V" .

What is the easiest way to achieve this? 

The import function of EDG suggests there is already a function under the hood that performs such behavior.

Grz Jan

[Holger Knublauch]

Hi Jan,

this may require ADS JavaScript, which gives you the most flexibility. Just parse the uploaded text row by row and split the string by |

https://archive.topquadrant.com/doc/latest/scripting/importing.html#

Alternatively, consider pre-processing the spreadsheets, e.g. with Excel to re-save them in a format that the out-of-the-box UI of TopBraid can process.

Holger

--
The topics of this mailing list include TopBraid EDG and related technologies such as SHACL.
To post to this group, send email to topbrai...@googlegroups.com
---
You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/86870127-84bf-4043-a693-2cca739a583fn%40googlegroups.com.