Welcome to the VanDyke Software Forums

Join the discussion today!


Go Back   VanDyke Software Forums > Scripting

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 03-20-2018, 03:13 PM
BrianV BrianV is offline
Registered User
 
Join Date: Mar 2018
Posts: 3
Issue with bulk import

Hi folks,
I've read thru everything I could find. I am running in to an error when trying to do a bulk import in to SecureCRT.



In case the image above doesn't work.
Error: Unknown field designation: *&^folder

I have double, triple, quadruple checked, cannot find any formatting in the CSV or anything wrong with my syntax.

SCRT Version: 8.3.2 build 1584

VBS script from here: vbs version last updated: 09 Aug, 2017
https://forums.vandyke.com/showpost....89&postcount=1

Sample of my CSV:
folder,session_name,hostname,protocol
MDC/Switch,COLO-19-7700-Admin,10.10.10.10,ssh2

I did also try removeing the - from the session_name but no change.

Any ideas?
Thanks,
-Brian
Reply With Quote
  #2  
Old 03-20-2018, 03:27 PM
bgagnon bgagnon is offline
VanDyke Technical Support
 
Join Date: Oct 2008
Posts: 4,112
Hi BrianV,

I think those three characters in front of folder points to an encoding issue with the source file.

Where/How did you create it?

What encoding was it saved with?

If you save it with ANSI (ASCII) encoding, what are the results?
__________________
Thanks,
--Brenda

VanDyke Software
Technical Support
support@vandyke.com
(505) 332-5730
Reply With Quote
  #3  
Old 03-21-2018, 12:39 PM
BrianV BrianV is offline
Registered User
 
Join Date: Mar 2018
Posts: 3
Quote:
Originally Posted by bgagnon View Post
Hi BrianV,

I think those three characters in front of folder points to an encoding issue with the source file.

Where/How did you create it?

What encoding was it saved with?

If you save it with ANSI (ASCII) encoding, what are the results?
I did some more experimenting today, if I run it as a python script it does not show any special characters in front of the "folder" but it does still error on "folder".

My CSV was originally created in Excel, that copy and pasted in to notepad and saved there to rule out any possibilities of formatting.

Thoughts?
Thanks,
-Brian
Reply With Quote
  #4  
Old 03-21-2018, 12:48 PM
bgagnon bgagnon is offline
VanDyke Technical Support
 
Join Date: Oct 2008
Posts: 4,112
Hi Brian,

Choose Save As... from Notepad's File menu.

What encoding is indicated on the bottom right next to the Save button?
__________________
Thanks,
--Brenda

VanDyke Software
Technical Support
support@vandyke.com
(505) 332-5730
Reply With Quote
  #5  
Old 03-22-2018, 11:41 AM
BrianV BrianV is offline
Registered User
 
Join Date: Mar 2018
Posts: 3
Issue has been resolved. It was definitely an encoding issue. I recreated the CSV and everything worked as expected. Thank you for your help.
-Brian
Reply With Quote
  #6  
Old 03-22-2018, 11:47 AM
bgagnon bgagnon is offline
VanDyke Technical Support
 
Join Date: Oct 2008
Posts: 4,112
Hi Brian,

I am glad to hear you were able to resolve the issue. Thanks for posting an update!
__________________
Thanks,
--Brenda

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


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

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 04:50 PM.