on 10-30-2015 11:25 AM
Hi Experts,
As per requirement i have added file upload control in embedded component and i want to read excel file data in sap c4c.
How we read .csv file data in sap c4c.
It would be helpful to me for brief description.
Regards,
Puneet Mittal
I know it's possible to add a file upload bit to a custom screen --- this allows you to upload CSV files (amongst other file types). Unfortunately what you've got then is a binary string displayed in hexadecimal --- I had a similar issue a while back. As far as I know, you'll have to write something which can interpret the string, I don't think there's any built-in CSV interpretation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Depending on what data you're actually trying to import --- account data, etc. --- you may be able to make use of the migration templates. I don't know much about those, but I know they're used to import large amounts of data when setting up a system. Beyond that, I think the only way you can import extra data en masse is by using the XML file inputs --- as I said, there's no native CSV file-reading ability in ByDesign to my knowledge, and I never got around to seeing if it's possible to get a solution reading the binary file contents.
Hi Puneet,
File upload requires XML data.
You can download the required xsd file defining the schema of the xml.
You can use Excel's developer tools to create the respective xml.
Best regards,
Ludger
--
Custom development with all4cloud.de
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Ludger for prompt reply !!!!
I have added file upload control and data list in our Embedded Component.In file upload control , we can upload only .csv file and i want to read all the .csv file data into this data list. How we can achieve this. Can you help me on this.
Regards,
Puneet Mittal
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.