Export to CSV, CSV mapping

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Export to CSV, CSV mapping

Postby christian harlass » Fri Oct 28, 2011 1:13 pm

I am currently evaluating the SQL Data Generator 2, got a few questions regarding the CSV part.

1) It looks like there is no way to "generate into .csv file", correct?
That would be a "nice to have" feature. For example, it could ask me for a folder, then it would generate one .csv file per table.

2) Using CSV as data source - column mapping: I have a .csv file with header (header text = column name). When I select this csv file as data source, the generators of each column remain mapped to the
default SQL Type Generator - I would expect this automatically to be reassigned to the appropriate csv column. => This is close to a showstopper for me.

3) Even when I manually assign each column to a CSV Generator, anytime I reassign a different csv file (or even the same csv file), the column mapping is reset to a SQL Generator => this is definitely a showstopper.

=> Pls let me know whether I made a mistake here or it works "as designed"
=> When "as designed" I strongly recommend to change the behavior, pls let me know if / when you'd make such a change.

Thank you very much!
christian harlass
 
Posts: 1
Joined: Fri Oct 28, 2011 12:59 pm

Postby eddie davis » Mon Oct 31, 2011 11:11 am

Hi Christian

I suspect that V2.0 has introduced a bug when using a csv file as a the generator source.

I have added this forum post to a Bug Report I submitted last week to bring this issue to the attention of the development team. The reference number for the bug report is SDG-964.

I will provide an update when I get further information.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

CSV Mapping

Postby pmap_anil » Mon Feb 13, 2012 12:58 pm

Hi,

Even iam facing the same problem as Christian. When i load data into a datbase from a csv file, i assign the columns of the database to the respective columns of that csv file and data generation done properly and i saved that project.

But, when i opened that project after few minutes, i couldn't see the assigned columns in the database table with csv file and they are showing the default generators which are given by the tool itself.

Is there any way to save that columns assigned or the tool has that property or not? Please find a solution for this problem sothat the next time when we want to generate data for the tables from a same csv file, it would help and can be done in few seconds.

Thanks
Anil.
pmap_anil
 
Posts: 2
Joined: Mon Feb 13, 2012 12:46 pm


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests