Long contact logs vs. memo character # limitation re faq807-1409

[syrynga]

Long contact logs vs. memo character # limitation re faq807-1409

I'd first like to thank all in this forum for just existing! I have hope now.

I've been using Sidekick 98 for about 9 years and am running about 7000 cards with long contact log fields. My employer is forcing me to change to ACT (frown).

I've downloaded Sidekick 97 Internet per faq807-1409. My plan is to open my 98 files with 97 and then export the lot (contact logs included) to a tab delim.txt file. I hope to then open the .txt file in excel or acess and to inport to ACT from there.

A problem arises with the character limitation within Acess (256?) within memo fields. Nearly all my logs have in excess of 1K characters. is there a way to use the time/date stamp within the contact log to avoid this problem? Any alternative suggestions?

Thanks in advance!

 

[james33]

Dear syrynga,
I don't believe I said that the character limitation in access Memo fields is 256 I think I said that Access Text fields have a default character limitation of 50 you can choose up to 256 characters in the import dialog otherwise(>256) the best idea is to export the contact log as a Memo field.
Are you using Access2000 or 97 and is that really the limit?

Regards Jim
Check the FAQ area of this Forum for answers (If there are any FAQs!) , it could save you a lot of time and effort and means that links are more likely to be current. Please 'Comment' on them if they are not!

 

[syrynga]

I already got a response on my problem from Jim! You Irish folk are great. Cheers to all of you - bottoms up!

hey there - I just read you profile - you're burning the night oil - hope you have a pint in front of you...

I've been trying to save my SK 97 file as .txt and keep getting a windows error message - tried on my brand new laptop and the same thing??? Any ideas?

SIDEKICK caused an invalid page fault in
module ILTIF32.DLL at 017f:030efb3c.
Registers:
EAX=00000000 CS=017f EIP=030efb3c EFLGS=00010246
EBX=00000ee5 SS=0187 ESP=00b4cc5c EBP=00aa018d
ECX=ffffffff DS=0187 ESI=00a9f2a8 FS=2a77
EDX=000104f0 ES=0187 EDI=00c305b8 GS=2a66
Bytes at CS:EIP:
f2 ae f7 d1 2b f9 8b d1 c1 e9 02 8b f7 8b 7c 24
Stack dump:
00a9b6b4 00b4d488 00a08d54 00aa018d 030db087 00b4d488 00aa018d 00b4cc94 00b4cc93 00000000 00a9f2a8 034d001f 00001000 010000ee 010f0000 00013a48

 

[james33]

Dear syrynga,
Have you tried to export a file that only has a couple of cards in it first?
It is morning here and I am just on my way out with my grandaughter but will check this thread when I get back...
I am James or/and Jim depending on which way the wind blows!

Actually it appears to be due to a MISSING OR incorrect dll.
Look for a DLL named as above in your install directory it's size should be 369KB(377,856 bytes)
See how you get on and post back.

Regards Jim
Check the FAQ area of this Forum for answers (If there are any FAQs!) , it could save you a lot of time and effort and means that links are more likely to be current. Please 'Comment' on them if they are not!

 

[syrynga]

Jim, thanks so much for responding once again. Hope you outing with the kids was good. Hope they didn't wear ya out like my nieces and nephews do to me!

Ok, I tried to save a very small file as .txt and got a similar error

SIDEKICK caused an invalid page fault in
module KERNEL32.DLL at 017f:bff7b9f2.
Registers:
EAX=036e5107 CS=017f EIP=bff7b9f2 EFLGS=00010206
EBX=00b4fe28 SS=0187 ESP=00b20000 EBP=00b20020
ECX=00b21ddc DS=0187 ESI=00000001 FS=436f
EDX=00000001 ES=0187 EDI=81954390 GS=0000
Bytes at CS:EIP:
53 85 d2 56 57 89 65 e8 75 04 33 c0 eb 54 85 c0
Stack dump:
036e5107 00000001 00b4fe28 0332c912 00b21ddc bffc05b4 bff79250 ffffffff 00b21dec bff7ce23 036e5107 00000001 0332c9f6 036e5107 00b21e30 0332c950

