bigga

############ REPLACE app/models/enterprise_token.rb in the source code with this file! ################
############ also be sure to RESTART OpenProject after replacing the file.             ################
############ it doesn't show that enterprise mode is enabled in the settings, but all  ################
############ enterprise mode features, such as KanBan boards, are enabled.             ################
#-- copyright
# OpenProject is an open source project management software.
# Copyright (C) 2012-2023 the OpenProject GmbH
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License version 3.

bigga

#https://apple.stackexchange.com/questions/80611/merging-multiple-csv-files-without-merging-the-header

awk '(NR == 1) || (FNR > 1)' *.csv > out.csv

bigga

#Output filename comes BEFORE the input name

iconv -f WINDOWS-874 -t UTF-8//TRANSLIT -o out_file.txt in_file.txt

bigga

# http://stackoverflow.com/questions/4544669/batch-convert-latin-1-files-to-utf-8-using-iconv
find . -type f -exec bash -c 'iconv -f iso-8859-1 -t utf-8 "{}" > /path/to/destination/"{}"' \;

bigga

#split test
$sw = new-object System.Diagnostics.Stopwatch
$sw.Start()
$filename = "IN_FILENAME.ext"
$rootName = "OUT_FILENAME_"
$ext = "ext"

$linesperFile = 2000#2k
$filecount = 1
$reader = $null

bigga

# Modified from: http://stackoverflow.com/a/11010158/215200

$fromFolder = "D:\FOLDER\"
$rootName = "FILENAME"
$ext = "EXT"

$from = "{0}{1}.{2}" -f ($fromFolder, $rootName, $ext)
$fromFile = [io.file]::OpenRead($from)

$upperBound = 100MB

bigga

@echo off
setlocal ENABLEDELAYEDEXPANSION
REM Edit this value to change the name of the file that needs splitting. Include the extension.

REM Edit this value to change the number of lines per file.
SET LPF=5000
REM Edit this value to change the name of each short file. It will be followed by a number indicating where it is in the list.

SET SFN=%~n1
SET SFX=%~x1

bigga

# This snippet is copied from: http://supadit.com/article/%E0%B8%95%E0%B8%B4%E0%B8%94%E0%B8%95%E0%B8%B1%E0%B9%89%E0%B8%87-geoserver-%E0%B8%9A%E0%B8%99-centos
# The site is already down. So I keep the code as reference here.

# To run Geoserver as a service in CentOS, first install Geoserver, obviously
# Then, put this script into /etc/systemd/system/
# You can also run this command and copy and paste the content below.
# vi /etc/systemd/system/geoserver.service

# After creating the script, you can run the following commands to start and check the service
# systemctl daemon-reload

bigga

#Updated to cover Geoserver 2.15.1
#Added sudo to apt-get lines

sudo apt-get update
sudo apt-get install openjdk-8-jre 

# PostgreSQL and PostGIS
sudo apt-get install postgresql postgresql-contrib postgis postgresql-10-postgis-2.4

# Create "geoserver" database

bigga

#! /bin/sh
### BEGIN INIT INFO
# Provides:          geoserver
# Required-Start:    $local_fs $remote_fs
# Required-Stop:     $local_fs $remote_fs
# Default-Start:     2 3 4 5
# Default-Stop:      S 0 1 6
# Short-Description: GeoServer OGC server
### END INIT INFO