Forum OpenACS Q&A: Re: Excel Spreadheet X Postgresql

Collapse
10: Re: Excel Spreadheet X Postgresql (response to 9)
Posted by Claudio Pasolini on 04/05/06 07:20 PM
i just finished my script to import the data from a cvs file. I'm on the tcl file right now and i have no clue how i will run it. from the browser?

Yes

from where?
As already said, you can put your script almost anywhere under the service root, e.g. in the www directory of your package

Collapse
11: Re: Re: Excel Spreadheet X Postgresql (response to 10)
Posted by Iuri Sampaio on 04/06/06 05:46 AM
sorry, i didn't express myself well. the question should be how do i run the script? Do i need an adp file?
if so...what should be in the adp file??

i'm asking because sometimes on oacs i waste too much time doing things that was totaly unnecessary and there was a way out a lot quickly. or even details that i don't know.for example the sql files always need to be reload if i do change something on it.

thanks

Collapse
12: Re: Re: Re: Excel Spreadheet X Postgresql (response to 11)
Posted by Iuri Sampaio on 04/19/06 03:44 AM
Claudio,

i got the script quite working. It's missing just to test on the real db.

sorry for the dumbest question about how to run the script. But OACS sometimes drives me crazy with few detaisls and i end up wasting too much time on easy little things that i didn't even tought it was needed

anyway, i'm learning and i believe this is a process that takes time whem we talk about OACS

Collapse
13: Re: Re: Re: Re: Excel Spreadheet X Postgresql (response to 12)
Posted by Claudio Pasolini on 04/19/06 08:52 AM
Hi Iuri,

the easyest way to run your script is to fire it from your browser. You could also run it from the Tcl shell, but only if you don't use any Aolserver or OpenACS API.

You can write a message confirming that the script has finished, along with some statistics, both with an ADP page or with a simple ns_return command, at your choice.

Collapse
14: Re: Re: Re: Re: Re: Excel Spreadheet X Postgresql (response to 13)
Posted by Iuri Sampaio on 04/28/06 10:35 AM
Hi Claudio,

i run the script and it's working fine, I mean the data has been inserted.
The only problem is some data comes with " or missplaced. I'm quite sure it's because of there's something wrong in the csv file.

Is there another way to get a good csv file??

Collapse
15: Re: Re: Re: Re: Re: Re: Excel Spreadheet X Postgresql (response to 14)
Posted by Iuri Sampaio on 04/28/06 11:10 AM
take a look on the data inserted. There's " and misplaced info

http://www.myybiz.net:8090/master-contacts/list-contacts