Create or Export Entities

With this Jupyter Notebook you can use all scripts to create and/or export the following Entities:

• Experiments

• Instruments

• Methods

• Persons

• Projects

• Samples

Each Script requires the following arguments:

• source_path: The path to the CSV or Excel file containing the entities you want to create in LOGS; default: None (nothing will be created)

• target_path: The path where the CSV or Excel file with the exported entities should be stored; default: None (nothing will be exported)

• export_format: Should be set to “.xlsx” if the export format should be an Excel table instead of a CSV file; default: “.csv”

To run this notebook you need a Jupyter kernel. A kernel is a Python environment that executes the code from your notebook. If no Jupyter kernel is set up yet, you can register one with the following command in the terminal:

python -m ipykernel install --user --name env_name --display-name "YourName"

Create or Export Experiments

from LOGS_solutions.CreateExportEntities.CreateExportExperiments.main import main, parse_args, validate_format
import sys

sys.argv = ["main.py", 
    "--source_path", r"CreateExportExperiments/experiment_csv_files/experiments.csv",
    "--target_path", r"CreateExportExperiments/experiment_csv_files",
    #"--export_format", ".xlsx",
]

args = parse_args()
validate_format(args)
main(args)

Create or Export Instruments

from LOGS_solutions.CreateExportEntities.CreateExportInstruments.main import main, parse_args, validate_format
import sys

sys.argv = ["main.py", 
    "--source_path", r"CreateExportInstruments/instrument_csv_files/instruments.csv",
    "--target_path", r"CreateExportInstruments/instrument_csv_files",
    #"--export_format", ".xlsx",
]

args = parse_args()
validate_format(args)
main(args)

Create or Export Methods

from LOGS_solutions.CreateExportEntities.CreateExportMethods.main import main, parse_args, validate_format
import sys

sys.argv = ["main.py", 
    "--source_path", r"CreateExportMethods/method_csv_files/methods.csv",
    "--target_path", r"CreateExportMethods/method_csv_files",
    #"--export_format", ".xlsx",
]

args = parse_args()
validate_format(args)
main(args)

Create or Export Persons

from LOGS_solutions.CreateExportEntities.CreateExportPersons.main import main, parse_args, validate_format
import sys

sys.argv = ["main.py", 
    "--source_path", r"CreateExportPersons/person_csv_files/person_account.csv", 
    "--target_path", r"CreateExportPersons/person_csv_files",
    #"--export_format", ".xlsx",
]
args = parse_args()
validate_format(args)
main(args)

Create or Export Projects

from LOGS_solutions.CreateExportEntities.CreateExportProjects.main import main, parse_args, validate_format
import sys

sys.argv = ["main.py", 
    "--source_path", r"CreateExportProjects/project_csv_files/projects.csv",
    "--target_path", r"CreateExportProjects/project_csv_files",
    #"--export_format", ".xlsx",
]

args = parse_args()
validate_format(args)
main(args)

Create or Export Samples

from LOGS_solutions.CreateExportEntities.CreateExportSamples.main import main, parse_args, validate_format
import sys

sys.argv = ["main.py", 
    "--source_path", r"CreateExportSamples/sample_csv_files/samples.csv",
    "--target_path", r"CreateExportSamples/sample_csv_files",
    #"--export_format", ".xlsx",
]

args = parse_args()
validate_format(args)
main(args)