Re: [libreoffice-users] export data from Calc, import to Base
Thanks for all the good tips. I have it working. This last one from Robert works, too. I had tried it before but for some reason only one record was imported that time. Anyway, good this time, although patience was needed to import more than 7000 records (felt like a minute, maybe only half). Cheers Harvey On Tue, 2022-08-09 at 07:24 +0200, Robert Großkopf wrote: > Hi Harvey, > > mark the content. Copy it to clipboard. > > Go to the database file and open the tables pane. > > Right mousclick → insert. > > Choose the table where to append the data to, choose the column in > the > wizard and it will be done. > > You won't need a *.csv-file and phpMyAdmin to do this the same way > for > MariaDB/MySQL. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] export data from Calc, import to Base
Hi Harvey, mark the content. Copy it to clipboard. Go to the database file and open the tables pane. Right mousclick → insert. Choose the table where to append the data to, choose the column in the wizard and it will be done. You won't need a *.csv-file and phpMyAdmin to do this the same way for MariaDB/MySQL. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] export data from Calc, import to Base
Hi Harvey, my answer is older and I have not checked, whether the methods still work, but perhaps you try it? https://listarchives.libreoffice.org/global/users/2011/msg02407.html Kind regards Regina Harvey Nimmo schrieb am 08.08.2022 um 21:16: Dear formum, I believe my objective should be rather simple, but I need to be pointed in the right direction. I have a column of text data (unique values) in Calc that I want to transfer to a Base table. The Base table has been set up with three columns, two of which I expect to remain empty after the data import. The one column of unique values will be the primary key. I thought that the best way to implement the data transfer would be to create a .csv file from the column of data, but I need help to find out how Calc supports this. Can anyone help? One idea I had, was to copy the data column (which contains more than 7000 values, incidentally) to a text file. Unfortunately, I do not understand enough about regular expressions to add two commas before each linefeed. Help there would be appreciated. (For completeness, the Base Table is a front end to a backend Mysql database, and I expect the import to be done using phpMyAdmin) Regards Harvey -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] export data from Calc, import to Base
On 9/8/22 05:16, Harvey Nimmo wrote: Dear formum, I believe my objective should be rather simple, but I need to be pointed in the right direction. I have a column of text data (unique values) in Calc that I want to transfer to a Base table. The Base table has been set up with three columns, two of which I expect to remain empty after the data import. The one column of unique values will be the primary key. I thought that the best way to implement the data transfer would be to create a .csv file from the column of data, but I need help to find out how Calc supports this. Can anyone help? One idea I had, was to copy the data column (which contains more than 7000 values, incidentally) to a text file. Unfortunately, I do not understand enough about regular expressions to add two commas before each linefeed. Help there would be appreciated. (For completeness, the Base Table is a front end to a backend Mysql database, and I expect the import to be done using phpMyAdmin) Regards Harvey Hi Harvey, In Calc the File->Save As option has a filter of filetypes for the output file, one of which is .csv. This will then save your spreadsheet as a csv file. When you import the csv into Base you may have to configure the type and format for each of the fields you are importing. regards, Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] export data from Calc, import to Base
Dear formum, I believe my objective should be rather simple, but I need to be pointed in the right direction. I have a column of text data (unique values) in Calc that I want to transfer to a Base table. The Base table has been set up with three columns, two of which I expect to remain empty after the data import. The one column of unique values will be the primary key. I thought that the best way to implement the data transfer would be to create a .csv file from the column of data, but I need help to find out how Calc supports this. Can anyone help? One idea I had, was to copy the data column (which contains more than 7000 values, incidentally) to a text file. Unfortunately, I do not understand enough about regular expressions to add two commas before each linefeed. Help there would be appreciated. (For completeness, the Base Table is a front end to a backend Mysql database, and I expect the import to be done using phpMyAdmin) Regards Harvey -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy