LoadViewer Integration - V1

import requests
import json

url = 'https://www.loadviewer.com/api/auth/jwt/token'

payload = {
    'email': 'YOUR_Email',
    'apikey': 'YOUR_API_KEY_HERE'
}

headers = {'Content-Type': 'application/json'}

response = requests.post(url, data=json.dumps(payload), headers=headers)

if response.status_code == 200:
    response_data = response.json()
    token = response_data['token']
    print(f'Token: {token}')
else:
    print(f'Error: {response.status_code} - {response.text}')

using System;
using System.Net.Http;
using System.Text;
using System.Threading.Tasks;
using Newtonsoft.Json.Linq;

class Program
{
    static async Task Main()
    {
        var url = "https://www.loadviewer.com/api/auth/jwt/token";
        var email = "YOUR_Email";
        var apiKey = "YOUR_API_KEY_HERE";

        var payload = new
        {
            email = email,
            apikey = apiKey
        };

        var json = System.Text.Json.JsonSerializer.Serialize(payload);
        var content = new StringContent(json, Encoding.UTF8, "application/json");

        using var client = new HttpClient();
        var response = await client.PostAsync(url, content);
        var responseBody = await response.Content.ReadAsStringAsync();

        if (response.IsSuccessStatusCode)
        {
            var token = JObject.Parse(responseBody)["token"]?.ToString();
            Console.WriteLine("Token: " + token);
        }
        else
        {
            Console.WriteLine($"Error: {(int)response.StatusCode} - {responseBody}");
        }
    }
}

// Using Fetch API
const url = 'https://www.loadviewer.com/api/auth/jwt/token';
const payload = {
  email: 'YOUR_Email',
  apikey: 'YOUR_API_KEY_HERE'
};

fetch(url, {
  method: 'POST',
  headers: {
    'Content-Type': 'application/json'
  },
  body: JSON.stringify(payload)
})
.then(response => response.json())
.then(data => {
  if (data.token) {
    console.log('Token:', data.token);
  } else {
    console.error('Authentication failed:', data);
  }
})
.catch(error => {
  console.error('Error:', error);
});

import java.io.OutputStream;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.Scanner;

