FMP6: import order unexpectedly CHANGED

[Paolo]

A script on a served file imports records from a local FMP6 file.

One day the import order changed with apparently no reason. As a result, some fields were imported on the wrong fields.

Now I fixed the import order and the badly-performed import. But still I can't understand why this happened and how to prevent it from happening in the future.

No changes were made on the served file. Minor changes have been made sometimes in the local file but without deleting or modifying existing fields.

Both files never crashed.

Any idea?

Thank you,

Paolo

[-Queue-]

Who has access to modify scripts? It sounds as if someone ran a manual import, changing the order, and then opened the script and Replaced the existing order.

[Paolo]

Who has access to modify scripts?

I'm the only one.

[Lee Smith]

Post your script.

Your profile doesn't reveal what operating system and platform you are using, so I can't be specific. However, you need to print the script to Text using the clipboard, or a text file, and then paste that into your message.

Lee

[Paolo]

Import Records [ Import Order: codice(Text), Descrizione(Text), Prezzo(Number), Iva(Number), Classe_1(Text),

Classe_2(Text), Classe_3(Text), Linea(Text), Colore(Text), Dimensione(Text), UdM(Text), Quantita(Number),

PaC(Text), CodiceBarre(Text), Stato(Text), descrizione45(Text), costo(Number), costo_ia(Text), costo_fa(Text),

costo_iv(Text), costo_fv(Text), csa(Text), csa_ia(Text), csa_fa(Text), csa_iv(Text), csa_fv(Text), csv(Text),

csv_iv(Text), csv_fv(Text), visp(Text), flag_A(Text), flag_C(Text), flag_Note(Text), flag_Import(Text), flag_B(Text),

angNote(Text), angMoltipl(Number), angKSup(Number), angSpall(Text), angClasse(Text), angFornCod(Text),

angFornRgs(Text), angFornList(Text), angDesArt2(Text), angUmAlter(Text), angScelta(Number),

ID_FORNITORE(Number), ID_LISTINO(Number), supPeso(Number), supQuantitaPlt(Number), supPzSca(Number),

supMqSca(Number), supMlSca(Number), supKgSca(Number), supScPlt(Number), supPzPlt(Number),

supMqPlt(Number), supMlPlt(Number), supKgPlt(Number), supLung(Number), supAlt(Number), supSpess(Number),

supPrezzoSpall(Number), supPrezzo2a(Number), supPrezzo3a(Number) ]

[ Restore import order, No dialog ]

If [ Status(CurrentError) = 0 ]

Set Field [ listini {[id_forn_sel][id_list_sel]}::recordCount, Status(CurrentFoundCount) ]

End If

Show All Records