VanDyke Software Forums

VanDyke Software Forums (https://forums.vandyke.com/index.php)
-   Scripting (https://forums.vandyke.com/forumdisplay.php?f=14)
-   -   Import Data To SecureCRT Sessions: Data File Error (https://forums.vandyke.com/showthread.php?t=12963)

iveybilly 01-03-2018 08:59 AM

Import Data To SecureCRT Sessions: Data File Error
 
I keep getting this error when trying to import sessions to SecureCRT via .csv. You can see that emulation is correctly entered, but it does not recognize it as a supported field. Has anyone seen this before?

Import Data To SecureCRT Sessions: Data File Error

Error: Unknown field designation: "emulation

Supported fields are as follows:

description,emulation,folder,hostname,port,protocol,session_name,username

For a description of supported fields, please see the comments in the sample script file.

ekoranyi 01-03-2018 09:05 AM

Hi iveybilly,

I'm sorry you're having trouble.

I have seen in the past that trailing spaces can cause trouble. Is it possible that your field has one or more trailing spaces behind the "emulation"?

If not, would it be possible for you to send me a copy of your excel sheet, just the first row, via email for testing. Please send the sheet to Support@VanDyke.com with "Attn Eric Forum Post 12963" in the subject line.

iveybilly 01-03-2018 09:21 AM

Email Sent
 
Heading your way

ekoranyi 01-03-2018 09:44 AM

2 Attachment(s)
Hi iveybilly,

It looks like there may be a little confusion about creating CSV files in Excel vs a text editor like Notepad.

Excel will automatically add the required "," between each cell. Therefore each field will go in a different column without requiring a "," be entered.

https://forums.vandyke.com/attachmen...1&d=1514997313

If you are using a text editor, that's less sophisticated than Excel, you will need to manually enter the "," to separate the data.

https://forums.vandyke.com/attachmen...1&d=1514997467

Both of these images are the same file opened with a different application. It looks like it's just a matter of Excel doing some of the work for you.

Does using Excel and modifying your CSV to have only one field in each column change the behavior you see?


All times are GMT -6. The time now is 10:56 PM.