public class AuthExample {
    public static void main(String[] args) {
        String tokenUrl = "https://www.loadviewer.com/api/auth/jwt/token";
        String email = "YOUR_Email";
        String apiKey = "YOUR_API_KEY_HERE";

        String jsonInputString = String.format("{\"email\":\"%s\",\"apikey\":\"%s\"}", email, apiKey);

        try {
            URL url = new URL(tokenUrl);
            HttpURLConnection conn = (HttpURLConnection) url.openConnection();
            conn.setRequestMethod("POST");
            conn.setRequestProperty("Content-Type", "application/json");
            conn.setDoOutput(true);

            try (OutputStream os = conn.getOutputStream()) {
                byte[] input = jsonInputString.getBytes("utf-8");
                os.write(input, 0, input.length);
            }

            int status = conn.getResponseCode();
            Scanner scanner;

            if (status == 200) {
                scanner = new Scanner(conn.getInputStream(), "utf-8");
                String responseBody = scanner.useDelimiter("\\A").next();
                System.out.println("Token: " + responseBody);
            } else {
                scanner = new Scanner(conn.getErrorStream(), "utf-8");
                String errorResponse = scanner.useDelimiter("\\A").next();
                System.out.println("Error: " + status + " - " + errorResponse);
            }
            scanner.close();
            conn.disconnect();

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

open System
open System.Net.Http
open System.Text
open System.Threading.Tasks

let getTokenAsync () =
    async {
        use client = new HttpClient()
        let url = "https://www.loadviewer.com/api/auth/jwt/token"
        let email = "YOUR_Email"
        let apiKey = "YOUR_API_KEY_HERE"
        let payload = sprintf """{ "email": "%s", "apikey": "%s" }""" email apiKey
        let content = new StringContent(payload, Encoding.UTF8, "application/json")

        try
            let! response = client.PostAsync(url, content) |> Async.AwaitTask
            if response.IsSuccessStatusCode then
                let! body = response.Content.ReadAsStringAsync() |> Async.AwaitTask
                printfn "Token: %s" body
            else
                let! error = response.Content.ReadAsStringAsync() |> Async.AwaitTask
                printfn "Error: %d - %s" (int response.StatusCode) error
        with ex ->
            printfn "Exception: %s" ex.Message
    }

[<EntryPoint>]
let main _ =
    getTokenAsync () |> Async.RunSynchronously
    0

package main

import (
    "bytes"
    "encoding/json"
    "fmt"
    "io/ioutil"
    "net/http"
)

func main() {
    url := "https://www.loadviewer.com/api/auth/jwt/token"
    payload := map[string]string{
        "email":  "YOUR_Email",
        "apikey": "YOUR_API_KEY_HERE",
    }

    jsonData, err := json.Marshal(payload)
    if err != nil {
        fmt.Println("Error encoding JSON:", err)
        return
    }

    req, err := http.NewRequest("POST", url, bytes.NewBuffer(jsonData))
    if err != nil {
        fmt.Println("Error creating request:", err)
        return
    }
    req.Header.Set("Content-Type", "application/json")

    client := &http.Client{}
    resp, err := client.Do(req)
    if err != nil {
        fmt.Println("Error making request:", err)
        return
    }
    defer resp.Body.Close()

    body, err := ioutil.ReadAll(resp.Body)
    if err != nil {
        fmt.Println("Error reading response:", err)
        return
    }

    if resp.StatusCode == http.StatusOK {
        var result map[string]interface{}
        if err := json.Unmarshal(body, &result); err != nil {
            fmt.Println("Error decoding JSON:", err)
            return
        }
        fmt.Println("Token:", result["token"])
    } else {
        fmt.Printf("Error: %d - %s\n", resp.StatusCode, string(body))
    }
}

library(httr)
library(jsonlite)

url <- "https://www.loadviewer.com/api/auth/jwt/token"
payload <- list(
  email = "YOUR_Email",
  apikey = "YOUR_API_KEY_HERE"
)

response <- POST(
  url,
  add_headers(`Content-Type` = "application/json"),
  body = toJSON(payload, auto_unbox = TRUE)
)

if (status_code(response) == 200) {
  token <- content(response, as = "parsed")$token
  cat("Token:", token, "\n")
} else {
  cat("Error:", status_code(response), "-", content(response, as = "text"), "\n")
}

<?php
$tokenUrl = 'https://www.loadviewer.com/api/auth/jwt/token';
$email = 'YOUR_Email';
$apiKey = 'YOUR_API_KEY_HERE';

$data = json_encode(['email' => $email, 'apikey' => $apiKey]);

$ch = curl_init($tokenUrl);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, [
    'Content-Type: application/json'
]);
curl_setopt($ch, CURLOPT_POSTFIELDS, $data);

$response = curl_exec($ch);
$httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close($ch);

if ($httpCode === 200) {
    $responseData = json_decode($response, true);
    echo "Token: " . $responseData['token'];
} else {
    echo "Error: $httpCode - $response";
}
?>

import 'dart:convert';
import 'package:http/http.dart' as http;

void main() async {
  var url = Uri.parse('https://www.loadviewer.com/api/auth/jwt/token');
  var headers = {'Content-Type': 'application/json'};
  var body = jsonEncode({
    'email': 'YOUR_Email',
    'apikey': 'YOUR_API_KEY_HERE'
  });

  var response = await http.post(url, headers: headers, body: body);

  if (response.statusCode == 200) {
    var responseData = jsonDecode(response.body);
    print('Token: \${responseData['token']}');
  } else {
    print('Error: \${response.statusCode} - \${response.body}');
  }
}

// ========================================
// Module: modLoadViewerCSV
// Purpose:
//     1. Generate LoadViewer-compatible CSV from hardcoded or database values
//     2. Upload CSV to LoadViewer using HTTP POST (WinHttp equivalent in C# is HttpClient)
// Includes helper functions:
//     - removeComma: for all string fields
//     - formatDecimal3: for weights with decimals
// ========================================

using System;
using System.Data.OleDb; // For ADODB recordset equivalent
using System.Net.Http;
using System.Text.Json;
using System.Threading.Tasks;

public class LoadViewerCSV
{
    // === Constants ===
    private const string LoadViewerTokenURL = "https://www.loadviewer.com/api/auth/jwt/token";
    private const string LoadViewerUploadURL = "https://www.loadviewer.com/api/integration/v1/upload";
    private const string LoadViewerAPIEmail = "YOUR_Email";
    private const string LoadViewerAPIKey = "YOUR_API_KEY_HERE";

    // Optional: You can fetch the above values from file or DB:
    //     - From INI file in App.Path (use System.Configuration in C#)
    //     - From encrypted DB table
    //     - From registry or environment variable (use Microsoft.Win32.Registry in C#)
    //

    // === Module level variable to cache the retrieved token ===
    public static string LoadViewerToken { get; private set; }

    // === Dynamically generates LoadViewer CSV from ADODB recordsets ===
    // For csvGenerate() to work properly, you may need to add System.Data.OleDb
    public static string CsvGenerate()
    {
        string csv = "";
        OleDbDataReader rsShipment = null;
        OleDbDataReader rsContainer = null;
        OleDbDataReader rsCargo = null;
        OleDbConnection connection = null;

        try
        {
            // --- Define Shipment fields ---
            string shipmentQuery = "SELECT 'SANDBOX-01' as Reference, true as HangingAllowed, false as UseMultipleContainers";
            string containerQuery = "SELECT 5867 as Length, 2352 as Width, 2393 as Height, 27200 as MaxWeight, 0 as BackMargin";
            string cargoQuery = "SELECT '#008000' as Color, 700 as Length, 500 as Width, 300 as Height, 91.5 as Weight, 300 as Cartons, 0 as AdditionalCartons, 0 as Placement, true as VerticalRotationAllowed, 1 as SKUPerCarton, 0 as EmptyPalletHeight, 0 as TrayCap, 0 as TrayHeight, 0 as AirSpaceLength, 0 as AirSpaceWidth, 0 as AirSpaceHeight, '' as NameOfSet, 0 as CartonRatio, '' as Description, 0 as Destination, '' as PO, '' as Shipper";

            // Create a dummy connection and reader just to simulate vb6 behaviour
            connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.;Extended Properties=dBASE IV;");
            connection.Open();

            OleDbCommand shipmentCommand = new OleDbCommand(shipmentQuery, connection);
            rsShipment = shipmentCommand.ExecuteReader();

            OleDbCommand containerCommand = new OleDbCommand(containerQuery, connection);
            rsContainer = containerCommand.ExecuteReader();

            OleDbCommand cargoCommand = new OleDbCommand(cargoQuery, connection);
            rsCargo = cargoCommand.ExecuteReader();

            // --- Begin CSV output ---
            csv = "S,H,Reference,Hanging Allowed,Use Multiple Containers" + Environment.NewLine;
            if (rsShipment.Read())
            {
                csv += "S,D," + RemoveComma(rsShipment["Reference"].ToString()) + "," + rsShipment["HangingAllowed"] + "," + rsShipment["UseMultipleContainers"] + Environment.NewLine;
            }

            csv += "B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm" + Environment.NewLine;
            if (rsContainer.Read())
            {
                csv += "B,D," + rsContainer["Length"] + "," + rsContainer["Width"] + "," + rsContainer["Height"] + "," + FormatDecimal3(rsContainer["MaxWeight"]) + "," + rsContainer["BackMargin"] + Environment.NewLine;
            }

            csv += "C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper" + Environment.NewLine;
            if (rsCargo.Read())
            {
                csv += "C,D," + RemoveComma(rsCargo["Color"].ToString()) + "," + rsCargo["Length"] + "," + rsCargo["Width"] + "," + rsCargo["Height"] + "," + FormatDecimal3(rsCargo["Weight"]) + "," + rsCargo["Cartons"] + "," + rsCargo["AdditionalCartons"] + "," + rsCargo["Placement"] + "," + rsCargo["VerticalRotationAllowed"] + "," + rsCargo["SKUPerCarton"] + "," + rsCargo["EmptyPalletHeight"] + "," + rsCargo["TrayCap"] + "," + rsCargo["TrayHeight"] + "," + rsCargo["AirSpaceLength"] + "," + rsCargo["AirSpaceWidth"] + "," + rsCargo["AirSpaceHeight"] + "," + RemoveComma(rsCargo["NameOfSet"].ToString()) + "," + rsCargo["CartonRatio"] + "," + RemoveComma(rsCargo["Description"].ToString()) + "," + rsCargo["Destination"] + "," + RemoveComma(rsCargo["PO"].ToString()) + "," + RemoveComma(rsCargo["Shipper"].ToString()) + Environment.NewLine;
            }
        }
        catch (Exception ex)
        {
            return "Exception: " + ex.Message;
        }
        finally
        {
            if (rsShipment != null) rsShipment.Close();
            if (rsContainer != null) rsContainer.Close();
            if (rsCargo != null) rsCargo.Close();
            if (connection != null) connection.Close();
        }

        return csv;
    }

    // === Generate CSV string for SANDBOX-01 ===
    public static string CsvCreate()
    {
        string csv = "S,H,Reference,Hanging Allowed,Use Multiple Containers" + Environment.NewLine;
        csv += "S,D,SANDBOX-01,True,False" + Environment.NewLine;
        csv += "B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm" + Environment.NewLine;
        csv += "B,D,5867,2352,2393,27200,0" + Environment.NewLine;
        csv += "C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper" + Environment.NewLine;
        csv += "C,D,#008000,700,500,300,91.5,300,0,0,True,1,0,0,0,0,0,0,,0,,0,," + Environment.NewLine;
        return csv;
    }

    // === Get JWT Token ===
    public static async Task<string> GetJwtTokenAsync()
    {
        try
        {
            using (HttpClient client = new HttpClient())
            {
                client.Timeout = TimeSpan.FromSeconds(5); // Adjust timeouts
                var jsonBody = JsonSerializer.Serialize(new { email = LoadViewerAPIEmail, apikey = LoadViewerAPIKey });
                var content = new StringContent(jsonBody, System.Text.Encoding.UTF8, "application/json");
                var response = await client.PostAsync(LoadViewerTokenURL, content);

                if (response.IsSuccessStatusCode)
                {
                    string responseText = await response.Content.ReadAsStringAsync();
                    string token = ExtractTokenFromResponse(responseText);
                    LoadViewerToken = token; // Cache the token
                    return token;
                }
                else
                {
                    return $"ERROR: {(int)response.StatusCode} - {await response.Content.ReadAsStringAsync()}";
                }
            }
        }
        catch (Exception ex)
        {
            return $"Exception: {ex.Message}";
        }
    }

    // === Extract "token" field from JSON response ===
    private static string ExtractTokenFromResponse(string jsonText)
    {
        try
        {
            using (JsonDocument doc = JsonDocument.Parse(jsonText))
            {
                if (doc.RootElement.TryGetProperty("token", out JsonElement tokenElement))
                {
                    return tokenElement.GetString();
                }
            }
        }
        catch { }
        return "";
    }

    // === Upload CSV using Bearer Token ===
    public static async Task<string> UploadToLoadViewerAsync(string csvData, string jwtToken)
    {
        int retry = 3;
        while (retry > 0)
        {
            try
            {
                using (HttpClient client = new HttpClient())
                {
                    client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", jwtToken);
                    var content = new StringContent(csvData, System.Text.Encoding.UTF8, "text/csv");
                    var response = await client.PostAsync(LoadViewerUploadURL, content);

                    if (response.StatusCode == System.Net.HttpStatusCode.OK || response.StatusCode == System.Net.HttpStatusCode.Accepted)
                    {
                        return $"{(int)response.StatusCode} - {await response.Content.ReadAsStringAsync()}";
                    }
                    else if (response.StatusCode == System.Net.HttpStatusCode.Gone) // 410
                    {
                        jwtToken = await GetJwtTokenAsync(); // Refresh token
                        if (jwtToken.StartsWith("ERROR") || jwtToken.StartsWith("Exception"))
                        {
                            return jwtToken; // Return error from token retrieval
                        }
                        retry--;
                        continue; // Retry upload
                    }
                    else
                    {
                        return $"ERROR: {(int)response.StatusCode} - {await response.Content.ReadAsStringAsync()}";
                    }
                }
            }
            catch (Exception ex)
            {
                return $"Exception: {ex.Message}";
            }
        }
        return "Upload failed after retries.";
    }

    // === Cleans text for CSV: removes commas and replaces line breaks ===
    // === Use this for all adVarChar (string) fields before writing to CSV ===
    //
    // Replaces:
    //     ,     ?     (removed)
    //     vbCrLf, vbCr, vbLf ? " " (space)
    public static string RemoveComma(string value)
    {
        if (string.IsNullOrEmpty(value))
        {
            return "";
        }

        string s = value.Trim();
        s = s.Replace(",", "");
        s = s.Replace(Environment.NewLine, " ");
        s = s.Replace("\r", " ");
        s = s.Replace("\n", " ");

        return s;
    }

    // === Converts numeric value to string with up to 3 decimal places ===
    // === Trailing zeros are removed. Use only for Weight-related fields ===
    //
    // Examples:
    //     Convert 91.5      ? "91.5"
    //     Convert 91.56789  ? "91.568"
    //     Keep 52           ? "52"    (no .000 added)
    public static string FormatDecimal3(double value)
    {
        return value.ToString("0.###");
    }

    // === OPTIONAL TEST CALL ===
    // Make calls Examples
    //     TestUploadAsync() //->SaveToDisk=No, CSVFromADO=No
    //     TestUploadAsync(true) //->SaveToDisk=Yes, CSVFromADO=No
    //     TestUploadAsync(false, true) //->SaveToDisk=No, CSVFromADO=Yes
    //     TestUploadAsync(true, true) //->SaveToDisk=Yes, CSVFromADO=Yes
    //===============================================================
    public static async Task TestUploadAsync(bool saveToDisk = false, bool useADORecordset = false)
    {
        string csv;
        if (!useADORecordset)
        {
            csv = CsvCreate(); //--Using Hard Coded values
        }
        else
        {
            csv = CsvGenerate(); //-->Using ADO
        }

        if (saveToDisk)
        {
            string filePath = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "SANDBOX-VB6.csv");
            System.IO.File.WriteAllText(filePath, csv);
        }

        string token;
        if (string.IsNullOrEmpty(LoadViewerToken))
        {
            token = await GetJwtTokenAsync();
        }
        else
        {
            token = LoadViewerToken;
        }

        if (string.IsNullOrEmpty(token) || token.StartsWith("ERROR") || token.StartsWith("Exception"))
        {
            Console.WriteLine("Token Error or Server Not Reachable: " + Environment.NewLine + token);
            return;
        }

        string response = await UploadToLoadViewerAsync(csv, token);
        Console.WriteLine(response);
    }
}

// ========================================
// Module: modLoadViewerCSV
// Purpose:
//     1. Generate LoadViewer-compatible CSV from hardcoded or database values
//     2. Upload CSV to LoadViewer using HTTP POST (fetch API)
// Includes helper functions:
//     - removeComma: for all string fields
//     - formatDecimal3: for weights with decimals
// ========================================

// === Constants ===
const LoadViewerTokenURL = "https://www.loadviewer.com/api/auth/jwt/token";
const LoadViewerUploadURL = "https://www.loadviewer.com/api/integration/v1/upload";
const LoadViewerAPIEmail = "YOUR_Email";
const LoadViewerAPIKey = "YOUR_API_KEY_HERE";

// Optional: You can fetch the above values from file or DB:
//     - From local storage, or from a server config file
//     - From encrypted DB table (Node.js with a database library)
//     - From environment variable (process.env in Node.js)
//

// === Module level variable to cache the retrieved token ===
let LoadViewerToken = "";

// === Dynamically generates LoadViewer CSV from hardcoded data ===
function csvGenerate() {
    let csv = "";
    const shipmentData = {
        Reference: "SANDBOX-01",
        HangingAllowed: true,
        UseMultipleContainers: false,
    };

    const containerData = {
        Length: 5867,
        Width: 2352,
        Height: 2393,
        MaxWeight: 27200,
        BackMargin: 0,
    };

    const cargoData = {
        Color: "#008000",
        Length: 700,
        Width: 500,
        Height: 300,
        Weight: 91.5,
        Cartons: 300,
        AdditionalCartons: 0,
        Placement: 0,
        VerticalRotationAllowed: true,
        SKUPerCarton: 1,
        EmptyPalletHeight: 0,
        TrayCap: 0,
        TrayHeight: 0,
        AirSpaceLength: 0,
        AirSpaceWidth: 0,
        AirSpaceHeight: 0,
        NameOfSet: "",
        CartonRatio: 0,
        Description: "",
        Destination: 0,
        PO: "",
        Shipper: "",
    };

    // --- Begin CSV output ---
    csv = "S,H,Reference,Hanging Allowed,Use Multiple Containers\n";
    csv += `S,D,${removeComma(shipmentData.Reference)},${shipmentData.HangingAllowed},${shipmentData.UseMultipleContainers}\n`;
    csv += "B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n";
    csv += `B,D,${containerData.Length},${containerData.Width},${containerData.Height},${formatDecimal3(containerData.MaxWeight)},${containerData.BackMargin}\n`;
    csv += "C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n";
    csv += `C,D,${removeComma(cargoData.Color)},${cargoData.Length},${cargoData.Width},${cargoData.Height},${formatDecimal3(cargoData.Weight)},${cargoData.Cartons},${cargoData.AdditionalCartons},${cargoData.Placement},${cargoData.VerticalRotationAllowed},${cargoData.SKUPerCarton},${cargoData.EmptyPalletHeight},${cargoData.TrayCap},${cargoData.TrayHeight},${cargoData.AirSpaceLength},${cargoData.AirSpaceWidth},${cargoData.AirSpaceHeight},${removeComma(cargoData.NameOfSet)},${cargoData.CartonRatio},${removeComma(cargoData.Description)},${cargoData.Destination},${removeComma(cargoData.PO)},${removeComma(cargoData.Shipper)}\n`;

    return csv;
}

// === Generate CSV string for SANDBOX-01 ===
function csvCreate() {
    let csv = "S,H,Reference,Hanging Allowed,Use Multiple Containers\n";
    csv += "S,D,SANDBOX-01,True,False\n";
    csv += "B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n";
    csv += "B,D,5867,2352,2393,27200,0\n";
    csv += "C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n";
    csv += "C,D,#008000,700,500,300,91.5,300,0,0,True,1,0,0,0,0,0,0,,0,,0,,\n";
    return csv;
}

// === Get JWT Token ===
async function getJwtToken() {
    try {
        const response = await fetch(LoadViewerTokenURL, {
            method: "POST",
            headers: {
                "Content-Type": "application/json",
            },
            body: JSON.stringify({ email: LoadViewerAPIEmail, apikey: LoadViewerAPIKey }),
        });

        if (response.ok) {
            const json = await response.json();
            const token = json.token;
            LoadViewerToken = token; // Cache the token
            return token;
        } else {
            return `ERROR: ${response.status} - ${await response.text()}`;
        }
    } catch (error) {
        return `Exception: ${error.message}`;
    }
}

// === Upload CSV using Bearer Token ===
async function UploadToLoadViewer(csvData, jwtToken) {
    let retry = 3;
    while (retry > 0) {
        try {
            const response = await fetch(LoadViewerUploadURL, {
                method: "POST",
                headers: {
                    "Content-Type": "text/csv",
                    Authorization: `Bearer ${jwtToken}`,
                },
                body: csvData,
            });

            if (response.status === 200 || response.status === 202) {
                return `${response.status} - ${await response.text()}`;
            } else if (response.status === 410) {
                jwtToken = await getJwtToken();
                if (jwtToken.startsWith("ERROR") || jwtToken.startsWith("Exception")) {
                    return jwtToken;
                }
                retry--;
                continue;
            } else {
                return `ERROR: ${response.status} - ${await response.text()}`;
            }
        } catch (error) {
            return `Exception: ${error.message}`;
        }
    }
    return "Upload failed after retries.";
}

// === Cleans text for CSV: removes commas and replaces line breaks ===
// === Use this for all string fields before writing to CSV ===
//
// Replaces:
//     ,     ?     (removed)
//     \r\n, \r, \n ? " " (space)
function removeComma(value) {
    if (value === null || value === undefined) {
        return "";
    }

    let s = String(value).trim();
    s = s.replace(/,/g, "");
    s = s.replace(/\r\n/g, " ");
    s = s.replace(/\r/g, " ");
    s = s.replace(/\n/g, " ");

    return s;
}

// === Converts numeric value to string with up to 3 decimal places ===
// === Trailing zeros are removed. Use only for Weight-related fields ===
//
// Examples:
//     Convert 91.5      ? "91.5"
//     Convert 91.56789  ? "91.568"
//     Keep 52           ? "52"    (no .000 added)
function formatDecimal3(value) {
    if (value === null || value === undefined || isNaN(value)) {
        return "0";
    }

    const strValue = value.toString();
    if (strValue.indexOf('.') === -1) {
        return strValue; // Return integer value as is
    }

    const rounded = parseFloat(value.toFixed(3));
    return rounded.toString();
}

// === OPTIONAL TEST CALL ===
// Make calls Examples
//     testUpload() //-> CSVFromHardCoded
//===============================================================
async function testUpload() {
    const csv = csvCreate(); //--Using Hard Coded values

    let token;
    if (!LoadViewerToken) {
        token = await getJwtToken();
    } else {
        token = LoadViewerToken;
    }

    if (!token || token.startsWith("ERROR") || token.startsWith("Exception")) {
        console.error("Token Error or Server Not Reachable: \n" + token);
        return;
    }

    const response = await UploadToLoadViewer(csv, token);
    console.log(response);
}

import java.io.IOException;
import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;
import java.text.DecimalFormat;
import java.util.HashMap;
import java.util.Map;

public class LoadViewerCSV {

