Hey, I am running a suitelet which takes input CSV...
# suitescriptr
razer456
03/27/2022, 2:53 AMHey, I am running a suitelet which takes input CSV files and imports custom records into netsuite.. That works good.
But i want to process those record after the import, but I don't get those custom records in the map/reduce script.
I only run map reduce after the schedule task has "complete" status, but still there seems to be a delay. And map reduce don't get those records. And doesn't work on those. Is there another way?
b
battk
03/27/2022, 3:30 AMnot really enough information to go on, not sure how you are importing those records, nor the link between the map/reduce and how you import those records
r
razer456
03/27/2022, 4:13 AMThrough script, task module
razer456
03/27/2022, 4:13 AMTask.create
razer456
03/27/2022, 4:14 AMI have to run map reduce after I import the records
razer456
03/27/2022, 4:14 AMTo process the custom records and create a vendor bill from those records
b
battk
03/27/2022, 4:15 AMthere are 2 approaches to importing csv files
battk
03/27/2022, 4:16 AMare you using the native csv import, or are you parsing the file yourself in a scheduled/map reduce script
r
razer456
03/27/2022, 4:16 AMI am parsing it myself and importing in schedule yes
razer456
03/27/2022, 4:17 AMI am able to import through schedule script
b
battk
03/27/2022, 4:19 AMmost straightforward and error resistant way is to set a field on the record you import so that you can search for it in your map/reduce
r
razer456
03/27/2022, 4:20 AMI am directly searching on the custom records created
razer456
03/27/2022, 4:21 AMWhich field do I set? I am getting the custom record created but I am not getting the newly imported records
razer456
03/27/2022, 4:21 AMIn the map reduce
b
battk
03/27/2022, 4:31 AMmake a custom field that you use only for identifying records to process in your map/reduce
battk
03/27/2022, 4:31 AMif you have simple needs, you can make it a checkbox
battk
03/27/2022, 4:31 AMelse a text field that you set to some unique value shared in your batch
r
razer456
03/27/2022, 4:35 AMBut still I won't get the records for some reason
razer456
03/27/2022, 4:36 AMI can do that
razer456
03/27/2022, 4:36 AMBut the thing is after importing the records through script and after getting the status complete via script. I am running the map reduce and not getting those records
b
battk
03/27/2022, 4:41 AMwhat does your map/reduce look like'
r
razer456
03/27/2022, 4:42 AMI don't think the issue is map reduce
razer456
03/27/2022, 4:45 AMBecause see, initially there are no records in the system, then I am importing the records through scheduled.
And while running the map reduce I am not getting any records
razer456
03/27/2022, 4:45 AMI think my code might be the problem
razer456
03/27/2022, 4:46 AMBut I am checking the status and then only running MR
b
battk
03/27/2022, 4:48 AMthat doesnt sound right
battk
03/27/2022, 4:48 AMnormally you would create the map/reduce task using the scheduled script
battk
03/27/2022, 4:49 AMthough honestly you may just want to use a map/reduce to create both the custom record and your transacctions
r
razer456
03/27/2022, 4:52 AMSo i should run the import in the get input stage ?
razer456
03/27/2022, 4:52 AMOh create the record
razer456
03/27/2022, 4:52 AMAnd everything
razer456
03/27/2022, 4:52 AMI see
razer456
03/27/2022, 4:52 AMI mean I could do that
razer456
03/27/2022, 4:53 AMThat is also a good option
razer456
03/27/2022, 4:53 AMI could take the CSV process it all then and there itself
b
battk
03/27/2022, 4:59 AMyour getInputData returns the csv file
battk
03/27/2022, 4:59 AMnetsuite knows how to parse a csv file into rows
battk
03/27/2022, 4:59 AMthen in your map you import the custom records
battk
03/27/2022, 4:59 AMand the reduce you do the transactions
battk
03/27/2022, 5:04 AMif you didnt actually need to create the transactipns after all the custom records are created, you can probably create it after you create your custom record in your map entry point
r
razer456
03/27/2022, 9:55 AMYou are a saver
razer456
03/27/2022, 9:55 AMJust life saver