Sometimes I can edit the column mappings, other times I can't, it seems completely inconsistent… What do I need to do to be able to edit the column mappings?
Can you post little more details like how to reproduce it. Actually i am not able to find any inconsistencies
Just occured again… I think it occurs where you are using an existing job xml file, so that it sees a new column in your SOURCE SQL, and it sees the field of the exact same name in the TARGET table, it lists the match in the mappings table, however it won't let you tick it because it is not listed in the XML job file.
I have got around it by editing the XML file directly
You know I always wondered why if you clicked the 'reply' button and not the 'quote' button, your reply would come prepopulated with the quote anyway, but have just then discovered the quote button is a toggle.
*ontopic* As stated earlier, the mapping DOES appear in the mappings list (the list of source columns and target columns and field data types etc).
Each row (an individual column mapping) has a tickbox at the start of the row.
None of these tickboxes are editable, ie, I cannot toggle them on and off. This usually doesn't bother me, as I am usually importing from access to mysql with all exact same fieldnames, and the column mapper recognises them all and ticks them *all* accordingly.
Sometimes however, it leaves a particular mapping unticked, and I cannot tick it. Upon investigation into the job xml file, it appears that the column from neither source nor target is listed at all.
*THis particular time it occured when i was using an existing import job file.*
I have just gone through the process of NOT using the existing job file, and started from scratch, using the same SQL to pull the data… selecting the same existing table
This time, as expected it mapped all the columns, and forcefully ticks every one ( i cannot untick them).
edit: forgot to mention field exists by the same name in both tables, both are numbers
scottah
MemberManoj
Memberpeterlaursen
Participant