    // === Constants ===
    private static final String LoadViewerTokenURL = "https://www.loadviewer.com/api/auth/jwt/token";
    private static final String LoadViewerUploadURL = "https://www.loadviewer.com/api/integration/v1/upload";
    private static final String LoadViewerAPIEmail = "YOUR_Email";
    private static final String LoadViewerAPIKey = "YOUR_API_KEY_HERE";

    // Optional: You can fetch the above values from file or DB:
    // - From properties file, or from a database config table
    // - From encrypted DB table
    // - From environment variable (System.getenv() in Java)

    // === Module level variable to cache the retrieved token ===
    private static String LoadViewerToken = "";

    // === Dynamically generates LoadViewer CSV from hardcoded data ===
    public static String csvGenerate() {
        StringBuilder csv = new StringBuilder();
        Map<String, Object> shipmentData=new HashMap<>(); shipmentData.put("Reference", "SANDBOX-01");
        shipmentData.put("HangingAllowed", true);
        shipmentData.put("UseMultipleContainers", false);

        Map<String, Object> containerData = new HashMap<>(); containerData.put("Length", 5867);
        containerData.put("Width", 2352);
        containerData.put("Height", 2393);
        containerData.put("MaxWeight", 27200.0);
        containerData.put("BackMargin", 0);

        Map<String, Object> cargoData = new HashMap<>(); cargoData.put("Color", "#008000");
        cargoData.put("Length", 700);
        cargoData.put("Width", 500);
        cargoData.put("Height", 300);
        cargoData.put("Weight", 91.5);
        cargoData.put("Cartons", 300);
        cargoData.put("AdditionalCartons", 0);
        cargoData.put("Placement", 0);
        cargoData.put("VerticalRotationAllowed", true);
        cargoData.put("SKUPerCarton", 1);
        cargoData.put("EmptyPalletHeight", 0);
        cargoData.put("TrayCap", 0);
        cargoData.put("TrayHeight", 0);
        cargoData.put("AirSpaceLength", 0);
        cargoData.put("AirSpaceWidth", 0);
        cargoData.put("AirSpaceHeight", 0);
        cargoData.put("NameOfSet", "");
        cargoData.put("CartonRatio", 0);
        cargoData.put("Description", "");
        cargoData.put("Destination", 0);
        cargoData.put("PO", "");
        cargoData.put("Shipper", "");

        // --- Begin CSV output ---
        csv.append("S,H,Reference,Hanging Allowed,Use Multiple Containers\n");
        csv.append(String.format("S,D,%s,%s,%s\n", removeComma(shipmentData.get("Reference").toString()),
                shipmentData.get("HangingAllowed"), shipmentData.get("UseMultipleContainers")));
        csv.append("B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n");
        csv.append(String.format("B,D,%s,%s,%s,%s,%s\n", containerData.get("Length"), containerData.get("Width"),
                containerData.get("Height"), formatDecimal3((Double) containerData.get("MaxWeight")),
                containerData.get("BackMargin")));
        csv.append("C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n");
        csv.append(String.format("C,D,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s\n",
                removeComma(cargoData.get("Color").toString()), cargoData.get("Length"), cargoData.get("Width"),
                cargoData.get("Height"), formatDecimal3((Double) cargoData.get("Weight")), cargoData.get("Cartons"),
                cargoData.get("AdditionalCartons"), cargoData.get("Placement"), cargoData.get("VerticalRotationAllowed"),
                cargoData.get("SKUPerCarton"), cargoData.get("EmptyPalletHeight"), cargoData.get("TrayCap"),
                cargoData.get("TrayHeight"), cargoData.get("AirSpaceLength"), cargoData.get("AirSpaceWidth"),
                cargoData.get("AirSpaceHeight"), removeComma(cargoData.get("NameOfSet").toString()),
                cargoData.get("CartonRatio"), removeComma(cargoData.get("Description").toString()),
                cargoData.get("Destination"), removeComma(cargoData.get("PO").toString()),
                removeComma(cargoData.get("Shipper").toString())));

        return csv.toString();
    }

