Import Error just in GESOPP function

Posted By zpmarcos over 5 years ago

Hi,

Im trying to import some Sales Quotes (SQH) files through IMPORTSIL code.

If I use the IMPORTSIL code in GESOPP function I get this error:

If I use the exactly same code, with the exactly same file anywhere outside the GESOPP it works fine without errors....

I have no more ideas what should I do, but I need it to work in GESOPP (Projects) function!

All the field showing errors should be auto-filled, as they are outside that GESOPP function

Any suggestions?

0 Karthick over 5 years ago

Please make sure the import template in above format. Check the "Structure" . This template is used to import CSV format.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 zpmarcos over 5 years ago in reply to Karthick

I think its all ok with the model.. As I said, it works nice, except when Im inside GESOPP function...

Any more suggestions?

Best Regards
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Saleck over 5 years ago

Hi,

Try closing the table SQUOTE [F:SQH] before the call of IMPOTSIL then open it after the import

Check also for SQUOTED and the quote screens if they are also already open in your context...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 zpmarcos over 5 years ago in reply to Saleck

Hi,

Thanks for the quick reply...

" If clalev ([F:SQH]) : LogicClose File [F:SQH] : Endif
If clalev ([F:SQD]) : LogicClose File [F:SQD] : Endif
If clalev ([F:CAL]) : LogicClose File [F:CAL] : Endif"

Used this instructions before the IMPORTSIL call...

Still same errors!

Any more suggestions?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Saleck over 5 years ago in reply to zpmarcos

zpmarcos said:
LogicClose

Not sure if this instruction exists en 4GL!

Try: If clalev ([F:SQH]) : Close local File [SQH] : Endif
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 zpmarcos over 5 years ago in reply to Saleck

Thanks for the reply...

Still the same error...

It seems that X3 can't "autofill" the fields when Im on GESOPP!

Any more idea?

Best Regards
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Saleck over 5 years ago in reply to zpmarcos

Try changing the values of the global variables GFONCTION1 and GFONCTION from GESOPP to another values before the call of IMPORTSIL and restore them after the call.

If this doesn't fix the issue, send me your script
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 zpmarcos over 5 years ago in reply to Saleck

Thanks for the reply.

Still not working... Sent you a friend invite.

Best Regards
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage X3

Import Error just in GESOPP function

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING