Posted 23 April 2012 - 02:14 PM
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!
Posted 23 April 2012 - 06:34 PM
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 email@example.com. You may of course fake connection and authenntication details.
Posted 23 April 2012 - 08:37 PM
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.
Posted 21 June 2012 - 06:44 PM
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