Hi,
If the file does not have doublequotes it is not a CSV-file that AR Import
can parse.
If you do not have any ","-characters in the data, you can import it as an
asc-file with "," as delimiter instead.
To convert your file, you will not need to create an AR-API-program. But
you may have to create a script/program that converts the data.
Another solution may be to change the output-format from the source, and
create a ";"-separated list or TAB-separated list instead.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
>
> All,
>
> We have another database where records are exported into a csv file. We
> have the need to import these records into Remedy now. We are using the
> ARS 6.3 import tool.The export was performed through SQL server export
> tool. What I have found is the columns and data that was exported without
> double quotes. The AR Import tool does not recognize this format since
> the double quotes are not around ever column and data value.
>
> My question is has anyone run into this issue before and what did you do?
> Did you have to write an API to add the double quotes?
>
> Thanks in advance!
>
> Regards,
>
> Jackson Samson
> Remedy Administrator
>
> _________________________________________________________________
> im is proud to present Cause Effect, a series about real people making a
> difference.
> http://im.live.com/Messenger/IM/MTV/?source=text_Cause_Effect
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
