Jump to content


Photo

Database Import - Includes Unchecked Fields

database import import external data

  • Please log in to reply
6 replies to this topic

#1 MatthiasFostel

MatthiasFostel

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 23 April 2012 - 02:14 PM

Good morning,

On attempting to "Import External Data", the SQL created by the wizard does not seem to be using the check boxes on the Mapping window ("Column Mappings and Transformation").

I uncheck numerous fields in a table, not wishing them to be imported, but all that seems to do is remove them in the CREATE SQL.

All of the unchecked fields still appear in the REPLACE SQL later later in the process, causing the import to fail.

I assume this is a bug, but if I'm missing something I appreciate any help!

Thank you,
Matthias

#2 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,868 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 23 April 2012 - 06:34 PM

There are many settings/choises in this wizard.


Please:

1) describe for each step in the dialog what you chose, what additional dialogs you open and do in those etc.

2) Instead for actully running the job, save an XML jobfile. If you don't want to attach it here you may create a private support ticket by sending a mail to support@webyog.com. You may of course fake connection and authenntication details.
Computers make your grey hair come off ....

Peter Laursen
Webyog

#3 MatthiasFostel

MatthiasFostel

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 23 April 2012 - 08:37 PM

I follow this process:

1. Open Import External Data Wizard from the Database -> Import menu.
2. Start a new job. Next.
3. Select Any ODBC Source, input System/User DSN and credentials for Data Source. Next.
4. Select MySQL Connection and Database. Next.
5. Select "Copy table(s) from the data source". Next.
6. Find table to select, hit checkbox next to table to import.
7. Hit the "..." button under Map.
8. Uncheck all fields I do not want to import (deselect all function would be really helpful, there are tons of fields to uncheck). Hit Okay.
9. Hit the "..." button under Advanced.
10. Select "Drop and recreate". Hit Okay.
11. Hit Next on Wizard.
12. Hit Next on "What do you want to do on error?".
13. Check "Run immediately", hit Next.
14. Errors out on CREATE table, listing Keys that were unchecked.

If I go back to the Map window (at step 7), hit the "Edit SQL.." button and just hit Okay without editting it, the CREATE table process completes and it errors on the REPLACE INTO command with the full list of fields including those unchecked earlier.

I don't think sharing the XML will help, it seems like the SQL generated by the Wizard is incorrect and I bet it will save that incorrect SQL into the XML file.

#4 sathish

sathish

    Advanced Member

  • Admin
  • PipPipPip
  • 292 posts
  • Gender:Male

Posted 24 April 2012 - 05:00 AM

Issue reproduced. We are looking into this.

#5 MatthiasFostel

MatthiasFostel

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 24 April 2012 - 06:31 PM

Good to hear. Let me know if you need any help!

#6 sathish

sathish

    Advanced Member

  • Admin
  • PipPipPip
  • 292 posts
  • Gender:Male

Posted 03 May 2012 - 06:57 AM

I have added this in our issue tracker here: http://code.google.c.../detail?id=1789 we will fix this with priority.

#7 MatthiasFostel

MatthiasFostel

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 21 June 2012 - 06:44 PM

Just downloaded the latest 10.1.1 and tried the same procedure to find it working flawlessly!

Also noticed the uncheck/check all option on the columns to select or deselect all. Incredibly helpful.

Thank you very much for addressing the problem!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users