Csv import not working

Scriptcase 8 Bugs
#1

I tried to import CSV file (from my local C: drive) into existing database on remote MySQL server. The procedure works but when the columns get to the database only one big field is created and all comma delimited fields land in one column.

Here is an example of CSV

1,City,Country,Longitude,Latitude
2,Aberdeen,United Kingdom,-2.07,57.13
3,Abu Dhabi,United Arab Emirates,54.52,24.42
4,Addis Ababa,Ethiopia,38.75,9.02
5,“Adelaide, SA”,Australia,138.6,-34.93
6,“Agana, GU”,Guam,144.75,13.47
7,Ahmadabad,India,72.6,23.05

IT DOES NOT WORK FOR ME unless I’m doing something wrong

I can import this into MySQL in 1 min without SC, so the buttom line is:

WHY BOTHER WITH USELESS FEATURE WHICH CAN BE RUN WITHOUT SC AND WASTE PRECIOUS PROGRAMERS TIME AND ENERGY WHILE THERE ARE TONS OF OTHER MEMBERS REQUESTS WIHCH HAVE NOT BEEN IMPLEMENTED ? IT WOULD BE REALLY HELPFUL IF NET MAKE COULD LISTEN TO WHAT UESRS WANT INSTEAD WORKING ON SOMETHING SO UNIMPORTANT LIKE CSV IMPORT.
Arthur

#2

No Problem to import this … not a bug.

#3

OK, SO PERHAPS YOU COULD EXPLAIN WHAT AM i DOING WRONG ? i STILL GET AN ERROR. i THINK THAT THE PROBLEM IS CAUSED BY COLUMN WITH THE DECIMALS.

ARTHUR

#4

ScriptCase might be getting confused with how the CSV file is defined - try delimiting all of the ‘City’ and ‘Country’ values with double quotes - then try re-importing.

[QUOTE=aka;41253]I tried to import CSV file (from my local C: drive) into existing database on remote MySQL server. The procedure works but when the columns get to the database only one big field is created and all comma delimited fields land in one column.

Here is an example of CSV

1,City,Country,Longitude,Latitude
2,Aberdeen,United Kingdom,-2.07,57.13
3,Abu Dhabi,United Arab Emirates,54.52,24.42
4,Addis Ababa,Ethiopia,38.75,9.02
5,“Adelaide, SA”,Australia,138.6,-34.93
6,“Agana, GU”,Guam,144.75,13.47
7,Ahmadabad,India,72.6,23.05

IT DOES NOT WORK FOR ME unless I’m doing something wrong

I can import this into MySQL in 1 min without SC, so the buttom line is:

WHY BOTHER WITH USELESS FEATURE WHICH CAN BE RUN WITHOUT SC AND WASTE PRECIOUS PROGRAMERS TIME AND ENERGY WHILE THERE ARE TONS OF OTHER MEMBERS REQUESTS WIHCH HAVE NOT BEEN IMPLEMENTED ? IT WOULD BE REALLY HELPFUL IF NET MAKE COULD LISTEN TO WHAT UESRS WANT INSTEAD WORKING ON SOMETHING SO UNIMPORTANT LIKE CSV IMPORT.
Arthur[/QUOTE]

#5

So long you write in (red) uppercase no … and so long you not tell what error you get also no …

#6

I wrote in red my opinion on implementing something that can be easily done with PHPMyAdmin (at least to MySQL, MSSQL, Postgress) not sure about other databases. Since it is implemented it should work but it is not. My question was why NetMake does not run some kind of survey and ask users what they really want. Yest there is a place to post a wish list but for the most part is it ignored when new versions are released and SC is well known from bugs that haven’t been fixed for years. This is the part that bothers me the most.

If you can import the fragment of CSV into MySQL table, then perhaps I’m doing something wrong, but so fat I see no reply confirming it works as expected.

ARTHUR

#7

Have you checked that the csv filename does not have any spaces? Seems that SC does not like this - I experienced this today.

Tony