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

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?

Top Replies

0 CVU 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$, "yyyyMMdd", System.Globalization.DateTimeFormatInfo.InvariantInfo)" />
</Columns>

(...)
Cancel
Up +1 Down

Reply

Verify Answer

Cancel
0 Markus Weiss-Ehlers over 3 years ago

I can validate the error from the syntax highlighting. But 8.1.5 shows a similar thing, it states "Namespace member declaration expected".

Is it just, that the error wave is shown, or does it not work in the end?
Cancel
Up +1 Down

Reply

Verify Answer

Cancel
0 denny breuer over 3 years ago in reply to Markus Weiss-Ehlers

It does not work, because the statement will not be stored.
Cancel
Up +1 Down

Reply

Verify Answer

Cancel
0 Markus Weiss-Ehlers over 3 years ago in reply to denny breuer

Okay. If so, then please contact support. Thank you.
Cancel
Up +1 Down

Reply

Verify Answer

Cancel