Submitted by viking on 2022/01/20 00:51

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

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?

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 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.....
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 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 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

a

so 100 items per minute while you've averaged just 10

 

Ah, of course...

z

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.
 

How do I ?