Easy Import Bulk Load Issues

[kailashthiyagar]

I m in Istanbul Release and we have bulk load requirement in PRD environmentwe

Using "Load Data" , "Transform Map" , we can do the bulk load in DEV environment but when it comes to PRD environment, whats the best way?

We would be getting multiple bulk load request and each time, we would like to test it in the DEV environment before doing it in PRD. We thought of doing it through Easy import process.

But the excel template which we download doesnt have the "List collector " fields even though the field has been selected in the list..

Whats the suggestion

ctomasi pradeepksharma abhinay

[kailashthiyagar]

mikereaves

So by the easy import feature itself wont support "List collector"?

[mikereaves]

Kailash, I'm not sure that I follow your first question completely, but it sounds correct.   You only want to promote data that you intend to present in your production instance. As far as auto-numbering goes, I recommend that you test this.   Try exporting a small set of records in XML from DEV and importing them to TEST.   I think you'll find that the numbers are promoted also.   This may influence your choice to use the Import Set / Transform Map approach and not the Export XML / Import XML approach. I hope this helps. Mike Reaves Please "Answer" or "Helpful".

[kailashthiyagar]

mikereaves

What i meant is, lets say i have 100 records in my dev instance and i have 10 records that needs to be imported into PRD instance.

If i want to do that, i need to delete all the 100 records in my dev instance first and then import the 10 records using the Transform map, then export data as an xml and import it into PRD. rit? So each time, i have to wipe out all the records in my dev instance.. for this approach.. am i right?

[mikereaves]

IF (you're using the Export XML / Import XML approach) { filter the list to include the 10 records that you want to move to production Export XML (will only contain 10 records) } I suggest that you examine the xml file in a text editor, you'll see the individual records in XML format. Please "Answered" or "Helpful" if you've found this information useful. Thanks, Mike Reaves / Acorio

[kailashthiyagar]

Thanks a lot mikereaves

If you could help me with the query which is posted in this thread, it would be great

alikuttyka

One last question.. Is there any validation script examples available for validating the "Reference"/"List" values before uploading the data using the transform map?

The reason is most of the fields in our application is a reference or List(multiple values seperated by comma).. In this case, if there is some mismatch in the spelling or space, new record would be created in the reference tables.. So if there is any example, it would be great.