    // === Generate CSV string for SANDBOX-01 ===
    public static String csvCreate() {
        StringBuilder csv = new StringBuilder();
        csv.append("S,H,Reference,Hanging Allowed,Use Multiple Containers\n");
        csv.append("S,D,SANDBOX-01,True,False\n");
        csv.append("B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n");
        csv.append("B,D,5867,2352,2393,27200,0\n");
        csv.append("C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n");
        csv.append("C,D,#008000,700,500,300,91.5,300,0,0,True,1,0,0,0,0,0,0,,0,,0,,\n");
        return csv.toString();
    }

    // === Get JWT Token ===
    public static String getJwtToken() throws IOException, InterruptedException {
        HttpClient client = HttpClient.newHttpClient();
        HttpRequest request = HttpRequest.newBuilder()
                .uri(URI.create(LoadViewerTokenURL))
                .header("Content-Type", "application/json")
                .POST(HttpRequest.BodyPublishers.ofString(String.format("{\"email\":\"%s\",\"apikey\":\"%s\"}",
                        LoadViewerAPIEmail, LoadViewerAPIKey)))
                .build();

        HttpResponse<String> response = client.send(request, HttpResponse.BodyHandlers.ofString());

        if (response.statusCode() == 200) {
            String json = response.body();
            String token = json.substring(json.indexOf("\"token\":\"") + 9, json.indexOf("\"", json.indexOf("\"token\":\"") + 9));
            LoadViewerToken = token; // Cache the token
            return token;
        } else {
            return "ERROR: " + response.statusCode() + " - " + response.body();
        }
    }

    // === Upload CSV using Bearer Token ===
    public static String UploadToLoadViewer(String csvData, String jwtToken) throws IOException, InterruptedException {
        int retry = 3;
        while (retry > 0) {
            HttpClient client = HttpClient.newHttpClient();
            HttpRequest request = HttpRequest.newBuilder()
                    .uri(URI.create(LoadViewerUploadURL))
                    .header("Content-Type", "text/csv")
                    .header("Authorization", "Bearer " + jwtToken)
                    .POST(HttpRequest.BodyPublishers.ofString(csvData))
                    .build();

            HttpResponse<String> response = client.send(request, HttpResponse.BodyHandlers.ofString());

            if (response.statusCode() == 200 || response.statusCode() == 202) {
                return response.statusCode() + " - " + response.body();
            } else if (response.statusCode() == 410) {
                jwtToken = getJwtToken();
                if (jwtToken.startsWith("ERROR")) {
                    return jwtToken;
                }
                retry--;
                continue;
            } else {
                return "ERROR: " + response.statusCode() + " - " + response.body();
            }
        }
        return "Upload failed after retries.";
    }

    // === Cleans text for CSV: removes commas and replaces line breaks ===
    // === Use this for all string fields before writing to CSV ===
    //
    // Replaces:
    // , ? (removed)
    // \r\n, \r, \n ? " " (space)
    public static String removeComma(String value) {
        if (value == null) {
            return "";
        }
        String s = value.trim();
        s = s.replace(",", "");
        s = s.replace("\r\n", " ");
        s = s.replace("\r", " ");
        s = s.replace("\n", " ");
        return s;
    }

    // === Converts numeric value to string with up to 3 decimal places ===
    // === Trailing zeros are removed. Use only for Weight-related fields ===
    //
    // Examples:
    // Convert 91.5 ? "91.5"
    // Convert 91.56789 ? "91.568"
    // Keep 52 ? "52" (no .000 added)
    public static String formatDecimal3(Double value) {
        DecimalFormat df = new DecimalFormat("0.###");
        return df.format(value);
    }

    // === OPTIONAL TEST CALL ===
    // Make calls Examples
    // testUpload() //-> CSVFromHardCoded
    // ===============================================================
    public static void testUpload() throws IOException, InterruptedException {
        String csv = csvCreate(); // --Using Hard Coded values

        String token;
        if (LoadViewerToken.isEmpty()) {
            token = getJwtToken();
        } else {
            token = LoadViewerToken;
        }

        if (token.startsWith("ERROR")) {
            System.err.println("Token Error or Server Not Reachable: \n" + token);
            return;
        }

        String response = UploadToLoadViewer(csv, token);
        System.out.println(response);
    }
}

open System
open System.Net.Http
open System.Text.Json
open System.Threading.Tasks

// ========================================
// Module: modLoadViewerCSV
// Purpose:
//     1. Generate LoadViewer-compatible CSV from hardcoded or database values
//     2. Upload CSV to LoadViewer using HTTP POST (HttpClient)
// Includes helper functions:
//     - removeComma: for all string fields
//     - formatDecimal3: for weights with decimals
// ========================================

// === Constants ===
let LoadViewerTokenURL = "https://www.loadviewer.com/api/auth/jwt/token"
let LoadViewerUploadURL = "https://www.loadviewer.com/api/integration/v1/upload"
let LoadViewerAPIEmail = "YOUR_Email"
let LoadViewerAPIKey = "YOUR_API_KEY_HERE"

// Optional: You can fetch the above values from file or DB:
//     - From config files, or from a database config table
//     - From encrypted DB table
//     - From environment variables (Environment.GetEnvironmentVariable in F#)

// === Module level variable to cache the retrieved token ===
let mutable LoadViewerToken = ""

// === Dynamically generates LoadViewer CSV from hardcoded data ===
let csvGenerate () =
    let shipmentData = 
        [ "Reference", "SANDBOX-01"; "HangingAllowed", true; "UseMultipleContainers", false ] |> Map.ofList

    let containerData = 
        [ "Length", 5867; "Width", 2352; "Height", 2393; "MaxWeight", 27200.0; "BackMargin", 0 ] |> Map.ofList

    let cargoData = 
        [ "Color", "#008000"; "Length", 700; "Width", 500; "Height", 300; "Weight", 91.5; "Cartons", 300; 
          "AdditionalCartons", 0; "Placement", 0; "VerticalRotationAllowed", true; "SKUPerCarton", 1; 
          "EmptyPalletHeight", 0; "TrayCap", 0; "TrayHeight", 0; "AirSpaceLength", 0; "AirSpaceWidth", 0; 
          "AirSpaceHeight", 0; "NameOfSet", ""; "CartonRatio", 0; "Description", ""; "Destination", 0; 
          "PO", ""; "Shipper", "" ] |> Map.ofList

