Re: Bulk loading of data into a table

2018-08-21 Thread Richard Kimberly Heck
On 08/21/2018 04:32 PM, Rich Shepard wrote:
>   The wiki has a process for linking a table to a spreadsheet but I
> found no
> hints on how to load bulk data into a table. Now I have quartile
> summaries
> for each of 19 years of data. That's a table with 19 rows and 7 columns.
>
>   I'll have more data like this to insert into tables and would
> welcome any
> hints on how to format the data so it can be inserted in one fell swoop.

It is possible to import CSV data, at File> Import> CSV.

Riki



Bulk loading of data into a table

2018-08-21 Thread Rich Shepard

  The wiki has a process for linking a table to a spreadsheet but I found no
hints on how to load bulk data into a table. Now I have quartile summaries
for each of 19 years of data. That's a table with 19 rows and 7 columns.

  I'll have more data like this to insert into tables and would welcome any
hints on how to format the data so it can be inserted in one fell swoop.

TIA,

Rich


Re: Sub-appendices

2018-08-21 Thread Kornel Benko
Am Dienstag, 21. August 2018 18:55:42 CEST schrieb racoon :
> On 2018-08-21 18:09, Kornel Benko wrote:
> > I wanted only to make a hint, how is is possible.
> > But, take as example the copernicus.layout with the definition for 
> > Flex:Appendix
> > 
> > I would use the attached:
> 
> On 2018-08-21 18:19, Kornel Benko wrote:
> > 
> > This time with correct attachment
> > 
> > Kornel
> Thanks. I don't know about the copernicus.layout and could not find it 
> in my layout directory. Where can I get it?

Part of lyx-master-trunk.
https://www.lyx.org/trac/browser/lyxgit/lib/layouts/copernicus.layout

> I cleaned up your suggestion up a bit (attached). However, there is 
> still the issue with the extra subsection layout. It cannot be done 
> without, right?
> 
> I guess what would be needed is something like a section counter 
> conditional on a certain environment, i.e. if a section is in the 
> appendix inset, then use .A, .B, etc., otherwise use the normal counter.

That is difficult, at least I found no way to achieve this. (I tried it for 
copernicus)

> (There were also still errors. I had to remove the "Format 69" from the 
> local layout to make it work.)

Sorry, our lyx2lyx did not take care of it.

> /Daniel

Kornel



signature.asc
Description: This is a digitally signed message part.


Re: Sub-appendices

2018-08-21 Thread racoon

On 2018-08-21 18:09, Kornel Benko wrote:

I wanted only to make a hint, how is is possible.
But, take as example the copernicus.layout with the definition for Flex:Appendix

I would use the attached:


On 2018-08-21 18:19, Kornel Benko wrote:


This time with correct attachment

Kornel
Thanks. I don't know about the copernicus.layout and could not find it 
in my layout directory. Where can I get it?


I cleaned up your suggestion up a bit (attached). However, there is 
still the issue with the extra subsection layout. It cannot be done 
without, right?


I guess what would be needed is something like a section counter 
conditional on a certain environment, i.e. if a section is in the 
appendix inset, then use .A, .B, etc., otherwise use the normal counter.


(There were also still errors. I had to remove the "Format 69" from the 
local layout to make it work.)


