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

8: Re: Re: Re: Excel Spreadheet X Postgresql (response to 7)

Posted by Claudio Pasolini on 03/14/06 08:53 AM

on the MS Excel, when i save the file as, what type of CVS file has to be? CVS(comma delimited) CVS (machintosh) CVS (MS0DOS)

I always use CVS comma delimited.

now the code,I want this data, which are contacts info, inside the table of the contacts package.

Here things are more difficult, because my example inserts data into a plain table, while 'contacts' are stored into the content repository and moreover makes use of the 'ams' package to dynamically extend the contact's attributes. You will have to use some package specific proc to load your data, but I can't help you because I never used it.

Where should i post and adapt this script? in a random tcl file, which i created in a random test directory?

Any place where you can point your browser is good.

9: Re: Re: Re: Re: Excel Spreadheet X Postgresql (response to 8)

Posted by Iuri Sampaio on 04/05/06 02:47 AM

hi claudio,

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?? from where???

sorry for my delay

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

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

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

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.

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??

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