    let csv = StringBuilder()
    csv.Append("S,H,Reference,Hanging Allowed,Use Multiple Containers\n") |> ignore
    csv.Append(sprintf "S,D,%s,%b,%b\n" (removeComma (shipmentData.["Reference"].ToString())) shipmentData.["HangingAllowed"] shipmentData.["UseMultipleContainers"]) |> ignore
    csv.Append("B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n") |> ignore
    csv.Append(sprintf "B,D,%i,%i,%i,%s,%i\n" containerData.["Length"] containerData.["Width"] containerData.["Height"] (formatDecimal3 (containerData.["MaxWeight"] :> float)) containerData.["BackMargin"]) |> ignore
    csv.Append("C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n") |> ignore
    csv.Append(sprintf "C,D,%s,%i,%i,%i,%s,%i,%i,%i,%b,%i,%i,%i,%i,%i,%i,%i,%s,%i,%s,%i,%s,%s\n" 
                       (removeComma (cargoData.["Color"].ToString())) cargoData.["Length"] cargoData.["Width"] cargoData.["Height"] 
                       (formatDecimal3 (cargoData.["Weight"] :> float)) cargoData.["Cartons"] cargoData.["AdditionalCartons"] cargoData.["Placement"] 
                       cargoData.["VerticalRotationAllowed"] cargoData.["SKUPerCarton"] cargoData.["EmptyPalletHeight"] cargoData.["TrayCap"] 
                       cargoData.["TrayHeight"] cargoData.["AirSpaceLength"] cargoData.["AirSpaceWidth"] cargoData.["AirSpaceHeight"] 
                       (removeComma (cargoData.["NameOfSet"].ToString())) cargoData.["CartonRatio"] (removeComma (cargoData.["Description"].ToString())) 
                       cargoData.["Destination"] (removeComma (cargoData.["PO"].ToString())) (removeComma (cargoData.["Shipper"].ToString()))) |> ignore
    csv.ToString()

// === Generate CSV string for SANDBOX-01 ===
let csvCreate () =
    let csv = StringBuilder()
    csv.Append("S,H,Reference,Hanging Allowed,Use Multiple Containers\n") |> ignore
    csv.Append("S,D,SANDBOX-01,True,False\n") |> ignore
    csv.Append("B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n") |> ignore
    csv.Append("B,D,5867,2352,2393,27200,0\n") |> ignore
    csv.Append("C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n") |> ignore
    csv.Append("C,D,#008000,700,500,300,91.5,300,0,0,True,1,0,0,0,0,0,0,,0,,0,,\n") |> ignore
    csv.ToString()

// === Get JWT Token ===
let getJwtToken () =
    task {
        try
            use client = new HttpClient()
            client.Timeout <- TimeSpan.FromSeconds(5.0)
            let jsonBody = JsonSerializer.Serialize([ "email", LoadViewerAPIEmail; "apikey", LoadViewerAPIKey ] |> Map.ofList)
            let content = new StringContent(jsonBody, System.Text.Encoding.UTF8, "application/json")
            let! response = client.PostAsync(LoadViewerTokenURL, content)
            if response.IsSuccessStatusCode then
                let! responseText = response.Content.ReadAsStringAsync()
                let json = JsonDocument.Parse(responseText)
                let token = json.RootElement.GetProperty("token").GetString()
                LoadViewerToken <- token
                return token
            else
                return sprintf "ERROR: %i - %s" (int response.StatusCode) (response.Content.ReadAsStringAsync().Result)
        with ex ->
            return sprintf "Exception: %s" ex.Message
    }

// === Upload CSV using Bearer Token ===
let UploadToLoadViewer (csvData: string) (jwtToken: string) =
    task {
        let mutable retry = 3
        while retry > 0 do
            try
                use client = new HttpClient()
                client.DefaultRequestHeaders.Authorization <- System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", jwtToken)
                let content = new StringContent(csvData, System.Text.Encoding.UTF8, "text/csv")
                let! response = client.PostAsync(LoadViewerUploadURL, content)
                if response.StatusCode = System.Net.HttpStatusCode.OK || response.StatusCode = System.Net.HttpStatusCode.Accepted then
                    return sprintf "%i - %s" (int response.StatusCode) (response.Content.ReadAsStringAsync().Result)
                elif response.StatusCode = System.Net.HttpStatusCode.Gone then
                    let! newToken = getJwtToken ()
                    if newToken.StartsWith("ERROR") || newToken.StartsWith("Exception") then
                        return newToken
                    jwtToken <- newToken
                    retry <- retry - 1
                else
                    return sprintf "ERROR: %i - %s" (int response.StatusCode) (response.Content.ReadAsStringAsync().Result)
            with ex ->
                return sprintf "Exception: %s" ex.Message
        return "Upload failed after retries."
    }

// === Cleans text for CSV: removes commas and replaces line breaks ===
// === Use this for all string fields before writing to CSV ===
//
// Replaces:
//     ,     ?     (removed)
//     \r\n, \r, \n ? " " (space)
let removeComma (value: string) =
    if String.IsNullOrEmpty(value) then ""
    else
        value.Trim().Replace(",", "").Replace("\r\n", " ").Replace("\r", " ").Replace("\n", " ")

// === Converts numeric value to string with up to 3 decimal places ===
// === Trailing zeros are removed. Use only for Weight-related fields ===
//
// Examples:
//     Convert 91.5      ? "91.5"
//     Convert 91.56789  ? "91.568"
//     Keep 52           ? "52"    (no .000 added)
let formatDecimal3 (value: float) =
    sprintf "%.3f" value |> float |> string

// === OPTIONAL TEST CALL ===
// Make calls Examples
//     testUpload () //-> CSVFromHardCoded
//===============================================================
let testUpload () =
    task {
        let csv = csvCreate ()
        let! token = if String.IsNullOrEmpty LoadViewerToken then getJwtToken () else async.Return LoadViewerToken |> Async.AwaitTask
        if token.StartsWith("ERROR") || token.StartsWith("Exception") then
            printfn "Token Error or Server Not Reachable: \n%s" token
        else
            let! response = UploadToLoadViewer csv token
            printfn "%s" response
    }

package main

import (
        "bytes"
        "encoding/json"
        "fmt"
        "io"
        "log"
        "net/http"
        "strconv"
        "strings"
)

// ========================================
// Module: modLoadViewerCSV
// Purpose:
//      1. Generate LoadViewer-compatible CSV from hardcoded or database values
//      2. Upload CSV to LoadViewer using HTTP POST (http.Client)
// Includes helper functions:
//      - removeComma: for all string fields
//      - formatDecimal3: for weights with decimals
// ========================================

// === Constants ===
const (
        LoadViewerTokenURL  = "https://www.loadviewer.com/api/auth/jwt/token"
        LoadViewerUploadURL = "https://www.loadviewer.com/api/integration/v1/upload"
        LoadViewerAPIEmail  = "YOUR_Email"
        LoadViewerAPIKey    = "YOUR_API_KEY_HERE"
)

// Optional: You can fetch the above values from file or DB:
//      - From config files, or from a database config table
//      - From encrypted DB table
//      - From environment variables (os.Getenv in Go)

// === Module level variable to cache the retrieved token ===
var LoadViewerToken string

// === Dynamically generates LoadViewer CSV from hardcoded data ===
func csvGenerate() string {
        var csv strings.Builder
        shipmentData := map[string]interface{}{
                "Reference":             "SANDBOX-01",
                "HangingAllowed":        true,
                "UseMultipleContainers": false,
        }

        containerData := map[string]interface{}{
                "Length":    5867,
                "Width":     2352,
                "Height":    2393,
                "MaxWeight": 27200.0,
                "BackMargin": 0,
        }

        cargoData := map[string]interface{}{
                "Color":                 "#008000",
                "Length":                700,
                "Width":                 500,
                "Height":                300,
                "Weight":                91.5,
                "Cartons":               300,
                "AdditionalCartons":     0,
                "Placement":             0,
                "VerticalRotationAllowed": true,
                "SKUPerCarton":          1,
                "EmptyPalletHeight":     0,
                "TrayCap":               0,
                "TrayHeight":            0,
                "AirSpaceLength":        0,
                "AirSpaceWidth":         0,
                "AirSpaceHeight":        0,
                "NameOfSet":             "",
                "CartonRatio":           0,
                "Description":           "",
                "Destination":           0,
                "PO":                    "",
                "Shipper":               "",
        }

        // --- Begin CSV output ---
        csv.WriteString("S,H,Reference,Hanging Allowed,Use Multiple Containers\n")
        csv.WriteString(fmt.Sprintf("S,D,%s,%t,%t\n", removeComma(shipmentData["Reference"].(string)), shipmentData["HangingAllowed"].(bool), shipmentData["UseMultipleContainers"].(bool)))
        csv.WriteString("B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n")
        csv.WriteString(fmt.Sprintf("B,D,%d,%d,%d,%s,%d\n", containerData["Length"].(int), containerData["Width"].(int), containerData["Height"].(int), formatDecimal3(containerData["MaxWeight"].(float64)), containerData["BackMargin"].(int)))
        csv.WriteString("C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n")
        csv.WriteString(fmt.Sprintf("C,D,%s,%d,%d,%d,%s,%d,%d,%d,%t,%d,%d,%d,%d,%d,%d,%d,%s,%d,%s,%d,%s,%s\n",
                removeComma(cargoData["Color"].(string)), cargoData["Length"].(int), cargoData["Width"].(int), cargoData["Height"].(int),
                formatDecimal3(cargoData["Weight"].(float64)), cargoData["Cartons"].(int), cargoData["AdditionalCartons"].(int), cargoData["Placement"].(int),
                cargoData["VerticalRotationAllowed"].(bool), cargoData["SKUPerCarton"].(int), cargoData["EmptyPalletHeight"].(int), cargoData["TrayCap"].(int),
                cargoData["TrayHeight"].(int), cargoData["AirSpaceLength"].(int), cargoData["AirSpaceWidth"].(int), cargoData["AirSpaceHeight"].(int),
                removeComma(cargoData["NameOfSet"].(string)), cargoData["CartonRatio"].(int), removeComma(cargoData["Description"].(string)),
                cargoData["Destination"].(int), removeComma(cargoData["PO"].(string)), removeComma(cargoData["Shipper"].(string))))
        return csv.String()
}

// === Generate CSV string for SANDBOX-01 ===
func csvCreate() string {
        var csv strings.Builder
        csv.WriteString("S,H,Reference,Hanging Allowed,Use Multiple Containers\n")
        csv.WriteString("S,D,SANDBOX-01,True,False\n")
        csv.WriteString("B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n")
        csv.WriteString("B,D,5867,2352,2393,27200,0\n")
        csv.WriteString("C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n")
        csv.WriteString("C,D,#008000,700,500,300,91.5,300,0,0,True,1,0,0,0,0,0,0,,0,,0,,\n")
        return csv.String()
}

// === Get JWT Token ===
func getJwtToken() (string, error) {
        payload := map[string]string{
                "email":  LoadViewerAPIEmail,
                "apikey": LoadViewerAPIKey,
        }
        jsonPayload, err := json.Marshal(payload)
        if err != nil {
                return "", err
        }

        resp, err := http.Post(LoadViewerTokenURL, "application/json", bytes.NewBuffer(jsonPayload))
        if err != nil {
                return "", err
        }
        defer resp.Body.Close()

        body, err := io.ReadAll(resp.Body)
        if err != nil {
                return "", err
        }

        if resp.StatusCode == http.StatusOK {
                var response map[string]string
                if err := json.Unmarshal(body, &response); err != nil {
                        return "", err
                }
                LoadViewerToken = response["token"]
                return response["token"], nil
        }
        return fmt.Sprintf("ERROR: %d - %s", resp.StatusCode, string(body)), nil
}

// === Upload CSV using Bearer Token ===
func UploadToLoadViewer(csvData, jwtToken string) (string, error) {
        retry := 3
        for retry > 0 {
                req, err := http.NewRequest("POST", LoadViewerUploadURL, bytes.NewBuffer([]byte(csvData)))
                if err != nil {
                        return "", err
                }
                req.Header.Set("Content-Type", "text/csv")
                req.Header.Set("Authorization", "Bearer "+jwtToken)

                client := &http.Client{}
                resp, err := client.Do(req)
                if err != nil {
                        return "", err
                }
                defer resp.Body.Close()

                body, err := io.ReadAll(resp.Body)
                if err != nil {
                        return "", err
                }

                if resp.StatusCode == http.StatusOK || resp.StatusCode == http.StatusAccepted {
                        return fmt.Sprintf("%d - %s", resp.StatusCode, string(body)), nil
                } else if resp.StatusCode == http.StatusGone {
                        token, err := getJwtToken()
                        if err != nil {
                                return "", err
                        }
                        if strings.HasPrefix(token, "ERROR") {
                                return token, nil
                        }
                        jwtToken = token
                        retry--
                } else {
                        return fmt.Sprintf("ERROR: %d - %s", resp.StatusCode, string(body)), nil
                }
        }
        return "Upload failed after retries.", nil
}

// === Cleans text for CSV: removes commas and replaces line breaks ===
// === Use this for all string fields before writing to CSV ===
//
// Replaces:
//      ,       ?       (removed)
//      \r\n, \r, \n   ? " " (space)
func removeComma(value string) string {
        s := strings.TrimSpace(value)
        s = strings.ReplaceAll(s, ",", "")
        s = strings.ReplaceAll(s, "\r\n", " ")
        s = strings.ReplaceAll(s, "\r", " ")
        s = strings.ReplaceAll(s, "\n", " ")
        return s
}

// === Converts numeric value to string with up to 3 decimal places ===
// === Trailing zeros are removed. Use only for Weight-related fields ===
//
// Examples:
//      Convert 91.5        ? "91.5"
//      Convert 91.56789    ? "91.568"
//      Keep 52             ? "52"    (no .000 added)
func formatDecimal3(value float64) string {
        return strconv.FormatFloat(value, 'f', 3, 64)
}

// === OPTIONAL TEST CALL ===
// Make calls Examples
//      testUpload() //-> CSVFromHardCoded
// ===============================================================
func testUpload() {
        csv := csvCreate()
        token := LoadViewerToken
        if token == "" {
                tok, err := getJwtToken()
                if err != nil {
                        log.Println(err)
                        return
                }
                token = tok
        }
        if strings.HasPrefix(token, "ERROR") {
                log.Println("Token Error or Server Not Reachable: \n" + token)
                return
        }
        resp, err := UploadToLoadViewer(csv, token)
        if err != nil {
                log.Println(err)
                return
        }
        log.Println(resp)
}

func main() {
        // testUpload()
}

# ========================================
# Module: modLoadViewerCSV
# Purpose:
#     1. Generate LoadViewer-compatible CSV from hardcoded or database values
#     2. Upload CSV to LoadViewer using HTTP POST (httr package)
# Includes helper functions:
#     - removeComma: for all string fields
#     - formatDecimal3: for weights with decimals
# ========================================

# === Constants ===
LoadViewerTokenURL <- "https://www.loadviewer.com/api/auth/jwt/token"
                      LoadViewerUploadURL <- "https://www.loadviewer.com/api/integration/v1/upload"
LoadViewerAPIEmail <- "YOUR_Email"
LoadViewerAPIKey <- "YOUR_API_KEY_HERE"

# Optional: You can fetch the above values from file or DB:
#     - From config files, or from a database config table
#     - From encrypted DB table
#     - From environment variables (Sys.getenv in R)

# === Module level variable to cache the retrieved token ===
LoadViewerToken <- ""

# === Dynamically generates LoadViewer CSV from hardcoded data ===
csvGenerate <- function() {
  shipmentData <- list(
    Reference = "SANDBOX-01",
    HangingAllowed = TRUE,
    UseMultipleContainers = FALSE
  )

  containerData <- list(
    Length = 5867,
    Width = 2352,
    Height = 2393,
    MaxWeight = 27200,
    BackMargin = 0
  )

  cargoData <- list(
    Color = "#008000",
    Length = 700,
    Width = 500,
    Height = 300,
    Weight = 91.5,
    Cartons = 300,
    AdditionalCartons = 0,
    Placement = 0,
    VerticalRotationAllowed = TRUE,
    SKUPerCarton = 1,
    EmptyPalletHeight = 0,
    TrayCap = 0,
    TrayHeight = 0,
    AirSpaceLength = 0,
    AirSpaceWidth = 0,
    AirSpaceHeight = 0,
    NameOfSet = "",
    CartonRatio = 0,
    Description = "",
    Destination = 0,
    PO = "",
    Shipper = ""
  )

  # --- Begin CSV output ---
  csv <- "S,H,Reference,Hanging Allowed,Use Multiple Containers\n"
  csv <- paste0(csv, "S,D,", removeComma(shipmentData$Reference), ",", shipmentData$HangingAllowed, ",", shipmentData$UseMultipleContainers, "\n")
  csv <- paste0(csv, "B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n")
  csv <- paste0(csv, "B,D,", containerData$Length, ",", containerData$Width, ",", containerData$Height, ",", formatDecimal3(containerData$MaxWeight), ",", containerData$BackMargin, "\n")
  csv <- paste0(csv, "C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n")
  csv <- paste0(csv, "C,D,", removeComma(cargoData$Color), ",", cargoData$Length, ",", cargoData$Width, ",", cargoData$Height, ",", formatDecimal3(cargoData$Weight), ",", cargoData$Cartons, ",", cargoData$AdditionalCartons, ",", cargoData$Placement, ",", cargoData$VerticalRotationAllowed, ",", cargoData$SKUPerCarton, ",", cargoData$EmptyPalletHeight, ",", cargoData$TrayCap, ",", cargoData$TrayHeight, ",", cargoData$AirSpaceLength, ",", cargoData$AirSpaceWidth, ",", cargoData$AirSpaceHeight, ",", removeComma(cargoData$NameOfSet), ",", cargoData$CartonRatio, ",", removeComma(cargoData$Description), ",", cargoData$Destination, ",", removeComma(cargoData$PO), ",", removeComma(cargoData$Shipper), "\n")

  return(csv)
}

# === Generate CSV string for SANDBOX-01 ===
csvCreate <- function() {
  csv <- "S,H,Reference,Hanging Allowed,Use Multiple Containers\n"
  csv <- paste0(csv, "S,D,SANDBOX-01,TRUE,FALSE\n")
  csv <- paste0(csv, "B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n")
  csv <- paste0(csv, "B,D,5867,2352,2393,27200,0\n")
  csv <- paste0(csv, "C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n")
  csv <- paste0(csv, "C,D,#008000,700,500,300,91.5,300,0,0,TRUE,1,0,0,0,0,0,0,,0,,0,,\n")
  return(csv)
}

# === Get JWT Token ===
getJwtToken <- function() {
  tryCatch({
    response <- httr::POST(
      LoadViewerTokenURL,
      httr::content_type_json(),
      body = list(email = LoadViewerAPIEmail, apikey = LoadViewerAPIKey)
    )

    if (httr::status_code(response) == 200) {
      json <- httr::content(response, "parsed")
      token <- json$token
      LoadViewerToken <<- token # Cache the token
      return(token)
    } else {
      return(paste0("ERROR: ", httr::status_code(response), " - ", httr::content(response, "text")))
    }
  }, error = function(e) {
    return(paste0("Exception: ", e$message))
  })
}

# === Upload CSV using Bearer Token ===
UploadToLoadViewer <- function(csvData, jwtToken) {
  retry <- 3
  while (retry > 0) {
    tryCatch({
      response <- httr::POST(
        LoadViewerUploadURL,
        httr::content_type("text/csv"),
        httr::add_headers(Authorization = paste0("Bearer ", jwtToken)),
        body = csvData
      )

      if (httr::status_code(response) %in% c(200, 202)) {
        return(paste0(httr::status_code(response), " - ", httr::content(response, "text")))
      } else if (httr::status_code(response) == 410) {
        jwtToken <- getJwtToken()
        if (startsWith(jwtToken, "ERROR") || startsWith(jwtToken, "Exception")) {
          return(jwtToken)
        }
        retry <- retry - 1
      } else {
        return(paste0("ERROR: ", httr::status_code(response), " - ", httr::content(response, "text")))
      }
    }, error = function(e) {
      return(paste0("Exception: ", e$message))
    })
  }
  return("Upload failed after retries.")
}

# === Cleans text for CSV: removes commas and replaces line breaks ===
# === Use this for all string fields before writing to CSV ===
#
# Replaces:
#     ,     ?     (removed)
#     \r\n, \r, \n ? " " (space)
removeComma <- function(value) {
  if (is.null(value)) {
    return("")
  }
  s <- trimws(value)
  s <- gsub(",", "", s)
  s <- gsub("[\r\n]", " ", s)
  return(s)
}

# === Converts numeric value to string with up to 3 decimal places ===
# === Trailing zeros are removed. Use only for Weight-related fields ===
#
# Examples:
#     Convert 91.5      ? "91.5"
#     Convert 91.56789  ? "91.568"
#     Keep 52           ? "52"    (no .000 added)
formatDecimal3 <- function(value) {
  if (is.null(value) || !is.numeric(value)) {
    return("0")
  }
  return(format(round(value, 3), nsmall = 3, scientific = FALSE))
}

# === OPTIONAL TEST CALL ===
# Make calls Examples
#     testUpload() //-> CSVFromHardCoded
#===============================================================
testUpload <- function() {
  csv <- csvCreate()
  token <- LoadViewerToken
  if (token == "") {
    token <- getJwtToken()
  }
  if (startsWith(token, "ERROR") || startsWith(token, "Exception")) {
    print(paste0("Token Error or Server Not Reachable: \n", token))
    return()
  }
  response <- UploadToLoadViewer(csv, token)
  print(response)
}

<?php
// ========================================
// Module: modLoadViewerCSV
// Purpose:
//     1. Generate LoadViewer-compatible CSV from hardcoded or database values
//     2. Upload CSV to LoadViewer using HTTP POST (cURL)
// Includes helper functions:
//     - removeComma: for all string fields
//     - formatDecimal3: for weights with decimals
// ========================================

// === Constants ===
const LoadViewerTokenURL = 'https://www.loadviewer.com/api/auth/jwt/token';
const LoadViewerUploadURL = 'https://www.loadviewer.com/api/integration/v1/upload';
const LoadViewerAPIEmail = 'YOUR_Email';
const LoadViewerAPIKey = 'YOUR_API_KEY_HERE';

// Optional: You can fetch the above values from file or DB:
//     - From config files, or from a database config table
//     - From encrypted DB table
//     - From environment variables (getenv in PHP)

// === Module level variable to cache the retrieved token ===
$LoadViewerToken = '';

// === Dynamically generates LoadViewer CSV from hardcoded data ===
function csvGenerate() {
    $shipmentData = [
        'Reference' => 'SANDBOX-01',
        'HangingAllowed' => true,
        'UseMultipleContainers' => false,
    ];

    $containerData = [
        'Length' => 5867,
        'Width' => 2352,
        'Height' => 2393,
        'MaxWeight' => 27200,
        'BackMargin' => 0,
    ];

    $cargoData = [
        'Color' => '#008000',
        'Length' => 700,
        'Width' => 500,
        'Height' => 300,
        'Weight' => 91.5,
        'Cartons' => 300,
        'AdditionalCartons' => 0,
        'Placement' => 0,
        'VerticalRotationAllowed' => true,
        'SKUPerCarton' => 1,
        'EmptyPalletHeight' => 0,
        'TrayCap' => 0,
        'TrayHeight' => 0,
        'AirSpaceLength' => 0,
        'AirSpaceWidth' => 0,
        'AirSpaceHeight' => 0,
        'NameOfSet' => '',
        'CartonRatio' => 0,
        'Description' => '',
        'Destination' => 0,
        'PO' => '',
        'Shipper' => '',
    ];

    // --- Begin CSV output ---
    $csv = 'S,H,Reference,Hanging Allowed,Use Multiple Containers\n';
    $csv .= 'S,D,' . removeComma($shipmentData['Reference']) . ',' . ($shipmentData['HangingAllowed'] ? 'TRUE' : 'FALSE') . ',' . ($shipmentData['UseMultipleContainers'] ? 'FALSE' : 'TRUE') . '\n';
    $csv .= 'B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n';
    $csv .= 'B,D,' . $containerData['Length'] . ',' . $containerData['Width'] . ',' . $containerData['Height'] . ',' . formatDecimal3($containerData['MaxWeight']) . ',' . $containerData['BackMargin'] . '\n';
    $csv .= 'C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n';
    $csv .= 'C,D,' . removeComma($cargoData['Color']) . ',' . $cargoData['Length'] . ',' . $cargoData['Width'] . ',' . $cargoData['Height'] . ',' . formatDecimal3($cargoData['Weight']) . ',' . $cargoData['Cartons'] . ',' . $cargoData['AdditionalCartons'] . ',' . $cargoData['Placement'] . ',' . ($cargoData['VerticalRotationAllowed'] ? 'TRUE' : 'FALSE') . ',' . $cargoData['SKUPerCarton'] . ',' . $cargoData['EmptyPalletHeight'] . ',' . $cargoData['TrayCap'] . ',' . $cargoData['TrayHeight'] . ',' . $cargoData['AirSpaceLength'] . ',' . $cargoData['AirSpaceWidth'] . ',' . $cargoData['AirSpaceHeight'] . ',' . removeComma($cargoData['NameOfSet']) . ',' . $cargoData['CartonRatio'] . ',' . removeComma($cargoData['Description']) . ',' . $cargoData['Destination'] . ',' . removeComma($cargoData['PO']) . ',' . removeComma($cargoData['Shipper']) . '\n';

    return $csv;
}

// === Generate CSV string for SANDBOX-01 ===
function csvCreate() {
    $csv = 'S,H,Reference,Hanging Allowed,Use Multiple Containers\n';
    $csv .= 'S,D,SANDBOX-01,TRUE,FALSE\n';
    $csv .= 'B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n';
    $csv .= 'B,D,5867,2352,2393,27200,0\n';
    $csv .= 'C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n';
    $csv .= 'C,D,#008000,700,500,300,91.5,300,0,0,TRUE,1,0,0,0,0,0,0,,0,,0,,\n';
    return $csv;
}

// === Get JWT Token ===
function getJwtToken() {
    global $LoadViewerToken;
    $postData = json_encode(['email' => LoadViewerAPIEmail, 'apikey' => LoadViewerAPIKey]);

    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, LoadViewerTokenURL);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $postData);
    curl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: application/json']);
    curl_setopt($ch, CURLOPT_TIMEOUT, 5);

    $response = curl_exec($ch);
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    curl_close($ch);

    if ($httpCode == 200) {
        $json = json_decode($response, true);
        $LoadViewerToken = $json['token'];
        return $json['token'];
    } else {
        return 'ERROR: ' . $httpCode . ' - ' . $response;
    }
}

