Hey I am running a suitelet which takes input CSV files and

Question

Hey 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

battk · Answer

not 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

razer456 · Answer

Through script task module

razer456 · Answer

Task create

razer456 · Answer

I have to run map reduce after I import the records

razer456 · Answer

To process the custom records and create a vendor bill from those records

battk · Answer

there are 2 approaches to importing csv files

battk · Answer

are you using the native csv import or are you parsing the file yourself in a scheduled map reduce script

razer456 · Answer

I am parsing it myself and importing in schedule yes

razer456 · Answer

I am able to import through schedule script

battk · Answer

most 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

razer456 · Answer

I am directly searching on the custom records created

razer456 · Answer

Which field do I set I am getting the custom record created but I am not getting the newly imported records

razer456 · Answer

In the map reduce

battk · Answer

make a custom field that you use only for identifying records to process in your map reduce

battk · Answer

if you have simple needs you can make it a checkbox

battk · Answer

else a text field that you set to some unique value shared in your batch

razer456 · Answer

But still I won t get the records for some reason

razer456 · Answer

I can do that

razer456 · Answer

But 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

battk · Answer

what does your map reduce look like

razer456 · Answer

I don t think the issue is map reduce

razer456 · Answer

Because 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 · Answer

I think my code might be the problem

razer456 · Answer

But I am checking the status and then only running MR

battk · Answer

that doesnt sound right

battk · Answer

normally you would create the map reduce task using the scheduled script

battk · Answer

though honestly you may just want to use a map reduce to create both the custom record and your transacctions

razer456 · Answer

So i should run the import in the get input stage

razer456 · Answer

Oh create the record

razer456 · Answer

And everything

razer456 · Answer

I see

razer456 · Answer

I mean I could do that

razer456 · Answer

That is also a good option

razer456 · Answer

I could take the CSV process it all then and there itself

battk · Answer

your getInputData returns the csv file

battk · Answer

netsuite knows how to parse a csv file into rows

battk · Answer

then in your map you import the custom records

battk · Answer

and the reduce you do the transactions

battk · Answer

if 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

razer456 · Answer

You are a saver

razer456 · Answer

Just life saver