x Want to participate? Join the group to interact

  • How can I enable "Data Import Manager" module?

    How can I enable "Data Import Manager" module. It is greyed out when I try to enable. Is this an extra fee or something I need to download? Thanks in advance, Dan

  • Using Data Import Manager with SQL source connection

    Remember that you can use Data Import Manager to import data from any SQL Server data source. In this example I am using an SQL view (vdvBudgetAnalysis_COA) to import budgets from company COA to company SOA. Make sure that in your case it’s possible to…

  • Data import manager: Cannot create a multi-format text import job

    FormerMember
    FormerMember
    For reasons I won't go into in this post, I cannot use Excel as a source for my data imports. Because of that, I'm looking at other formats. I got a flat text file to work for a very simple import which had only one staging table, but now I'm looking…

  • Data Import Manager

    Hi, We have a vendor that sends us invoices in pdf and an xml file. To save the people in accounting some time, we are looking at importing the vendors invoice(s) into Sage 500. We have the Data Import Module. Is there an example of an XML file or…

  • access to database

    hello i want to access sage 500 database , i am creating an application where we get the data from the client and we are going to run few calculations and implement it on sage 500 thank you

  • Using Data Import Manager for importing Inventory Items

    We would like to use the DIM module to automate creating new Items in Sage500 - I have not had much experience using it and cannot find much documentation on how to use it - or - sample import files for creating Items in SOA - unlike the IM Import Utiltiy…

  • Invalid MAS_500_Admin user and password

    Hello, Sage City. I have a issue with the Data Import Manager module of the Sage 500 ERP. 2014 The Import Job Progress will become stuck after executing it. After cancelling the import, a message reads the step was canceled. The other message states…

  • Data Import Manager jobs - where do errors go?

    I have a set of data import manager jobs configured to run on a nightly basis. Basically the SSIS job schedule has been adjusted via SQL management studio to run every night instead of the one time schedule set up by DIM. All is working well in testing…

  • Data Import Manager Problem

    Import job to bring vendor invoices into Pending AP Vouchers had been running successfully for 10 months. The source file is Excel, and new rows (records) have been added from a different system that hadn't provided anything to import previously. Upon…

*Community Hub is the new name for Sage City