Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1925 > unrolled thread

Solved: Import dates from spreadsheet apps

Back to article view | Back to comp.databases.filemaker

Contents

  Solved: Import dates from spreadsheet apps clkaufmann@gmx.ch (Christoph Kaufmann) - 2014-11-15 14:41 +0100
    Re: Solved: Import dates from spreadsheet apps Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-11-16 10:35 +1300

#1925 — Solved: Import dates from spreadsheet apps

Problem: If you have a date field in Filemaker and import records from
Excel, you get the dates correctly.

This does not work for xls or xlsx created with Numbers or
LibreOffice[1]. I used to take the dates into pieces in the spreadsheet
app (day, month, year), import these and put them together in Filemaker.
What a drag.

Solution: save the sreadsheet as dbf rather than xlsx (yes, I slapped my
forehead).

[1] Can no longer test this, I don't have Numbers. Filemaker 11 and 13
on OS 10.7 refuse to accept xlsx files created by LibreOffice.
-- 
Christoph Kaufmann
http://clk.ch

[toc] | [next] | [standalone]

#1926

In article <1lv5i5t.1sf2giv1s5z6viN%clkaufmann@gmx.ch>, Christoph
Kaufmann <clkaufmann@gmx.ch> wrote:

> Problem: If you have a date field in Filemaker and import records from
> Excel, you get the dates correctly.
> 
> This does not work for xls or xlsx created with Numbers or
> LibreOffice[1]. I used to take the dates into pieces in the spreadsheet
> app (day, month, year), import these and put them together in Filemaker.
> What a drag.
> 
> Solution: save the sreadsheet as dbf rather than xlsx (yes, I slapped my
> forehead).
> 
> [1] Can no longer test this, I don't have Numbers. Filemaker 11 and 13
> on OS 10.7 refuse to accept xlsx files created by LibreOffice.

I think it's a bug in Excel, and a long-standing one. 

I've recently been working on Excel spreadsheets, both saved as .xls,
but one from a web-exported CSV file and one from an .xlsx. Dates
simply copied from the pre-CSV file and pasted into the pre-xlsx file
stupidly gained one day.  :o\

Dates imported from the pre-CSV file (saved back to a CSV) into
Filemaker worked properly.

Helpful Harry  :o)

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.filemaker

csiph-web