Developer forum

Forum » Integration » CSV Provider without string delimiter

CSV Provider without string delimiter

E-mail notifications
Kasper Laursen
Reply
Posted on 22/06/2020 09:29:41

Hi there,

 

I would like to know if anyone has some pointers to avoid using string delimiters in the csv provider when writing a file.

Do I need to write my own provider?

 

Best Regards,

Kasper


Replies

 
Nicolai Pedersen
Posted on 22/06/2020 10:50:36
Reply

Hi Kasper.

Could you explain? What is the use case?

You can probably use a space, but that is also a seperator.

BR Nicolai

 
Kasper Laursen
Posted on 22/06/2020 11:36:08
Reply

Thanks for fast response.

 

Usecase is that I would like my file to look like this:

value1|value2|value3|value4

 

Instead of like this:

'value1'|'value2'|'value3'|'value4'

 

I have a system expecting a pipe delimited file for import that can't handle additional characters.

 

/Kasper

 
Nicolai Pedersen
Posted on 22/06/2020 12:21:14
Reply

Hi Kasper

Yes, apparantly you cannot set that to empty string. Editing the xml definition will just break the UI/loading of the xml.

You can try to inherit Dynamicweb.DataIntegration.Providers.CsvProvider and then give it one more attribute as a checkbox "set string delimter to empty string" and then override the DestinationQuoteCharacter property at 'the right time' - maybe when an instance is created.

BR Nicolai

 
Kasper Laursen
Posted on 23/06/2020 06:45:34
Reply

I'll take a look at it. Thanks for your help.

 

/Kasper

 

You must be logged in to post in the forum