• State Not Answered
  • Replies 4 replies
  • Subscribers 95 subscribers
  • Views 2843 views
  • Users 0 members are here
Options
Related

Data Importer - Conversion Script - Import statemants, assembly .....

denny breuer
over 3 years ago

Hi,

I need to import some user and the date is a simple string. So converting this to date time should no big deal, but I can´t put my script in the script field. It says: "Imports statements, ass.... expected". Event the excample from 5 month ago shows the same error.

We are running a brand new 8.2 installation.

My conversion is:

Value = Date.ParseExact($sxValidFrom$, "yyyyMMdd", System.Globalization.DateTimeFormatInfo.InvariantInfo)

But also the longer Version does not work:

Dim EntryDate As Date
EntryDate = Date.ParseExact($sxValidFrom$, "yyyyMMdd", System.Globalization.DateTimeFormatInfo.InvariantInfo)
Value = EntryDate

It directly starts complaining after "DIM". Any Idea what i´m doing wrong?

Parents
  • 0 over 3 years ago

    Seems like a bug to me. I've noticed some issues regarding modal windows in the new version,aside this one. You should contact support.

    I've created an import definition file and noticed it won't store the scripts at all. Tested the same on 8.1.3 and it works fine.

    As a workaround you could try an edit the script directly in the .xml file. That would help a bit:

    (...)

    <Columns>
    <Column Definition="CentralAccount" IsKey="True" FixValue="" SourceColumn="Usuario" ConvertScript="" />
    <Column Definition="BirthDate" IsKey="False" FixValue="" SourceColumn="Fecha" ConvertScript="Value = Date.ParseExact($1$, &quot;yyyyMMdd&quot;, System.Globalization.DateTimeFormatInfo.InvariantInfo)" />
    </Columns>

    (...)

Reply
  • 0 over 3 years ago

    Seems like a bug to me. I've noticed some issues regarding modal windows in the new version,aside this one. You should contact support.

    I've created an import definition file and noticed it won't store the scripts at all. Tested the same on 8.1.3 and it works fine.

    As a workaround you could try an edit the script directly in the .xml file. That would help a bit:

    (...)

    <Columns>
    <Column Definition="CentralAccount" IsKey="True" FixValue="" SourceColumn="Usuario" ConvertScript="" />
    <Column Definition="BirthDate" IsKey="False" FixValue="" SourceColumn="Fecha" ConvertScript="Value = Date.ParseExact($1$, &quot;yyyyMMdd&quot;, System.Globalization.DateTimeFormatInfo.InvariantInfo)" />
    </Columns>

    (...)

Children
No Data