Just letting everyone know that Ian and I have resolved all 3 problems offline.
Problem #1 was due to the data being exported using the legacy export facility (Export/Tab-delimited TEXT file) instead of the new export facility (Export/Map Data). I'll log an enhancement request to make the selection less confusing. Problem #2 and #3 were due to a license issue. This will be addressed in InterMapper 4.4, where the server will give clearer error messages. Thank you, Ruth Kurniawati Dartware, LLC > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Ruth > Kurniawati > Sent: Wednesday, August 31, 2005 12:43 AM > To: [EMAIL PROTECTED] > Cc: "InterMapper Discussion" > Subject: Re: [IM-Talk] Data export and import problem > > Ian: > > Can you send me the import files that you used in #1, #2 and #3? > > I could not reproduce the import failures you described in #2 > and #3 using InterMapper 4.3.2 -- Please find attached the > zip file that contain the import files that I used (test2.txt > for problem #2 and test3.txt for problem #3). > > I am not sure what might have caused problem #1. From your > description, it looks like you exported fields from the > devices table. User is not a field in the devices table -- I > have verified that this field did not appear when I exported > all fields in the devices table on my machine. > > Currently, exporting all fields from the Devices and > reimporting them back may not work since some of the exported > fields may be null (empty). You will also get various > warnings for the read-only fields. However, the import should > not fail due to non-existing field. > > I suspect the problem may be related to the character set / > locale that is being used on your machine. Can you let me > know if you are using a localized / Japanese version of Mac OSX 2.8? > > Thanks, > Ruth Kurniawati > Dartware, LLC > 1-603-643-9600 > > --- You wrote: > 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] > --- end of quote --- > > ____________________________________________________________________ List archives: http://www.mail-archive.com/intermapper-talk%40list.dartware.com/ To unsubscribe: send email to: [EMAIL PROTECTED]
