How do I get a file to be sql format?

45 pts.
Tags:
Data formatting
File
Trying to submit a file to sql and it is telling me the file is not in sqlite3 format?  Please help!
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 9  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Having no info about the platforms and tools that are available to you, nor any info on your background, nor any info on the structure of the existing file, only general comments can be made. A plausible assumption is that SQLlite functions are unable to input the current file for some reason.

    To start, you would create a SQLlite table that describes the file data. Next, a common method would be to create programming that is appropriate to the current file to read the file a record at a time, apply any needed data reformatting and insert the new row into the table.

    The new table should then be fully acceptable to SQLlite.

    If the assumption is invalid, it should be possible to input the current file to a SQLlite statement that reformats each record and inserts them into the new table. However, if that was cleanly possible, it should also be possible to modify your failing statement so that it would work with the current file.
    36,370 pointsBadges:
    report
  • fernbizz
    Thank you so much for your prompt response! I am taking a python for everybody course on a platform called coursera, we are on an sql portion of the course. I am using atom to write the code. I finished the code and tested it on my Mac terminal and it ran perfectly. When I was trying to upload the file on the coursera website is when the site was giving me the error about the file format.
    45 pointsBadges:
    report
  • Subhendu Sen
    Assuming you must have Login name for this website. If yes, after logging you can ask for help directly from them for this issue.
    141,290 pointsBadges:
    report
  • ToddN2000
    What is the current file format you are trying to upload ?

    135,365 pointsBadges:
    report
  • fernbizz
    It is an File from a program that I am using to code called Atom.
    45 pointsBadges:
    report
  • ToddN2000
    If it's in the default file format for Atom, the format is generally an XML format.  You probably need to write something to parse the data and insert it into the SQL file. It's not going to be a simple copy from what I see.
    135,365 pointsBadges:
    report
  • fernbizz
    Thank you I will keep on trucking!
    45 pointsBadges:
    report
  • Subhendu Sen
    Try Python to insert XML data, here is a help to get some idea, https://www.journaldev.com/20515/python-sqlite-tutorial
    141,290 pointsBadges:
    report
  • fernbizz
    Ok thank you very much for the recommendation, I will watch it and attempt!
    45 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: