Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
6%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
23%
Total votes: 65

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 3rd January 2019, 07:05
JanePapa's Avatar
JanePapa JanePapa is offline
Junior Member
 
Join Date: Nov 2018
Posts: 29
JanePapa is on a distinguished road
Baan: 5 - DB: SQL server - OS: Window
Post Need to get data all records from database
Baan: ERP LN 6.1 FP11 (Infor ERP 10.5)
C/S: None/Unknown

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

Last edited by JanePapa : 3rd January 2019 at 07:06. Reason: mistake
Reply With Quote
  #2  
Old 3rd January 2019, 08:06
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,767
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
SEQ Dump

Hello,

depends on your expected result.

create a seq dump of tables ttaad4226m000

Regards
__________________
//Bernd
Reply With Quote
Sponsored Links
  #3  
Old 3rd January 2019, 08:15
JanePapa's Avatar
JanePapa JanePapa is offline
Junior Member
 
Join Date: Nov 2018
Posts: 29
JanePapa is on a distinguished road
Baan: 5 - DB: SQL server - OS: Window
Quote:
Originally Posted by bdittmar View Post
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
Reply With Quote
  #4  
Old 3rd January 2019, 14:25
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,248
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
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.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #5  
Old 4th January 2019, 02:42
JanePapa's Avatar
JanePapa JanePapa is offline
Junior Member
 
Join Date: Nov 2018
Posts: 29
JanePapa is on a distinguished road
Baan: 5 - DB: SQL server - OS: Window
Quote:
Originally Posted by mark_h View Post
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?
Attached Images
File Type: png Create seperator disable.png (3.7 KB, 17 views)
__________________
Regards,
JanePapa

Last edited by JanePapa : 4th January 2019 at 03:39.
Reply With Quote
  #6  
Old 4th January 2019, 03:38
JanePapa's Avatar
JanePapa JanePapa is offline
Junior Member
 
Join Date: Nov 2018
Posts: 29
JanePapa is on a distinguished road
Baan: 5 - DB: SQL server - OS: Window
Smile

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,
__________________
Regards,
JanePapa
Reply With Quote
  #7  
Old 4th January 2019, 21:52
BaanInOhio BaanInOhio is offline
Senior Member
 
Join Date: Oct 2005
Location: Northeast Ohio
Posts: 191
BaanInOhio is on a distinguished road
Baan: Baan 4c4, 5C, LN - DB: Informix, Oracle, SQL - OS: HP UX, Win2K
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.
Reply With Quote
  #8  
Old 7th January 2019, 14:36
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,248
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Is it possible you could share the code in the code and utilities forum? I understand if you can't.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import data from non unicode into unicode database jclju1 Tools Administration & Installation 5 26th January 2017 16:20
Hiding Data from Database (Using Filter Hooks) azeez.hussain Blogs and Web links 0 28th December 2016 16:04
Application data dictionary vs. run-time data dictionary NPRao Tools Development 5 7th July 2009 08:16
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
Is there any documents available to clear transaction data from database? baan_slmf Tools Administration & Installation 1 16th March 2006 12:04


All times are GMT +2. The time now is 22:33.


©2001-2018 - Baanboard.com - Baanforums.com