// === Upload CSV using Bearer Token ===
function UploadToLoadViewer($csvData, $jwtToken) {
    $retry = 3;
    while ($retry > 0) {
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, LoadViewerUploadURL);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_POST, true);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $csvData);
        curl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: text/csv', 'Authorization: Bearer ' . $jwtToken]);

        $response = curl_exec($ch);
        $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
        curl_close($ch);

        if ($httpCode == 200 || $httpCode == 202) {
            return $httpCode . ' - ' . $response;
        } else if ($httpCode == 410) {
            $jwtToken = getJwtToken();
            if (strpos($jwtToken, 'ERROR') === 0) {
                return $jwtToken;
            }
            $retry--;
        } else {
            return 'ERROR: ' . $httpCode . ' - ' . $response;
        }
    }
    return 'Upload failed after retries.';
}

// === Cleans text for CSV: removes commas and replaces line breaks ===
// === Use this for all string fields before writing to CSV ===
//
// Replaces:
//     ,     ?     (removed)
//     \r\n, \r, \n ? ' ' (space)
function removeComma($value) {
    if ($value === null) {
        return '';
    }
    $s = trim($value);
    $s = str_replace(',', '', $s);
    $s = preg_replace('/[\r\n]+/', ' ', $s);
    return $s;
}

// === Converts numeric value to string with up to 3 decimal places ===
// === Trailing zeros are removed. Use only for Weight-related fields ===
//
// Examples:
//     Convert 91.5      ? '91.5'
//     Convert 91.56789  ? '91.568'
//     Keep 52           ? '52'    (no .000 added)
function formatDecimal3($value) {
    if ($value === null || !is_numeric($value)) {
        return '0';
    }
    return rtrim(sprintf('%.3f', $value), '0.');
}

