29 lines
6.6 KiB
Batchfile
29 lines
6.6 KiB
Batchfile
::---------------------------------------Greenhouse--------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'GUAU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\GUAU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'GUBU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\GUBU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'GCAU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\GCAU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'GCBU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\GCBU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'GCEU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\GCEU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'GCWU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\GCWU.csv"
|
|
::---------------------------------------Fiber-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'FCAC'" -t --csv -o"C:\Users\PTrowbridge\price_lists\FCAC.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'FCBC'" -t --csv -o"C:\Users\PTrowbridge\price_lists\FCBC.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'FCCC'" -t --csv -o"C:\Users\PTrowbridge\price_lists\FCCC.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'FUAU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\FUAU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'FUBU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\FUBU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'FUCU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\FUCU.csv"
|
|
::---------------------------------------Nursery-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'NUEU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\NUEU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'NUGU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\NUGU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'NUFU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\NUFU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'NUSU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\NUSU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'NUWU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\NUWU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'NUOU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\NUOU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'NUYU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\NUYU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'NUDU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\NUDU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'NCEU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\NCEU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'NCWU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\NCWU.csv"
|
|
::---------------------------------------Protective Packaging----------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'PUBU'" -t --csv -o"C:\Users\PTrowbridge\price_lists\PUBU.csv"
|
|
"C:\Program Files\PostgreSQL\15\bin\psql.exe" -U ptrowbridge -d ubm -p 5432 -h usmidsap01 -c "SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 FROM rlarp.plcore_upload WHERE listcode = 'PCBC'" -t --csv -o"C:\Users\PTrowbridge\price_lists\PCBC.csv"
|