#! /bin/sh
# sidconf
# recordno serial not null ,
# sid char(32) not null ,
# sidmainttype char(32),
# sdate date not null ,
# edate date,
# grid char(8),
# directoryid integer,
# serialnumber char(32),
# purchased date,
# manufacturer char(32),
# model char(32),
# supplier char(32),
# datatype char(32),
# carriercode char(32),
# servicetype char(32),
# intfld1 integer,
# intfld2 integer,
# intfld3 integer,
# intfld4 integer,
# intfld5 integer,
# intfld6 integer,
# intfld7 integer,
# intfld8 integer,
# intfld9 integer,
# floatfld1 float,
# floatfld2 float,
# floatfld3 float,
# floatfld4 float,
# floatfld5 float,
# floatfld6 float,
# floatfld7 float,
# floatfld8 float,
# floatfld9 float,
# datefld1 date,
# datefld2 date,
# datefld3 date,
# datefld4 date,
# datefld5 date,
# datefld6 date,
# datefld7 date,
# datefld8 date,
# datefld9 date,
# costfld1 money(10,2),
# costfld2 money(10,2),
# costfld3 money(10,2),
# costfld4 money(10,2),
# costfld5 money(10,2),
# costfld6 money(10,2),
# costfld7 money(10,2),
# costfld8 money(10,2),
# costfld9 money(10,2),
# genfld1 char(50),
# genfld2 char(50),
# genfld3 char(50),
# genfld4 char(50),
# genfld5 char(50),
# genfld6 char(50),
# genfld7 char(50),
# genfld8 char(50),
# genfld9 char(50),
# dateupdated date not null ,
# msg1 char(132),
# msg2 char(132),
# msg3 char(132),
# msg4 char(132),
# msg5 char(132),
# msg6 char(132),
# msg7 char(132),
# msg8 char(132),
# msg9 char(132)
# mobconf
#recordno serial no
#mobile char(32) no
#customid char(32) yes
#sdate date no
#edate date yes
#directoryid integer yes
#groupid char(8) yes
#datatype char(32) yes
#purchased date yes
#supplier char(32) yes
#manufacturer char(32) yes
#model char(32) yes
#carriercode char(32) yes
#servicetype char(32) yes
#create view "catcom".mobconf (recordno,mobile,customid,sdate,edate,directoryid,groupid,datatype,purchased,supplier,manufacturer,model,carriercode,servicetype,introaming,gprs,simnumber,imeinumber,puk,dataplan,contractstart,contractfinish,archivecomment,updated,msg1,msg2,msg3,msg4,msg5,msg6,msg7,msg8,msg9) as
# select x0.recordno ,x0.sid ,x0.sidmainttype ,x0.sdate ,x0.edate
# ,x0.directoryid ,x0.grid ,x0.datatype ,x0.purchased ,x0.supplier
# ,x0.manufacturer ,x0.model ,x0.carriercode ,x0.servicetype
# ,x0.datefld1 ,x0.genfld1 ,x0.genfld2 ,x0.genfld3 ,x0.genfld6
# ,x0.genfld4 ,x0.datefld2 ,x0.datefld3 ,x0.genfld5 ,x0.dateupdated
# ,x0.msg1 ,x0.msg2 ,x0.msg3 ,x0.msg4 ,x0.msg5 ,x0.msg6 ,x0.msg7
# ,x0.msg8 ,x0.msg9 from "catcom".sidconf x0 where (x0.sidmainttype
# = 'mobile_phones' ) ;
#---------------------------------------------------------------
startRecordNo="17801"
recordno="$startRecordNo"
domkmob2()
{
SIM="$1"
MSN="$2"
Archive_Comment="$3"
Activation="$4"
Data_Plan="$5"
Data_Type="$6"
Carrier_Code="$7"
Cost_Centre="$8"
nextrecordno=`expr $recordno + 1`
# mobconf view
mc_recordno="$nextrecordno"
mc_mobile="$MSN"
mc_customid="mobile_phones"
mc_sdate="$Activation"
mc_edate=""
mc_directoryid=""
mc_groupid="$Cost_Centre"
mc_datatype="$Data_Type"
mc_purchased=""
mc_supplier=""
mc_manufacturer=""
mc_model=""
mc_carriercode="$Carrier_Code"
mc_servicetype=""
mc_introaming=""
mc_gprs=""
mc_simnumber="$SIM"
mc_imeinumber=""
mc_puk=""
mc_dataplan="$Data_Plan"
mc_contractstart=""
mc_contractfinish=""
mc_archivecomment="$Archive_Comment"
mc_updated="10/04/2024"
mc_msg1=""
mc_msg2=""
mc_msg3=""
mc_msg4=""
mc_msg5=""
mc_msg6=""
mc_msg7=""
mc_msg8=""
mc_msg9=""
# sidconf table
recordno="$mc_recordno"
sid="$mc_mobile"
sidmainttype="$mc_customid"
sdate="$mc_sdate"
edate="$mc_edate"
grid="$mc_groupid"
directoryid="$mc_directoryid"
serialnumber=""
purchased="$mc_purchased"
manufacturer="$mc_manufacturer"
model="$mc_model"
supplier="$mc_supplier"
datatype="$mc_datatype"
carriercode="$mc_carriercode"
servicetype="$mc_servicetype"
intfld1=""
intfld2=""
intfld3=""
intfld4=""
intfld5=""
intfld6=""
intfld7=""
intfld8=""
intfld9=""
floatfld1=""
floatfld2=""
floatfld3=""
floatfld4=""
floatfld5=""
floatfld6=""
floatfld7=""
floatfld8=""
floatfld9=""
datefld1="$mc_introaming"
datefld2="$mc_contractstart"
datefld3="$mc_contractfinish"
datefld4=""
datefld5=""
datefld6=""
datefld7=""
datefld8=""
datefld9=""
costfld1=""
costfld2=""
costfld3=""
costfld4=""
costfld5=""
costfld6=""
costfld7=""
costfld8=""
costfld9=""
genfld1="$mc_gprs"
genfld2="$mc_simnumber"
genfld3="$mc_imeinumber"
genfld4="$mc_dataplan"
genfld5="$mc_archivecomment"
genfld6="$mc_puk"
genfld7=""
genfld8=""
genfld9=""
dateupdated="$mc_updated"
msg1="$mc_msg1"
msg2="$mc_msg2"
msg3="$mc_msg3"
msg4="$mc_msg4"
msg5="$mc_msg5"
msg6="$mc_msg6"
msg7="$mc_msg7"
msg8="$mc_msg8"
msg9="$mc_msg9"
echo "$recordno|$sid|$sidmainttype|$sdate|$edate|$grid|$directoryid|$serialnumber|$purchased|$manufacturer|$model|$supplier|$datatype|$carriercode|$servicetype|$intfld1|$intfld2|$intfld3|$intfld4|$intfld5|$intfld6|$intfld7|$intfld8|$intfld9|$floatfld1|$floatfld2|$floatfld3|$floatfld4|$floatfld5|$floatfld6|$floatfld7|$floatfld8|$floatfld9|$datefld1|$datefld2|$datefld3|$datefld4|$datefld5|$datefld6|$datefld7|$datefld8|$datefld9|$costfld1|$costfld2|$costfld3|$costfld4|$costfld5|$costfld6|$costfld7|$costfld8|$costfld9|$genfld1|$genfld2|$genfld3|$genfld4|$genfld5|$genfld6|$genfld7|$genfld8|$genfld9|$dateupdated|$msg1|$msg2|$msg3|$msg4|$msg5|$msg6|$msg7|$msg8|$msg9|"
}
# SLC2_Transmit.csv
#SIM,MSN,Archive Comment,Actvation,Data Plan,Data Type,Carrier Code,Cost Centre
domkmob2 5921043634495 0481241143 SLC2-1 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634487 0481242952 SLC2-2 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634479 0481243072 SLC2-3 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634461 0481247991 SLC2-4 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634453 0481248728 SLC2-5 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634446 0481249402 SLC2-6 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634438 0481245792 SLC2-7 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634420 0481246735 SLC2-8 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634412 0481247484 SLC2-9 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634404 0481243925 SLC2-10 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634396 0481249586 SLC2-11 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634388 0481253334 SLC2-12 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634370 0481252644 SLC2-13 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634362 0481256338 SLC2-14 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634354 0481251435 SLC2-15 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634347 0481253488 SLC2-16 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634339 0481253376 SLC2-17 10-10-2024 GOV16 8 o FBL-EXEC
domkmob2 5921043634321 0481252567 SLC2-18 10-10-2024 GOV16 8 o FBL-EXEC