Importing data from CSV file

[nfl02]

Any ideas on how I can get ASPECT to retrieve a field from a CSV file? I want to automate my PBX programming by having the script refer to an external file for the responses to certain prompts returned by the PBX i.e. phone number, name etc.

 

[Wills7577]

The only thing that I have ever been able to get it to work is to save from excell as *.CSV, then open that file in a plain text editor (such as notepad) and save it again as *.TXT. Once it is a *.TXT, it's pretty simple to get aspect to recognize it. Here is part of a script that gets data from an external, comma seprated, text file:

...
fopen 3 sourcefile Read
fgets 3 datastr
strtok indexnumber datastr "," 1
strtok hospitalnum datastr "," 1
strtok accountnum datastr "," 1
...

this will read the current line of the source file, and break it into three seprate strings.

I hope that this helps,
William Sheehan

 

[Guest_imported]

I am trying to get aspect to get text from a .csv(saved as .txt)file. I would like the script to get on line of values (4 values in total) and return to them to procomm screen. I am brand new to aspect scripting and would very much appreciate any help.

Thankx