You are not logged in.

Database empty after Data Import via Palo.Setdata

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Anni

Intermediate

  • "Anni" is female
  • "Anni" started this thread

Posts: 11

Date of registration: Aug 31st 2007

Location: Barleben

  • Send private message

1

Friday, August 31st 2007, 10:07am

Database empty after Data Import via Palo.Setdata

Hello,

I just created an Excel-Sheet in order to import data from a .csv-File into a local Database.

In the import-sheet, the Palo.Setdata formula gives back the proper values without error messages, but when I test the result of the data import the database is empty.

What am I doing wrong?

Stephanie

Sage

Posts: 540

Date of registration: Oct 23rd 2006

Location: Freiburg

  • Send private message

2

Friday, August 31st 2007, 10:34am

RE: Database empty after Data Import via Palo.Setdata

Hello Anni,

Could you please paste your formula?

Regards,
Stephanie

Anni

Intermediate

  • "Anni" is female
  • "Anni" started this thread

Posts: 11

Date of registration: Aug 31st 2007

Location: Barleben

  • Send private message

3

Friday, August 31st 2007, 11:01am

RE: Database empty after Data Import via Palo.Setdata

Hello Stephanie,

I use the following formula:

=WENN($C$9;"Übersprungen";PALO.SETDATA(Anzahl;FALSCH;Datenbank;Würfel;$C$13;$C$14;$C$15;$C$16;$C$17;$C$18;$C$19;$C$20;$C$21;$C$22;$C$23))

"Anzahl" C9 contains the value I want to import, the cells C13 - C23 contain the specific dimension elements. The formula gives back the right value for "Anzahl").

Stephanie

Sage

Posts: 540

Date of registration: Oct 23rd 2006

Location: Freiburg

  • Send private message

4

Friday, August 31st 2007, 12:31pm

RE: Database empty after Data Import via Palo.Setdata

Hello Anni,

That seems to be alright so far. What does the Paloserver-log file say?

To have a closer look on your import, you could send me your database,
the data to import and your Excel file via email.

Regards,
Stephanie

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

5

Friday, August 31st 2007, 2:49pm

RE: Database empty after Data Import via Palo.Setdata

Hi,
what about the $C$9 condition in your IF-Statement. Was does c9 contain? If it is not a true or false (WAHR/FALSCH) I think PALO.SETDATA is never executed.

Holger

Anni

Intermediate

  • "Anni" is female
  • "Anni" started this thread

Posts: 11

Date of registration: Aug 31st 2007

Location: Barleben

  • Send private message

6

Monday, September 10th 2007, 12:05pm

RE: Database empty after Data Import via Palo.Setdata

Hello,

thanks for your help!

Holger, that was not the fault because C9 was just a true/false cell.
I built the whole database and sheets new and now it works perfectly.

I think I had problems because of the cell formatting ... never mind.

Greetings from Barleben,
Anni

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

7

Monday, September 10th 2007, 12:40pm

RE: Database empty after Data Import via Palo.Setdata

Good to hear.

Greetings from Cologne
Holger
Rate this thread