Do you mean that I need to add a sheet name to convert CSV files into Excel files and transfer them to the database?

You should pass it the Sheet Name as it is inside Excel, and not the Excel file name. The Sheet Name in this case would be "Sheet 1".

I followed your instructions and the webpage has been unable to appear. What should I do?

My bad, I missed out on 1 step.

1. Add "Workbook_Open_BinaryData" as a dependency from Advanced_Excel

2. Pass it the BinaryData as input

3. Pass the generated output to "Worksheet_SelectByIndex" as input for the "Workbook" property

4. Keep the rest of the code the same as before

This should work :)

Uploading Excel files is possible, but CSV files are still not possible, and the webpage cannot be displayed.

Please use my csv file. Thank you very much!

I have mastered this method（LoadCSV2RecordList）. I want to try using the method of converting CSV to Excel and uploading it to the database.

Hi Nam Sitsu,

where do I get GetphysicalTableName and BulkInsert actions?

Many Thanks in advance.

can you share your oml Naku Sitsu..Thanks, I am a new learner want study your flow.

Hi Nam Nguyen ,

can you please share above screenshot oml file

Hi @subhajit ghosh,

Sorry, I can't share the oml because business involves.

Bulkinsert is in the forge.
GetPhysicalTable is an action that I create.  Here is the action detail.

First, you need {Entity} from Systems,

Then, filter it to get the Physical_Table_Name. Here are the filter conditions.

If you have any questions regarding this subject, please DM me.

Cheers,

Nam

CSV conversion to Excel file upload missing data | OutSystems 

Please review this article.

Hi @Nam Nguyen,

I am successfully uploaded data from excel file but for csv file still I am struggling.

Not able to understand what to fill up in (recordlist,startindex,maxnum areas(loadcsv2list)).

also for bulkupload(tablename,recordlist)

sharing my oml can you please help me out .

Thanks

Hi @Nam Nguyen,

I am successfully uploaded data from excel file but for csv file still I am struggling.

Not able to understand what to fill up in (recordlist,startindex,maxnum areas(loadcsv2list)).

also for bulkupload(tablename,recordlist)

sharing my oml can you please help me out .

Thanks

Hi @Nam Nguyen,

I am successfully uploaded data from excel file but for csv file still I am struggling.

Not able to understand what to fill up in (recordlist,startindex,maxnum areas(loadcsv2list)).

also for bulkupload(tablename,recordlist)

sharing my oml can you please help me out .

Thanks

Hi @Nam Nguyen,

I am successfully uploaded data from excel file but for csv file still I am struggling.

Not able to understand what to fill up in (recordlist,startindex,maxnum areas(loadcsv2list)).

also for bulkupload(tablename,recordlist)

sharing my oml can you please help me out .

Thanks

Hi @Nam Nguyen,

I am successfully uploaded data from excel file but for csv file still I am struggling.

Not able to understand what to fill up in (recordlist,startindex,maxnum areas(loadcsv2list)).

also for bulkupload(tablename,recordlist)

sharing my oml can you please help me out .

Thanks

Hi @Nam Nguyen,

I am successfully uploaded data from excel file but for csv file still I am struggling.

Not able to understand what to fill up in (recordlist,startindex,maxnum areas(loadcsv2list)).

also for bulkupload(tablename,recordlist)

sharing my oml can you please help me out .

Thanks

Hi @subhajit ghosh,

I have updated this oml. 

Hi @nam nguyen,

I have checked your oml but the problem is you are using older version of that server action which show me a error.

but when I am using latest server action of that loadcsv2 record list it keep asking me start index max,maxnum 

do you have any idea about this??

Thanks 

I am using version 1.11.8 (latest version).

From the image you share, you are using modified extension.
Please re-check it.

Nam

Hi Nam Nguyen,

Thank you for your support. I have updated latest version and now not showing any error in my code but when I run the application, process showing done but not inserting any new data .

can you please recheck my code or oml.

sample- csv I have attached.

Hi @subhajit ghosh,

Your code is not running because LoadCSV2RecordList action is not success.
Check LoadCSV2RecordList.DebugInfo to view detail. 
The reason is the structure of record list is not the same with your csv.
First option:
Just insert column Id in your csv. Since the Identifier entity is auto number, so that the id will auto increase.

Note : I used csv file from Resources and that file is not contain Id column. Update or replace it with your csv.

Second option is to create a structure without id to receive your csv file. After that assign it to the original record list.

Cheers, 

Nam

Hi Nam Nguyen,

I have implemented first step now it is success fully uploading csv files But I want to learn the second step also I have created one structure but  how I will assign it to the original record list can you elaborate?

and one more question we have to use after loadcsv server action right?

cheers,

S G

@nam nguyen can you please suggest me any videos or link regarding that structure ?

Hi @subhajit ghosh,

The second option:

Instead of a RecordList with the same structure with your entity (Id,solution_space_name,.... ), you create a RecordList that has structure without Id (solution_space_name ,space_key,...) for the LoadCSV2RecordList action then assign it to the original RecordList ( the one with Id). 

With this approach, you don't have to create a column Id in your excel file because the new structure is match with your csv

Cheers, 
Nam