×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

SK98 Contact logs to DB conversion

SK98 Contact logs to DB conversion

SK98 Contact logs to DB conversion

(OP)
My company is stuck on SK98 for over 20k customers.
I want to move to a cloud-based program for obvious reasons.
The issue is I need the contact log to be transferred into the new database.
Are there any scripts that exist that can read from the SKCard file, extracting the contact logs as well as the other entities all under one table? Into some reasonably workable file-type?

If not, is there anyone who could give me some pointers into the SKCard file-type layout?
My coding is all self-taught but I should be able to get my head round it with sufficient help.

Thanks :)

RE: SK98 Contact logs to DB conversion

You can export card files in 98 under File>Export cardfile. It can export as tab delimited text or comma delimited csv or several others. Only problem is it does not say where it is exporting to but can be easily found as the file name is same as the card title.

RE: SK98 Contact logs to DB conversion

Dear tramdev1
As I have said in previous posts, the only way to export the contact log as a field is by using Internet Sidekick97 because Sidekick98 does not include the contact log when exporting to a comma separated values (.csv) file or tab delimited .txt file.
It is also preferable to export to tab delimited .txt as I believe it accepts a greater number of characters. There is a limit on the number of characters which can be exported to tab delimited .txt and I believe it is around 254 although I vaguely remember having managed to export more than that, but it depends on the actual number of hard returns which have been used in the contact log.
Regards
Jim

RE: SK98 Contact logs to DB conversion

And I have just remembered that when importing the tab delimited .txt file into Access one has to specify that the contact log is imported as a NOTES field which allows an enormous amount of characters in the field. That should be continued whenever the file is imported into any database as most fields are limited also to 256 characters (which was the quantity I meant to say before) !

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! Good Luck!

RE: SK98 Contact logs to DB conversion

(OP)
James33, I understand what you are saying and I did read that forum prior to making this post.
I do not think the SideKick 97 Internet is an option for us as we already had great difficulty.

I've browsed through the SKCard file format and all the data is there. Surely it is possible to write a script to
extract all the relevant information and write it to a new file in a program-compatible format?

Please excuse me if I am wrong. Thank you for all your help.

RE: SK98 Contact logs to DB conversion

Is the contact log that which includes list of calls made & received? If so the file layout seems clear enough so it should be possible to have a script to do it. In mine I only have entries starting with [called] but I assume there are other alternatives.

RE: SK98 Contact logs to DB conversion

(OP)
Yeah, it's definitely stored in the SKCard because when you transfer the SKCard file between SideKick's you keep all the contact logs. Also i'm pretty confident it was in the file when I opened it up with notepad.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close