// === OPTIONAL TEST CALL ===
// Make calls Examples
//     testUpload() //-> CSVFromHardCoded
//===============================================================
function testUpload() {
    global $LoadViewerToken;
    $csv = csvCreate();
    $token = $LoadViewerToken;
    if (empty($token)) {
        $token = getJwtToken();
    }
    if (strpos($token, 'ERROR') === 0) {
        echo 'Token Error or Server Not Reachable: \n' . $token;
        return;
    }
    $response = UploadToLoadViewer($csv, $token);
    echo $response;
}
?>

import 'dart:convert';
import 'package:http/http.dart' as http;

// ========================================
// Module: modLoadViewerCSV
// Purpose:
//     1. Generate LoadViewer-compatible CSV from hardcoded or database values
//     2. Upload CSV to LoadViewer using HTTP POST (http package)
// Includes helper functions:
//     - removeComma: for all string fields
//     - formatDecimal3: for weights with decimals
// ========================================

// === Constants ===
const String LoadViewerTokenURL = "https://www.loadviewer.com/api/auth/jwt/token";
const String LoadViewerUploadURL = "https://www.loadviewer.com/api/integration/v1/upload";
const String LoadViewerAPIEmail = "YOUR_Email";
const String LoadViewerAPIKey = "YOUR_API_KEY_HERE";

