[Vtigercrm-developers] Importing data from CSV(created time, modified time, Assigned to) not working

Alan Lord (News) alanslists at gmail.com
Tue Aug 3 04:14:41 PDT 2010


On 03/08/10 12:05, Mutuku Ndeti wrote:
> Dear All,
>
> I have a csv file with data.  Among other fields, it has created time,
> modified time, Assigned to.  vtiger is importing created time as the
> current time and Assigned to as the current logged user, not as it is on
> the csv file. Is there a way I can import data into/from these fields?

I have successfully used the "Assigned To" field in a CSV so that one 
does work, not tried the created/modified time fields though.

You might well just have a typo in the csv. Check for trailing spaces 
which I discovered MSO seems to add with abandon in Excel.

I usually use OOo Calc and use the Trim() function to strip any leading 
and trailing whitespace.

HTH

Al


-- 
The Open Learning Centre
http://www.theopenlearningcentre.com




More information about the vtigercrm-developers mailing list