Excel Mapping Tool-import to Vendor Bank Account w/Excel07

phill01
Member Posts: 10
User is trying to import using the Excel Mapping Tool to the Vendor Bank Account Table (288).
Import starts but we then get no messages and the import does not bring any data into table.
In addition, Excel remains in the task manager. (Similar to another post on exporting data).
We are on 4.00 SP3 and can successfully import to other tables (we did the Vendor table - 23 earlier today).
I ran the import in debug mode and found within code unit 8601 (Mapping Handle) the system is finding the workbook. It only has one sheet we want to import from, so it is hitting the "If not Multiple Import" logicof the Sheet Imported function.
When it gets to the test If ISCLEAR(XLApp) the value is Unknown Automation Server.Application.
It gets into the SheetActivated function but the found value remains at 'No'. It then gets into the SETRANGE logic of the FORM 8601.
Can anyone help on this? I believe I read somewhere that a form should not be "SHOWN" in another post?
Update: The user exported this table using the Excel Mapping Tool to a spreadsheet. It exported fine. He then took the file that the mapping tool created, put the information into it that he originally tried importing (including adding some columns) used it as the source for the Excel Mapping Tool import and it worked fine. We don't know why, but it is a workaround.
Import starts but we then get no messages and the import does not bring any data into table.
In addition, Excel remains in the task manager. (Similar to another post on exporting data).
We are on 4.00 SP3 and can successfully import to other tables (we did the Vendor table - 23 earlier today).
I ran the import in debug mode and found within code unit 8601 (Mapping Handle) the system is finding the workbook. It only has one sheet we want to import from, so it is hitting the "If not Multiple Import" logicof the Sheet Imported function.
When it gets to the test If ISCLEAR(XLApp) the value is Unknown Automation Server.Application.
It gets into the SheetActivated function but the found value remains at 'No'. It then gets into the SETRANGE logic of the FORM 8601.
Can anyone help on this? I believe I read somewhere that a form should not be "SHOWN" in another post?
Update: The user exported this table using the Excel Mapping Tool to a spreadsheet. It exported fine. He then took the file that the mapping tool created, put the information into it that he originally tried importing (including adding some columns) used it as the source for the Excel Mapping Tool import and it worked fine. We don't know why, but it is a workaround.
0
Answers
-
Thanks for your response. It's odd that we didn't have to do this for all tables, but it's great to have additional information on what is happening with the tool.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K 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
- 320 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