Dear all,

Currently, we are using Infor LN but I don't have authorize access to database and I need to get data all column or all records from any table.

Could you please advise tool or method for get all records from table?

Regards,
JanePapa

Hello,

depends on your expected result.

create a seq dump of tables ttaad4226m000

Regards

Hello,

depends on your expected result.

create a seq dump of tables ttaad4226m000

Regards

Hi Bernd,

I need to export data all records and all column from any table to Excel file.
But when I used "Create Sequential Dump of Table", I got a dump file that I can't use in another process.

Regards,
JanePapa

I typically use create sequential dump and specify a field separator of |. Then I can export it into excel like any pipe delimited file. Other than that I cannot think of anything that does it easily. You could look at using OLE automation (basically writing VB code in excel to extract data). I know I use have a tool from Gordon Fasbender that would read the structure of any table into excel - but it did not import the records. I don't recommend OLE automation - but others use it. I had way to many problems and it was extremely slow for me.

I typically use create sequential dump and specify a field separator of |. Then I can export it into excel like any pipe delimited file. Other than that I cannot think of anything that does it easily. You could look at using OLE automation (basically writing VB code in excel to extract data). I know I use have a tool from Gordon Fasbender that would read the structure of any table into excel - but it did not import the records. I don't recommend OLE automation - but others use it. I had way to many problems and it was extremely slow for me.

Hi Mark,

I try to use create sequential dump but I can't specify a separator (|) in Infor LN WEBUI image as attachment.

Could you please to help me?

Hi Mark,

I know a reason about why I cannot check to specify field data with "|".
Now, I can to create dump file and import to excel separate column by "|"

Thanks,

I have written my own flexible export sessions using RDI calls to determine fields and field types for a single or list of tables from a spreadsheet. The nice part of doing it this way is that you can trim string fields, handle delimiters within fields, convert dates/times to an excel-friendly format, and convert enum values to a string. This is a good tool for export of data into a data warehouse or for migrating to another ERP. A few days of programming is a good investment for this type of a tool.

Is it possible you could share the code in the code and utilities forum? I understand if you can't.