Re: SQL Examples
Re: SQL Examples
- Subject: Re: SQL Examples
- From: Bruce Robertson <email@hidden>
- Date: Fri, 13 Mar 2009 09:59:38 -0700
> The Create SQLite Database action isn't a standard Automator action.
> So it would have been handy to know which one you were referring to.
> I found one at http://automator.us/developer-02.html#1003, but who's
> to keep anyone else from creating an Action with the same name.
>
> This action's description points out that its expected input is an
> AppleScript list, not text or sql. So using it properly will almost
> certainly improve your outcome. I toyed around with it and don't see
> a lot of benefit to what you are trying to accomplish. Since you will
> have a csv file you will know the structure of the data (unless that
> is the part you are wanting to automate). I suggest manually creating
> the database file and table structure. I have one main database file
> that I use in nearly all my sql-related actions and just create new
> tables for each new project. I then move it out to MySQL when cleaned
> up, processed, etc.
Thank you but I would still like an answer to the question I asked.
How DO you use the CSV to SQL action to create an SQLite database, and how
do you "round trip" it and pull data back out of the resulting database.
That is, what does the result really look like?
The CSV to SQL action is an Apple action.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Automator-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden