Hello
Please forgive the length of this mail. I'm trying to include as much
information about my problem as possible.
I'm having some problems exporting and importing data. If someone can give
me a clue to where I'm going wrong I'd be grateful.
1. As suggested in the manual I exported data from my map as tab delimited
text. However when I try to re-import that same information without any
amendment at all I get the following error:
"Unable to import map data
Field User doesn't exist in the table devices"
It seems very strange that Intermapper can't import data that it, only
seconds ago, exported.
2. So I thought I'd try to do an import test using data taken directly from
the Intermapper help files ("Importing Data Into Maps").
The help files state:
"The recommended format for creating an import file is a spreadsheet style
format, in which the first line contains tab-separated column names that
correspond to the remaining rows:
Name MapName Address
Machine1 Map1 192.0.0.1
Machine2 Map1 192.0.0.2"
So I tried to import the following tab-delimited data (File -> import -> map
data):
Name MapName Address
Machine1 Map1 192.0.0.1
Machine2 Map1 192.0.0.2
I got the following error:
"Unable to import map data
2 errors
Insert operation failed, check CREATE field valuesDelete operation failed (2
total errors)
Please consult the error log for details"
The error log contains the following:
08/31 10:53:07 impt Importing from file test1.txt: Starting ...
08/31 10:53:07 impt Import operation: Insert (reason: insert directive is
specified).
08/31 10:53:07 impt Import warning: read-only fields will not be modified:
Name
08/31 10:53:07 impt Import Directive - Format=tab Table=devices,
Fields=Name,MapName,Address.
08/31 10:53:07 impt AssignFieldFlags failed: Name Field cannot be used as
insert field, will attempt to use as modify field instead
08/31 10:53:07 impt Map Map1 - Failed to create device using improbe
string improbe://192.0.0.1/com.dartware.automatic.
08/31 10:53:07 impt Map Map1 - none of the given insert field can be used
to create a device.
08/31 10:53:07 impt Map Map1 - Failed to create device using improbe
string improbe://192.0.0.2/com.dartware.automatic.
08/31 10:53:07 impt Map Map1 - none of the given insert field can be used
to create a device.
08/31 10:53:07 impt Importing from file test1.txt: Error: 2 errors: Insert
operation failed, check CREATE field valuesDelete operation failed (2 total
errors)..
Why can't Intermapper import this data?
3. On the same help page in the section titled "Import File Example" it says
"Below is an example of an Import file. This file specifies itself as a
tab-delimited file containing a list of devices. All devices are going into
the map named "MapA", and each device definition contains Address, Probe,
Latitude, and Longitude columns.
# format=tab table=devices fields=MapName,Address,Probe,Latitude,Longitude
MapA 192.168.2.100 http 43.3 -72.0
MapA 192.168.2.101 http 43.9 -72.3
MapA 192.168.2.102 http 43.8 -72.8
MapA 192.168.2.103 http 43.0 -72.4
MapA 192.168.2.104 http 43.2 -72.3
MapA 192.168.2.105 http 43.6 -72.2"
So I tried to import that the same way but that failed too with the
following error:
"Unable to import map data
6 errors
Insert operation failed, check CREATE field valuesDelete operation failed (6
total errors)
Please consult the error log for details"
The error log contains the following:
08/31 11:05:35 impt Importing from file test2.txt: Starting ...
08/31 11:05:35 impt Import operation: Insert (reason: (using all fields)
-- the default operation when the insert/modify/delete directive is not
specified).
08/31 11:05:35 impt Import Directive - Format=tab Table=devices,
Fields=MapName,Address,Probe,Latitude,Longitude.
08/31 11:05:35 impt AssignFieldFlags failed: Probe Field cannot be used as
insert field, will attempt to use as modify field instead
08/31 11:05:35 impt AssignFieldFlags failed: Latitude Field cannot be used
as insert field, will attempt to use as modify field instead
08/31 11:05:35 impt AssignFieldFlags failed: Longitude Field cannot be
used as insert field, will attempt to use as modify field instead
08/31 11:05:35 impt Map MapA - Failed to create device using improbe
string improbe://192.168.2.100/com.dartware.automatic.
08/31 11:05:35 impt Map MapA - none of the given insert field can be used
to create a device.
08/31 11:05:35 impt Map MapA - Failed to create device using improbe
string improbe://192.168.2.101/com.dartware.automatic.
08/31 11:05:35 impt Map MapA - none of the given insert field can be used
to create a device.
08/31 11:05:35 impt Map MapA - Failed to create device using improbe
string improbe://192.168.2.102/com.dartware.automatic.
08/31 11:05:35 impt Map MapA - none of the given insert field can be used
to create a device.
08/31 11:05:35 impt Map MapA - Failed to create device using improbe
string improbe://192.168.2.103/com.dartware.automatic.
08/31 11:05:35 impt Map MapA - none of the given insert field can be used
to create a device.
08/31 11:05:35 impt Map MapA - Failed to create device using improbe
string improbe://192.168.2.104/com.dartware.automatic.
08/31 11:05:35 impt Map MapA - none of the given insert field can be used
to create a device.
08/31 11:05:35 impt Map MapA - Failed to create device using improbe
string improbe://192.168.2.105/com.dartware.automatic.
08/31 11:05:35 impt Map MapA - none of the given insert field can be used
to create a device.
08/31 11:05:35 impt Importing from file test2.txt: Error: 6 errors: Insert
operation failed, check CREATE field valuesDelete operation failed (6 total
errors)..
If anyone can tell me where I'm going so wrong, I'd be very grateful. Or if
anyone can give me some sample data that won't throw up errors when I try to
import it that would be great too.
Thanks
Ian Masters
p.s. Intermapper Console version info: 4.3.2 (Build 57222) running on Mac
OSX 10.2.8
____________________________________________________________________
List archives:
http://www.mail-archive.com/intermapper-talk%40list.dartware.com/
To unsubscribe: send email to: [EMAIL PROTECTED]