should I be looking for that file you mentioned?

syrynga / Scott

 

[syrynga]

Jim, I tried the same operation on my laptop with similar results I got a window that wanted me to mail a response to Microsoft and was not able to copy the error database. I believe your missing file theory is correct as I am getting the same problem on both machines. Can you identify the missing file? Ifso, can you point me to a download location? Thanks so much. Scott

 

[james33]

Dear Scott,
The file I should have pointed out to you last time is in the C:\Program Files\Starfish\Internet Sidekick\Program Directory,
It is called:
ILTIF32.DLL
Re-Installing Internet Sidekick(VIP BackupBackup) should help that to replace that file but it also might help(and I am vaguely remembering this) to try first to copy the file (the small one first) into the Internet Sidekick Userdata folder and try again to do the export.

Regards Jim
Check the FAQ area of this Forum for answers (If there are any FAQs!) , it could save you a lot of time and effort and means that links are more likely to be current. Please 'Comment' on them if they are not!

 

[syrynga]

Jim,

Ok, did that - copied the .dll file into the userdata folder - got an illegal operation - will be shut down message -

SIDEKICK caused an invalid page fault in
module ILTIF32.DLL at 017f:032dfb3c.
Registers:
EAX=00000000 CS=017f EIP=032dfb3c EFLGS=00010246
EBX=00000ee5 SS=0187 ESP=00b4cc5c EBP=00a2ed71
ECX=ffffffff DS=0187 ESI=00a2de8c FS=61af
EDX=000104f0 ES=0187 EDI=00bbf19c GS=619e
Bytes at CS:EIP:
f2 ae f7 d1 2b f9 8b d1 c1 e9 02 8b f7 8b 7c 24
Stack dump:
00a27f1c 00b4d488 00a10238 00a2ed71 032cb087 00b4d488 00a2ed71 00b4cc94 00b4cc93 00000000 00a2de8c 036c001f 00001000 010000ee 010f0000 00013a48

 

[james33]

Dear Scott,
I meant the small CARDFILE and then try to export it/save it as a txt file
Not the .dll file
Whoops!

Regards Jim
Check the FAQ area of this Forum for answers (If there are any FAQs!) , it could save you a lot of time and effort and means that links are more likely to be current. Please 'Comment' on them if they are not!

 

[syrynga]

whoops! ok - where exactly do I need to place the .dll file? I'd put is in

C:\Program Files\Starfish\Internet Sidekick\userdata\Iltif32.dll

the .dll file was and still is residing in:

C:\Program Files\Starfish\Internet Sidekick\program\Iltif32.dll

so I now have it in both places

The copy of Internet SK was downloaded and I can reinstall if necessary - advise?

the small file I'm using to test the export is:

C:\Program Files\Starfish\Internet Sidekick\userdata\test.SKCard

from what I"m getting from you message is that I need to place the .dll file in C:\Program Files\Starfish\Internet Sidekick\userdata\test.SKCard - is this correct? I don't know how to do that

I don't know if it makes a difference if my SK 98 is in the same Starfish folder as SK Internet:
C:\Program Files\Starfish\Sidekick 98
C:\Program Files\Starfish\Internet Sidekick

 

[james33]

No Scott,
Delete Iltif32.dll from the Userdata folder it Belongs in the
Starfish\Internet Sidekick\Program
Folder.
But it will be re-installed in there if you re-install Internet Sidekick it is part of the program so don't worry about that yet just try exporting Test.SKCard from within Internet Sidekick (ie Save it AS a text file)
We can see about the re-install I just want to see if moving the file Test.SKCard has made it work!!




