1 Topic by diventi.enterprises (edited by diventi.enterprises Today 04:43:44 am)

  • From: USA
  • Registered: 02/05/2018
  • Posts: 39

Topic: Import transactions not working

I am trying to import sales order data from Shopify into FA.  I've read all the posts I can find on the subject and have tried numerous variations of data types in the .csv file.  I have used the template FA makes available.  Does it matter which character set is selected on the csv import dialogue?

I have progressed to the point where no errors are reported and the FA interface feeds back a line highlighted in green of the data that was processed.  However, when I check to see if a new SO record was created I don't find one.

I would expect that the feed back resulting from a successful upload would be more than the green highlighted information.

Also, the menu option to IMPORT TRANSACTIONS is perpetually greyed out, forcing me to go through the steps to save the access rights for the Administrator (me) each time I want to try to import.  Not sure if this is somehow related but even if it isn't it's very frustrating!

Post's attachments

Screenshot 2026-04-16 151125.jpg 118.9 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.
  • From: USA
  • Registered: 02/05/2018
  • Posts: 39

Re: Import transactions not working

Update on this problem:

With the help of my programmer son, we tracked the upload progress through the import_transactions.php file by dropping in display debug statements at various points in the code.  We finally found some code that if we comment out one line the import program continues to the point where it reports that the .csv has been imported.  However, the imported order cannot be found.

The line of code that we commented out is line 360 (we were using Notepad to search the file, so this may not be the actual line of code).  Here is a snippet of the code (the suspect line is $_SESSION[ 'Items' ]->write(0);):

display_notification_centered("a");
                    //$_SESSION['Items']->write(0);
display_notification_centered("b");
                    $_SESSION['Items']->clear_items();
                    unset($_SESSION['Items']->line_items);
                    unset($_SESSION['Items']);
                    $firstlinecopied = false;
                }
            }
            // Commit import to database

            if ($type == ST_JOURNAL) {
                $typeString = "General Journals";
            } elseif ($type == ST_BANKDEPOSIT) {
                $typeString = "Deposits";
            } elseif ($type == ST_BANKPAYMENT) {
                $typeString = "Payments";
            } elseif ($type == ST_SALESORDER) {
                $typeString = "Sales Order csv lines / $doc_num order(s)";
            } elseif ($type == ST_SALESINVOICE) {
                $typeString = "Sales Invoices csv lines / $doc_num invoice(s)";
            }

It would be appreciated if someone would provide some next steps for us to check.  The FA version is 2.4.9.  Thanks