Import txt file and autonumber

ROBO

I want to import txt files with a dataport and then use autonumber. But the problem is when I use autoincrement in my table and there are more lines in the text file the line are overwritten. Can someone help me?

ThanX

Marije_Brummel

What kind of table are you populating?

I think you will either need to write some code or add the number to your importfile.

Savatage

Yes more info Needed...

But you can do

OnPreDataItem()
"Line No." := 1;
OnAfterImportRecord()
"Line No." := "Line No." + 1;

:?: :?: :?:

ROBO

ROBO wrote:

I want to import txt files with a dataport and then use autonumber. But the problem is when I use autoincrement in my table and there are more lines in the text file the line are overwritten. Can someone help me?

ThanX

The autonumber field is integer with autoincrement. In the dataport i wrote some code:

IF msgInfo.FIND('+') THEN
msgInfo."Nr." := msgInfo."Nr." + 1
ELSE
msgInfo."Nr." := 1;
INSERT(TRUE);

Savatage

="ROBO
The autonumber field is integer with autoincrement. In the dataport i wrote some code:

IF msgInfo.FIND('+') THEN
msgInfo."Nr." := msgInfo."Nr." + 1
ELSE
msgInfo."Nr." := 1;
INSERT(TRUE);

1) What trigger are you using.
2) Everytime it hits "ELSE" the number is "1" overwriting the previous "1" are you sure it's finding anything?
3) What table are you trying to bring this into?

Marije_Brummel

Please remove the autoincrement. This is not a realy relicable function. We've had some problems with this in the past.

ROBO

Mark Brummel wrote:

Please remove the autoincrement. This is not a realy relicable function. We've had some problems with this in the past.

If I remove autoincrement then automunber doesn't work

Marije_Brummel

Navision invented no. series for this. Please use either this or use code like in the other navision entry tables.

ROBO

Savatage wrote:

="ROBO
The autonumber field is integer with autoincrement. In the dataport i wrote some code:

IF msgInfo.FIND('+') THEN
msgInfo."Nr." := msgInfo."Nr." + 1
ELSE
msgInfo."Nr." := 1;
INSERT(TRUE);

1) What trigger are you using.
2) Everytime it hits "ELSE" the number is "1" overwriting the previous "1" are you sure it's finding anything?
3) What table are you trying to bring this into?

1) it's a dataport that must import text files (single line and multiline). After the import it delete the file.
2) I want to find the last number that is used
3) It is a self made table with "nr." as key (integer) this is the field i want the autonumber apply's to.

Thanx for your help

kriki

Mark Brummel wrote:

Please remove the autoincrement. This is not a realy relicable function. We've had some problems with this in the past.

Strange, because standard Navision uses this in T405:"Change Log Entry" field 1:"Entry No.".
But the field is a BigInteger, and not an integer.

kriki

ROBO wrote:

2) I want to find the last number that is used
3) It is a self made table with "nr." as key (integer) this is the field i want the autonumber apply's to.

Use this system:
Dataport - OnPreDataport():

msgInfo.RESET;
IF msgInfo.FIND('+') THEN
  intLastUsedNo := msgInfo."Nr.";

OnAfterImportRecord();

intLastUsedNo += 1;

Like this, you do the read for the last one only once.

Marije_Brummel

We've had some strange SQL error that was caused by the autoincrement property. I don't remember precisely what the error was.

ROBO

Hi Alain,

It imports the txt file but the line's get overwritten when its a multiline txt file. Do you have a solution for that also?

Thanx a lot

kriki

Mark Brummel wrote:

We've had some strange SQL error that was caused by the autoincrement property. I don't remember precisely what the error was.

Maybe it was with an Integer and not a BigInteger?

kriki

ROBO wrote:

Hi Alain,

It imports the txt file but the line's get overwritten when its a multiline txt file. Do you have a solution for that also?

Thanx a lot

In case you do the INSERTS yourself, when you start to fill (in general just after INIT or CLEAR of the record) a new record to be written, put the code I gave you.

DenSter

I think your dataport is mixing up the variables, or it's not setting the number in the right trigger. To take the whole thing into your own hands, you can import your text file into variables instead of the fields of your table directly, and then write the code to insert the records using the values of the variables.

ROBO

I don't insert it myself i use the dataport fields is it possible with this also?

ROBO

DenSter wrote:

I think your dataport is mixing up the variables, or it's not setting the number in the right trigger. To take the whole thing into your own hands, you can import your text file into variables instead of the fields of your table directly, and then write the code to insert the records using the values of the variables.

I never did this is there an example for this?

DenSter

where you enter fields into the dataport fields editor, you can also enter variable names. Then in the OnAfterImportRecord trigger you handle the values.

Savatage

ROBO wrote:

DenSter wrote:

I think your dataport is mixing up the variables, or it's not setting the number in the right trigger. To take the whole thing into your own hands, you can import your text file into variables instead of the fields of your table directly, and then write the code to insert the records using the values of the variables.

I never did this is there an example for this?

This is what I did on post: (As an example)
http://www.mibuso.com/forum/viewtopic.php?t=9631

I set it before anything happens & bring it back later
OnAfterImportRecord()Code:
Internet_Cust_Orig_Item := "No.";

Item.GET("Sales Line"."No.");

IF Item.Blocked THEN
BEGIN
"Sales Line"."No." := '99904';
END;

"Sales Line".VALIDATE("No.");
"Sales Line"."Qty. Ordered" := Internet_Cust_Qty;
"Sales Line".Quantity := Internet_Cust_Qty;
"Sales Line".VALIDATE("Qty. Ordered");
"Sales Line"."EDI Unit Price" := Internet_Price;

"Sales Line"."EDI Item Cross Ref." := Internet_Cust_Orig_Item;

---

Importing the data into vaiables & then assigning them to it's proper Navision Field OnAfterImportRecord, as Denster stated, always solves my dataport problems

ROBO

Denster & Savatage and everybody Thanx for your help. The variabele does the trick.

ThanX again

DenSter

Cool, glad you got it to work.

Veel plezier ermee

Jonathan2708

I had this problem, you need to add the following to the OnBeforeImportRecord() trigger of your Dataitem :

CLEAR(Rec);


Your autoincrement field will then work fine.

Jonathan