Command Prompt Imports
A batch file can be created to invoke Spire’s import routine. Some examples would be:
· Un-compatible web stores or other order entry systems.
· External manufacturing systems by importing inventory adjustments
· New customers added in “Contact Manager Software”
· Payroll data from an external timeclock
Use this in the command prompt from C:\Program Files (x8x)\Spire\Desktop
spire -H Servername -c InSpireHealth -u spire -p 12345 -m spireapp.importer.main --config c:\import\invadj.ini --source c:\import --dest c:\import --fail c:\import
-H is the name of the server to look for the database. Leaving this out assumes locahost
-c is the database name from SpireTray on the server
-u is the user name (all settings from the user will be used)
-p is that user’s password
-m is the module to launch (spireapp.importer.main is the import module)
--config points to the ini file (note we use 2 - not a long - )
--source is the source file to import
--dest is where the successfully import Excel or csv file moves to.
--fail is where an unsuccessful import file goes.
· If the .ini file is set to point to a folder as its source instead of a file name, all files that appear in that folder will get imported.
· The batch file that is created can then we run from the Windows Task Scheduler to automatically run at set intervals or double clicked and run at will. (Be sure to set the permission of the Task Scheduler to allow the import to be run when not logged in)
NOTE: Spire does not offer support on this command line import routine. Partners that attempt this MUST have a good knowledge of creating batch files and setting up MS Windows Task Scheduler.