When I try to import CSV files, Omron says "Invalid Data Format". I tried to merge 2 CSV Files with Excel but the problem persists.

Google is your friend.

Maybe this helps convert to what you want:

https://support.office.com/en-us/article/import-contacts-from-an-excel-spreadsheet-to-outlook-f6483469-0684-4c30-82c5-c881930f5451

use the export - and select csv as the output format

Exporting Hotmail ContactsThe first step is to get the information you need out of Hotmail, you can achieve this by doing the following:-

1. Select Contacts from the Hotmail navigation bar.
2. Click On Print View.
3. Highlight the entire contents of the table (including the heading names e.g. Name, E-Mail and Phone as well as all your contacts).
4. Press Ctrl+C to copy the table.
5. Create a new spreadsheet document in Excel.
6. Select Edit and then Paste from the main menu.
7. Sort the data by the E-Mail column.
8. For any rows with a blank E-Mail column copy any e-mail address from the Name column to theE-Mail column.
9. Read this guide from Google on the format of CSV contact files and make any adjustments as may be necaserry.
10. Select File and then Save As... from the menu.
11. Make sure you select a format involving "CSV" for saving the file. (GMail can import csv files)

You should now have a csv file containing all your Hotmail contacts ready for importing into GMail.
Importing Your Hotmail Contacts Into GMailImporting your new contacts file into GMail is really straight forward:-

1. Select Contacts from the GMail left hand menu.
2. Select Import from the 3 options at the top right of your list of contacts.
3. Click Browse to locate your csv file containing your Hotmail contacts.
4. Click Import.

Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.



Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.



Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,



Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.



Hope this is helpful. Let us know if the issue is resolved.





*Rating and Comments are invited for this solution

Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.

Hope this is helpful. Let us know if the issue is resolved.

*Rating and Comments are invited for this solution

Hi,

I had seen the same download problem many times, and after fiddling with the pedometer for a couple of hours I figured out the basis of the problem and was able to fix it.

Being a software engineer, I figured that since it copies each day's data to memory once the clock clicks over to 12 AM, there must have been one day somewhere that had corrupt data.

The download would always reach a certain percentage and then fail and as more days were saved, the percentage went up slowly. Unfortunately,

Omron does not provide a mechanism to clear the internal memory inside the pedometer, which it really needs to do. The reset button on the back does NOT do this.The software on the computer has nothing to do with this problem. It is completely internal to the pedometer itself.

In any case, to fix the problem, I just started setting the clock to 11:59 PM, waiting a minute and doing this quite a few times until the corrupt day's data was pushed out of memory. It holds 42 days, so eventually the data will be erased. Well, it fixed the problem!

Of course, when the download finally worked the data was all screwed up. Then I just exported all the data to CSV, opened it up in a text editor and fixed the screwed up days, then re-imported the CSV file using the software.

Shame on Omron for not making it more user-friendly and providing a button to clear the memory or enabling the software to skip over and delete corrupt data.

Following this step should solve your issue...

Please leave me comment, if you need further assistance
Rnj VinodKumar

Nathan Price says: I had the same download problem, and after fiddling with the pedometer for a couple of hours I figured out the basis of the problem and was able to fix it. Being a software engineer, I figured that since it copies each day's data to memory once the clock clicks over to 12 AM, there must have been one day somewhere that had corrupt data. The download would always reach a certain percentage and then fail and as more days were saved, the percentage went up slowly. Unfortunately, Omron does not provide a mechanism to clear the internal memory inside the pedometer, which it really needs to do. The reset button on the back does NOT do this. The software on the computer has nothing to do with this problem. It is completely internal to the pedometer itself. In any case, to fix the problem, I just started setting the clock to 11:59 PM, waiting a minute and doing this quite a few times until the corrupt day's data was pushed out of memory. It holds 42 days, so eventually the data will be erased. Well, it fixed the problem! Of course, when the download finally worked the data was all screwed up. Then I just exported all the data to CSV, opened it up in a text editor and fixed the screwed up days, then re-imported the CSV file using the software.

Unfortunately, this whole process takes patience and a good knowledge of computers and software. Shame on Omron for not making it more user-friendly and providing a button to clear the memory or enabling the software to skip over and delete corrupt data. But hey, that's what you get for $30, software developed in India.

Hi freaks11,
I am DennisGladx and I hope to assist you.

This sounds like the Column of the data you want should be changed when you import the text file.
Right click on the column letter,
Left click on format cells from the drop down list and select the cell Con-tense you want to display.

Glad to be of assistance
please rate the solution - I can learn from your rating - Thanks

AppleWorks is a quirky and hopelessly outdated product. I am aware that a few people have an extreme fondness for it however.
It should only have taken minutes to import data, but don't do it in AppleWorks - they stopped making it years ago and it is unsupported and non-standard.
I have just taken two AppleWorks databases, - one older and one newer that needed to be combined. I exported them as tab delimited text and then imported them into Excel (You could use Apple Numbers - the modern equivalent to AppleWorks). Because the to db's had different headers, I imported them into two different Excel docs first and moved the columns around so the matched first, them copy each column over to the 'master' excel sheet.
You can either use the basic database tools in Excel, or once your data is combined and in this kind of data form, it is easy to import a .xls, or .csv into a new database program, such as Filemaker.
If you do copy over the data to Excel, any merge function - for label printing etc. has to be done in Word (or at least up to Word 2004). I was thrown by this until I realised you have to do this. Once a merge doc is set up with the right labels, it worked beautifully. Typical MS though it is a wholly unintuitive process.
Copy and importing data should be done with attention to care obviously. Make sure you have your original AW files backed up before you start.

Rudils,

The key is to import the data and not open the file directly.

1. Open a Blank Workbook in Excel.
2. Data, Get External Data, Import Data. (Excel 2007 is Data, Get External Data, Data from Text)
3. Browse to your .csv file and Select "Import".
4. Import Wizard should appear.
5. Page 1 Select "Delimited"
6. Select the row which you want to start the import.
7. click "Next"
8. In the Delimiters, select "semicolon" and/or other delimiters you are using.
Note: The bottom half of the window will preview the way the data is to be imported.
9. click "Next"
10. highlight each column of your data in the window below. For each column you can specify "General", "Text", "Data", or "do not import column" using the radio buttons in the top left of the Wizard box. This is an optional step.
11. Click Finish.

I hope that helps. Please add a comment if it not clear.

kpenguin