[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