I am trying to import my Ecco phoneBook into an IQ file and I am running into several issues (Numbered 1-3).
I have several thousand items and I cannot show them all at once in Ecco (memory overflow), so I will have to import 25 times (once for each letter).
1. When I import the first letter, IQ imports all Ecco folders (many hundreds). They are not empty in Ecco, but they are not used for the PhoneBook items. IQ therefore creates hundreds of folders with 0 items. Can this be avoided?
2. When I import the next letter, all the folders are read again. No duplicates are created, but it takes 30-60 min each time. Can this be avoided?
3. I want to delete all the Ecco folders that have 0 items. In the Field Properties Dialogue, I can sort the Fields to show the Fields with 0 items on top.
A. How do I delete all the 0 item Fields all at once? There are several hundred (close to a thousand) and I can only select one at a time..
B. How do I avoid also deleting the IQ Fields that have 0 items (if I somehow could select all 0 item Fields at once)?
Comments
Hi viking, Importing only…
Hi viking,
Importing only relevant Ecco folders and multi-select for the manage fields dialog are both on the wish list
Thanks for reporting
Sounds great! Meanwhile, I…
Sounds great!
Meanwhile, I have been struggling with trying to copy PhoneBook data from my working file to a "clean" Ecco file and then importing to IQ.
I still come across issues:
1. The clean Ecco file still has a lot of folders that I can't delete? Do you know how to delete them by any chance?
2. In the "Manage Fields Dialog" I will still get a lot of Ecco Fields that I need to manage. The Field description shows that it is an Ecco Field, but there is no way to Filter for the description. I would like to rename all Ecco Fields by adding a suffix like _ECCO so that I can filter those. Any way to do this?
An option for prefix /…
An option for prefix / suffix to imported field names is a good idea !
Great! Another suggestion…
Great!
Another suggestion would be to have a Field Tree (matching the Properties Pane), but that may be more difficult to program? And also to have more than one level of the Tree (in both)?
1- A tree-view in the Manage…
1- A tree-view in the Manage fields dialog is planned
2- There are no limits to the field hierarchy in the Properties pane. Try it !!
2- Correct. No limits to the…
2- Correct. No limits to the field hierarchy in the Properties pane :-)
I tried to import 27…
I tried to import 27 selected PhoneBook items using the latest v119e into a new IQ database as a test (I have more than 1,000 PhoneBook items)
1. It took 16 min to import (IQ was not responding during this time). Most of this time was spent in Step 1: "Reading Ecco Folders...". I guess, Folders that will not be imported anyway?
2. Only relevant folders were imported with this version.
3. Only 25 of the 27 items were imported. I searched the whole file and they are not there.
4. I see six error Fields: Ecco_DDE_ERROR_, Ecco_DDE_ERROR_2, ...,Ecco_DDE_ERROR_5 (There was no Ecco_DDE_ERROR_1). Each of these error Fields have multiple items. What do these fields mean?
Hi Viking, Indeed, one of…
Hi Viking,
Indeed, one of the first steps is currently to get the list of all folders. On my test files / computer, it was a fast process. It is evidently not the case for you. What is your folder count in Ecco ?
It should be possible for me to avoid this step and read folder on demand, as items are imported
w.r.t. the error fields, you way want to ask Ecco... if it is returning an error for a folder, not much I can do. From the items in those fields, it should be super easy for you to identify the Ecco folder names no ? (and then eventually rename the fields)
I have 1,167 Folders…
I have 1,167 Folders.....
The error fields have more than 100 items and each item has many fields. Here are two examples of an item's "Item Values" Column:
Example 1:
Ecco__DDE_ERROR_3: Follow up Setup (ADP) Direct D… || Ecco__DDE_ERROR_4: ADP Total Source || Ecco_DateStamp_2008-2010: 9/24/09 || Ecco_ModStamp2011-2012: 2/26/12 || Ecco_TimeStamp2011-2012: 2/26/12
Example 2:
Ecco__DDE_ERROR_3: ADP Total Source || Ecco__DDE_ERROR_4: ADP Total Source || Ecco_Category: Finance || Ecco_Color: 16711935 || Ecco_DateStamp_2008-2010: 6/17/10 || Ecco_Duration: 0.25 || Ecco_Finance: 8 || Ecco_Get To It: 8 || Ecco_MkApp: 8 || Ecco_Task: 8 || Ecco_TDate: 3/11/11 || Ecco_TType: Call || ItemDuration: 0.25
(Note that the second example (only) have "image" Tags which shows up as check Marks in the "Items Values" Column).
Not sure what to do about this?
EccoExt has a feature that lets you copy items with their folder values from one Ecco file to another.
I may try to use EE to copy each PhoneBook letter to a blank Ecco File to get 26 files and then import those one by one into IQ.
Lots of work though...
(Or Maybe try to add a couple of letters into separate Folders; e.g. Letters A-D in Folder "A-D" etc... I can't do all letters at once as I get memory overflow).
I used EccoExt to copy…
I used EccoExt to copy PhoneBook Items starting with A (there were 109 TLIs) to a "blank" file (that still had lot of Folders that couldn't be deleted). After I pasted the "A" items, I had 164 folders.
I ran IQ Ecco importer, and it now took only 18 sec to read all folders. However, I got a lot of errors (maybe 20-30) that I had to click OK on; "Error trying to save the value". However, when done, there were no Ecco__DDE_ERRORs.
I found 3 "bad" folders in the new Ecco File. After I deleted those, the import succeeded w/o errors.
It took about 10 min to import the 109 items. Thus, I estimate it will take about 3 hours to import all PhoneBook items if I could do it in one shot. (However, I need to do it in multiple segments so it may take the larger part of day).
I improved the import…
I improved the import process, but it is likely to not make a huge difference.
But, there seems to be a problem with your computer as I have a run of the mill 5 year old notebook computer (i5 6th gen dual core) and it took just 4 minutes to import 1000 TLI for a total of 4050 items, and approx 25,000 field values
so 100 items per minute while you've averaged just 10
How did you get the…
How did you get the information in your image?
File > Properties
File > Properties
Ah, of course...
Ah, of course...
So much less than your file....
I am using a quad core processor (Intel i5 -760 @ 2.80 Ghz) which is about 11 years old.....
(It is on my ToDo list to put together a new PC....)
Maybe I will try it on a newer laptop later.