Importing table ascii problem

[Chris.Tanti]

The below code works fine in A5v5 but not in A5v4.3.

I generated it in 4.3 and unfortunatly I only have runtime licences for this version so I nead to make it work!
(I am squeazing the finance dept regarding v5 runtime)

The result in the earlier version just gives me a field chopped to 1 character.

***
xroot="D:\WORK\_WTB\data converter"+chr(92)
var->XSelectFile=ui_get_file("Data File","Text(*.txt)",var->xroot+"*.txt","x")
If var->XSelectFile=""
End
End If

xstatus="IMPORTING CSV DATA FILE"
topparent.resynch()
import.type = file_format_table_ascii
import.names = "none"
import.file = var->XSelectFile
import.db = "import03.DBF"
import.skip_lines = 0
import.skip_bytes = 0
import.field_sep = ""
import.record_sep = ""
import.text_qualifier = ""
import.record_len = 1
import.rem_blanks = .F.
import.fields = 1
import.field1 = "line,c,1,90,0"
import()

[Tom Cone Jr]

RE: Importing table ascii problem

Explain again, please. You created the script in A5v4 and it runs in A5v5, but not in A5v4 ???

-- tom

[Chris.Tanti]

RE: Importing table ascii problem

Yep!

I am in an office with A5v4 unlimited runtime licences installed.

But I just happen to have purchased the full version of v5v5 and tried running the same scrypt, and it worked!

[Tom Cone Jr]

RE: Importing table ascii problem

chris,

I suggest you define an import operation. run it, check it, modify it, run it, check it, modify it... then save it when it's right.

Then activate the script recorder, low level.

then run the import operation.

then check the script recorder to get the script which alpha five created.

Save it to a text file, or put it on a button.

Then modify it to run from your form.

It should resemble what you've written by hand, but there will probably be some key differences. let us know if you can't get it going.

-- tom

[Tom Cone Jr]

RE: Importing table ascii problem

Chris, by the way, I'm still confused about how you built the first script. Sorry to be dense, but if you're in an office with ONLY the runtime installed, you could not have built the script with A5v4. The runtime won't permit you to create scripts.

-- tom

[Chris.Tanti]

RE: Importing table ascii problem

sorry,

I have 1 full copy of A5 v4.3 full version (for developing)
An unlimited runtime of A5v4

And 1 copy of A5v5 (full version)

[Tom Cone Jr]

RE: Importing table ascii problem

Chris, thanks. The penny has finally dropped over here, and I now understand! So many people get the versions and the product numbers mixed up I was concerned that you had developed the script in A5v5, not A5v4. Sorry.

Let us know how things go. If you haven't worked with the script recorder before you'll find it's ideal for this kind of problem.

-- tom

[Chris.Tanti]

RE: Importing table ascii problem

Actualy did use the recorder and then just amended the loader bit to use a variable, its odd. It may be there is an ascii character in the text file that I cant see and that A5v5 is handling the file better.

[Tom Cone Jr]

RE: Importing table ascii problem

Chris,

If you want to email the CSV file here, I'll try to import it to a new DBF.

-- tom

[Chris.Tanti]

RE: Importing table ascii problem

Thanks for the offer, actaully I am going to carry on the app in A5v5 and try and force our finace depts to release the cash for an unlimited runtime licence!