Welcome to the VanDyke Software Forums

Join the discussion today!


Go Back   VanDyke Software Forums > General

Reply
 
Thread Tools Display Modes
  #1  
Old 07-01-2020, 08:45 AM
lcpunix lcpunix is offline
Registered User
 
Join Date: Jul 2020
Posts: 2
Attempting to import from text file or csv fails

SecureCRT Version: 8.7.1 (x64 build 2171)
Host OS: Windows 10

Attempting to use the script found on the vandyke support page (VBS version) to import a text file (also tried with csv file) to import sessions into the tool.

Script Name: ImportArbitraryDataFromFileToSecureCRTSessions.vbs

When I run the script, and select either the .txt or the .csv file, I receive an error as follows:

Error: Unknown field designation: description
Supported fields are as follows:

description,emulation,folder,hostname,port,protocol,session_name_username

My header from my text file is as follows (with no additional characters):
description,emulation,folder,hostname,port,protocol,session_name,username

The text and csv files are correctly created via Excel and have been reviewed in notepad to not contain any extraneous characters.
Reply With Quote
  #2  
Old 07-01-2020, 10:22 AM
cboyack cboyack is offline
VanDyke Technical Support
 
Join Date: Apr 2020
Location: Albuquerque, NM
Posts: 24
Quote:
Originally Posted by lcpunix View Post
When I run the script, and select either the .txt or the .csv file, I receive an error as follows:

Error: Unknown field designation: description
The extra characters we see above () are a result of the text file being saved with Unicode encoding.

This script is only able to read ANSI file encoding at this time.

Please re-open your .txt file in Notepad, navigate to File > Save As, and there should be an Encoding: option near the bottom of the Save As dialog box. Change this option to ANSI and save the file. For back up purposes, you may wish to save this change under a different name.

Once you have your newly saved, ANSI-encoded .txt file, please attempt to run the script using the new file.
__________________
Thanks,
--Cameron

VanDyke Software
Technical Support
support@vandyke.com
(505) 332-5730

Last edited by cboyack; 07-01-2020 at 11:39 AM.
Reply With Quote
  #3  
Old 07-02-2020, 07:30 AM
lcpunix lcpunix is offline
Registered User
 
Join Date: Jul 2020
Posts: 2
Smile

Thank you very much. That was it. My text editor was saving in UTF-8, and once I resaved the file as ANSI, it imported perfectly.

Thank you.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 09:00 PM.