I have information in a TEXT (actually .dvc but can be viewed in notepad) file I'd like to be able to import into ZOHO creator. Every line of text I'd like to be a different entry of data in a form.
This is the example of the file I'd like to import:
// DVC VERSION 2
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/producerpromos11.m2t" 00:01:29.880
SU --/--/-- --:28:30 *.dcmd PS "/media/hd0/media/producerpromos11.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/communityboardslides43a.m2t" 00:01:29.850
SU --/--/-- --:58:30 *.dcmd PS "/media/hd0/media/communityboardslides43a.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3115_006_TheOccupiedZone_EP^_the grayces.m2t" 00:28:29.100
SU --/--/-- 00:00:01 *.dcmd PS "/media/hd0/media/3115_006_TheOccupiedZone_EP^_the grayces.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3037_018_MicCheck_ApolloSchool_EP18.mpg" 00:28:40.440
SU --/--/-- 00:30:00 *.dcmd PS "/media/hd0/media/3037_018_MicCheck_ApolloSchool_EP18.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3070_032_TSUHipHopintheVille_EP32.mpg" 00:28:29.560
SU --/--/-- 01:00:00 *.dcmd PS "/media/hd0/media/3070_032_TSUHipHopintheVille_EP32.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3044_036_MysteryUS_EP36_JeffPrattStudio.mpg" 00:28:30.230
SU --/--/-- 01:30:00 *.dcmd PS "/media/hd0/media/3044_036_MysteryUS_EP36_JeffPrattStudio.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3062_027a_Jesse Goldberg Show _EP27a_Ayla Brown part 2.mpg" 00:28:28.330
SU --/--/-- 02:00:00 *.dcmd PS "/media/hd0/media/3062_027a_Jesse Goldberg Show _EP27a_Ayla Brown part 2.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3048_058a_OnTheScene_EP58a.mpg" 00:28:29.060
SU --/--/-- 02:30:00 *.dcmd PS "/media/hd0/media/3048_058a_OnTheScene_EP58a.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3022_012_Firepitfriday_American_Pickers_EP12.m2t" 00:28:29.100
SU --/--/-- 03:00:00 *.dcmd PS "/media/hd0/media/3022_012_Firepitfriday_American_Pickers_EP12.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3092_016_Ethio_Nashville032412_EP16.mpg" 00:30:12.670
SU --/--/-- 03:30:00 *.dcmd PS "/media/hd0/media/3092_016_Ethio_Nashville032412_EP16.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3105_002_LaTertulia_EP2.mpg" 00:28:29.690
SU --/--/-- 04:00:00 *.dcmd PS "/media/hd0/media/3105_002_LaTertulia_EP2.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3009_129_CashvilleLiveTV_EP129_Show3Season6.mpg" 00:29:01.430
SU --/--/-- 04:30:00 *.dcmd PS "/media/hd0/media/3009_129_CashvilleLiveTV_EP129_Show3Season6.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3101_013a_StateoftheCity_EP13a_MikeJameson.mpg" 00:28:28.500
SU --/--/-- 05:00:00 *.dcmd PS "/media/hd0/media/3101_013a_StateoftheCity_EP13a_MikeJameson.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3097_046_PentacostalBreakthrough_EP46_ComeForth.mpg" 00:28:29.340
SU --/--/-- 05:30:00 *.dcmd PS "/media/hd0/media/3097_046_PentacostalBreakthrough_EP46_ComeForth.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3004_021_BillyBlockShow_EP21_EP771_060512.m2t" 00:28:32.210
SU --/--/-- 06:00:00 *.dcmd PS "/media/hd0/media/3004_021_BillyBlockShow_EP21_EP771_060512.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3115_006_TheOccupiedZone_EP^_the grayces.m2t" 00:28:29.100
SU --/--/-- 06:30:00 *.dcmd PS "/media/hd0/media/3115_006_TheOccupiedZone_EP^_the grayces.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3055_72212_PowerofPrayer_EP72212.mpg" 00:28:32.430
SU --/--/-- 07:00:00 *.dcmd PS "/media/hd0/media/3055_72212_PowerofPrayer_EP72212.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3111_72212_KingdomLight_EP72212.mpg" 00:28:29.420
SU --/--/-- 07:30:00 *.dcmd PS "/media/hd0/media/3111_72212_KingdomLight_EP72212.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3109_026_Chico Bman Episode_EP26_TheFutureTeller.m2t" 00:28:37.040
SU --/--/-- 08:00:00 *.dcmd PS "/media/hd0/media/3109_026_Chico Bman Episode_EP26_TheFutureTeller.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3097_046_PentacostalBreakthrough_EP46_ComeForth.mpg" 00:28:29.340
SU --/--/-- 08:30:00 *.dcmd PS "/media/hd0/media/3097_046_PentacostalBreakthrough_EP46_ComeForth.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3010_72212_CCGospel_EP72212.mpg" 00:28:33.060
SU --/--/-- 09:00:00 *.dcmd PS "/media/hd0/media/3010_72212_CCGospel_EP72212.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3023_72212_GardenofPrayer_EP72212.mpg" 00:28:30.400
SU --/--/-- 09:30:00 *.dcmd PS "/media/hd0/media/3023_72212_GardenofPrayer_EP72212.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3091_72212_MomentofTruth_EP72212.mpg" 00:28:30.400
SU --/--/-- 10:00:00 *.dcmd PS "/media/hd0/media/3091_72212_MomentofTruth_EP72212.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3065-103 Spirit Soul and Body Ep103.m2t" 00:28:36.790
SU --/--/-- 10:30:00 *.dcmd PS "/media/hd0/media/3065-103 Spirit Soul and Body Ep103.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3101_013a_StateoftheCity_EP13a_MikeJameson.mpg" 00:28:28.500
SU --/--/-- 11:00:00 *.dcmd PS "/media/hd0/media/3101_013a_StateoftheCity_EP13a_MikeJameson.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3051-003 Our Community Ep3.m2t" 00:28:30.790
SU --/--/-- 11:30:00 *.dcmd PS "/media/hd0/media/3051-003 Our Community Ep3.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3118_007_PropheticFlow_EP7_Abortion.mpg" 00:28:29.300
SU --/--/-- 12:00:00 *.dcmd PS "/media/hd0/media/3118_007_PropheticFlow_EP7_Abortion.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3037_018_MicCheck_ApolloSchool_EP18.mpg" 00:28:40.440
SU --/--/-- 12:30:00 *.dcmd PS "/media/hd0/media/3037_018_MicCheck_ApolloSchool_EP18.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3094-843 We Believe EP843.m2t" 00:28:31.620
SU --/--/-- 13:00:00 *.dcmd PS "/media/hd0/media/3094-843 We Believe EP843.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3035_003_LivingWord_EP3.m2t" 00:28:29.420
SU --/--/-- 13:30:00 *.dcmd PS "/media/hd0/media/3035_003_LivingWord_EP3.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3019_068b_EarthRevolutions_EP68b_JasonHolleman.mpg" 00:28:17.000
SU --/--/-- 14:00:00 *.dcmd PS "/media/hd0/media/3019_068b_EarthRevolutions_EP68b_JasonHolleman.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3086_116_SpiritualMetaphysics_EP116_LightoftheWorld.mpg" 00:29:01.050
SU --/--/-- 14:30:00 *.dcmd PS "/media/hd0/media/3086_116_SpiritualMetaphysics_EP116_LightoftheWorld.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3084-005 Music City Gospel EP5.m2t" 00:28:29.340
SU --/--/-- 15:00:00 *.dcmd PS "/media/hd0/media/3084-005 Music City Gospel EP5.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3011_031_ChangedLives_EP31_MakingtheAmericanDream5.mpg" 00:28:29.060
SU --/--/-- 15:30:00 *.dcmd PS "/media/hd0/media/3011_031_ChangedLives_EP31_MakingtheAmericanDream5.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3027_849_InnerCityChurchofChrist_EP849.mpg" 00:28:29.230
SU --/--/-- 16:00:00 *.dcmd PS "/media/hd0/media/3027_849_InnerCityChurchofChrist_EP849.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3099_001_WeHearYou_ soul souljas_EP1.mpg" 00:28:26.930
SU --/--/-- 16:30:00 *.dcmd PS "/media/hd0/media/3099_001_WeHearYou_ soul souljas_EP1.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3063_7812_SouloftheCity_EP7812.mpg" 00:28:40.850
SU --/--/-- 17:00:00 *.dcmd PS "/media/hd0/media/3063_7812_SouloftheCity_EP7812.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3046_140_Nashville_Spotlight_EP_140.m2t" 00:28:29.150
SU --/--/-- 17:30:00 *.dcmd PS "/media/hd0/media/3046_140_Nashville_Spotlight_EP_140.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3016_005_DanceAroundNashville_005.m2t" 00:28:29.090
SU --/--/-- 18:00:00 *.dcmd PS "/media/hd0/media/3016_005_DanceAroundNashville_005.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3114_011_BibleQuestionsTV_EP11_Foxes.mpg" 00:28:29.010
SU --/--/-- 18:30:00 *.dcmd PS "/media/hd0/media/3114_011_BibleQuestionsTV_EP11_Foxes.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3030_047_JustMen_EP47_MichaelGooch.mpg" 00:28:31.090
SU --/--/-- 19:00:00 *.dcmd PS "/media/hd0/media/3030_047_JustMen_EP47_MichaelGooch.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3069_027_trythelight5_EP27.m2t" 00:28:13.010
SU --/--/-- 19:30:00 *.dcmd PS "/media/hd0/media/3069_027_trythelight5_EP27.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3029_236_JohnnyDanielsShow_EP236.mpg" 00:28:37.920
SU --/--/-- 20:00:00 *.dcmd PS "/media/hd0/media/3029_236_JohnnyDanielsShow_EP236.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3092_017_Ethio_Nashville033112_EP17.mpg" 00:28:54.480
SU --/--/-- 20:30:00 *.dcmd PS "/media/hd0/media/3092_017_Ethio_Nashville033112_EP17.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3106_002_DoinitDavesWay_EP2.m2t" 00:28:29.190
SU --/--/-- 21:00:00 *.dcmd PS "/media/hd0/media/3106_002_DoinitDavesWay_EP2.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3039_032a_mind your own music business_EP32a_Jeff Mobley.mpg" 00:28:28.400
SU --/--/-- 21:30:00 *.dcmd PS "/media/hd0/media/3039_032a_mind your own music business_EP32a_Jeff Mobley.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3022_012_Firepitfriday_American_Pickers_EP12.m2t" 00:28:29.100
SU --/--/-- 22:00:00 *.dcmd PS "/media/hd0/media/3022_012_Firepitfriday_American_Pickers_EP12.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3122_001GodsTruthandDeliverance_EP001.m2t" 00:28:39.150
SU --/--/-- 22:30:00 *.dcmd PS "/media/hd0/media/3122_001GodsTruthandDeliverance_EP001.m2t"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3017_076_DramaticPoetryWorks_EP76_GreekShow.mpg" 00:29:59.150
SU --/--/-- 23:00:00 *.dcmd PS "/media/hd0/media/3017_076_DramaticPoetryWorks_EP76_GreekShow.mpg"
// "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/3104_023_FoundationofTruth_RichMan5.mpg" 00:28:30.420
SU --/--/-- 23:30:00 *.dcmd PS "/media/hd0/media/3104_023_FoundationofTruth_RichMan5.mpg"
// "Start" "TRANSPORT" "RUN" "/media/hd0/dvc/SCHmonday.DVC"
SU --/--/-- 23:59:59 *.sysd RU "/media/hd0/dvc/SCHmonday.DVC"
It is a schedule that runs. I want the "SU" to feed a certain field in the form. I'd like the time to feed another field. And so on and so forth. There has to be away to just load these files and have a zoho script do the rest. Can anyone help me? I would be happy to give access to my Application for a better understanding. Let me know.
John Ferguson