Missing Fields when Importing Opportunities

[mrmmm]

Hi,
I am running into a small problem when importing data into Sugar 5.0 OS. When mapping the fields to be imported, there is no "Assigned to ID:" field in the list. There is an "Assigned to" field, but when I mapped that to a field containing user IDs it did not get imported (the field was null for all imported records). Is there a way to control which fields are available in the "Import" function? Why aren't all of them available? (The IDs that I am trying to map already exist as sugar users since I imported them earlier)
Any suggestion on how to solve this issue without resorting to running UPDATE queries in MySQL or doing the whole import by running INSERT?

Thank you.

[dpatech]

You can change this in the following file:

\include\SugarObjects\implements\assignable\vardef s.php

Find the definition of "assigned_user_id" and change the "Importable" property to true. This should be on line 48. After doing this you need to go into Admin-> Repair-> "Clear Vardefs Data Cache". Uncheck all options except "Clear Vardefs" and then click Repair.

The "Assigned To ID" field should now be listed on the Opportunities import as a field you can choose.

[mrmmm]

Thank you for the quick and very helpful reply. I did the changes, and tried the import.
If before the field for all records was null, now it is set to "1" which is the ID of the Admin user.
Any idea why it would not set the correct user ID?

[kuske]

On import in Version 5, assigned_to should not be mapped to the id of the user but to the user_name of the user.
In demo environment e.g. to chris not to chris_id.

[mrmmm]

So there is no way to import using the "assigned to id"? The problem is that in the export from my custom system, I get the "user id" on the opportunity, not the user name. (I should be able to join the user table to get the name on there, but it would be easier to just map to ID).

Thank you.

[kuske]

I'm afraid not!
If you want to user the id of the user you must change code of some modules.