Paste from Excel into NAV - works on a TABLE - not on a PAGE
awarn
Member Posts: 261
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?
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?
0
Comments
-
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..0 -
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.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 323 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
