Wednesday, June 8, 2011

Exact Globe - asimport.exe

  • Make sure the file asimport.exe is in the Exact Software/globe/bin directory or to where you installed the Globe Application.
  • The syntax of the ASIMPORT.EXE statement:
    • to transfer humres data from Globe to Synergy
      • ASIMPORT.EXE -rglobeDBsqlServerName -DglobeDBname -u -~ E -URLsynergyWebAddress    -Tresources -OPT22 –Oauto
    • to transfer GL Accounts data from Synergy to Globe
      • ASIMPORT.EXE -rglobeDBsqlServerName -DglobeDBname -u -~ I -URLsynergyWebAddress    -Tglaccounts –Oauto
  • - Careful with the E and I switch. ( E - stands for export, I - stands for import)
    - The parameters (in blue) are case sensitive, for safety reason, test it without -Oauto first before actual scheduling.
    - It is not possible to use filters (ex: Year, Period, Journal, Entry number) in the command line, that is why i'm not using this approach is most cases. Instead, I'm using Exact.Jobs.FinExchange or XML / Financial  Export module of Globe. I will have a separate blog on AsImport.exe and Exact.Jobs.FinExchange

    - Here is the actual command with the following assumptions :
         * globeDBsqlServerName = GlobeServer
         * globeDBName = 555
         * synergyWebAddress = http://HQServer/Synergy

    ASIMPORT.EXE -rGlobeServer -D555 -u -~ E -URLhttp://HQServer/Synergy -Tglaccounts –Oauto

  • To synchronize the data between Globe and Synergy or vice-versa properly, certain criteria are required, I suggest reading this document: 01.457.694 (How-to: Scheduling Import and Export of Data between Exact Globe and Exact Synergy / Exact Synergy Enterprise) thoroughly in order to get the replication up and running. Pay attention to the front office application (Synergy Classic or Synergy Enterprise) you are using, because when installing Globe, the default setting is set to Exact Synergy (also known as Synergy Classic).  To check this, go to System/General/Settings/General settings in Exact Globe. Under Exact Synergy Options, select the appropriate Synergy version you belong.
Related Blog : http://anthonyexactglobe.blogspot.com/2011/06/where-to-best-run-asimportexe-windows.html
    Posted by at
    Labels:

    5 comments:

    1. UnknownFebruary 13, 2016 at 12:03 PM

      Hi!, does anybody have idea if possible to open
      Sales Order via Command Line using Sales Order Numnber as parameter? Kindly share. Thanks.

      Jun Jopia

      ReplyDelete
    2. AnonymousApril 16, 2017 at 12:22 PM

      Hi Eli,

      Can you please try this:
      "C:\Program Files (x86)\Exact Software\bin\EOENTRY.exe" -p1 -f652180 -r"SERVERNAME" -D"DBNAME" -u -d42841 -T0 -~ ON

      am using EGN413. hope this helps.

      ReplyDelete
    3. AnonymousJuly 17, 2017 at 4:56 PM

      Hi there,

      I was asking myself exactly the same question as Eli. When I try to run EOENTRY with the proper database values, I get an empty order form.
      Where do I have to fill in the order number? If I understand correctly this may open the order form. How could we use this to create a xml file?

      Please reply

      ReplyDelete
    4. AnonymousAugust 4, 2019 at 7:02 PM

      Hi,

      Is it necessary to have Exact Globe to be installed on the computer from where you're running ASImport? I copied the whole bin folder from an installed machine to the machine from where I want to run ASImport, but it doesn't work. I don't get any errors.

      Thanks.

      ReplyDelete
    5. AnonymousOctober 11, 2024 at 10:35 AM

      Thanks and that i have a nifty give: What Does A Full House Renovation Cost homes to renovate

      ReplyDelete

    Subscribe to: Post Comments (Atom)