MetaCase Homepage
Forum Home Forum Home > > MetaEdit+
  New Posts New Posts RSS Feed - Importing CSV file
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Importing CSV file

 Post Reply Post Reply Page  <12
Author
Message
stevek View Drop Down
MetaCase
MetaCase
Avatar

Joined: 11.Mar.2008
Points: 643
Post Options Post Options   Thanks (0) Thanks(0)   Quote stevek Quote  Post ReplyReply Direct Link To This Post Posted: 25.Feb.2015 at 23:12
Originally posted by bernardino bernardino wrote:

...At the end of processing, the MetaEdit+ shows a critical #addEvent: error
I haven't seen that, and I don't see it trying this example, so could you please email metaedit.support (at) metacase.com the meplus0.err file from your MetaEdit+ working directory?
Originally posted by bernardino bernardino wrote:

Despite that both MXM file and the Graph has been generated, the Graph was generated without any information extracted from CSV.
Sorry, that was my typo above (now corrected). I had created $tableRows as a global variable then tried to use the local variable @tableRows. Change the latter to $tableRows and it works.

It looks like your CSV includes the header row "Category;Subcategory": either drop that from the CSV, or skip the first line when iterating, e.g. by extending the where statement (which is run for all elements, before beginning to iterate over the ones that passed):
@ix = ''
@seenFirst = ''
do $csvContents where id and @seenFirst++
{  '      <object id="Row' @++ix '" type="Row">' newline


Edited by stevek - 25.Feb.2015 at 23:17
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.05
Copyright ©2001-2022 Web Wiz Ltd.

This page was generated in 0.043 seconds.