You need to sign in to do that
Don't have an account?
AmeyB
reading/storing and parsing big (~70-80 MB) XML file
Hi,
I need help in reading/storing and parsing big (~70-80 MB) XML file.
1] As per our requirement, the third party system will upload the xml on secure ftp, which we will need to bring in Salesforce.
I know Salesforce doesn't support FTP natively, I amy need to introduce a java/dotnet app in between or go for third party solutions like Jittebit or dataloader.io.
2] This xml will contain 2000-3000 records, each with approx 150 fields. We will need to prse this big xml, and upsert these records.
I have used Apex DOM to parse xmls in Salesforce, but not sure it will be the appropriate for our requirement.
Any recommended appraoches for these requirements?
Thanks,
I need help in reading/storing and parsing big (~70-80 MB) XML file.
1] As per our requirement, the third party system will upload the xml on secure ftp, which we will need to bring in Salesforce.
I know Salesforce doesn't support FTP natively, I amy need to introduce a java/dotnet app in between or go for third party solutions like Jittebit or dataloader.io.
2] This xml will contain 2000-3000 records, each with approx 150 fields. We will need to prse this big xml, and upsert these records.
I have used Apex DOM to parse xmls in Salesforce, but not sure it will be the appropriate for our requirement.
Any recommended appraoches for these requirements?
Thanks,
String length exceeds maximum: 6000000.
So looks like Salesforce will not be able to parse a big xml with size of 70-80 MB.
I am also getting the same error when trying to parse large XML file. Did you find any solution for this issue?