Announcement

Collapse
No announcement yet.

Csv import not working

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Csv import not working

    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
    Last edited by aka; 10-04-2015, 12:10 AM.
    -----------------------------------------
    Arthur Klisiewicz
    dATA POINT SOFTWARE
    www.datapointsoftware.com

  • #2
    No Problem to import this ... not a bug.
    Best regards: - Reinhard -

    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

    Comment


    • #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
      -----------------------------------------
      Arthur Klisiewicz
      dATA POINT SOFTWARE
      www.datapointsoftware.com

      Comment


      • #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.

        Originally posted by aka View Post
        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

        Comment


        • #5
          Originally posted by aka View Post
          OK, SO PERHAPS YOU COULD EXPLAIN WHAT AM i DOING WRONG ?
          So long you write in (red) uppercase no ... and so long you not tell what error you get also no ...
          Best regards: - Reinhard -

          I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

          Comment


          • #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
            -----------------------------------------
            Arthur Klisiewicz
            dATA POINT SOFTWARE
            www.datapointsoftware.com

            Comment


            • #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

              Comment

              Working...
              X