Importing CSV file.

[chikito1990]

Hi all!

I am trying to import a CSV file in AutoCAD 2014 but cannot find proper function. Is there any automatic function that will do it for me or I have to create some kind of tool to accomplish that task?

Thank you in advance.

Best regards,

Dimitar Georgiev

[maxim_k]

Hi Dimitar,

How do you want to represent data from CSV file in AutoCAD:

- table

- points or polyline (3D polyline)

- any other?

Maxim

[chikito1990]

Hi Maxim,

Well I have table with X, Y possitions and also blocknames. So what i have to do is insert the bolock on the coresponding position.

Thank you.

Dimitar Georgiev

[maxim_k]

You need AutoLISP routine, or Script file to accomplish this.

Could uoy post your CSV file here?

(If it fail to attach to the post - just compress it in ZIP format and then attach to your post)

Maxim

[maxim_k]

Does your blocks contain attributes (I mean "Block label" in your CSV file)?
If yes - than converting CSV file to AutoCAD script may be bad idea.
Than you need AutoLISP routine, that reads CSV file line by line and executes INSERT command with parameters from each line.


Maxim

[Ajilal.Vijayan]

Use Excel file to generate the script file and run the script to insert the blocks.
Assuming you have  a single attribute block and the insertion option for scale and rotation needs user input.

Find the attached Excel file and copy the highlighted rows information to a notepad file and save it as a script file.
Then run the script command.

[k.bedekar]

Hi, This is Kaustubh Bedekar from India.

I am a profetional trader in indian stock market. I receive every day a comma separated stock price data file in .txt format. I want to import this text file in to auto cad 2013.

I WANT TO VIEW THE IMPORTED DATA AS A STOCK CHART USING THE MITOTIC SCALING WHICH IS A BRIDGE JOINING CHARTS WITH GEOMETRICAL OVERLAYS.

Attaching a text file. 3 files

each file containing 1300 + share scrip

sample:-

name, date, open, high, low, close, volume, open intrest

BANKNIFTY-I,20160225,13801.1,13850,13541.25,13567.9,128616,1081020

I have almost 3900 text files. that means over 20 years of data of indian stock market.

Just like a Professionals use Meta Stock to analyse their price movement.

I want to use the data for resistances & supports.

I wanted to have a this kind of chart for every stock name. and further i will be able to do the geometrical analysis using the angular lines. snap shot below is the jpeg image imported & tried to explain what i want actully. 

Thanks in advance. all the best.

[martti.halminen]

So what was your question?

Which part of this do you not know how to do?

You might start by reading http://www.catb.org/esr/faqs/smart-questions.html

-- 

[k.bedekar]

I DONT KNOW ANY THIG OF IMPORTING TEXT FILES SO PLEASE HELP ME IMPORTING MY TEXT FILES IN TO AUTOCAD

[martti.halminen]

(defun read-csv-file (path separator / f1 line result)
  ;; reads a csv file (separator as a one-character string) into a list, each line as a list
  (setq f1 (open path "r"))
  (while (setq line (read-line f1))
    (setq result
          (cons
           (split-at separator line)
           result)))
  (close f1)
  (reverse result))

(defun split-at (char str / pos  )
  ;; Splits string to a list of strings at each char occurrence.
  ;; Separators omitted from the result.
  ;; char as an one-character string.
  (setq pos (vl-string-position (ascii char) str))
  (cond
    ((or (null char) (null str)) nil)
    ((null pos) (list str))
    (T (cons (substr str 1 pos)
             (split-at char (substr str (+ 2 pos)))))))

-- 

[k.bedekar]

WHAT DO I DO WITH THIS. I DONT UNDERSTAND IT

[martti.halminen]

---

@k.bedekar wrote:
WHAT DO I DO WITH THIS. I DONT UNDERSTAND IT

---

As an out-of-the-box AutoCAD knows nothing about practically anything mentioned in your first message, you write a program around that to do the things you want.

- Or pay a professional programmer to do that. I know nothing about stock analysis, but as a first guess we would be talking about several weeks of full-time work.

--