x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 10 replies
  • Subscribers 107 subscribers
  • Views 9586 views
  • Users 0 members are here
Browse Forums
Announcements
289
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
43
topics
90
replies
Payroll, Time Tracking, and Job Cost
775
topics
1k
replies
Reporting and Analytics
960
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
Sean M

Error 88 in program VI_IMPORT_UI.PVC

Posted By

So, I am not new to Sage 100 ERP, but I have not done too much with it. 

I am setting up a new server for a client, and I am trying to import awn item list into CI_Item, I got the import to go when I severely truncated the import data and list. Only about 250 of the 12000+ items went in.

I am trying to import all of the item, having retooled the spreadsheet to better fit what Sage wants.

I keep getting the same error, and I cannot get any items to actually import. Both on test and on accept.

I can post any information that you need, and I have full admin access and rights, both on my Sage user, as well as my Windows user. Also ADMINISTRATOR account access to Sage and the server.

Follows is the information I could easily pull. Time in ample, but I have a client who would really like to start using the product they have paid for.

Thanks!!

Error 88 in program VI_IMPORT_UI.PVC at line 1285

More Info:

Error #88: Invalid/unknown property name

Program VI_IMPORT_UI.F Line 1285

Program Stack:

00032C:\Sage\Sage 100 Advanced ERP\MAS90\VI\VIWI04
00550C:\Sage\Sage 100 Advanced ERP\MAS90\home\lib\_nomads.pvc
07120C:\Sage\Sage 100 Advanced ERP\MAS90\home\lib\_winproc
00040C:\Sage\Sage 100 Advanced ERP\MAS90\home\lib\_winproc.xeq
00360C:\Sage\Sage 100 Advanced ERP\MAS90\VI\VI_Import_UI.pvc
01285C:\Sage\Sage 100 Advanced ERP\MAS90\VI\VI_Import_UI.pvc
01030C:\Sage\Sage 100 Advanced ERP\MAS90\soa\SWERRW
02010C:\Sage\Sage 100 Advanced ERP\MAS90\soa\SWERRM
07072C:\Sage\Sage 100 Advanced ERP\MAS90\home\lib\_winproc
02100C:\Sage\Sage 100 Advanced ERP\MAS90\soa\swerrm

Global Flags:

%system_32 = 1
%sys_windows_version = 602
%sys_yr2000_default = 30
%sys_original_fid$ = 0
%sys_session = 1
%sys_system_option$ = "NYNN "
%sys_winprt_default$ = "*WINPRT*;Foxit Reader PDF Printer"
%sys_os_nt = 0
%sys_launch_hwnd = 721588
%sys_os_csnt = 1
%sys_cse_hwnd = 0
%sys_os_wdx = 1
%windx_port$ = ""
%sys_host_port$ = ""
%sys_host_ipaddr$ = ""

  • 0

    Forgot to mention, Sage ERP 100 2014 Update 5 (occurred on update 4 too).

  • 0

    Did you check the "On Host" which is on the Configuration tab?

  • 0 in reply to Maureenil

    I have tried with the box checked and unchecked both on and off the server (workstation instance).

  • 0 in reply to Sean M

    Error 88 occurs when the property or method name of an object is invalid, or the parameters passed to a method call are incorrect. Have you created any required fields with the CI_Item table or are there any developer enhancements?  If not, try to change the spreadsheet to a .csv file and import the job as a .csv source type.  It should be fairly easy to test.  

    If that works you probably have an issue with excel. The source file could be in a Microsoft Excel 2007,10,13 format (.xlsx file extension), and that version of Microsoft Excel is not installed on the workstation. Try either Running the import job from a workstation that has Microsoft Excel installed or Install Microsoft Excel on the workstation, and start Microsoft Excel at least once before running the import job to update the registry keys.

    If running the .csv file fails, you could have a problem with the VI Job log file.  The MAS90/MAS_SYSTEM/VI_JobLog.M4T could be corrupted.  Try renaming and then manually Reinitialize the MAS90/MAS_SYSTEM/VI_JobLog.m4t

    Good Luck!

    Van

  • 0 in reply to VanMan

    When I try a csv, xls, or any other format, I get an "Unable to open" error referencing the file a

    attempting to import.

    Excel is installed on both workstation and server, otherwise the xlsx would not be allowed from that location. It is the same installation that the spreadsheets are created from.

    I can rename the file, but I do not know how to re-initialize the file. Also, attempting to reinstall (repair) the installation does not appear to fix the issue, or re-initialize the file(s).

    More ideas?

    Anyone?

    Bueller?

    Thanks

  • 0 in reply to Sean M

    Ruling out some dumb things...CSV is always better, IMO.  Make sure the file isn't open and that it doesn't have special characters in its name.

    Sincerely, Bueller

  • 0 in reply to Rsmcnamara

    CSV does not work, simeply fails, cannot open file. The file is not open. No special characters, just the name import.

  • 0 in reply to Sean M

    Sean - the csv will not work with the first import, as you chose an excel option as your File Type on the Configuration tab, and once the import is used, you cannot change the file type.  

    SO - just copy the current import, but change the File Type on the new version to Delimited - and then try the csv file.  I'm betting it will work just fine for you.

  • 0 in reply to Maureenil

    I have multiple import jobs. Two for CSV, one for XLS, and three for XLSX.

    They do not work.

  • 0 in reply to Sean M

    Sounds like the MAS90/MAS_SYSTEM/VI_JobLog.M4T could be corrupted.  Try renaming and then manually Reinitialize the MAS90/MAS_SYSTEM/VI_JobLog.m4t After renaming the file go into LM/Utilities/Reinitialize Data files.  Click Ok then click on the "Manual" button in the upper right screen. When prompted with a field for file name, type VI_JOBLOG.M4T and press enter, it should come up with the description" VI Import Job Log" and the current company code.  If so, click proceed. You should now have a new VI_Joblog,.m4t file in the folder where you renamed the old one.  Then try an import.

*Community Hub is the new name for Sage City