topic CSV delimiter rsadmin -unload in Insight Remote Support

CSV delimiter rsadmin -unload

shatra_sa — Tue, 21 Feb 2017 07:47:16 GMT

I am looking for a solution to change csv delimiter when exporting all systems from IRS to csv.

rsadmin -unload -file export.csv

Default delimiter is ,

Unfortunately the < , > is used in other fields like site address and so on, because of this when the csv is imported additional collumns are added.

Re: CSV delimiter rsadmin -unload

toddg1 — Tue, 21 Feb 2017 14:10:03 GMT

Can you please let me know specifically which version of Insight Remote Support you are running?

The embedded "," are supposed to be protected in the unload, this may be a defect - but in previous releases, you used to have to add an extra command line option to do the protect. In the most recent releases, the protection is supposed to automatically be applied.

Re: CSV delimiter rsadmin -unload

shatra — Wed, 08 Mar 2017 08:21:27 GMT

Hi Todd

Sorry for the late reply I had some authorizations issue accessing the forum. I am using Insight Remote Support 7.7.0.0042

Re: CSV delimiter rsadmin -unload

toddg1 — Wed, 08 Mar 2017 13:31:27 GMT

I do not expect a problem with this version of the product and commas. We are working in the area of the code

that is responsible for this. Would you be willing to share your "unload" file with us so we can see how it may be different from what we are testing? It seems we must be missing some case.

This is the R&D team for teh Insight Remote Support product - please reply if you are willing, and I will find a way for you to put a file some place, but before I set that up - let me know if willing to do this.

Re: CSV delimiter rsadmin -unload

shatra — Thu, 09 Mar 2017 11:26:21 GMT

sent you PM