Import from CSV

Discussions about Diving Log 6.0 - questions and hints
Post Reply
bagiuba
Posts: 3
Joined: Sun Mar 15, 2020 14:15

Import from CSV

Post by bagiuba »

Hello
Among the various import formats, there is no CSV format with delimited fields, with the possibility of 'associating' the fields with those present in the DB. Don't you think this functionality that is effectively present in other software can be useful?
Thank you
bagiuba
Posts: 3
Joined: Sun Mar 15, 2020 14:15

Re: Import from CSV

Post by bagiuba »

CSV eportation is available! Thank you
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Import from CSV

Post by divinglog »

Hello

You can copy and paste column by column from Excel into the logbook table editor:

https://www.divinglog.de/blog/?p=142

Please make sure that all numeric data is copied in metric units.

Kind regards,
Sven
bagiuba
Posts: 3
Joined: Sun Mar 15, 2020 14:15

Re: Import from CSV

Post by bagiuba »

OK Tanks
McDiver
Posts: 13
Joined: Wed Sep 28, 2022 06:41

Re: Import from CSV

Post by McDiver »

I have my logbook in Excel with about 1500 dives. Is there a more convenient way than copy/pasting 1500 lines?
Even if I would do it via copy/paste, as far as I understand, before I copy/paste I would have to arrange the columns in my excel file in a way that it fits to the column headings, am I right?
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Import from CSV

Post by divinglog »

You select and copy one column at a time, but all 1500 rows. That way you do not have to arrange the columns and you have to repeat it only a few times, depending on how many columns you have. So for example, you select all dive numbers in Excel (click into the first cell, then Ctrl-Shift-DownArrow), Ctrl-C (Copy).

Switch to Diving Log, add 1500 new rows, click into the first cell of the Number column and Ctrl-V. Repeat for each data column.

Please note that all data in the table editor of Diving Log has to be entered in metric units.

Image1.png
Image1.png (7.9 KiB) Viewed 2131 times
Image2.png
Image2.png (25.48 KiB) Viewed 2131 times
Image3.png
Image3.png (20.21 KiB) Viewed 2131 times
McDiver
Posts: 13
Joined: Wed Sep 28, 2022 06:41

Re: Import from CSV

Post by McDiver »

Thnaks a lot for the fast reply. I found another way meanwhile by directly copying all data into tha database by using MC Access. Seem that it worked as well.
McDiver
Posts: 13
Joined: Wed Sep 28, 2022 06:41

Re: Import from CSV

Post by McDiver »

It seems that I did something wrong, because whenever I open my logbook now, I get the error message:

"Für mindestens einen erforderlichen Parameter wurde kein Wert angegeben".

Which parameters are required, which ones are optional?

(I speak German, but I am writing in English since this is the English forum)

Thanks,
Jens
McDiver
Posts: 13
Joined: Wed Sep 28, 2022 06:41

Re: Import from CSV

Post by McDiver »

I found the problem. For unclear reasons (lets call it user failure), during my copy/paste actions with MS Access, a form called "Einfügefehler" was created which is of course invisible in Diving Log. I just erased this form with MS Access,the error message is gone now.
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Import from CSV

Post by divinglog »

Alles klar, freut mich zu hören das es geklappt hat.
Post Reply