You are here: Home » All Software Solutions » How to import CSV file to any application?

Categories

See all categories

How to import CSV file to any application?

Automation Anywhere is an intelligent automation software for IT & business processes.
This month's most popular software guide you should know - How to move photos from my iPhone to my computer

1.
Create a new Variable
  • From Tools->Variable Manager, select User Variables
  • Click on 'Add New Variable'
  • Specify the name of the variable say for e.g. ImportList
  • Select the type as 'List' from the drop down menu
  • Click on 'Read from text file' option
  • Specify the path of your csv file for e.g. C:my-csv-to-import.txt
2.
Import csv file
  • Let's say your csv file looks as shown in Screenshot 2
  • Add the variable name "ImportList=" in front of the list to be imported as shown in Screenshot 3
  • Similarly if you have multiple lines of comma separated values you can add the variable name in front of all those lines and add those variable in Automation Anywhere Variable Manager as shown in Screenshot 4
3.
Process csv file
  • In previous two steps you have setup Automation Anywhere to read the values from your csv file.
  • Now, let's process the values of csv file one by one
  • All the values of the csv file in one line will be read into the List variable. In this case "ImportList".
  • You can use this variable in a loop to access the values one at a time.
  • See the Screenshot 5 on how it reads each value and inserts it into the database.

Screenshot 1:

Automation Anywhere

Screenshot 2:

Automation Anywhere

Screenshot 3:

Automation Anywhere

Screenshot 4:

Automation Anywhere

Screenshot 5:

Automation Anywhere

Related Software: Automation Anywhere -    

Recommended Essentialware
Windows media player 12
With it, you can play audio, video and viewing images on Windows 7 and have a great experience.
Norton Internet Security 2010
Norton Internet Security 2010 offers comprehensive protection against all types of online threats.
WinRAR 3.9
WinRAR is an powerful archiving utility that completely supports RAR and ZIP archives.

Recommended Mac Software
Senuti for Mac
Use Senuti to quickly and easily transfer music from your iPod or iPhone to your Mac.
VLC Media Player for Mac
VLC for Mac OS X is distributed as a disk image. Download the .dmg file, open it, and copy VLC to your hard drive.
iSquint
iSquint a program for converting videos from the internet to iPod or TV.

by on 20/08/2007Web Developer
Tags:Automation Anywhere, CSV file

Tips & Guides Related to How to import CSV file to any application?

  • How to import CSV file to any application?

    Automation Anywhere is an intelligent automation software for IT & business processes.

    by Admin on Aug 20, 2007

  • How to optimize PC startup?

    Guide on how to optimize your PC startup with SpeedUpMyPC 2009 in an easy.

    by Frank Yu on Apr 21, 2009

  • How to optimize CPU?

    Guide on how to optimize CPU with SpeedUpMyPC 2009 in an easy.

    by Frank Yu on Apr 22, 2009

  • How to optimize your PC memory?

    Guide on how to optimize your PC memory with SpeedUpMyPC 2009.

    by Frank Yu on Apr 21, 2009

  • How to convert M4V to AVI for Mac

    I can burn an AVI to a DVD but not the iTunes M4V, anyone knows how to convert M4V file to AVI file in an easy way?4Media MP4 Converter for Mac, the safest and full functional AVI/MP4 Converter tool!

    by Amber on Apr 13, 2009

Rss

Software Guides

on Web Developer

See all

Top Reviews

on Web Developer

  • Flash Gallery Builder
    Flash Gallery Builder

    "Flash Gallery Builder Reviews & Free Download"

    by Heren Watson on Jan 10, 2008

  • CoffeeCup HTML Editor
    CoffeeCup HTML Editor

    "CoffeeCup HTML Editor Reviews"

    by Dr. File Finder on Jan 29, 2008

  • SiteSpinner
    SiteSpinner

    "SiteSpinner Review & Download"

    by Dr. File Finder on Feb 23, 2008

  • NoteTab Pro
    NoteTab Pro

    "NoteTab Pro Reviews & Download"

    by Dr. File Finder on Jan 31, 2008

See all