Dataport limitations

DenSter

Is anyone aware of any dataport limitations? One of my clients has a Customer dataport, and the maximum number of fields seem to be 34 fields. Once I run the dataport with the 35th field, I get a fatal application error and it throws me out.

This happens in both C/SIDE and SQL Server option.

Daniel.

Luc_VanDyck

Maybe it's the line length that is the limitation. Are you exporting or importing data?

Sbhat

Hi,

Use 'Integer' as the DataItem and then you will not have any limitations on Dataport fields. Yes, you will have to write code but a clean way of doing the Dataports.

Regards
Suresh.

DenSter

I'm importing fields into the customer table. There are no custom fields. My client wrote the dataport themselves, and they are importing into variables and then validating the fields using the variable values, because for some reason they could not make auto-validation work.

By the way, I also tried it in a standard Navision database, and it does the same thing.

Suresh, so you're saying that you know of these limitations? If you do, what are they?

StephenG

Hi

I have created Dataports with 100 fields, with no problems, without using the Integer table as a dataitem.

Importing into Variables, doing checks/Validation on the variables then assigning to the appropiate fields to insert/modify.

I don't know what type of file you areading from, But i tend to use MSDOS (Text) type files which are Tab delimited,
On the Datatport
Set FieldStartDelimeter = <None>
FieldEndDelimeter = <None>
FieldSeperator = <TAB>

eromein

Sounds like Navision....

"Navision... the 35th field is the limit."



Yeah well... how need that sky anyways...