mibuso.com

Hey guyz,

I created a dataport to import some information from a csv file.

It creates a No. for the record but it doesnt import any of the information. All the fields are left blank.

I tried debugging it, it doesnt seem to read any of the information from the excel file. All the fields from the excel file are blank in the debugging mode.

I have created all the variables in the C/AL Global, and Dataport fields. I have set import to yes, FileFormat to variable, FieldSeperator to , ,Record and dataitem seperator to NewLine. I have set AutoSave, AutoUpdate, and AutoPrelace to YES.

I dont know what else I could be missing. All the code I have written is in OnAfterImportRecord.

Any idea why it might be doing wrong since it doesnt seem to read the csv file???

Is importing one line or no lines just to clarify. What trigger of the data port do you have that code on. Check the keys of the table your importing to so you know your covering all the "main" fields /ie "line no."

I also see in your code your simply assigning an imported value to nav fields without using VALIDATE to fill in the values.

The csv file has alot of line. Each line in the csv file is one record.

Trigger - OnAfterImportRecord()

The Table key is "No." field. What would I have to with the key field of the table??

I have to validate the values...i didnt know that. The last dataport I created, i never validated all the values and the dataport worked fine.

When I create a dataport I import all fields into variables and map them back to nav fields.
I import them in the order you would naturally manually enter them. Validating where needed. You can always throw a message on the code , say after you get the " no." fields throw MESSAgE('%1',"no.");
To see if it's even picking up the value. Then that helps you find the problem. It will either be while importing or after importing. Then you can narrow you focus.

You also say you don't validate, even in the past. The best check I can do to find out if a data port is working 100% is to import 1 line. Then manually enter one line. View the table for those two lines , they should one on top of another. If the data port is filling all the fields just like the manual entry then you can start feling good about the port.

Thats the thing, the dataport is not picking up the values from the csv file. It leave all the fields blank. Even when I try to debug the code, all the variables are blank even when its is in the OnAfterImport trigger.

I am not sure why they are blank.

I took out all the other lines from the CSV file except one and its still empty. It creates a Job No. for that line. But the rest of the line is blank. None of the information gets imported.

Try losing the insert( true).
Since I can't See i have ask if you've filled in the data port fields.
You also say it finds nothing then you said it imported just the "no."
Please be specific on exactly what's happening

Are you importing into your own global variables and mapping back?

I got rid of the True, and still nothing.

No. field is increment using a No. Series. Before a record gets inserted into the database, it has its own unique No.

Each line in the CSV file will have a unique No. field (this will help us differentiate between different records).

After the unique No. has been created using the No. Series, information from the CSV file is suppose to be assigned to different variables in that table.

I have created global variables and I am mapping back to them.

Are you sure your getting the number series properly? Search the forum for " dataport number series" for examples.
Also, make sure your trigger you are using is correct and nothing on the others

The No. series is working fine. Its creating a new (unique No.) for each line in the csv file. Its just not copy the information from the file and inserting it in the table.

Try changing
"Fixed Asset"."No." := "no.";
To "Fixed Asset".validate(No.",yourNOvariable);
Do you get a message?

Also in your code I see nothing about getting a number series? Why?

I'm not at a computer right now so it's hard to visualize the fixed assets table.
You said you've made data ports before, with what I told you you should be able to figure out the problem.

I don't understand what you are asking here. You do realize when importing into a table filling the key fields is a big deal. You need to validate more. Check the application designers guide that comes with the product. It has a section on dataports.