#! /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="17753" 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|" } # Aus4Skills_April_24-Transmit.csv #SIM,MSN,Archive Comment,Actvation,Data Plan,Data Type,Carrier Code,Cost Centre domkmob2 5921043634081 0482131795 Aus4Skills1 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634073 0482131796 Aus4Skills2 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634065 0482131798 Aus4Skills3 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634057 0482131800 Aus4Skills4 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634040 0482131801 Aus4Skills5 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634032 0482131802 Aus4Skills6 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634784 0482131803 Aus4Skills7 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634792 0482131804 Aus4Skills8 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634800 0482131805 Aus4Skills9 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634818 0482131806 Aus4Skills10 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634826 0482131807 Aus4Skills11 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634834 0482131808 Aus4Skills12 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634842 0482131825 Aus4Skills13 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634867 0482131966 Aus4Skills15 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634875 0482131969 Aus4Skills16 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634883 0482131972 Aus4Skills17 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634891 0482131976 Aus4Skills18 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634909 0482131981 Aus4Skills19 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634917 0482131990 Aus4Skills20 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634925 0482131993 Aus4Skills21 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634933 0482131995 Aus4Skills22 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634941 0482131998 Aus4Skills23 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634958 0482132001 Aus4Skills24 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634966 0482132003 Aus4Skills25 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634974 0482132025 Aus4Skills26 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634982 0482132026 Aus4Skills27 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043634990 0482132027 Aus4Skills28 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043635005 0482132028 Aus4Skills29 28/03/2024 GOV16 8 o FBL-EXEC domkmob2 5921043631673 0482132007 Aus4Skills30 28/03/2024 GOV16 8 o FBL-EXEC