/Daniel
#LyX 2.3 created this file. For more info see http://www.lyx.org/
\lyxformat 544
\begin_document
\begin_header
\save_transient_properties true
\origin unavailable
\textclass article
\begin_preamble
\usepackage{appendix}
\end_preamble
\use_default_options true
\maintain_unincluded_children false
\begin_local_layout
Counter subappendix
Within Section
End
Style Subsection_Appendix
CopyStyle   Subsection
CategoryAppendix
LabelCountersubappendix
LabelString "\thesection.\Alph{subappendix}"
End
InsetLayout Flex:Appendix
LyXType custom
LatexType   Environment
LatexName subappendices
Decoration  Classic
MultiPartrue
LabelString "Subappendices"
KeepEmpty   1
End
\end_local_layout
\language english
\language_package default
\inputencoding auto
\fontencoding global
\font_roman "default" "default"
\font_sans "default" "default"
\font_typewriter "default" "default"
\font_math "auto" "auto"
\font_default_family default
\use_non_tex_fonts false
\font_sc false
\font_osf false
\font_sf_scale 100 100
\font_tt_scale 100 100
\use_microtype false
\use_dash_ligatures true
\graphics default
\default_output_format default
\output_sync 0
\bibtex_command default
\index_command default
\paperfontsize default
\spacing single
\use_hyperref false
\papersize default
\use_geometry false
\use_package amsmath 1
\use_package amssymb 1
\use_package cancel 1
\use_package esint 1
\use_package mathdots 1
\use_package mathtools 1
\use_package mhchem 1
\use_package stackrel 1
\use_package stmaryrd 1
\use_package undertilde 1
\cite_engine basic
\cite_engine_type default
\biblio_style plain
\use_bibtopic false
\use_indices false
\paperorientation portrait
\suppress_date false
\justification true
\use_refstyle 1
\use_minted 0
\index Index
\shortcut idx
\color #008000
\end_index
\secnumdepth 3
\tocdepth 3
\paragraph_separation indent
\paragraph_indentation default
\is_math_indent 0
\math_numbering_side default
\quotes_style english
\dynamic_quotes 0
\papercolumns 1
\papersides 1
\paperpagestyle default
\tracking_changes false
\output_changes false
\html_math_output 0
\html_css_as_file 0
\html_be_strict false
\end_header

\begin_body

\begin_layout Section
Start
\end_layout

\begin_layout Section
Section
\end_layout

\begin_layout Subsection
Subsection
\end_layout

\begin_layout Standard
\begin_inset Flex Appendix
status open

\begin_layout Subsection Appendix
Subsection Appendix
\end_layout

\begin_layout Plain Layout

\end_layout

\end_inset


\end_layout

\end_body
\end_document


Re: Sub-appendices

2018-08-21 Thread Kornel Benko
Am Dienstag, 21. August 2018 18:09:35 CEST schrieb Kornel Benko 
:
> Am Dienstag, 21. August 2018 16:11:13 CEST schrieb Daniel :

This time with correct attachment

Kornel 



test2.3.lyx
Description: application/lyx


signature.asc
Description: This is a digitally signed message part.


Re: Sub-appendices

2018-08-21 Thread Kornel Benko
Am Dienstag, 21. August 2018 16:11:13 CEST schrieb Daniel :
> On 21/08/2018 14:02, Kornel Benko wrote:
> > Am Dienstag, 21. August 2018 13:41:21 CEST schrieb Daniel :
> >> On 21/08/2018 13:22, Kornel Benko wrote:
> >>> Am Dienstag, 21. August 2018 12:22:24 CEST schrieb Daniel 
> >>> :
>  Hi,
> 
>  Document
> 
>  Is there an implementation in LyX for the subapendices (from the
>  appendix package)?
> 
>  "Document > Start Appendix Here" seems to treat the whole rest of the
>  document as appendix while a subappendix will (at most) only treat the
>  rest of a section (or subsection) as as appendix.
> 
>  Alternatively, is it possible to change the section counter temporarily
>  within an (subappendix) inset? I would like to create a sub-appendices
>  inset that counts 2.A, 2.B, etc. within a chapter. So the structure in
>  the outline would be:
> 
>  ...
>  2 Chapter title
>  2.1 First section title
>  ...
>  2.A First appendix title
>  ...
> >>>
> >>> You mean the appendix-number should start with the latest chapter number?
> >>>
>  Best,
>  Daniel
> >>>
> >>> The attached defines a new section style (in Local Format)
> >>> It is in lyx-view only, if that is what you want.
> >>>
> >>>   Kornel
> >>
> >> Thanks. But I get a conversion scrip failure. Is the file created with a
> >> newer version than 2.3.0?
> >>
> >> Daniel
> >>
> > 
> > Yes, but that should not matter. Simply changing the second line to
> > \lyxformat 544
> > should help.
> > 
> > Kornel
> 
> Okay, I have taken your local layout and created a new document with it. 
> Now it works. In the attached file I have change the composition a bit 
> to show how it works. Mainly, the appendix subsection needs to be inside 
> the subappendices environment for latex to recognize it as an appendix.
> 
> However, it is not exactly what I was looking for. I don't want a new 
> (sub)section layout. Rather I want to have the default layout change its 
> numbering depending on whether it is inside a subappendices 
> environment/inset. Similarly to how the "Document > Start Appendix Here" 
> works.
> 
> But maybe your workaround is as good as it gets?
> 
> /Daniel

