We recently upgraded to the latest version of Import-o-matic [2.1]
After creating a tab delimited import file with a header via BCP and successfully importing the generated file manually. I am having difficulty getting it to work from the command line.
The following command is what I have not been able to run successfully, it keeps giving exceptions on the whole file, this same file works correctly when doing the import manually:
Can you please tell us what the exceptions are that you are receiving when you attempt to run the import via The Scheduler?
Thanks!
Tiffany
S
Scott Hall
said
over 9 years ago
HI Tiffany!
Thanks for the reply, below is the Exception file...
IOM Version: 2.1.1.0 RE Version: 791.5056.28 Profile: [ProfileName] REImport Error File Import File: [\\UNC\Path\file.tab] Master ID Source: Raiser's Edge
Line 1: Number of fields in this data row (1) does not match number of fields profile (3). Line 2: Number of fields in this data row (1) does not match number of fields profile (3). Line 3: Number of fields in this data row (1) does not match number of fields profile (3). Line 4: Number of fields in this data row (1) does not match number of fields profile (3). Line 5: Number of fields in this data row (1) does not match number of fields profile (3). Line 6: Number of fields in this data row (1) does not match number of fields profile (3). Line 7: Number of fields in this data row (1) does not match number of fields profile (3). Line 8: Number of fields in this data row (1) does not match number of fields profile (3). Line 9: Number of fields in this data row (1) does not match number of fields profile (3). Line 10: Number of fields in this data row (1) does not match number of fields profile (3). Line 11: Number of fields in this data row (1) does not match number of fields profile (3). Line 12: Number of fields in this data row (1) does not match number of fields profile (3).
T
Tiffany Theissen
said
over 9 years ago
Hi Scott,
I am sorry you are encountering a more complicated issue! In order to properly assist you with this particular issue, I will need to examine the following files: the data file, the error.txt, and the IOM profile being used for this import. Please send these files to Support@omaticsoftware.com so that I can better assist you with your issue. When I have a resolution, I will post to this thread.
Scott Hall
We recently upgraded to the latest version of Import-o-matic [2.1]
After creating a tab delimited import file with a header via BCP and successfully importing the generated file manually. I am having difficulty getting it to work from the command line.
The following command is what I have not been able to run successfully, it keeps giving exceptions on the whole file, this same file works correctly when doing the import manually:
"C:\Program Files\Blackbaud\The Raisers Edge 7\Plugins\iom.exe" -d=1 -p=[ProfileName] -f=[\\UNC\Path\file.tab]
* The command line tool was working properly with Import-o-matic version [1.9]
Is anyone else having trouble from the command line with the new version?
Thanks for your time,
Scott