Parse CSV and export into Mysql database in Grails

Question

I am newbie in Groovy & Grails. I want to submit parse CSV file and export into several tables of MySQL database. I have looked some coding but it was confusing for me as newbie. So can anybody help me in understanding simple csv file Parsing and exporting into MySQL database.

Thanks Sonu

hvgotcodes · Accepted Answer · 2011-01-25 00:49:43Z

11

Grails a bootstrap process that runs whenever your app starts. Its nifty; you can configure it to do different things in different environments.

One approach is to do the following in bootstrap:

1) Read the csv file, creating Domain objects as you go.
2) For each domain object, check to see if it exists, and if not do youDomainObject.save()

thats it.

for code, something like

new File(filePath).splitEachLine(',') {fields ->
    def domainObject = new YouDomainObject(
        id: fields[0].trim(),
        name: fields[1].trim()
    )

    if (domainObject.hasErrors() || domainObject.save(flush: true) == null) {
        log.error("Could not import domainObject  ${domainObject.errors}")
    }

    log.debug("Importing domainObject  ${domainObject.toString()}")
}

edited Jan 25, 2011 at 0:49

answered Jan 24, 2011 at 21:56

hvgotcodes

121k33 gold badges209 silver badges237 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fletch · Accepted Answer · 2011-01-27 09:01:12Z

0

Since Groovy integrates with Java you can also use a Java library called opencsv to read the CSV if you're more comfortable with that.

answered Jan 27, 2011 at 9:01

Fletch

5,2972 gold badges46 silver badges59 bronze badges

Collectives™ on Stack Overflow

Parse CSV and export into Mysql database in Grails

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related