Regards Jim
Check the FAQ area of this Forum for answers (If there are any FAQs!) , it could save you a lot of time and effort and means that links are more likely to be current. Please 'Comment' on them if they are not!

 

[james33]

Dear Scott,
If the above doesn't work then re-install Internet Sidekick and furthermore to answer your question: it installs into the Starfish folder the same as Sidekick98 and it is fine there.


Regards Jim
Check the FAQ area of this Forum for answers (If there are any FAQs!) , it could save you a lot of time and effort and means that links are more likely to be current. Please 'Comment' on them if they are not!

 

[syrynga]

Jim,

Ok, deleted the .dll file from userdata. Checked the .dll file in program folder and size is 377,856 bytes - same as you thought.

Tried to export from within SK internet and same message - illegal operation and program will be shut down.

Should I now try to reinstall SK internet or just try to replace the .dll file? If I need to ininstall SK internet, what is the best procedeure to avoid messing up my registry?

Thanks so much!

Scott

 

[james33]

Dear Scott,
There is an uninstall program in the
C:\Program Files\Starfish\Internet Sidekick\Program
Folder in that folder is a file called
Sfun32.exe
Double-Click on that and it will pop up a dialog that asks if you wish to uninstall and just go ahead from that but keep any files it feels another program may need, unless it shows
ILTIF32.DLL
as one of them
in which case choose yes to uninstall that file (ILTIF32.DLL).
That should leave the registry clean.

Remember if you start to fiddle around in the Registry that Sidekick95 Sidekick98 and Sidekick99 have a load of similar entries to Internet Sidekick so be VERY VERY CAREFUL WHAT YOU CHOOSE TO DELETE IN THERE.
Good Luck

Regards Jim
Check the FAQ area of this Forum for answers (If there are any FAQs!) , it could save you a lot of time and effort and means that links are more likely to be current. Please 'Comment' on them if they are not!

 

[syrynga]

Jim,

reinstalled and exported both the large (first) and small cardfiles. both exported however - it got to 99% (writing text files) and I got an error message:

SIDEKICK caused an invalid page fault in
module KERNEL32.DLL at 017f:bff7b9f2.
Registers:
EAX=03725107 CS=017f EIP=bff7b9f2 EFLGS=00010206
EBX=00b4fe28 SS=0187 ESP=00b20000 EBP=00b20020
ECX=00b21ddc DS=0187 ESI=00000001 FS=331f
EDX=00000001 ES=0187 EDI=819caea0 GS=0000
Bytes at CS:EIP:
53 85 d2 56 57 89 65 e8 75 04 33 c0 eb 54 85 c0
Stack dump:
03725107 00000001 00b4fe28 033cc912 00b21ddc bffc05b4 bff79250 ffffffff 00b21dec bff7ce23 03725107 00000001 033cc9f6 03725107 00b21e30 033cc950

I opened the large file in acess and most of the information seems to be there but a bit mixed up.

Any ideas?

Scott

 

[james33]

Dear Scott,
Both cardfiles got to 99%.
You went through the match fields dialog and then reading the cardfile and then the writing txt phone cards with both cardfiles, so what are the field names on the cardfiles do they contain reserved(!) characters like & or # or "? as they mess up the export but if you change them, they mess up the cardfile!

Maybe they don't as you would have had an error message saying they weren't valid Cardfiles?
I could try to re-assemble them for you if you send me the small (Test.SKCard) or maybe a bit of the large one to convert as I don't have the same problem!

Regards Jim
Check the FAQ area of this Forum for answers (If there are any FAQs!) , it could save you a lot of time and effort and means that links are more likely to be current. Please 'Comment' on them if they are not!

 

[james33]

Dear Scott,
I forgot to tell you my email address but i think you know it already!
james.maidment(remove this bit)@oceanfree.net


Regards Jim
Check the FAQ area of this Forum for answers (If there are any FAQs!) , it could save you a lot of time and effort and means that links are more likely to be current. Please 'Comment' on them if they are not!