Menu

#755 (Ok 4.3) export with table/column name changes

Next_release
fixed
1
2014-12-05
2005-07-29
paulus
No

I love the current export functionality - works perfect
every time (for me at least).. what would be really
helpful in the end would be an export feature that would
allow you to transform/translate the field names & table
names in the exported information...

For example: I'm migrating data from one database into
another, but the field names are different and the table
names are different.

So I could check an option like "translate data output"
and then a DHTML frame would display showing the
current field & table names with a handy ---> and then a
text box..

e.g.

[] Translate Column or Table Names:

[] Old Table 1 Name ---> [___________]
- Old Column 1 Name ---> [___________]
- Old Column 2 Name ---> [___________]

[] Old Table 2 Name ---> [___________]
- Old Column 1 Name ---> [___________]
- Old Column 2 Name ---> [___________]

where the checkbox in front of a table name could be
used to indicate if that is included in the transformation
(could be optional vs. having to check for input all the
way).

This would greatly enhance the handiness of
phpmyadmin and just be plain ole cool.

Thanks!

Discussion

  • Marc Delisle

    Marc Delisle - 2014-01-15
    • summary: export with field transformations --> export with table/column name changes
     
  • Marc Delisle

    Marc Delisle - 2014-01-17
    • labels: Data Export --> Data Export, GSOC 2014
    • assigned_to: Isaac Bennetch
     
  • Dhananjay

    Dhananjay - 2014-01-18

    Hi, I would love to work on this feature. The feature seems to be very useful because many a times such scenarios arises for db administrator.

    Can I work on it in GSOC-2014..??

    Just drop an email at my-email if you need to discuss anything in specific.

    [ Btw I am new to open source projects and really don't know what the above comment means, so forgive me if I am asking something silly...:) ]

     

    Last edit: Dhananjay 2014-01-18
  • Marc Delisle

    Marc Delisle - 2014-01-18

    Dhananjay,
    this feature request is part of a collection of ideas that will be implemented by a student in GSoC 2014. There will be an organization selection process, followed by a student selection process. For now, I refer you to http://www.google-melange.com/gsoc/homepage/google/gsoc2014, there is a FAQ section.

     
  • Isaac Bennetch

    Isaac Bennetch - 2014-06-18
    • summary: export with table/column name changes --> (Ok 4.3) export with table/column name changes
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2014-12-05
    • Status: resolved --> fixed
     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.