I wanted only to make a hint, how is is possible.
But, take as example the copernicus.layout with the definition for Flex:Appendix

I would use the attached:

Kornel


test.2.3.lyx
Description: application/lyx


signature.asc
Description: This is a digitally signed message part.


Re: Sub-appendices

2018-08-21 Thread Daniel

On 21/08/2018 14:02, Kornel Benko wrote:

Am Dienstag, 21. August 2018 13:41:21 CEST schrieb Daniel :

On 21/08/2018 13:22, Kornel Benko wrote:

Am Dienstag, 21. August 2018 12:22:24 CEST schrieb Daniel :

Hi,

Document

Is there an implementation in LyX for the subapendices (from the
appendix package)?

"Document > Start Appendix Here" seems to treat the whole rest of the
document as appendix while a subappendix will (at most) only treat the
rest of a section (or subsection) as as appendix.

Alternatively, is it possible to change the section counter temporarily
within an (subappendix) inset? I would like to create a sub-appendices
inset that counts 2.A, 2.B, etc. within a chapter. So the structure in
the outline would be:

...
2 Chapter title
2.1 First section title
...
2.A First appendix title
...


You mean the appendix-number should start with the latest chapter number?


Best,
Daniel


The attached defines a new section style (in Local Format)
It is in lyx-view only, if that is what you want.

Kornel


Thanks. But I get a conversion scrip failure. Is the file created with a
newer version than 2.3.0?

Daniel



Yes, but that should not matter. Simply changing the second line to
\lyxformat 544
should help.

Kornel


Okay, I have taken your local layout and created a new document with it. 
Now it works. In the attached file I have change the composition a bit 
to show how it works. Mainly, the appendix subsection needs to be inside 
the subappendices environment for latex to recognize it as an appendix.


However, it is not exactly what I was looking for. I don't want a new 
(sub)section layout. Rather I want to have the default layout change its 
numbering depending on whether it is inside a subappendices 
environment/inset. Similarly to how the "Document > Start Appendix Here" 
works.


But maybe your workaround is as good as it gets?

/Daniel


test.lyx
Description: application/lyx


Re: Sub-appendices

2018-08-21 Thread Daniel

On 21/08/2018 14:02, Kornel Benko wrote:

Am Dienstag, 21. August 2018 13:41:21 CEST schrieb Daniel :

On 21/08/2018 13:22, Kornel Benko wrote:

Am Dienstag, 21. August 2018 12:22:24 CEST schrieb Daniel :

Hi,

Document

Is there an implementation in LyX for the subapendices (from the
appendix package)?

"Document > Start Appendix Here" seems to treat the whole rest of the
document as appendix while a subappendix will (at most) only treat the
rest of a section (or subsection) as as appendix.

Alternatively, is it possible to change the section counter temporarily
within an (subappendix) inset? I would like to create a sub-appendices
inset that counts 2.A, 2.B, etc. within a chapter. So the structure in
the outline would be:

...
2 Chapter title
2.1 First section title
...
2.A First appendix title
...


You mean the appendix-number should start with the latest chapter number?


Best,
Daniel


The attached defines a new section style (in Local Format)
It is in lyx-view only, if that is what you want.

Kornel


Thanks. But I get a conversion scrip failure. Is the file created with a
newer version than 2.3.0?

Daniel



Yes, but that should not matter. Simply changing the second line to
\lyxformat 544
should help.

Kornel


Apparently not. Gives me a

"Read Error: Error reading internal laypout information"

Followed by

