Why Does Access work where FM doesn't?
Let me show you:
There are no blank records? (although even blanks should be imported)
If opened, not imported, does the CVS Opened New database contain 8 or 5 thousand records.
Is the import scripted, or a straight import from the File Menu.
OS is Win in both cases? Ver of FMP looks to be 12? or 12.0.3 (current)?
- There are no blank records but there are blank fields. Many of them in fact.
- Opening and Importing both have the same result
- The import is entirely manual. Haven't gotten far enough to even begin scripting
- Version is 12.0.3. All work is being done on Windows 7. I haven't experimented with the Mac version of FM to see if it acts any differently.
To be fair, no two programs can agree on this CSV file:
MS Excel 2010
Open Office Calc/Base 3.4.1 (Note: Calc and Base use the same import function so results were identical)
Could it be that the CSV itself is a little screwy? While nothing matches the actual number of records reported in my accounting program, Excel and Access are at least in the ballpark.
One more note. Doing a straight copy/paste from notepad to Excel, not seperating the commas, just doing line for line, Excel shows 8952 rows (8953 with headers).
Selecting one of the imported results (Excel would be my choice) and exporting it and importing it into the other applications, does every one agree?
Then I would suspect the file, though damage to such a simple file format is hard to envision. (control characters would be possible).
It is possible to hit an upper limit as to how many records you can export when exporting to Excel. I seem to recall that this limit applied to .xls and not .xlsx files...
I found a solution. I found a software developer that writes utilities for my accounting software to mirror the program's database to an SQL Server. I remembered reading somewhere that Filemaker could work with an SQL server so I got one of those running and then the OBCD drivers and DNS configuration blah blah blah... Long story short after many hours of googling, I now have FM referencing my accounting database as an external data source. So, setup was a bit cumbersome but it should streamline the process in the long run.
Thanks for trying to help me work out the import issue. I never did figure out what was up witht that CSV file but its a moot point now. Off topic, what does OBCD actually stand for?
You can google it you know...
I am done googleing for the day dammit! Thanks, though.
Also, there is a known file size limit issue when importing data that may or may not apply here:
For More Information see: Import of a large CSV file halts after 4GB
This is one of many acknowledged bugs that can be found in the Known Bug List thread here in the Report an Issue section of the forum.
It can also be downloaded as a database file from: https://www.dropbox.com/s/jt09b82i0xijbu3/FMP%20Bugs.zip
Thanks. I won't be getting anywhere close to that limit. Judging by the rate our database has grown over the last ten years, I think it will start to become an issue around 2043. Do you suppose FileMaker will have a fix by then?
Retrieving data ...