[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

ImportFile Error -4

Posted on 2006-07-11
5
Medium Priority
?
1,646 Views
Last Modified: 2013-12-26
I have the following code where I get retrun error = -4 (which is Invalid Input)


//ML sample

datastore   lds_obj

lds_obj = create datastore
lds_obj.dataobject = "d_rps510_sort"  // NO select stt associated here
lds_obj.SetTransObject(sqlca)

long ll_row
ll_row = lds_obj.ImportFile("C:\rps510_sample.CSV")
If ll_row < 1 Then
   MessageBox("Message","Error : [" + string(ll_row) + "]")
End If
string ls_sortorder
ls_sortorder = "parcel_id A"  // use "A" for ascending or "D" for descending
lds_obj.SetSort(ls_sortorder)
lds_obj.Sort()
lds_obj.SaveAs("C:\rps510_sample_sorted.txt", CSV!, false)
MessageBox("Info","Output File Created")


Whats wrong above ? My datawindow has 17 columnss as that of CSV file and theor datatypes are same though.

Pls help
M
0
Comment
Question by:mahalakshmi_s
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 4

Expert Comment

by:Lordain
ID: 17094097
Posting the following for reference purposes:

dwcontrol.ImportFile ( filename {, startrow {, endrow {, startcolumn       {, endcolumn {, dwstartcolumn } } } } } )

The file should consist of rows of data.

----CHECK THIS----
If the file includes column headings or row labels, set the startrow and startcolumn arguments to skip them. The data types and order of the DataWindow object's columns must match the columns of data in the file.
----CHECK THIS----

If row 1 = headers or row labels then set startcolumn = 2 as this may be causing your issue.
0
 

Author Comment

by:mahalakshmi_s
ID: 17099627
My file doesnt have any col headings or row labels though...
0
 
LVL 4

Accepted Solution

by:
Lordain earned 2000 total points
ID: 17100458
Ruling out this cause the next thing I would look at is to make sure your datatypes and size are of the appropriate type and length in your dataobject which I presume is an external data object source.

I just noticed and remembered something about the ImportFile Function.

Inserts data into a DataWindow control or DataStore from a file. The data can be tab-delimited text or dBase format 2 or 3.

Notice:  It does not say its supports a CSV file.  I would save your CSV file into one of the named supporting formats and see if this fixes your problem as I have the feeling it is the CSV format which is throwing your INVALID INPUT Error.
0
 

Author Comment

by:mahalakshmi_s
ID: 17107897
For example, I took just 2 lines of text file n tried Importing.

Maha     PB10
XYZ       ASA9

Well, if there is no comma and 2 words r separated by tab , then Import funtion works perfect. The above example works good.

But my original working TEXT file has commas ,inbetween all columns. Like
Maha,PB10
XYZ,ASA9
How can I convert the comma into TAB delimited, so that I can go ahead with further coding ?
Any idea ??
Many thx
0
 

Author Comment

by:mahalakshmi_s
ID: 17109817
I used Text! argument in SAVEAS method of datawindow and obtained what I wanted. Thx...
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand column That will then direct you to their download page. From that p…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question