logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
TMG  
#1 Posted : Saturday, March 14, 2009 5:54:29 AM(UTC)
TMG

Rank: Newbie

Groups: Member
Joined: 3/14/2009(UTC)
Posts: 2

HTC 3470. WM6 pro. Historia 2
1.when opening Excel File it looks like this
UserPostedImage

2. Trouble with Russian fonts

Edited by user Saturday, March 14, 2009 6:35:32 AM(UTC)  | Reason: Not specified

ronenfe  
#2 Posted : Sunday, March 15, 2009 9:21:03 AM(UTC)
ronenfe

Rank: Administration

Groups: Administration
Joined: 11/22/2008(UTC)
Posts: 176

How can I use the exporting function?

Exported calls will be in a folder named Historia and it will be located in My Documents folder in the device, this folder will be synchronized to your desktop computer, if you chose to synchronize files in Activesync.
To open it in Excel, just double click the Historia.csv file, make sure you don't change the original file, or Historia might not function correctly.
If you happen to change the original file and you get an error message in Historia, simply delete the file and Historia will recreate it again, but you will lose all calls in the file. if you backed up the file before,you can also replace the corrupted file with the backup.
Next, make sure you select the number column format in Excel as text.
Note for people who uses non-regular characters: Before opening the file in Excel, right click the file, open it with Notepad, click File, Save as, change encoding to Ansi, name the file with a different name with csv extension, choose file type as: all files, and click Save. Now you can double click the new file to open it in excel correctly.

also it seems that you didn't open the file correctly, the data should be placed in the table columns automatically, like that:

UserPostedImage

Edited by user Sunday, March 15, 2009 9:25:12 AM(UTC)  | Reason: Not specified

ronenfe  
#3 Posted : Sunday, March 15, 2009 10:01:15 AM(UTC)
ronenfe

Rank: Administration

Groups: Administration
Joined: 11/22/2008(UTC)
Posts: 176

Ok, now i notice that leading zeros are missing from the numbers, so a better way to open the file will be:

1. Open Excel.
2. Create a new file in Excel.
3. Click Data, Import external Data, Import data.
4. Open Historia.csv File.
5. See in the preview if the data is displayed correctly, if not, choose "65001 Unicode UTF-8" encoding
6. Click Next.
7. Select comma as the separator.
8. Change the numbers column format to text.
9. Click Finish.
10. Click OK.


in version 3 which will be out soon, the export will be easier.
ronenfe  
#4 Posted : Sunday, March 15, 2009 12:29:21 PM(UTC)
ronenfe

Rank: Administration

Groups: Administration
Joined: 11/22/2008(UTC)
Posts: 176

Another way is to copy the file to another location, rename it to historia.txt, then open excel and open the histroia.txt file.
then follow instructions from step 5.
TMG  
#5 Posted : Monday, March 16, 2009 4:25:01 PM(UTC)
TMG

Rank: Newbie

Groups: Member
Joined: 3/14/2009(UTC)
Posts: 2

Thanks a lot. Now it worksApplause , but only one day for free test is left. The program looks like a very useful one.Boo hoo!
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.