Can't import Date Created or Date Modified

[ffletch]

Hey all I'm running Sugar Version 5.2.0 (Build 5380). I'm trying to import Opportunities from Salesforce. I'd like to be able to import the Date Created as well as the Date Modified fields. Both fields in Sugar appear to not be importable. Does anyone know of a way to make either (preferably both) of them importable at least temporarily so that I can get the initial data imported?

TIA for any ideas.

[andopes]

Edit the file cache/modules/Opportunities/Opportunityvardefs.php
Look for date_entered and date_modified.
set the attribute importable to true.

When you finish importing restore the default value.

[ffletch]

Thanks (once again) for your response. When I do what you described, every time I go to a new page the file is updated with those fields being set to false and (I'm assuming) as a result they don't show up as importable in the import dialog. I also tried to copy those variable sections into \modules\Opportunities\vardefs.php and that didn't work either? Do you have another ideas?

[andopes]

Create an extended vardefs for Opportunities and update the attribute 'importable' for both 'date_entered' and 'date_modified' fields

custom/Extension/modules/Opportunities/Ext/Vardefs/vardefs.ext.php

 <?php
$dictionary['Opportunity']['fields']['date_entered']['importable'] = true;
$dictionary['Opportunity']['fields']['date_modified']['importable'] = true;
?>  

Then go to Admin -> Repair -> Rebuild Extension.

You will see the cache/modules/Opportunities/Opportunityvardefs.php will be updated according to that customization and both fields will be importable.

[ffletch]

Ok, did that and I do see that cache/modules/Opportunities/Opportunityvardefs.php is updated. And when I look at the fields in Studio I see that they are updated there as well (they are blank as opposed to false). However when I look in the pulldowns in the "Database Field" column the Created Date (date_entered) and Modified Date (date_modified) don't show up. I do see that this info is stored in a blob in the import_maps table in the DB. I tried editing that blob and it still didn't import either of the fields. Or do you have any other ideas?

[ffletch]

*Bump*

Anyone have any ideas on this one?

[jmavor]

Hi

We are experiencing this exact problem. I see that we are not the only ones. Can anyone help us?

[theone]

I'm running into the same problem with all date fields on an import for Account. Even some custom date fields will not import. Anyone import date created and modified into SugarCRM Accounts successfully?

TIA

[wallydb]

I had the same problem and for me this solved it:

When you Import and get to Step 3: Confirm Fields and Import - Click on "Show Advances Options" at the bottom and make sure that your "Date Format" is set to the same format your fields are in. DD/MM/YYYY or whatever...

Let me know ...

[erikbrown]

I had this problem when trying to import using the Sugar Interface, so I imported directly into the tables. I think that is much easier. I am importing into SQL Server and so used SSIS. It's pretty slick once you get it set up. For dropdowns you need to remember to import the actual value, not the display value.