Skip to Content
author's profile photo Former Member
Former Member

Date field conversion in Import Manager

Hi,

I am getting the source Date field as 'Text' type and want to convert it to Date type.

Is it possible in import Manager?

What are the best way to manage the issue.

Appreciate your reply

regards,

reo

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2006 at 10:57 PM

    Hi Reo,

    You define to destination field as Date Type then you can map the field

    Source (type:text) to destination (type:date).

    In the import manager you determine your date import formate in the import Configuration window e.g YYYMMDD or DDMMYYYY etc

    You can then convert to text by right clicking on the source field and converting to Original Value

    Hope this helps

    Con

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 01:39 PM

    Hi reo,

    I think u have not manually converted the date values before importing. You need to convert the text field into destination literal date in the bottom pane after mapping it and before importing.

    Thanks,

    Minaz

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 10:17 AM

    Hi,

    Initially you have to map the two fields at source and destination side,then you will have to manually do the value mapping for destination field .

    I hope this will help you.

    Regards

    Nisha

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 07:26 AM

    Hi Reo,

    The data types of source data values are automatically

    converted within the Source Values grid based on the data type of the

    destination field to which the source field is mapped, even when stored

    in the source data as text values.

    Original source values appear with their original data type in the Value

    column, and the converted values appear in the Converted Value

    column with the data type of the mapped destination field and the

    proper grid cell type for editing (e.g. text, numeric, measurement,

    currency, date, time, Boolean).<i> If necessary, individual values can then

    be manually edited to override errors or omissions in the source data.</i>

    Regards

    Neethu Joy.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.