x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 5 replies
  • Subscribers 59 subscribers
  • Views 5506 views
  • Users 0 members are here
Browse Forums
Announcements
268
topics
260
replies
Databases and Operating Systems
755
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
849
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
182
topics
407
replies
J-Y

Sage 300 OE IMPORT SCRIPT

Posted By

II need to import OE from an external application. Spent many hours trying to create a valid script without success. I am not using serialized or lotted items but the import function keeps looking for them even though System Information does not list these modules?? It is a shame the documentation is practically inexistent for such important function.

Q1: Instead of reinventing the wheel I was wondering if someone would be willing to share or sell a working OE import script that I can use as a starting point?

Q2: Which file format is easier to use? Single CSV or Individual CSV/XLS files?

Q3: Has anyone successfully created a macro to run OE imports? 

My environment is Sage 300 v2104 SP1 (SQL Server 2008 R2)

Parents
  • 0

    Hi J-Y, not sure if you've resolved this as yet or not, but, our OE Host Interface does exactly this. While our import formats are hierarchical they are declarative and if matched with our external EnableSCRIPT utility, files can be picked up remotely, logged and transformed. The script will also prepare each file for presentation to the Host Interface.

    The OE Host Interface itself has a large number of options for each import template and is highly declarative.

    The import can be run automatically or manually and during import, audit logs are created.  

Reply
  • 0

    Hi J-Y, not sure if you've resolved this as yet or not, but, our OE Host Interface does exactly this. While our import formats are hierarchical they are declarative and if matched with our external EnableSCRIPT utility, files can be picked up remotely, logged and transformed. The script will also prepare each file for presentation to the Host Interface.

    The OE Host Interface itself has a large number of options for each import template and is highly declarative.

    The import can be run automatically or manually and during import, audit logs are created.  

Children

*Community Hub is the new name for Sage City