// Optional: You can fetch the above values from file or DB:
//     - From config files, or from a database config table
//     - From encrypted DB table
//     - From environment variables (Platform.environment in Dart)

// === Module level variable to cache the retrieved token ===
String LoadViewerToken = "";

// === Dynamically generates LoadViewer CSV from hardcoded data ===
String csvGenerate() {
  Map<String, dynamic> shipmentData={
    "Reference": "SANDBOX-01",
    "HangingAllowed": true,
    "UseMultipleContainers": false,
  };
              Map<String, dynamic> containerData = {
    "Length": 5867,
    "Width": 2352,
    "Height": 2393,
    "MaxWeight": 27200.0,
    "BackMargin": 0,
  };

  Map<String, dynamic> cargoData = {
    "Color": "#008000",
    "Length": 700,
    "Width": 500,
    "Height": 300,
    "Weight": 91.5,
    "Cartons": 300,
    "AdditionalCartons": 0,
    "Placement": 0,
    "VerticalRotationAllowed": true,
    "SKUPerCarton": 1,
    "EmptyPalletHeight": 0,
    "TrayCap": 0,
    "TrayHeight": 0,
    "AirSpaceLength": 0,
    "AirSpaceWidth": 0,
    "AirSpaceHeight": 0,
    "NameOfSet": "",
    "CartonRatio": 0,
    "Description": "",
    "Destination": 0,
    "PO": "",
    "Shipper": "",
  };

  // --- Begin CSV output ---
  String csv = "S,H,Reference,Hanging Allowed,Use Multiple Containers\n";
  csv += "S,D,<span class="math-inline">\{removeComma\(shipmentData\["Reference"\]\)\},</span>{shipmentData["HangingAllowed"]},<span class="math-inline" >\{shipmentData\["UseMultipleContainers"\]\}\\n";
csv \+\= "B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\\n";
csv \+\= "B,D,</span>{containerData["Length"]},<span class="math-inline" >\{containerData\["Width"\]\},</span>{containerData["Height"]},<span class="math-inline" >\{formatDecimal3\(containerData\["MaxWeight"\]\)\},</span>{containerData["BackMargin"]}\n";
  csv += "C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n";
  csv += "C,D,<span class="math-inline">\{removeComma\(cargoData\["Color"\]\)\},</`>{cargoData["Length"]},<span class="math-inline" >\{cargoData\["Width"\]\},</span>{cargoData["Height"]},<span class="math-inline" >\{formatDecimal3\(cargoData\["Weight"\]\)\},</span>{cargoData["Cartons"]},<span class="math-inline" >\{cargoData\["AdditionalCartons"\]\},</span>{cargoData["Placement"]},<span class="math-inline" >\{cargoData\["VerticalRotationAllowed"\]\},</span>{cargoData["SKUPerCarton"]},<span class="math-inline" >\{cargoData\["EmptyPalletHeight"\]\},</span>{cargoData["TrayCap"]},<span class="math-inline" >\{cargoData\["TrayHeight"\]\},</span>{cargoData["AirSpaceLength"]},<span class="math-inline" >\{cargoData\["AirSpaceWidth"\]\},</span>{cargoData["AirSpaceHeight"]},<span class="math-inline" >\{removeComma\(cargoData\["NameOfSet"\]\)\},</span>{cargoData["CartonRatio"]},<span class="math-inline" >\{removeComma\(cargoData\["Description"\]\)\},</span>{cargoData["Destination"]},<span class="math-inline" >\{removeComma\(cargoData\["PO"\]\)\},</span>{removeComma(cargoData["Shipper"])}\n";

  return csv;
}

// === Generate CSV string for SANDBOX-01 ===
String csvCreate() {
  String csv = "S,H,Reference,Hanging Allowed,Use Multiple Containers\n";
  csv += "S,D,SANDBOX-01,TRUE,FALSE\n";
  csv += "B,H,Length mm,Width mm,Height mm,Max Weight Kg,Back Margin mm\n";
  csv += "B,D,5867,2352,2393,27200,0\n";
  csv += "C,H,Color,Length mm,Width mm,Height mm,Weight Kg,Cartons,Additional Cartons,Placement,Vertical Rotation Allowed,SKU per Carton,Empty Pallet Height mm,Tray Cap mm,Tray Height mm,Air Space Lenght mm,Air Space Width mm,Air Space Height mm,Name of Set,Cartons Ratio in the Set,Description,Destination,PO,Shipper\n";
  csv += "C,D,#008000,700,500,300,91.5,300,0,0,TRUE,1,0,0,0,0,0,0,,0,,0,,\n";
  return csv;
}

// === Get JWT Token ===
Future<String> getJwtToken() async {
  try {
    final response = await http.post(
      Uri.parse(LoadViewerTokenURL),
      headers: {'Content-Type': 'application/json'},
      body: jsonEncode({"email": LoadViewerAPIEmail, "apikey": LoadViewerAPIKey}),
    );

    if (response.statusCode == 200) {
      final json = jsonDecode(response.body);
      LoadViewerToken = json['token'];
      return json['token'];
    } else {
      return "ERROR: ${response.statusCode} - ${response.body}";
    }
  } catch (e) {
    return "Exception: $e";
  }
}

// === Upload CSV using Bearer Token ===
Future<String> UploadToLoadViewer(String csvData, String jwtToken) async {
  int retry = 3;
  while (retry > 0) {
    try {
      final response = await http.post(
        Uri.parse(LoadViewerUploadURL),
        headers: {'Content-Type': 'text/csv', 'Authorization': 'Bearer <span class="math-inline">jwtToken'\},
body\: csvData,
\);
if \(response\.statusCode \=\= 200 \|\| response\.statusCode \=\= 202\) \{
return "</span>{response.statusCode} - ${response.body}";
      } else if (response.statusCode == 410) {
        jwtToken = await getJwtToken();
        if (jwtToken.startsWith("ERROR")) {
          return jwtToken;
        }
        retry--;
      } else {
        return "ERROR: ${response.statusCode} - ${response.body}";
      }
    } catch (e) {
      return "Exception: <span class="math-inline">e";
\}
\}
return "Upload failed after retries\.";
\}
// \=\=\= Cleans text for CSV\: removes commas and replaces line breaks \=\=\=
// \=\=\= Use this for all string fields before writing to CSV \=\=\=
//
// Replaces\:
//     ,     ?     \(removed\)
//     \\r\\n, \\r, \\n ? " " \(space\)
String removeComma\(String value\) \{
if \(value \=\= null\) \{
return "";
\}
String s \= value\.trim\(\);
s \= s\.replaceAll\(",", ""\);
s \= s\.replaceAll\(RegExp\(r"\[\\r\\n\]\+"\), " "\);
return s;
\}
// \=\=\= Converts numeric value to string with up to 3 decimal places \=\=\=
// \=\=\= Trailing zeros are removed\. Use only for Weight\-related fields \=\=\=
//
// Examples\:
//     Convert 91\.5      ? "91\.5"
//     Convert 91\.56789  ? "91\.568"
//     Keep 52           ? "52"    \(no \.000 added\)
String formatDecimal3\(double value\) \{
if \(value \=\= null \|\| value\.isNaN\) \{
return "0";
\}
return value\.toStringAsFixed\(3\)\.replaceAll\(RegExp\(r"0\*</span>"), '').replaceAll(RegExp(r"\.$"), '');
}

// === OPTIONAL TEST CALL ===
// Make calls Examples
//     testUpload() //-> CSVFromHardCoded
//===============================================================
Future<void> testUpload() async {
  String csv = csvCreate();
  String token = LoadViewerToken;
  if (token.isEmpty) {
    token = await getJwtToken();
  }
  if (token.startsWith("ERROR")) {
    print("Token Error or Server Not Reachable: \n$token");
    return;
  }
  String response = await UploadToLoadViewer(csv, token);
  print(response);
}