Paste from Excel into NAV - works on a TABLE - not on a PAGE

awarn

Hi,

I have a situation where I'd like to have the customer select a few rows from excel, and paste them into an editable list or worksheet page.

If I run the table directly (this is a new table, custom fields, no triggers), I can copy from excel and then paste into the table. Works fine.

If I run either an editable list page or a worksheet, with MultipleNewLines set to Yes in either case, I get an odd error. I am right clicking on the grid and pressing Paste Rows. I can see one record that appears inserted, but then when I tab off I see the error:
'The Code type of a key field cannot be automatically split'

I do not have autosplitkey set, and the PK of this table is only one field (a code field).

Again, if I run the table, I can paste right in.

This is R2, and my exact situation is that a customer has an excel sheet with a list of orders for fuel delivery. At the end of the day, the drivers update the excel sheet with the actual quantity delivered (regardless of what you order you cannot be delivered the exact # of liters or $$ amount). I want to bring this into nav - I could use rapidstart or an import, but it would be so simple if I could have a temporary screen with order #, actual liters and actual $$ as three fields, and just copy / paste from excel, and then I can run a routine to use this information to update my sales orders. I do not want to run the table to paste - it would be ideal and so easy for the client if I could find a way to copy / paste from excel.

Hopefully I am missing something stupid - has anyone seen this before?

mohana_cse06

What are the all fields available in table?
Are all fields from table shown on Page and are in Order as in excel?

Each field will be validated after value is pasted in fields..

awarn

I must have been missing a field in the excel sheet - I created a new table / page to test with less fields and now it works fine.