HomeForum
Welcome, Guest

Complex XML import
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Complex XML import

Complex XML import 7 months, 3 weeks ago #3967

  • gkovacs
  • OFFLINE
  • Senior Boarder
  • Posts: 47
  • Karma: 0

File Attachment:

File Name: 295133270.zip
File Size: 3 KB

Attachment 295133270.xml not found


I have attached a complex xml file and am trying to determine if we can read with VisImp. I will read multiple times if necessary but cannot get the parent / child record relationship for each read pass to bring in the levels of data. Can you check and see if not a good candidate for VisImp at this time?

Re: Complex XML import 7 months, 3 weeks ago #3969

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
You should be able to apply some transformations to make it more readable.

tick apply transformations
than click View

Here you can enter XSLT transformation and check the results

Mike

Re: Complex XML import 7 months, 2 weeks ago #3971

  • gkovacs
  • OFFLINE
  • Senior Boarder
  • Posts: 47
  • Karma: 0
In VimpPro 7.7.7.24 when you select transform to add xlst transformations you get "Class TToolBar not Found" (see attachment screencap). I have reverted to 7.7.7.20 where it works. Please advise.

File Attachment:

File Name: 7.7.7.24xlst_tranform.jpg.zip
File Size: 9 KB


File Attachment:

File Name: 7.7.7.24xlst_tranform.jpg.zip
File Size: 9 KB

Re: Complex XML import 7 months, 2 weeks ago #3974

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Can you try latest version please (This one was addressed as well)

7.7.8.0

+ Support for MySQL 5.5 was introduced
+ Interface Improvements
+ Command line parameter transformation function
+ Standard print preview
+ Support for scrolling in Package editor
- Boolean fix for MySql
- Better error handling for ADO and MS Sql scripts

Re: Complex XML import 7 months, 2 weeks ago #3983

  • gkovacs
  • OFFLINE
  • Senior Boarder
  • Posts: 47
  • Karma: 0
7.7.8.0 installed and tested ok for xml transformations.Thanks
  • Page:
  • 1
Time to create page: 0.20 seconds

Testimonials

Visual Importer ETL  saved us 25-30 hours per month. Much of that comes from being able to build in error checking into the scripting. I've even been able to script corrections that run on the fly triggered by the error checking on incoming order files.

Gene Kovacs,
Director of Technical Business Operations,
A2B

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top