"Parse Errors:
Document header error (Unknown token: \float_alignment \float_alignment)
Document header error (Unknown token: class class)
Layout Not Found (Layout `Section Appendix' was not found.)"

/Daniel






Re: Sub-appendices

2018-08-21 Thread Kornel Benko
Am Dienstag, 21. August 2018 13:41:21 CEST schrieb Daniel :
> On 21/08/2018 13:22, Kornel Benko wrote:
> > Am Dienstag, 21. August 2018 12:22:24 CEST schrieb Daniel :
> >> Hi,
> >>
> >> Document
> >>
> >> Is there an implementation in LyX for the subapendices (from the
> >> appendix package)?
> >>
> >> "Document > Start Appendix Here" seems to treat the whole rest of the
> >> document as appendix while a subappendix will (at most) only treat the
> >> rest of a section (or subsection) as as appendix.
> >>
> >> Alternatively, is it possible to change the section counter temporarily
> >> within an (subappendix) inset? I would like to create a sub-appendices
> >> inset that counts 2.A, 2.B, etc. within a chapter. So the structure in
> >> the outline would be:
> >>
> >> ...
> >> 2 Chapter title
> >> 2.1 First section title
> >> ...
> >> 2.A First appendix title
> >> ...
> > 
> > You mean the appendix-number should start with the latest chapter number?
> > 
> >> Best,
> >> Daniel
> > 
> > The attached defines a new section style (in Local Format)
> > It is in lyx-view only, if that is what you want.
> > 
> > Kornel
> 
> Thanks. But I get a conversion scrip failure. Is the file created with a 
> newer version than 2.3.0?
> 
> Daniel
> 

Yes, but that should not matter. Simply changing the second line to
\lyxformat 544
should help.

Kornel



signature.asc
Description: This is a digitally signed message part.


Re: Sub-appendices

2018-08-21 Thread Daniel

On 21/08/2018 13:22, Kornel Benko wrote:

Am Dienstag, 21. August 2018 12:22:24 CEST schrieb Daniel :

Hi,

Document

Is there an implementation in LyX for the subapendices (from the
appendix package)?

"Document > Start Appendix Here" seems to treat the whole rest of the
document as appendix while a subappendix will (at most) only treat the
rest of a section (or subsection) as as appendix.

Alternatively, is it possible to change the section counter temporarily
within an (subappendix) inset? I would like to create a sub-appendices
inset that counts 2.A, 2.B, etc. within a chapter. So the structure in
the outline would be:

...
2 Chapter title
2.1 First section title
...
2.A First appendix title
...


You mean the appendix-number should start with the latest chapter number?


Best,
Daniel


The attached defines a new section style (in Local Format)
It is in lyx-view only, if that is what you want.

Kornel


Thanks. But I get a conversion scrip failure. Is the file created with a 
newer version than 2.3.0?


Daniel



Re: Sub-appendices

2018-08-21 Thread Kornel Benko
Am Dienstag, 21. August 2018 12:22:24 CEST schrieb Daniel :
> Hi,
> 
> Document
> 
> Is there an implementation in LyX for the subapendices (from the 
> appendix package)?
> 
> "Document > Start Appendix Here" seems to treat the whole rest of the 
> document as appendix while a subappendix will (at most) only treat the 
> rest of a section (or subsection) as as appendix.
> 
> Alternatively, is it possible to change the section counter temporarily 
> within an (subappendix) inset? I would like to create a sub-appendices 
> inset that counts 2.A, 2.B, etc. within a chapter. So the structure in 
> the outline would be:
> 
> ...
> 2 Chapter title
> 2.1 First section title
> ...
> 2.A First appendix title
> ...

You mean the appendix-number should start with the latest chapter number?

> Best,
> Daniel

The attached defines a new section style (in Local Format)
It is in lyx-view only, if that is what you want.

Kornel





test.lyx
Description: application/lyx


signature.asc
Description: This is a digitally signed message part.


Sub-appendices

2018-08-21 Thread Daniel

Hi,

Document

Is there an implementation in LyX for the subapendices (from the 
appendix package)?


"Document > Start Appendix Here" seems to treat the whole rest of the 
document as appendix while a subappendix will (at most) only treat the 
rest of a section (or subsection) as as appendix.


Alternatively, is it possible to change the section counter temporarily 
within an (subappendix) inset? I would like to create a sub-appendices 
inset that counts 2.A, 2.B, etc. within a chapter. So the structure in 
the outline would be:


...
2 Chapter title
2.1 First section title
...
2.A First appendix title
...

Best,
Daniel